johnseito Posted April 8, 2013 Share Posted April 8, 2013 user input string into browser, system returns the name of any table that contains this string . and when user click on the name of a table display the names of all attributes in that table, and when user click on attribute it display the names of all table containing this attribute. how can I do this? I'm new to metadata. Thanks Link to comment https://forums.phpfreaks.com/topic/276694-metadata-user-to-explore-structure-of-tables/ Share on other sites More sharing options...
Barand Posted April 8, 2013 Share Posted April 8, 2013 I take it that this will not be on a website accessible to anyone other than the database owner? You can get the info you want from the information_schema database within MySql Link to comment https://forums.phpfreaks.com/topic/276694-metadata-user-to-explore-structure-of-tables/#findComment-1423578 Share on other sites More sharing options...
johnseito Posted April 8, 2013 Author Share Posted April 8, 2013 I look everywhere on the web, I couldn't see on how to do that. So how does that go into the browser, could you provide me some examples? Thanks Link to comment https://forums.phpfreaks.com/topic/276694-metadata-user-to-explore-structure-of-tables/#findComment-1423594 Share on other sites More sharing options...
Jessica Posted April 8, 2013 Share Posted April 8, 2013 EVERYWHERE? So quickly??! Wow!!! Link to comment https://forums.phpfreaks.com/topic/276694-metadata-user-to-explore-structure-of-tables/#findComment-1423597 Share on other sites More sharing options...
johnseito Posted April 9, 2013 Author Share Posted April 9, 2013 I looked before I started this thread, so yes I have look for a bit. Link to comment https://forums.phpfreaks.com/topic/276694-metadata-user-to-explore-structure-of-tables/#findComment-1423618 Share on other sites More sharing options...
Barand Posted April 9, 2013 Share Posted April 9, 2013 I told you where to look. Your MySQL server will have an information_schema database. Explore in there. Link to comment https://forums.phpfreaks.com/topic/276694-metadata-user-to-explore-structure-of-tables/#findComment-1423625 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.