php and phpmyadmin and a database full of tables

adam_uk · 09-02-2003, 01:33 PM

hey people

anyone use phpmyadmin?

u see on the left frame once you selected a database it shows links to the tables

how would i selelect them

i looked at the phpmyadmin code and its all confusing

cheers

deadserious · 09-02-2003, 07:25 PM

You can click on the table you want to work with, then up at the top you should see some links like:

[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

You can then select the field you want to work with and click one of them links and go from there to insert data, select data, etc..

Optionally you can run queries directly by typing them in the text area where it says:

Run SQL query/queries on database DbName :

For example, if you have a table named friends and type the following in the text area:

select * from friends;

It will select everything from that table and present it in a nicely formatted table for you.

adam_uk · 09-03-2003, 08:14 AM

ahhhhhh sorry you have mis understood me

i want to create my own version (or at leaslest select the tables and then add them to a drop down box)

i know how to use phpmy admin

i just dont know how to select the names of the tables from a database in php

adam_uk · 09-03-2003, 01:20 PM

ive sussed it now cheers

PHP Code:

  <?

 
echo "<select name='adasd'>";

$dbname="contentsystem";

$result = mysql_list_tables($dbname);

while($row = mysql_fetch_row($result)){

echo"<option value='$row[0]<br>n'>$row[0]<br>n";

    }

mysql_free_result($result);

echo "</select>";

?>

this will display the tables that are in a database

deadserious · 09-03-2003, 02:37 PM

Quote:

Originally posted by adam_uk
ahhhhhh sorry you have mis understood me

I don't think I misunderstood you, but rather you didn't ask your question very well. You can't just expect someone to read your mind. It's really a waste of time for others to help you when you ask questions that really say nothing about what you're actually wanting to do and they try to help you out and you come back with what you should have said in the first place. If you read your original question I think you'll see that I did in fact answer exactly what you asked. You need to put a little thought and effort into your questions.

Quote:

Originally posted by adam_uk
i want to create my own version (or at leaslest select the tables and then add them to a drop down box)

i know how to use phpmy admin

i just dont know how to select the names of the tables from a database in php

And you see with a little thought and effort on your part you could have came up with that in the first place.

I believe I have told you this before and I'm not saying you do this intentionally or anything, but I think you should be aware of it because you do it often and I think it will help you and others that may be trying to help.

By the way, here's my version:

PHP Code:

  echo "<select name=tables size=1>n";

 
    $result = mysql_query("SHOW tables");

    while($row = mysql_fetch_row($result)){

        print "<option>$row[0]n";

  }

echo "</select>n";

:beer:

09-02-2003, 01:33 PM	#1 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	php and phpmyadmin and a database full of tables hey people anyone use phpmyadmin? u see on the left frame once you selected a database it shows links to the tables how would i selelect them i looked at the phpmyadmin code and its all confusing cheers

09-03-2003, 01:20 PM	#4 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	ive sussed it now cheers PHP Code: `<? echo "<select name='adasd'>"; $dbname="contentsystem"; $result = mysql_list_tables($dbname); while($row = mysql_fetch_row($result)){ echo"<option value='$row[0]<br>n'>$row[0]<br>n"; } mysql_free_result($result); echo "</select>"; ?>` this will display the tables that are in a database

09-02-2003, 07:25 PM	#2 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,300 2.85 NP$ (Donate)	You can click on the table you want to work with, then up at the top you should see some links like: [ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ] You can then select the field you want to work with and click one of them links and go from there to insert data, select data, etc.. Optionally you can run queries directly by typing them in the text area where it says: Run SQL query/queries on database DbName : For example, if you have a table named friends and type the following in the text area: select * from friends; It will select everything from that table and present it in a nicely formatted table for you.

09-03-2003, 08:14 AM	#3 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	ahhhhhh sorry you have mis understood me i want to create my own version (or at leaslest select the tables and then add them to a drop down box) i know how to use phpmy admin i just dont know how to select the names of the tables from a database in php

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)