#49573 [NEW]: Mysqli_info doesn't return results when using INSERT .. values

From: terryllong at gmail dot com Operating system: Windows XP PHP version: 5.3.0 PHP Bug Type: MySQLi related Bug description: Mysqli_info doesn't return results when using INSERT .. values Description: ------------ Mysqli_info doesn't seem to return results when using INSERT .. values Reproduce code: --------------- <?php $link = mysqli_connect( 'host,'un', 'pw' ) or die("Connect to db didn't work..."); $crlf=chr(13) .chr(10); $test = mysqli_query($link, "CREATE DATABASE IF NOT EXISTS test") or die("Create db didn't work..."); $test = mysqli_query($link, "USE test") or die("Use TEST db didn't.."); $test = mysqli_query($link, "CREATE TEMPORARY TABLE IF NOT EXISTS t1 (city varchar(30))") or die("Create Temp Table didn't work..."); $data = mysqli_query($link, "INSERT INTO t1 (city) VALUES ('Tulsa')") or die("Insert data didn't work..."); $info_from_insert = mysqli_info($link); print_r("mysqli_info values from 'INSERT' = $info_from_insert $crlf"); print_r("Var_Dump of mysqli_info = "); var_dump($info_from_insert); print_r("---------$crlf"); $data= mysqli_query( $link , "SELECT CITY FROM t1 " ) or die("Select statement didn't..."); $rows = mysqli_affected_rows($link); echo "Rows 'Affected' = $rows $crlf"; //- Get number of affected rows in previous MySQL operation $select_info = mysqli_info($link); print_r("select info: $select_info $crlf"); print_r("Var_Dump of mysqli_info = "); var_dump($info_from_insert); echo $crlf; $mysqli_test = mysqli_fetch_all($data, MYSQLI_ASSOC) ; echo "results from mysqli_fetch_all..$crlf"; var_dump($mysqli_test); ?> Expected result: ---------------- Expect text string show the results of the insert. Actual result: -------------- Results of Insert query returns a string(0) as shown with a Var_dump -- Edit bug report at http://bugs.php.net/?id=49573&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=49573&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=49573&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=49573&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=49573&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=49573&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=49573&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=49573&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=49573&r=needscript Try newer version: http://bugs.php.net/fix.php?id=49573&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=49573&r=support Expected behavior: http://bugs.php.net/fix.php?id=49573&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=49573&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=49573&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=49573&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=49573&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=49573&r=dst IIS Stability: http://bugs.php.net/fix.php?id=49573&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=49573&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=49573&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=49573&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=49573&r=mysqlcfg