DisplayGrid functionality in PHP/MySQL/HTML?
More a call for advice than fixing a specific problem.
I want to display some MySQL tables in a DisplayGrid format.
In Delphi a few clinks and links and the display grid would be up and running.
What is the advice of the EE team on how to how about this for a Web Page.
I'd prefer this to be PHPed if at all possible.
Many thanks,
I want to display some MySQL tables in a DisplayGrid format.
In Delphi a few clinks and links and the display grid would be up and running.
What is the advice of the EE team on how to how about this for a Web Page.
I'd prefer this to be PHPed if at all possible.
Many thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, I didn't mean to be misleading. I was just stating how trivial it is to create a data grid in Delphi.
I hadn't got my head hwo to injetc an equivalent in my HTML pages which is what I wnat to achieve.
Thanks for the links and will follow this through.
I hadn't got my head hwo to injetc an equivalent in my HTML pages which is what I wnat to achieve.
Thanks for the links and will follow this through.
greetings edhasted, , Yes there is automatic "Grid" (row-column) creation in some of the database access in Delphi. But, if you need a special unique "Grid" (row-column) creation in Delphi for a certain display specification, then you can get the row - column data from the data table, and show it any way you want on your GUI.
I do not think that PHP offers any automatic DHTML formatting for a database table select request. So you will need to code your own MySQL connection, your own MySQL database table select request, and then do your own code for a loop through the requested data set rows, to place (echo) the elements in whatever column order you need for display.
Not sure what you want as an answer here, since each of those steps I gave require different kinds PHP knowledge. There are very many "tutorial" pages on the web for using PHP with MySQL and using WHILE loops to display the row-column from a select request, is a tutorial type of thing what you as an answer? Or some sort of pre built PHP class, that are offered, to copy into your PHP code to try and automatically show a MySQL select as a roe-column DHTML output?
I do not think that PHP offers any automatic DHTML formatting for a database table select request. So you will need to code your own MySQL connection, your own MySQL database table select request, and then do your own code for a loop through the requested data set rows, to place (echo) the elements in whatever column order you need for display.
Not sure what you want as an answer here, since each of those steps I gave require different kinds PHP knowledge. There are very many "tutorial" pages on the web for using PHP with MySQL and using WHILE loops to display the row-column from a select request, is a tutorial type of thing what you as an answer? Or some sort of pre built PHP class, that are offered, to copy into your PHP code to try and automatically show a MySQL select as a roe-column DHTML output?
ASKER
That's the type of answer I was looking for. Thanks
Personally, I know there is some javascript component: you can try to look at TableGear (http://andrewplummer.com/code/tablegear/): I've not tested it yet, but it seems to be a great script.
Cheers