SHOW TABLES not returning correct items in array

Question

I have multiple tables named like so MOM2016, MOM2017, MOM2018.

When i run query in phpmyadmin

SHOW TABLES LIKE 'MOM%'

it returns 3 items as expected.

BUT!!!! When i run in php, my code seem to give me only 1 item in the array (first one only MOM2016).

$sql = "SHOW TABLES LIKE 'MOM%'";
$result = $conn->query($sql);
$dbArray = $result->fetch_assoc();
echo "DEBUG:".count($dbArray);

This give:

DEBUG:1

My php code is wrong? Pls help.

you don't need to, you need to iterate through your result set — Napoli
– Napoli, Commented Mar 15, 2018 at 0:33

Nick · Accepted Answer · 2018-03-15 00:38:49Z

1

If you want to get all the results at once,

$dbArray = $result->fetch_all();
echo "DEBUG:".count($dbArray);

answered Mar 15, 2018 at 0:38

Nick

147k23 gold badges67 silver badges106 bronze badges

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

3 Comments

GeneCode Over a year ago

I get 3 count too. But how do I access the items in array? i tried print dbArray[0] and it prints "Array" only.

Nick Over a year ago

fetch_all will return an array of arrays, so the table names are in $dbArray[0][0], $dbArray[1][0], $dbArray[2][0]. The same applies to the other poster's answer.

GeneCode Over a year ago

I guess this is basic stuff that I do not know. Thank you this works now. Thanks for your help and have a nice day.

Napoli · Accepted Answer · 2018-03-15 00:34:00Z

1

Iterate through your fetch resource

$dbArray = array();
while ($row = $result->fetch_assoc()) {
   $dbArray[] = $row;
}

print "DEBUG: " . count($dbArray);

answered Mar 15, 2018 at 0:34

Napoli

1,4032 gold badges17 silver badges26 bronze badges

1 Comment

GeneCode Over a year ago

by this way i get count 3. but the content of dbArray is [Array, Array, Array].

Collectives™ on Stack Overflow

SHOW TABLES not returning correct items in array

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related