Home
last modified time | relevance | path

Searched refs:id (Results 226 – 250 of 794) sorted by last modified time

12345678910>>...32

/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_local_infile_directory_denied.phpt41 …exec_and_count(2, $db, sprintf('CREATE TABLE test_local_inifile_dir_denied(id INT NOT NULL PRIMARY…
47 $stmt = $db->query('SELECT id, col1 FROM test_local_inifile_dir_denied ORDER BY id ASC');
H A Dpdo_mysql_local_infile_overrides_local_infile_directory.phpt41 …exec_and_count(2, $db, sprintf('CREATE TABLE test_local_inifile_overrides(id INT NOT NULL PRIMARY …
47 $stmt = $db->query('SELECT id, col1 FROM test_local_inifile_overrides ORDER BY id ASC');
49 array("id" => 1, "col1" => "one"),
50 array("id" => 2, "col1" => "two"),
51 array("id" => 3, "col1" => "three"),
H A Dpdo_mysql_multi_stmt_nextrowset.phpt25 … {$procedure}() BEGIN SELECT id FROM $table ORDER BY id ASC LIMIT 3; SELECT id, label FROM {$table…
88 ["id"]=>
93 ["id"]=>
98 ["id"]=>
105 ["id"]=>
112 ["id"]=>
119 ["id"]=>
131 ["id"]=>
136 ["id"]=>
141 ["id"]=>
[all …]
H A Dpdo_mysql_prepare_emulated.phpt100 prepex(7, $db, "INSERT INTO test_prepare_emulated(id, label) VALUES(1, ':placeholder')");
105 prepex(10, $db, "INSERT INTO test_prepare_emulated(id, label) VALUES(1, ':placeholder')",
111 prepex(13, $db, 'INSERT INTO test_prepare_emulated(id, label) VALUES(1, :placeholder)',
113 prepex(14, $db, 'INSERT INTO test_prepare_emulated(id, label) VALUES(2, :placeholder)',
120 array(':placeholder' => 'id'));
121 prepex(17, $db, 'SELECT :placeholder FROM test_prepare_emulated WHERE id > 1',
122 array(':placeholder' => 'id'));
131 … prepex(19, $db, 'SELECT id, label FROM test_prepare_emulated WHERE label > :placeholder',
138 $stmt = prepex(22, $db, 'SELECT id, label FROM test_prepare_emulated');
196 ["id"]=>
[all …]
H A Dpdo_mysql_prepare_emulated_anonymous.phpt20 …$db->exec(sprintf('CREATE TABLE test_prepare_emulated_anonymous(id INT, label CHAR(255)) ENGINE=%s…
22 … $stmt = $db->prepare("INSERT INTO test_prepare_emulated_anonymous(id, label) VALUES(1, '?')");
30 $stmt = $db->prepare('SELECT id, label FROM test_prepare_emulated_anonymous');
41 … $stmt = $db->prepare("INSERT INTO test_prepare_emulated_anonymous(id, label) VALUES(1, '?')");
49 $stmt = $db->prepare('SELECT id, label FROM test_prepare_emulated_anonymous');
H A Dpdo_mysql_prepare_emulated_anonymous_placeholders.phpt97 …prepex(5, $db, "INSERT INTO test_prepare_emulated_anonymous_placeholder(id, label) VALUES(1, '?')"…
102 …prepex(8, $db, "INSERT INTO test_prepare_emulated_anonymous_placeholder(id, label) VALUES(1, '?')",
108 … prepex(11, $db, 'INSERT INTO test_prepare_emulated_anonymous_placeholder(id, label) VALUES(1, ?)',
110 … prepex(12, $db, 'INSERT INTO test_prepare_emulated_anonymous_placeholder(id, label) VALUES(2, ?)',
117 array('id'));
118 prepex(15, $db, 'SELECT ? FROM test_prepare_emulated_anonymous_placeholder WHERE id > 1',
119 array('id'));
124 array('id', 'label', 'value'));
138 … $stmt = prepex(21, $db, 'SELECT id, label FROM test_prepare_emulated_anonymous_placeholder');
191 ["id"]=>
[all …]
H A Dpdo_mysql_prepare_emulated_myisam.phpt95 …prepex(4, $db, 'CREATE TABLE test_prepare_emulated_myisam(id INT, label CHAR(255)) ENGINE=MyISAM');
97 … prepex(6, $db, 'INSERT INTO test_prepare_emulated_myisam(id, label) VALUES (1, :placeholder)',
99 … prepex(7, $db, 'INSERT INTO test_prepare_emulated_myisam(id, label) VALUES (1, :placeholder)',
101 …$stmt = prepex(8, $db, 'SELECT id, label FROM test_prepare_emulated_myisam WHERE MATCH label AGAIN…
110 …prepex(10, $db, 'INSERT INTO test_prepare_emulated_myisam(id, label) VALUES (1, :placeholder), (2,…
113 …$stmt = prepex(11, $db, 'SELECT id, label FROM "test_prepare_emulated_myisam WHERE MATCH label AGA…
117 …$stmt = prepex(12, $db, 'SELECT id, label FROM \'test_prepare_emulated_myisam WHERE MATCH label AG…
121 …$stmt = prepex(13, $db, 'SELECT id, label AS "label" FROM test_prepare_emulated_myisam WHERE label…
124 …$sql = sprintf("SELECT id, label FROM test_prepare_emulated_myisam WHERE (label LIKE %s) AND (id =…
131 …$sql = sprintf("SELECT id, label FROM test_prepare_emulated_myisam WHERE (id = :placeholder) OR (…
[all …]
H A Dpdo_mysql_prepare_emulated_myisam_index.phpt98 …prepex(4, $db, 'CREATE TABLE test_prepare_emulated_myisam_index(id INT, label CHAR(255)) ENGINE=My…
100 … prepex(6, $db, 'INSERT INTO test_prepare_emulated_myisam_index(id, label) VALUES (1, ?)',
102 … prepex(7, $db, 'INSERT INTO test_prepare_emulated_myisam_index(id, label) VALUES (1, ?)',
104 …$stmt = prepex(8, $db, 'SELECT id, label FROM test_prepare_emulated_myisam_index WHERE MATCH label…
114 … prepex(10, $db, 'INSERT INTO test_prepare_emulated_myisam_index(id, label) VALUES (1, ?), (2, ?)',
117 …$stmt = prepex(11, $db, 'SELECT id, label FROM "test_prepare_emulated_myisam_index WHERE MATCH lab…
128 …$stmt = prepex(13, $db, 'SELECT id, label AS "label" FROM test_prepare_emulated_myisam_index WHERE…
131 …$sql = sprintf("SELECT id, label FROM test_prepare_emulated_myisam_index WHERE (label LIKE %s) AND…
138 …$sql = sprintf("SELECT id, label FROM test_prepare_emulated_myisam_index WHERE (id = ?) OR (label…
144 …T id, label FROM test_prepare_emulated_myisam_index WHERE id = ? AND label = (SELECT label AS 'SEL…
[all …]
H A Dpdo_mysql_prepare_emulated_placeholder_everywhere.phpt22 …$db->exec(sprintf('CREATE TABLE test_prepare_emulated_placeholder_everywhere(id INT, label CHAR(25…
23 …$db->exec("INSERT INTO test_prepare_emulated_placeholder_everywhere(id, label) VALUES (1, 'row1')"…
H A Dpdo_mysql_prepare_match_against.phpt16 $db->exec('CREATE TABLE test_prepare_match_against(id INT, label CHAR(255)) ENGINE=MyISAM');
19 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (…
23 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (…
27 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_match_against WHERE MATCH label AGAINST (…
H A Dpdo_mysql_prepare_native_anonymous_placeholder.phpt119 array('id'));
121 array('id'));
123 array('id', 'label', 'value'));
137 …$stmt = prepex(16, $db, 'SELECT id, label FROM test_prepare_native_anonymous_placeholder ORDER BY …
141 "id" => "1",
145 "id" => "2",
152 $exp[0]['id'] = 1;
153 $exp[1]['id'] = 2;
207 $exp[0]['id'] = 1;
215 …$sql = sprintf("SELECT id, label FROM test_prepare_native_anonymous_placeholder WHERE (label LIKE …
[all …]
H A Dpdo_mysql_prepare_native_clear_error.phpt17 …$db->exec(sprintf('CREATE TABLE test_prepare_native_clear_error(id INT, label CHAR(255)) ENGINE=%s…
25 $db->exec("INSERT INTO test_prepare_native_clear_error(id, label) VALUES (1, 'row1')");
27 …LECT unknown_column FROM test_prepare_native_clear_error WHERE id > :placeholder ORDER BY id ASC');
34 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_native_clear_error WHERE id > :placeholde…
47 …LECT unknown_column FROM test_prepare_native_clear_error WHERE id > :placeholder ORDER BY id ASC');
54 …$stmt = $db->prepare('SELECT id, label FROM test_prepare_native_clear_error WHERE id > :placeholde…
84 ["id"]=>
H A Dpdo_mysql_prepare_native_column.phpt22 $stmt = $db->prepare("SELECT :param FROM {$table} ORDER BY id ASC LIMIT 1");
23 $stmt->execute(array(':param' => 'id'));
44 string(2) "id"
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt17 …$db->exec(sprintf('CREATE TABLE test_prepare_native_dup_named(id INT, label1 CHAR(255), label2 CHA…
25 …$stmt = $db->prepare('INSERT INTO test_prepare_native_dup_named(id, label1, label2) VALUES (1, :pl…
34 … $stmt = $db->prepare('SELECT id, label1, label2 FROM test_prepare_native_dup_named WHERE id = 1');
44 …$stmt = $db->prepare('INSERT INTO test_prepare_native_dup_named(id, label1, label2) VALUES(2, :pla…
53 … $stmt = $db->prepare('SELECT id, label1, label2 FROM test_prepare_native_dup_named WHERE id = 2');
62 …$db->exec("INSERT INTO test_prepare_native_dup_named (id, label1, label2) VALUES (1, 'row1', 'row2…
63 …id, label1 FROM test_prepare_native_dup_named WHERE id = :placeholder AND label1 = (SELECT label1 …
115 ["id"]=>
126 ["id"]=>
H A Dpdo_mysql_prepare_native_myisam.phpt104 … prepex(4, $db, 'CREATE TABLE test_prepare_native_myisam(id INT, label CHAR(255)) ENGINE=MyISAM');
107 … prepex(6, $db, 'INSERT INTO test_prepare_native_myisam(id, label) VALUES (1, :placeholder)',
109 … prepex(7, $db, 'INSERT INTO test_prepare_native_myisam(id, label) VALUES (2, :placeholder)',
111 …$stmt = prepex(8, $db, 'SELECT id, label FROM test_prepare_native_myisam WHERE MATCH label AGAINST…
119 … $stmt = prepex(9, $db, 'SELECT id, label FROM test_prepare_native_myisam ORDER BY id ASC');
131 … $db->exec("INSERT INTO test_prepare_native_myisam(id, label) VALUES (1, 'row1'), (2, 'row2')");
133 …$sql = sprintf("SELECT id, label FROM test_prepare_native_myisam WHERE (label LIKE %s) AND (id = :…
139 …$sql = sprintf("SELECT id, label FROM test_prepare_native_myisam WHERE (id = :placeholder) OR (la…
H A Dpdo_mysql_prepare_native.phpt118 …prepex(6, $db, sprintf('CREATE TABLE test_prepare_native(id INT, label CHAR(255)) ENGINE=%s', PDO_…
119 prepex(7, $db, "INSERT INTO test_prepare_native(id, label) VALUES(1, ':placeholder')");
120 $stmt = prepex(8, $db, 'SELECT label FROM test_prepare_native ORDER BY id ASC');
124 prepex(10, $db, 'INSERT INTO test_prepare_native(id, label) VALUES(1, :placeholder)',
126 prepex(11, $db, 'INSERT INTO test_prepare_native(id, label) VALUES(2, :placeholder)',
128 $stmt = prepex(12, $db, 'SELECT label FROM test_prepare_native ORDER BY id ASC');
133 array(':placeholder' => 'id'));
141 prepex(16, $db, 'SELECT id, label FROM test_prepare_native WHERE label > :placeholder',
145 …$stmt = prepex(16, $db, 'SELECT id, label FROM test_prepare_native WHERE :placeholder IS NOT NULL',
150 … $stmt = prepex(18, $db, 'SELECT id, label FROM test_prepare_native WHERE :placeholder IS NULL',
H A Dpdo_mysql_exec_load_data.phpt62 exec_and_count(3, $db, sprintf('CREATE TABLE test_mysql_exec_load_data(id INT NOT NULL PRIMARY KEY,…
79 $stmt = $db->query('SELECT id, col1 FROM test_mysql_exec_load_data ORDER BY id ASC');
80 $expected = array(array("id" => 1, "col1" => "foo"), array("id" => 2, "col1" => "bar"));
H A Dpdo_mysql_attr_statement_class.phpt99 $stmt = $db->query("SELECT id, label FROM {$table} ORDER BY id ASC LIMIT 2");
109 $stmt = $db->query("SELECT id, label FROM {$table} ORDER BY id ASC LIMIT 2");
115 $stmt = $db->query("SELECT id, label FROM {$table} ORDER BY id ASC LIMIT 1");
123 $stmt = $db->query("SELECT id, label FROM {$table} ORDER BY id ASC LIMIT 1");
162 ["id"]=>
H A Dpdo_mysql_errorinfo.phpt49 $stmt = $db->query("SELECT id, label FROM {$table}");
60 @$stmt = $db->query('SELECT id, label FROM unknown');
64 $stmt = $db->query("SELECT id, label FROM {$table}");
70 @$db->query('SELECT id, label FROM pdo_mysql_errorinfo_unknown');
H A Dpdo_mysql_exec.phpt39 exec_and_count(4, $db, "INSERT INTO test_mysql_exec(id, col1) VALUES (1, 'a')", 1);
40 … exec_and_count(5, $db, "INSERT INTO test_mysql_exec(id, col1) VALUES (2, 'b'), (3, 'c')", 2);
41 exec_and_count(6, $db, "UPDATE test_mysql_exec SET id = 4 WHERE id = 3", 1);
42 …ec_and_count(7, $db, "INSERT INTO test_mysql_exec(id, col1) VALUES (1, 'd') ON DUPLICATE KEY UPDAT…
43 exec_and_count(8, $db, "UPDATE test_mysql_exec SET id = 5 WHERE id = 5", 0);
44 …ec_and_count(9, $db, "INSERT INTO test_mysql_exec(id, col1) VALUES (5, 'e') ON DUPLICATE KEY UPDAT…
45 exec_and_count(10, $db, "REPLACE INTO test_mysql_exec(id, col1) VALUES (5, 'f')", 2);
46 exec_and_count(11, $db, "REPLACE INTO test_mysql_exec(id, col1) VALUES (6, 'g')", 1);
47 exec_and_count(12, $db, 'DELETE FROM test_mysql_exec WHERE id > 2', 4);
55 exec_and_count(37, $db, "INSERT INTO test_mysql_exec(id, col1) VALUES (1, 'a')", 1);
[all …]
H A Dpdo_mysql_exec_ddl.phpt49 if (0 === $db->exec("CREATE TABLE {$table} (id INT, col1 CHAR(2))")) {
50 exec_and_count(5, $db, "CREATE INDEX idx1 ON {$table} (id)", 0);
52 exec_and_count(7, $db, "ALTER TABLE {$table} DROP id", 0);
53 exec_and_count(8, $db, "ALTER TABLE {$table} ADD id INT", 0);
54 exec_and_count(9, $db, "ALTER TABLE {$table} ALTER id SET DEFAULT 1", 0);
H A Dpdo_mysql_attr_case.phpt32 …if (!is_object($stmt = $db->query("SELECT id, id AS 'ID_UPPER', label FROM {$table} ORDER BY id AS…
54 …if (!is_object($stmt = $db->query("SELECT id, id AS 'ID_UPPER', label, MiXeD, MYUPPER FROM {$table…
68 …f (!is_object($stmt = $db->query("SELECT id, label, MiXeD, MYUPPER, MYUPPER AS 'lower' FROM {$tabl…
82 …if (!is_object($stmt = $db->query("SELECT id, label, MiXeD, MYUPPER, id AS 'ID' FROM {$table} ORDE…
101 ["id"]=>
116 ["id"]=>
133 ["id"]=>
156 ["id"]=>
206 ["id"]=>
H A Dpdo_mysql_attr_init_command.phpt23 $create = sprintf('CREATE TABLE %s(id INT)', $table);
31 $db->exec(sprintf('INSERT INTO %s(id) VALUES (1)', $table));
32 $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
44 string(48) "CREATE TABLE pdo_mysql_attr_init_command(id INT)"
49 ["id"]=>
H A Dlast_insert_id.phpt2 PDO MySQL auto_increment / last insert id
15 print_r($db->query("CREATE TABLE test_last_insert_id (id INT AUTO_INCREMENT PRIMARY KEY, num INT)")…
17 print_r($db->query("INSERT INTO test_last_insert_id (id, num) VALUES (23, 42)"));
32 [queryString] => CREATE TABLE test_last_insert_id (id INT AUTO_INCREMENT PRIMARY KEY, num INT)
36 [queryString] => INSERT INTO test_last_insert_id (id, num) VALUES (23, 42)
H A Dpdo_mysql_exec_select.phpt37 …exec_and_count(3, $db, sprintf('CREATE TABLE test_mysql_exec_select(id INT NOT NULL PRIMARY KEY, c…
38 exec_and_count(4, $db, "INSERT INTO test_mysql_exec_select(id, col1) VALUES (1, 'a')", 1);
42 exec_and_count(5, $db, 'SELECT id FROM test_mysql_exec_select', 0);
43 exec_and_count(6, $db, "INSERT INTO test_mysql_exec_select(id, col1) VALUES (2, 'b')", 1);
61 [006] Expecting '1'/integer got ''/boolean when running 'INSERT INTO test_mysql_exec_select(id, col…

Completed in 31 milliseconds

12345678910>>...32