/PHP-5.5/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_stmt_bindparam_types.phpt | 24 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE… 29 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?)'); 41 $stmt = $db->query('SELECT id, label FROM test'); 42 $id = $label = null; 48 if (!$stmt->bindColumn(2, $label)) { 61 if ($label != $value) { 64 var_export($label, true), var_export($value, true)); 76 if ($row['label'] != $value) { 79 var_export($row['label'], true), var_export($value, true)); 83 if ($row['label'] != $label) { [all …]
|
H A D | pdo_mysql_stmt_bindvalue.phpt | 30 $id = $label = null; 44 var_export($label, true), gettype($label)); 66 var_export($label, true), gettype($label)); 90 var_export($label, true), gettype($label)); 119 var_export($label, true), gettype($label)); 149 var_export($label, true), gettype($label)); 184 var_export($label, true), gettype($label)); 206 var_export($label, true), gettype($label)); 230 var_export($label, true), gettype($label)); 259 var_export($label, true), gettype($label)); [all …]
|
H A D | pdo_mysql_stmt_blobs.phpt | 28 …$db->exec(sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, PDO_MYSQL_TEST_ENGIN… 31 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 40 $stmt = $db->query('SELECT id, label FROM test'); 41 $id = $label = NULL; 43 $stmt->bindColumn(2, $label, PDO::PARAM_LOB); 51 if ($label !== $value) { 53 $offset, strlen($label), strlen($value)); 63 $stmt = $db->query('SELECT id, label FROM test'); 66 if ($ret['label'] !== $value) { 68 $offset, strlen($ret['label']), strlen($value));
|
H A D | pdo_mysql_stmt_columncount.phpt | 25 $stmt = $db->prepare("SELECT id, label, '?' as foo FROM test"); 43 $stmt = $db->prepare("SELECT id, label, '?' as foo, 'TODO - Stored Procedure' as bar FROM test");
|
H A D | pdo_mysql_stmt_errorinfo.phpt | 28 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1'); 49 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
|
H A D | pdo_mysql_types.phpt | 23 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 31 $stmt = $db->query('SELECT id, label FROM test'); 35 if (!isset($row['id']) || !isset($row['label'])) { 46 if (!preg_match($pattern, $row['label'])) { 48 $offset, $pattern, var_export($row['label'], true)); 60 …if ($row['label'] !== $exp && !is_null($alternative_type) && gettype($row['label']) != $alternativ… 63 var_export($row['label'], true), gettype($row['label']), 71 $stmt = $db->query('SELECT id, label FROM test'); 74 if (is_null($pattern) && ($row['label'] != $row_string['label'])) { 75 …= %s, NATIVE = %s\n", $sql_type, var_export($row_string['label'], true), var_export($row['label'],… [all …]
|
H A D | table.inc | 7 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine); 8 $db->exec('INSERT INTO test(id, label) VALUES (1, "a"), (2, "b"), (3, "c"), (4, "d"), (5, "e"), (6,…
|
H A D | pdo_mysql_stmt_getcolumnmeta.phpt | 73 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE… 79 if (!$db->exec(sprintf("INSERT INTO test(id, label) VALUES (1, '%s')", $value))) { 85 $stmt = $db->prepare('SELECT id, label FROM test'); 104 if (($meta['table'] != 'test') || ($meta['name'] != 'label')) { 237 …$sql = sprintf('CREATE TABLE test(id INT, label INT UNIQUE) ENGINE = %s', MySQLPDOTest::getTableEn… 239 $db->exec('INSERT INTO test(id, label) VALUES (1, 2)'); 240 $stmt = $db->query('SELECT id, label FROM test');
|
H A D | pdo_mysql_stmt_multiquery.phpt | 15 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B… 24 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B… 72 [%u|b%"label"]=> 87 [%u|b%"label"]=> 94 [%u|b%"label"]=> 100 …onds to your %s server version for the right syntax to use near '%SSELECT label FROM test ORDER BY…
|
H A D | pdo_mysql_stmt_nextrowset.phpt | 148 [%u|b%"label"]=> 155 [%u|b%"label"]=> 162 [%u|b%"label"]=> 197 [%u|b%"label"]=> 204 [%u|b%"label"]=> 211 [%u|b%"label"]=> 247 [%u|b%"label"]=> 254 [%u|b%"label"]=> 261 [%u|b%"label"]=> 296 [%u|b%"label"]=> [all …]
|
H A D | pdo_mysql_stmt_unbuffered_2050.phpt | 27 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1'); 29 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1'); 35 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1'); 87 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1'); 99 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1'); 126 [%u|b%"label"]=> 135 [%u|b%"label"]=> 153 [%u|b%"label"]=> 162 [%u|b%"label"]=> 171 [%u|b%"label"]=> [all …]
|
H A D | pdo_mysql_types_zerofill.phpt | 16 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE… 23 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 38 $stmt = $db->query('SELECT id, label FROM test'); 41 if (!isset($row['id']) || !isset($row['label'])) { 53 if (!preg_match($pattern, $row['label'])) { 55 $offset, $pattern, var_export($row['label'], true)); 68 if ($row['label'] !== $exp) { 71 var_export($row['label'], true), gettype($row['label'])); 78 $stmt = $db->query('SELECT id, label FROM test'); 81 if ($row['label'] != $row_string['label']) { [all …]
|
H A D | pdo_mysql_multi_stmt_nextrowset.phpt | 115 ["label"]=> 122 ["label"]=> 129 ["label"]=> 156 ["label"]=> 163 ["label"]=> 170 ["label"]=> 200 ["label"]=> 207 ["label"]=> 214 ["label"]=> 241 ["label"]=> [all …]
|
H A D | pdo_mysql_stmt_blobfromsteam.phpt | 56 $sql = sprintf('CREATE TABLE test(id INT, label BLOB) ENGINE=%s', PDO_MYSQL_TEST_ENGINE); 59 if (!$stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)')) { 86 $stmt2 = $db->query('SELECT id, label FROM test WHERE id = 1'); 88 if ($row['label'] != $blob) { 98 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 104 $stmt2 = $db->query('SELECT id, label FROM test WHERE id = 1'); 106 if ($row['label'] != $blob) {
|
H A D | pdo_mysql_stmt_closecursor.phpt | 52 if (!isset($row2['label']) || ('z' !== $row2['label'])) 86 $id = $label = null; 100 var_export($label, true), gettype($label)); 158 in = 0 -> id = 1 (integer) / label = 'a' (string) 159 in = 0 -> id = 2 (integer) / label = 'b' (string) 163 in = 0 -> id = 1 (integer) / label = 'a' (string) 164 in = 0 -> id = 2 (integer) / label = 'b' (string) 169 in = 0 -> id = 1 (integer) / label = 'a' (string) 170 in = 0 -> id = 2 (integer) / label = 'b' (string) 174 in = 0 -> id = 1 (integer) / label = 'a' (string) [all …]
|
H A D | pdo_mysql_stmt_closecursor_empty.phpt | 25 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2'); 32 $id = $label = null; 38 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR)) 43 printf("in = %d -> id = %s (%s) / label = %s (%s)\n", 46 var_export($label, true), gettype($label)); 51 printf("in = %d -> id = %s (%s) / label = %s (%s)\n", 54 var_export($label, true), gettype($label)); 70 in = 0 -> id = 1 (integer) / label = 'a' (string) 71 in = 0 -> id = 2 (integer) / label = 'b' (string) 72 in = 0 -> id = 1 (integer) / label = 'a' (string) [all …]
|
H A D | mysql_pdo_test.inc | 40 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine); 41 …$db->exec("INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6…
|
H A D | pdo_mysql_attr_autocommit.phpt | 60 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
|
H A D | pdo_mysql_attr_case.phpt | 29 …if (!is_object($stmt = $db->query("SELECT id, id AS 'ID_UPPER', label FROM test ORDER BY id ASC LI… 51 …if (!is_object($stmt = $db->query("SELECT id, id AS 'ID_UPPER', label, MiXeD, MYUPPER FROM test OR… 65 …if (!is_object($stmt = $db->query("SELECT id, label, MiXeD, MYUPPER, MYUPPER AS 'lower' FROM test … 79 …if (!is_object($stmt = $db->query("SELECT id, label, MiXeD, MYUPPER, id AS 'ID' FROM test ORDER BY… 105 [%u|b%"label"]=> 120 [%u|b%"label"]=> 137 [%u|b%"label"]=> 160 [%u|b%"label"]=> 206 [%u|b%"label"]=>
|
H A D | pdo_mysql_attr_fetch_table_names.phpt | 16 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 21 $stmt = $db->query('SELECT label FROM test LIMIT 1'); 31 [%u|b%"test.label"]=> 38 [%u|b%"label"]=>
|
H A D | pdo_mysql_attr_statement_class.phpt | 82 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 2'); 92 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 2'); 98 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 1'); 106 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 1'); 148 [%u|b%"label"]=>
|
H A D | pdo_mysql_begintransaction.phpt | 36 if (!($stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC'))) 54 if (!($stmt = $db->query(sprintf('SELECT id, label FROM test WHERE id = %d', $row['id'])))) 62 $db->exec(sprintf("INSERT INTO test(id, label) VALUES (%d, 'z')", $row['id'])); 64 if (!($stmt = $db->query(sprintf('SELECT id, label FROM test WHERE id = %d', $row['id'])))) 73 if (!($stmt = $db->query(sprintf('SELECT id, label FROM test WHERE id = %d', $row['id'])))) 95 if (!($stmt = $db->query(sprintf('SELECT id, label FROM test WHERE id = %d', $row['id'])))) 169 if (0 == $db->exec("INSERT INTO test(id, label) VALUES (1, 'a')")) 193 [%u|b%"label"]=> 200 [%u|b%"label"]=>
|
H A D | pdo_mysql_bit.phpt | 19 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE… 26 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 33 $stmt = $db->query('SELECT id, label FROM test'); 60 [%u|b%"label"]=>
|
H A D | pdo_mysql_commit.phpt | 40 $db->exec("INSERT INTO test(id, label) VALUES (100, 'z')"); 47 $stmt = $db->query('SELECT id, label FROM test WHERE id = 100'); 49 if (!isset($rows[0]['label']) || ($rows[0]['label'] != 'z')) { 62 $db->exec("INSERT INTO test(id, label) VALUES (100, 'z')"); 68 $stmt = $db->query('SELECT id, label FROM test WHERE id = 100'); 70 if (!isset($rows[0]['label']) || ($rows[0]['label'] != 'z')) {
|
H A D | pdo_mysql_errorcode.phpt | 38 $stmt = $db->query('SELECT id, label FROM test'); 50 @$stmt = $db->query('SELECT id, label FROM unknown'); 54 $stmt = $db->query('SELECT id, label FROM test'); 59 @$db->query('SELECT id, label FROM unknown');
|