/PHP-7.3/ext/pgsql/tests/ |
H A D | 06copy.phpt | 12 $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 D | 12pg_insert_9.phpt | 19 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
|
H A D | 15pg_delete.phpt | 15 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 D | 98old_api.phpt | 11 $result = pg_exec("SELECT * FROM ".$table_name); 21 $result = pg_exec("INSERT INTO ".$table_name." VALUES (7777, 'KKK')"); 25 $result = pg_exec("UPDATE ".$table_name." SET str = 'QQQ' WHERE str like 'RGD';");
|
H A D | 04async_query.phpt | 12 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 D | 23sync_query_params.phpt | 17 $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 D | 14pg_update.phpt | 18 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 D | 13pg_select_9.phpt | 20 $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";
|
H A D | 14pg_update_9.phpt | 20 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 D | 03sync_query.phpt | 12 $result = pg_query($db, "SELECT * FROM ".$table_name.";"); 55 pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); 56 pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";")); 64 $result = pg_query($db, "INSERT INTO ".$table_name." VALUES (9999, 'ABC');");
|
H A D | 25async_query_params.phpt | 17 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 D | 30nb_async_query_params.phpt | 25 $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 D | 32nb_async_query.phpt | 25 $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 D | config.inc | 10 $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 D | 12pg_insert.phpt | 17 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 D | 13pg_select.phpt | 18 $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 D | 18pg_escape_bytea_before.phpt | 17 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 D | 18pg_escape_bytea_esc.phpt | 17 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 D | 18pg_escape_bytea_hex.phpt | 20 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-7.3/ext/interbase/tests/ |
H A D | interbase.inc | 39 function out_table($table_name) 41 echo "--- $table_name ---\n"; 42 $res = ibase_query("select * from $table_name"); 50 function out_result($result, $table_name = "") 52 echo "--- $table_name ---\n"; 59 function out_result_trap_error($result, $table_name = "") 61 echo "--- $table_name ---\n";
|
/PHP-7.3/ext/oci8/tests/ |
H A D | lob_011.phpt | 15 ".$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 D | lob_030.phpt | 43 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 D | create_table.inc | 6 "DROP TABLE ".$schema.$table_name, 7 …"CREATE TABLE ".$schema.$table_name." (id NUMBER, value NUMBER, blob BLOB, clob CLOB, string VARCH…
|
H A D | lob_035.phpt | 15 ".$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"; 74 $select_sql = "SELECT blob FROM ".$schema.$table_name." WHERE id = 2 FOR UPDATE";
|
H A D | lob_038.phpt | 17 ".$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);
|