johnseito Posted April 8, 2013 Share Posted April 8, 2013 (edited) 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 Edited April 8, 2013 by johnseito Quote 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 Quote 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 Quote 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!!! Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.