Please help with table select

stanforrest

No I know there must be away to create a list of tables from a mysql database and have each of those tables be a link to view records in the table because it can be done from within phpmyadmin. However I have a client who does not know much about computers and having her use phpmyadmin would a bit to much for her.

I really need help with some how creating a list of tables in the database and then clicking a table in the list and opening up all records from that table to be edited. Please keep in mind the table list needs to be created dynamically because there is the ability to add tables into the database in the form I have created.

Any help on his would be greatly appreciated.

jpmoriarty

my advice - dont spend a week reinventing the wheel when you will spend at most a day teaching them how to use the basics of phpmyadmin (which is a fab program and took countless years for many people to write).

rich_d

Look at the mysql_list_tables function. Now you know the table names and can present forms to populate them accordingly (you already know how to do this part as you've said).

Cheers,

Rich

stanforrest

I think I need to state my problem a bit more in detail.

I created an event and ticket tracking system for my client a year ago. It took about 6 months to create from scratch. Now I am in the process of adding more functionality to the program. My client has requested that I add the feature of updating more than one field and record upon one submit, which I have now accomplished.

Now here is the problem. To make things easier I have created a form which has only one text field in it. My client will simply type the name of a new entertainment event in this text field and upon clicking the submit button a new table with the same name will be created in the database and all of the data from the Master Table will be dumped into this new table. This is working fine as well. Because my client will be adding all the event tables to the database herself, I could not possibly know what all the tables are in advance. This is why I need to be able to dynamically have a list of all tables created with each one being a link which when clicked will take the user to a details page where they can view and update records in the chosen table.

I have already created a details page which currently only shows the records from the Master Table. Therefore I beleive that the name of the table must be passed as a variable to the details page, and on the details page a "select * from $varname" statement is written. Where $varname is the variable being passed from the tables list.

I have everything working just fine but can not figure out how to create the tables list dynamically with links to the details page to show the correct record list from the choosen table.

rich_d

No offence but - did you read my post?! 🙂 It shows you the PHP function you can use to get a list of all tables in the given database. Turning this list into a page of links passing the variables to your script should not, given what you've said already, take you more than 5 minutes.

Cheers,

Rich

batman

Try something like this:

<?
include "db.php";

$tables = mysql_query();

while ($line = mysql_list_tables($tables))
{
foreach ($line as $table) 
{
echo "$table<br>";
}
}
?>

If that works, then you will have to figure out how you want to link to the table.

Hope that helps,
     -Blake