ThunderAI Posted June 21, 2008 Share Posted June 21, 2008 Does anyone have a good module or 3rd party code that they use to display rows of data across many different tables? I am looking into redesigning the code i use for the datagrid and i was curious what was out there. Link to comment https://forums.phpfreaks.com/topic/111272-php-datagrids/ Share on other sites More sharing options...
DarkWater Posted June 21, 2008 Share Posted June 21, 2008 Wait, graphing or just displaying data? Also, what do you mean "across many different tables"? Link to comment https://forums.phpfreaks.com/topic/111272-php-datagrids/#findComment-571180 Share on other sites More sharing options...
ThunderAI Posted June 21, 2008 Author Share Posted June 21, 2008 Wait, graphing or just displaying data? Also, what do you mean "across many different tables"? Just displaying table data in row format. By many different tables i mean it can support tables that have primary and child key fields, like in InnoDB tables. And the code can be reused for a different table by chaning only a few lines of code. Link to comment https://forums.phpfreaks.com/topic/111272-php-datagrids/#findComment-571181 Share on other sites More sharing options...
Barand Posted June 21, 2008 Share Posted June 21, 2008 there's one in my sig Link to comment https://forums.phpfreaks.com/topic/111272-php-datagrids/#findComment-571227 Share on other sites More sharing options...
ThunderAI Posted June 22, 2008 Author Share Posted June 22, 2008 there's one in my sig That looks good, what about the following situation tbl_users > user_id > user_name tbl_activity > activity_id > activity_user_id SELECT * FROM tbl_activity INNER JOIN tbl_users ON tbl_users.user_id = tbl_activity.activity_user_id Can your table do the relation of those two tables automatically or how do i pass what fields I want displayed? Link to comment https://forums.phpfreaks.com/topic/111272-php-datagrids/#findComment-571268 Share on other sites More sharing options...
Barand Posted June 22, 2008 Share Posted June 22, 2008 Can your table do the relation of those two tables automatically ? It leaves that to MySQL. Just pass it the query how do i pass what fields I want displayed? In the SELECT clause. You can also specify hidden columns Link to comment https://forums.phpfreaks.com/topic/111272-php-datagrids/#findComment-571406 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.