PHP: SHOW TABLES with MYSQLI_USE_RESULT not work

Question

Like in theme. In query :

$query = $link->query('SHOW TABLES LIKE "table"',MYSQLI_USE_RESULT);

and check like:

echo $query->num_rows;

always shows 0 I mention $query->close(); don't help.

Actually voted as documentation bug : https://bugs.php.net/bug.php?id=74262

surely you're using MYSQLI_USE_RESULT on purpose, aren't you? — Your Common Sense, Mar 17 '17 at 13:59
Yes, if I remove MYSQLI_USE_RESULT everything works fine ! ~Fred -ii - query checked not failed... — Daro from Poland, Mar 17 '17 at 14:00
So even after all these explanations you decided to waste PHP team's time with your silly bogus complaint. That's sad. — Your Common Sense, Mar 18 '17 at 17:44
For my stupid explanation what you provided, this is sad, there is no bad questions only bad answers, think about this... — Daro from Poland, Mar 18 '17 at 18:05

score 0 · Answer 1 · answered Mar 17 '17 at 14:00

0

You're doing it wrong that's why.

$result = $link->query("SHOW TABLES LIKE 'table'");
$rows = $result->num_rows;

echo $rows;

Procedural:

$result = mysqli_query($link,"SHOW TABLES LIKE 'table'");
$rows = mysqli_num_rows($result);

echo $rows;

answered Mar 17 '17 at 14:00

clearshot66

2,292
1
8
17

Yes it works that way but with MYSQLI_USE_RESULT -not, why ? – Daro from Poland Mar 17 '17 at 14:04
@DarofromPoland because it's how MYSQLI_USE_RESULT exactly works? – Your Common Sense Mar 17 '17 at 14:08
Don't understand you , You suggest that MYSQLI_USE_RESULT works not showing any rows in mysqli_result ? – Daro from Poland Mar 17 '17 at 14:10
@DarofromPoland MYSQLI_USE_RESULT works exactly as it's described in the manual. Either you are using it on purpose, and therefore have an idea on what are you doing, or just leave this option alone. – Your Common Sense Mar 17 '17 at 14:12
refer to this post: http://stackoverflow.com/questions/9876730/mysqli-store-result-vs-mysqli-use-result – clearshot66 Mar 17 '17 at 14:13
In manual describes to use with big data in mysqli_result received by query, to force to clear mysqli_result by close() or free(), for beter control of memory, like I understand. Other way always after query with MYSQLI_USE_RESULT You should clear mysqli_result. But it not works. – Daro from Poland Mar 17 '17 at 14:18
@DarofromPoland 1. SHOW TABLES result nowhere is any big. 2. What you want after all - the number of rows or actual table names? If the latter **then just fetch them!** – Your Common Sense Mar 17 '17 at 14:24
Simple checking if is one row. SHOW dont shows number of tables(rows) even if there is no tables it returns true or false(casting in if) only if query fails. For checking if is that table we must check by num_rows property of mysqli_result object. With MYSQLI_USE_RESULT is 0 , without is 1, in my case. – Daro from Poland Mar 17 '17 at 14:29
@DarofromPoland frankly, FORGET about MYSQLI_USE_RESULT. Leave it alone – Your Common Sense Mar 17 '17 at 14:33
:) but why ?... – Daro from Poland Mar 17 '17 at 14:34
@DarofromPoland, Read the documentation on php.net if you don't understand why. It's clearly explained. It's not for small result sets. – clearshot66 Mar 17 '17 at 14:39
@DarofromPoland simply because it doesn't work for you – Your Common Sense Mar 17 '17 at 14:41

PHP: SHOW TABLES with MYSQLI_USE_RESULT not work

1 Answers1