Home
last modified time | relevance | path

Searched refs:table_name (Results 1 – 25 of 88) sorted by relevance

1234

/PHP-8.0/ext/pgsql/tests/
H A D12pg_insert_9.phpt19 pg_insert($db, $table_name, $fields) or print "Error in test 1\n";
20 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING)."\n";
21 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
22 var_dump( pg_insert($db, $table_name, $fields, PGSQL_DML_EXEC) ); // Return resource
26 $converted = pg_insert($db, $table_name, [5 => 'AAA']);
31 $converted = pg_insert($db, $table_name, ['AAA']);
36 $converted = pg_insert($db, $table_name, ['num' => []]);
41 $converted = pg_insert($db, $table_name, ['num' => new stdClass()]);
46 $converted = pg_insert($db, $table_name, ['num' => $db]);
H A D13pg_select_9.phpt20 $res = pg_select($db, $table_name, $ids) or print "Error\n";
22 echo pg_select($db, $table_name, $ids, PGSQL_DML_STRING)."\n";
23 echo pg_select($db, $table_name, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
27 $converted = pg_select($db, $table_name, [5 => 'AAA']);
32 $converted = pg_select($db, $table_name, ['AAA']);
37 $converted = pg_select($db, $table_name, ['num' => []]);
42 $converted = pg_select($db, $table_name, ['num' => new stdClass()]);
47 $converted = pg_select($db, $table_name, ['num' => $db]);
H A D06copy.phpt12 $rows = pg_copy_to($db, $table_name);
14 pg_query($db, "DELETE FROM $table_name");
16 pg_copy_from($db, $table_name, $rows);
H A D10pg_convert_9.phpt18 $converted = pg_convert($db, $table_name, $fields);
24 $converted = pg_convert($db, $table_name, [5 => 'AAA']);
29 $converted = pg_convert($db, $table_name, ['AAA']);
34 $converted = pg_convert($db, $table_name, ['num' => []]);
39 $converted = pg_convert($db, $table_name, ['num' => new stdClass()]);
44 $converted = pg_convert($db, $table_name, ['num' => $db]);
H A D15pg_delete.phpt15 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING)."\n";
16 echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
17 if (!pg_delete($db, $table_name, $ids)) {
H A D04async_query.phpt12 if (!pg_send_query($db, "SELECT * FROM ".$table_name.";")) {
44 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
45 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";"));
53 if (!pg_send_query($db, "INSERT INTO ".$table_name." VALUES (8888, 'GGG');"))
H A D23sync_query_params.phpt17 $result = pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100));
40 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
41 … pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
49 …$result = pg_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'BC…
H A D14pg_update.phpt18 pg_update($db, $table_name, $fields, $ids) or print "Error in test 1\n";
19 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING)."\n";
20 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
H A D14pg_update_9.phpt20 pg_update($db, $table_name, $fields, $ids) or print "Error in test 1\n";
21 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING)."\n";
22 echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
H A D25async_query_params.phpt17 if (!pg_send_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100))) {
48 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
49 … pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
57 …if (!pg_send_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'BC…
H A Dconfig.inc10 $table_name = "php_pgsql_test"; // test table that will be created
16 $view_def = "CREATE VIEW {$view_name} AS SELECT * FROM {$table_name};";
19 $table_def = "CREATE TABLE ${table_name} (num int, str text, bin bytea);";
H A D30nb_async_query_params.phpt25 $sent = pg_send_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100));
53 pg_num_rows(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
54 pg_num_fields(pg_query_params($db, "SELECT * FROM ".$table_name." WHERE num > \$1;", array(100)));
62 $sent = pg_send_query_params($db, "INSERT INTO ".$table_name." VALUES (\$1, \$2);", array(9999, "A'…
H A D32nb_async_query.phpt25 $nb_send = pg_send_query($db, "SELECT * FROM ".$table_name.";");
54 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
55 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";"));
63 $nb_send = pg_send_query($db, "INSERT INTO ".$table_name." VALUES (8888, 'GGG');");
H A D12pg_insert.phpt17 pg_insert($db, $table_name, $fields) or print "Error in test 1\n";
18 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING)."\n";
H A D13pg_select.phpt18 $res = pg_select($db, $table_name, $ids) or print "Error\n";
20 echo pg_select($db, $table_name, $ids, PGSQL_DML_STRING)."\n";
H A D18pg_escape_bytea_before.phpt17 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, E\''.$esc_image.'\');');
18 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D18pg_escape_bytea_esc.phpt17 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
18 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
H A D18pg_escape_bytea_hex.phpt20 pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
21 $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
/PHP-8.0/ext/oci8/tests/
H A Dcreate_table.inc6 "DROP TABLE ".$schema.$table_name,
7 …"CREATE TABLE ".$schema.$table_name." (id NUMBER, value NUMBER, blob BLOB, clob CLOB, string VARCH…
H A Dlob_011.phpt15 ".$schema.$table_name." (id, blob)
30 ".$schema.$table_name." (id, blob)
43 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 1";
49 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
60 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
H A Dlob_030.phpt43 insert_verify($c, $schema.$table_name, 1, 1050000);
46 insert_verify($c, $schema.$table_name, 2, 1050001);
49 insert_verify($c, $schema.$table_name, 3, 1048576);
52 insert_verify($c, $schema.$table_name, 4, 1049028);
55 insert_verify($c, $schema.$table_name, 5, 1049028-1);
58 insert_verify($c, $schema.$table_name, 6, 1049028+1);
H A Dlob_035.phpt15 ".$schema.$table_name." (id, blob)
31 ".$schema.$table_name." (id, blob)
44 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 1";
50 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
87 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
H A Dlob_038.phpt17 ".$schema.$table_name." (clob)
39 $s = oci_parse($c,"select clob from ".$schema.$table_name);
49 $s = oci_parse($c, "select clob from ".$schema.$table_name);
65 ".$schema.$table_name." (blob)
86 $s = oci_parse($c, "select blob from ".$schema.$table_name);
93 $s = oci_parse($c, "select blob from ".$schema.$table_name);
H A Dlob_037.phpt16 ".$schema.$table_name." (blob)
33 ".$schema.$table_name." (blob)
50 $ora_sql = "SELECT blob FROM ".$schema.$table_name;
H A Dpecl_bug10194.phpt21 ".$schema.$table_name." (clob)
28 $ora_sql = "SELECT clob FROM ".$schema.$table_name." FOR UPDATE";
42 $ora_sql = "SELECT clob FROM ".$schema.$table_name."";

Completed in 24 milliseconds

1234