Home > php > Get all table name from a database

Get all table name from a database


String mysql_tablename(resource $result,  int $i)

<?php

mysql_connect(“localhost”,  “root”,  “password”);

$resutl = mysql_list_tables(“database”);

$num_rows = mysql_num_rows($result);

for($i = 0; $i < $num_rows; $i++){

 echo “Table”, mysql_tablename($result,  $i), “<br/>”;

}

mysql_free_result($result);

?>

Advertisements
Categories: php
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: