need some php/sql help - PHP

Mr. P-teo

so im playing around with php and sql and i was wondering if anyone could help me, i want to run an sql command and it to return me the table name's, i tryed googleing but i dont exactly know what im searching for. Im using this but it doesnt work:


if($login){
mysql_connect(\"localhost\", \"root\", \"\");
mysql_select_db(\"users\");
echo \"Fetching Data&#46;&#46;&#46;\";
$collect = mysql_query(\"SELECT * FROM INFORMATION_SCHEMA&#46;COLUMNS\");
echo $collect;

}

any help?

Sh3llc0d3

Would this help:

http://php.net/manual/en/function.mysql-list-tables.php

Seems to be what your wanting to do.

The example specifically.

Praxis

When you say "it doesn't work", what do you mean? Do you get any errors?

I know it's a shit suggestion, but make sure your PHP is updated as well. This won't work on older versions.

Xin

this may help too, http://www.nparikh.org/unix/mysql.php

Mr. P-teo

lol this thread is quite old, my php skills have improved a hell of alot since when this was made.

Howdy, Stranger!

Top Posters

Who's Online (0)