[PHP-CVS] cvs: php-src /ext/mysqli/tests 059.phpt

[Georg Richter]

georg           Tue Jul 15 09:13:59 2003 EDT

  Added files:                 
    /php-src/ext/mysqli/tests   059.phpt 
  Log:
  test for bind + sql_mode=PIPES_AS_CONCAT
  
  

Index: php-src/ext/mysqli/tests/059.phpt
+++ php-src/ext/mysqli/tests/059.phpt
--TEST--
sqlmode + bind
--FILE--
<?php
        include "connect.inc";
        
        /*** test mysqli_connect 127.0.0.1 ***/
        $link = mysqli_connect("localhost", $user, $passwd);

        mysqli_select_db($link, "test");

        mysqli_query($link, "SET SQL_MODE='PIPES_AS_CONCAT'");

        mysqli_query($link,"DROP TABLE IF EXISTS mbind");
        mysqli_query($link,"CREATE TABLE mbind (b varchar(25))");

        $stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?||?)");
        
        mysqli_bind_param($stmt, array(MYSQLI_BIND_STRING, MYSQLI_BIND_STRING), $a, 
$b);

        $a = "foo";
        $b = "bar";

        mysqli_execute($stmt);

        mysqli_stmt_close($stmt);

        $stmt = mysqli_prepare($link, "SELECT * FROM mbind");
        mysqli_execute($stmt);

        mysqli_bind_result($stmt, $e);
        mysqli_fetch($stmt);

        var_dump($e);

        mysqli_close($link);
?>
--EXPECT--
string(6) "foobar"



-- 
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php