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
