[PHP-CVS] cvs: php-src(PHP_5_2) /ext/pdo/tests pdo_033.phpt /ext/pdo_mysql/tests last_insert_id.phpt

[Hartmut Holzgraefe]

hholzgra                Mon Jul 10 14:06:13 2006 UTC

  Added files:                 (Branch: PHP_5_2)
    /php-src/ext/pdo/tests      pdo_033.phpt 
    /php-src/ext/pdo_mysql/tests        last_insert_id.phpt 
  Log:
  MFH
  

http://cvs.php.net/viewvc.cgi/php-src/ext/pdo/tests/pdo_033.phpt?view=markup&rev=1.1
Index: php-src/ext/pdo/tests/pdo_033.phpt
+++ php-src/ext/pdo/tests/pdo_033.phpt
--TEST--
PDO Common: PDO::quote()
--SKIPIF--
<?php # vim:ft=php
if (!extension_loaded('pdo')) die('skip');
$dir = getenv('REDIR_TEST_DIR');
if (false == $dir) die('skip no driver');
require_once $dir . 'pdo_test.inc';
PDOTest::skip();
?>
--FILE--
<?php
if (getenv('REDIR_TEST_DIR') === false) 
putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/');
require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
$db = PDOTest::factory();

$unquoted = ' !"#$%&\'()*+,-./0123456789:;<=>[EMAIL PROTECTED]|}~';

$quoted = $db->quote($unquoted);

$db->query("CREATE TABLE test (t char(100))");
$db->query("INSERT INTO test (t) VALUES($quoted)");

$stmt = $db->prepare('SELECT * from test');
$stmt->execute();

print_r($stmt->fetchAll(PDO::FETCH_ASSOC));


?>
--EXPECT--
Array
(
    [0] => Array
        (
            [t] =>  !"#$%&'()*+,-./0123456789:;<=>[EMAIL PROTECTED]|}~
        )

)

http://cvs.php.net/viewvc.cgi/php-src/ext/pdo_mysql/tests/last_insert_id.phpt?view=markup&rev=1.1
Index: php-src/ext/pdo_mysql/tests/last_insert_id.phpt
+++ php-src/ext/pdo_mysql/tests/last_insert_id.phpt
--TEST--
PDO MySQL auto_increment / last insert id
--SKIPIF--
<?php
if (!extension_loaded('pdo') || !extension_loaded('pdo_mysql')) die('skip not 
loaded');
require dirname(__FILE__) . '/config.inc';
require  dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
PDOTest::skip();
?>
--FILE--
<?php
require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');

print_r($db->query("CREATE TABLE test (id int auto_increment primary key, num 
int)"));

print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)"));

print_r($db->query("INSERT INTO test (num) VALUES (451)"));

print_r($db->lastInsertId());
--EXPECT--
PDOStatement Object
(
    [queryString] => CREATE TABLE test (id int auto_increment primary key, num 
int)
)
PDOStatement Object
(
    [queryString] => INSERT INTO test (id, num) VALUES (23, 42)
)
PDOStatement Object
(
    [queryString] => INSERT INTO test (num) VALUES (451)
)
24

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