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

[Georg Richter]

georg           Wed Aug 25 09:58:03 2004 EDT

  Added files:                 
    /php-src/ext/mysqli/tests   061.phpt 
  Log:
  test for local_infile_handler
  
  

http://cvs.php.net/co.php/php-src/ext/mysqli/tests/061.phpt?r=1.1&p=1
Index: php-src/ext/mysqli/tests/061.phpt
+++ php-src/ext/mysqli/tests/061.phpt
--TEST--
local infile handler
--FILE--
<?php
        include "connect.inc";

        function my_read($fp, &$buffer, $buflen, &$error) {
                $buffer = strrev(fread($fp, $buflen));
                return(strlen($buffer));
        }
        
        /*** test mysqli_connect 127.0.0.1 ***/
        $link = mysqli_connect("localhost", $user, $passwd, "test");

        /* create temporary file */
        $fp = fopen("061.csv", "w");
        fwrite($fp, "foo;bar");
        fclose($fp);

        mysqli_query($link,"DROP TABLE IF EXISTS t_061");
        mysqli_query($link,"CREATE TABLE t_061 (c1 varchar(10), c2 varchar(10))");

        mysqli_query($link, "LOAD DATA LOCAL INFILE '061.csv' INTO TABLE t_061 FIELDS 
TERMINATED BY ';'"); 

        mysqli_set_local_infile_handler($link, "my_read");
        mysqli_query($link, "LOAD DATA LOCAL INFILE '061.csv' INTO TABLE t_061 FIELDS 
TERMINATED BY ';'"); 

        if ($result = mysqli_query($link, "SELECT c1,c2 FROM t_061")) {
                while (($row = mysqli_fetch_row($result))) {
                        printf("%s-%s\n", $row[0], $row[1]);
                }
                mysqli_free_result($result);
        }

        mysqli_close($link);
?>
--EXPECT--
foo-bar
rab-oof

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