#37260 [Opn->Fbk]: mysqli does NOT insert data

[georg]

 ID:               37260
 Updated by:       [EMAIL PROTECTED]
 Reported By:      lana0 at zahav dot net dot il
-Status:           Open
+Status:           Feedback
 Bug Type:         MySQLi related
 Operating System: XP SP2 Home edition
 PHP Version:      5.1.2
 New Comment:

Please try with a php_mysqli.dll (and libmysql.dll) linked against
actual 5.0.20 sources from
http://dev.mysql.com/downloads/connector/php/


Previous Comments:
------------------------------------------------------------------------

[2006-05-01 15:36:18] lana0 at zahav dot net dot il

correct summary: mysqli does NOT insert data

------------------------------------------------------------------------

[2006-05-01 14:58:02] lana0 at zahav dot net dot il

Description:
------------
extension php_mysqli.dll does not work properly in new release.

5.04 - it works
5.12 and 5.20SnapShort - it fails;

Reproduce code:
---------------
<?php
  //grant create,insert,select,delete on test.* to
'testuser'@'localhost';
  $db=mysqli_connect('localhost','testuser','','test');
  echo "Php version: ".phpversion()."\n";
  echo "Mysqli client version: ".mysqli_get_client_info()."\n";
  echo "Mysqli server version: ".mysqli_get_server_info($db)."\n";
  $Query='CREATE TABLE IF NOT EXISTS test.test (binData blob)';
  $res=mysqli_query($db,$Query);
  if ($res===TRUE){
    $Query='insert into test.test  set binData=?';
    $binData="\0";          //BYTE ZERO! 
    $binData="123x\000567"; //TRY
    $binData="12345";
    $stmt =mysqli_prepare($db,$Query);
    if (!$stmt){
      echo "Fail on prepare!";
      exit;
    }
    $res=mysqli_stmt_bind_param($stmt,'b',$binData);
    $res=mysqli_stmt_execute($stmt);
    if ($res){
      $Query="select length(binData) as n from test.test";
      $res=mysqli_query($db,$Query);
      if ($res){
        $row=mysqli_fetch_assoc($res);
        if ($row){
          mysqli_free_result($res);
          echo "input strlen=".strlen($binData)."\n";
          echo "stored strlen={$row['n']}"."\n";
          mysqli_query($db,'delete from test.test');
        }
      }
    }
  }
  exit;
?>


Expected result:
----------------
ver 5.0.4 works: (see strlen value)

R:\PhpMySQL>php blobcutzero.php
Php version: 5.0.4
Mysqli client version: 4.1.7
Mysqli server version: 5.0.16-nt
input strlen=5
stored strlen=5

Actual result:
--------------
new release fails: (see strlen value)

R:\PhpMySQL>php blobcutzero.php
Php version: 5.1.2
Mysqli client version: 4.1.7
Mysqli server version: 5.0.16-nt
input strlen=5
stored strlen=0

R:\PhpMySQL>php blobcutzero.php
Php version: 5.2.0-dev
Mysqli client version: 4.1.7
Mysqli server version: 5.0.16-nt
input strlen=5
stored strlen=0




------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=37260&edit=1