Query all Tables in Database in MySQL & PHP

Question

How would I be able to make a list of tables and traverse them in php?

I tried to figure out how the mysqli_query would output, but I keep getting an error.

$link = mysqli_connect($host,$user,$pass);
mysqli_select_db($link,$name);
$result = mysqli_query($link, "SHOW TABLES");
echo $result;

Essentially I want to be able to place them in an array and traverse the array going through each single table and do a quick query on them.

Thanks for the help.

edit: title

"Catchable fatal error: Object of class mysqli_result could not be converted to string" and this is pertaining to the line "echo $result;" — Aaron Nguyen
– Aaron Nguyen, Commented Sep 10, 2012 at 21:48
don't do show tables. use the INFORMATION_SCHEMA db. that's what it's there for. — Marc B
– Marc B, Commented Sep 10, 2012 at 21:50
First you must read the PHP manual pages for mysqli_* functions — Jocelyn
– Jocelyn, Commented Sep 10, 2012 at 21:51
@Palladium: Nearly all questions on SO could be solved by reading docs and searching the net, but that would defeat the purpose of Stack Overflow. The OP has obviously tried something and had a problem with it. That's why we're here. — Herbert
– Herbert, Commented Sep 10, 2012 at 21:56

rodion · Accepted Answer · 2012-09-10 21:51:47Z

2

Note that $result is not a string, but a MySQLi result.

Use something like

while ($row = $result->fetch_assoc()) {
    /* Process $row here ... */
    var_dump($row);
}

answered Sep 10, 2012 at 21:51

rodion

6,1364 gold badges26 silver badges29 bronze badges

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

1 Comment

Aaron Nguyen Over a year ago

thanks for the solution. Much easier than tossing it into an array and then traversing it.

Alain · Accepted Answer · 2012-09-10 21:53:11Z

2

This should work

$tables = array();
$result = mysqli_query($link, "SHOW TABLES");
while (($row = mysqli_fetch_assoc($result)) !== null)
{
        $tables[] = $row[key($row)];
}

answered Sep 10, 2012 at 21:53

Alain

37.1k18 gold badges128 silver badges160 bronze badges

1 Comment

Aaron Nguyen Over a year ago

exactly what I was describing, but rodion's solution is much simpler. thanks for the input though!

Collectives™ on Stack Overflow

Query all Tables in Database in MySQL & PHP

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related