how to display all tables name from mysql database using php? [duplicate]

Question

how to display all tables name from mysql database using php? I am using this syntax.. can anybody guide me where i m wrong.. thanks in advance

    <?php

$db = mysqli_connect('localhost','root','','realestate');

// Check connection
if (mysqli_connect_errno($db))
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  else 
  {
  echo "Successfully connected to database.</br>";
  }

  $result = mysql_query("SHOW TABLES FROM 'realestate'");

  while ($row = mysql_fetch_array($result))
  {
  echo $row[0];
  }


  ?>

Do you get an error? A white screen? What does mysql_error() give you? — andrewsi
– andrewsi, Commented Nov 5, 2013 at 20:09
I'm not pretty sure, but I guess the quotes are unnecessary at database name in your query. Also you could do "SHOW TABLES" only as well, because database name was already specified. — Wagner Leonardi
– Wagner Leonardi, Commented Nov 5, 2013 at 20:12
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\00000\tables2.php on line 17 — user2957799
– user2957799, Commented Nov 5, 2013 at 20:17

Mihai · Accepted Answer · 2013-11-05 20:41:09Z

2

1.You are mixing mysqli with mysql

2.Use backticks for table,database or column names

SHOW TABLES FROM `realestate`

answered Nov 5, 2013 at 20:41

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2957799 Over a year ago

sir, its giving me error that mysql_fetch_array() expects parameter 1 to be resource, boolean given and all

Collectives™ on Stack Overflow

how to display all tables name from mysql database using php? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related