/php-src/ext/odbc/tests/ |
H A D | odbc_exec_001.phpt | 2 odbc_exec(): Basic test 19 odbc_exec($conn, 'foo'); 21 odbc_exec($conn, ''); 23 odbc_exec($conn, 1); 27 Warning: odbc_exec(): SQL error: %s in %s on line %d 29 Warning: odbc_exec(): SQL error: %s in %s on line %d
|
H A D | bug60616.phpt | 2 odbc_exec(): Getting accurate unicode data from query 14 $result = @odbc_exec($conn, "SELECT @@Version"); 37 odbc_exec($conn, 'CREATE DATABASE bug60616Test ENCODING=\'EUC_JP\''); 38 odbc_exec($conn, 'USE bug60616Test'); 39 odbc_exec($conn, 'CREATE TABLE bug60616 (ID INT, CHAR_COL CHAR(200), VARCHAR_COL VARCHAR(200), TEXT… 40 odbc_exec($conn, "INSERT INTO bug60616(ID, CHAR_COL, VARCHAR_COL, TEXT_COL) VALUES (1, '$euc_jp', '… 42 $res = odbc_exec($conn, 'SELECT * FROM bug60616 ORDER BY ID ASC'); 79 odbc_exec($conn, 'USE bug60616Test'); 80 odbc_exec($conn, 'DROP TABLE bug60616'); 81 odbc_exec($conn, 'DROP DATABASE bug60616Test');
|
H A D | odbc_exec_002.phpt | 2 odbc_exec(): Getting data from query 14 odbc_exec($conn, 'CREATE TABLE exec2 (TEST INT)'); 15 odbc_exec($conn, 'INSERT INTO exec2 VALUES (1), (2)'); 17 $res = odbc_exec($conn, 'SELECT * FROM exec2'); 27 odbc_exec($conn, 'DROP TABLE exec2');
|
H A D | odbc_primarykeys_001.phpt | 10 $result = @odbc_exec($conn, "SELECT @@Version"); 26 odbc_exec($conn, 'CREATE DATABASE PrimarykeysTest'); 27 odbc_exec($conn, 'USE PrimarykeysTest'); 28 odbc_exec($conn, 'CREATE TABLE primarykeys (test INT NOT NULL)'); 34 odbc_exec($conn, 'ALTER TABLE primarykeys ADD CONSTRAINT primarykeys_pk PRIMARY KEY (test)'); 57 odbc_exec($conn, 'USE PrimarykeysTest'); 58 odbc_exec($conn, 'DROP TABLE primarykeys'); 59 odbc_exec($conn, 'USE master'); 60 odbc_exec($conn, 'DROP DATABASE PrimarykeysTest');
|
H A D | odbc_num_rows_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE num_rows (test INT)'); 15 odbc_exec($conn, 'INSERT INTO num_rows VALUES (1), (2), (3)'); 17 $res = odbc_exec($conn, 'SELECT * FROM num_rows'); 21 $res = odbc_exec($conn, 'SELECT * FROM num_rows WHERE test = 4'); 31 odbc_exec($conn, 'DROP TABLE num_rows');
|
H A D | odbc_num_fields_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE num_fields (foo INT, bar INT, baz INT)'); 15 odbc_exec($conn, 'INSERT INTO num_fields VALUES (1, 2, 3)'); 17 $res = odbc_exec($conn, 'SELECT * FROM num_fields'); 21 $res = odbc_exec($conn, 'SELECT * FROM num_fields WHERE foo = 4'); 31 odbc_exec($conn, 'DROP TABLE num_fields');
|
H A D | odbc_cursor_001.phpt | 13 odbc_exec($conn, "CREATE TABLE cursor_table (id INT, whatever TEXT)"); 14 odbc_exec($conn, "INSERT INTO cursor_table VALUES (1, 'whatever')"); 15 $res = odbc_exec($conn, 'SELECT * FROM cursor_table'); 26 odbc_exec($conn, "DROP TABLE cursor_table");
|
H A D | odbc_commit_001.phpt | 13 odbc_exec($conn, 'CREATE TABLE commit_table (test INT)'); 16 odbc_exec($conn, 'INSERT INTO commit_table VALUES(1)'); 19 $res = odbc_exec($conn, 'SELECT * FROM commit_table'); 27 odbc_exec($conn, 'DROP TABLE commit_table');
|
H A D | odbc_rollback_001.phpt | 13 odbc_exec($conn, 'CREATE TABLE rollback_table (test INT)'); 16 odbc_exec($conn, 'INSERT INTO rollback_table VALUES(1)'); 19 $res = odbc_exec($conn, 'SELECT * FROM rollback_table'); 27 odbc_exec($conn, 'DROP TABLE rollback_table');
|
H A D | odbc_longreadlen_001.phpt | 13 odbc_exec($conn, "CREATE TABLE longreadlen (id INT, whatever VARBINARY(50))"); 14 odbc_exec($conn, "INSERT INTO longreadlen VALUES (1, CONVERT(VARBINARY(50), 'whatever'))"); 16 $res = odbc_exec($conn, "SELECT * FROM longreadlen"); 28 odbc_exec($conn, "DROP TABLE longreadlen");
|
H A D | bug80147.phpt | 13 odbc_exec($conn, "CREATE TABLE bug80147 (id INT, whatever VARBINARY(50))"); 14 odbc_exec($conn, "INSERT INTO bug80147 VALUES (1, CONVERT(VARBINARY(50), 'whatever'))"); 16 $res = odbc_exec($conn, "SELECT * FROM bug80147"); 26 odbc_exec($conn, "DROP TABLE bug80147");
|
H A D | bug69975.phpt | 12 odbc_exec($conn, 'CREATE TABLE bug69975 (ID INT, VARCHAR_COL NVARCHAR(MAX))'); 13 odbc_exec($conn, "INSERT INTO bug69975 VALUES (1, 'foo')"); 15 $result = odbc_exec($conn, "SELECT VARCHAR_COL FROM bug69975"); 25 odbc_exec($conn, 'DROP TABLE bug69975');
|
H A D | bug68087.phpt | 2 odbc_exec(): Getting accurate date data from query 17 odbc_exec($conn, 'CREATE TABLE bug68087 (ID INT, VARCHAR_COL VARCHAR(100), DATE_COL DATE)'); 19 odbc_exec($conn, "INSERT INTO bug68087(ID, VARCHAR_COL, DATE_COL) VALUES (1, 'hello', '$id_1_date')… 21 $res = odbc_exec($conn, 'SELECT * FROM bug68087 ORDER BY ID ASC'); 50 odbc_exec($conn, 'DROP TABLE bug68087');
|
H A D | odbc_fetch_array_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE fetch_array (foo INT)'); 15 odbc_exec($conn, 'INSERT INTO fetch_array VALUES (1), (2)'); 17 $res = odbc_exec($conn, 'SELECT * FROM fetch_array'); 29 odbc_exec($conn, 'DROP TABLE fetch_array');
|
H A D | bug44618.phpt | 18 odbc_exec($conn, "CREATE TABLE bug44618(ID INT, real1 REAL, text1 TEXT)"); 19 odbc_exec($conn, "INSERT INTO bug44618 VALUES (1, 10.0199995, 'testing 1,2,3')"); 21 $result = odbc_exec($conn, "SELECT * FROM bug44618"); 25 $result = odbc_exec($conn, "SELECT * FROM bug44618"); 30 $result = odbc_exec($conn, "SELECT * FROM bug44618"); 35 $result = odbc_exec($conn, "SELECT * FROM bug44618"); 43 odbc_exec($conn, "DROP TABLE bug44618");
|
H A D | bug71171.phpt | 14 odbc_exec($conn, 'CREATE TABLE bug71171 (ID INT, VARCHAR_COL NVARCHAR(40))'); 16 odbc_exec($conn, "INSERT INTO bug71171(ID, VARCHAR_COL) VALUES (1, '" . chr(0x81) . "')"); 18 $res = odbc_exec($conn,"SELECT ID FROM bug71171 WHERE VARCHAR_COL = '" . chr(0x81) . "'"); 31 odbc_exec($conn, 'DROP TABLE bug71171');
|
H A D | odbc_fetch_object_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE fetch_object (foo INT)'); 15 odbc_exec($conn, 'INSERT INTO fetch_object VALUES (1), (2)'); 17 $res = odbc_exec($conn, 'SELECT * FROM fetch_object'); 29 odbc_exec($conn, 'DROP TABLE fetch_object');
|
H A D | bug69354.phpt | 14 odbc_exec($conn, 'CREATE TABLE bug69354 (ID INT, VARCHAR_COL VARCHAR(100))'); 16 odbc_exec($conn, "INSERT INTO bug69354(ID, VARCHAR_COL) VALUES (1, '" . str_repeat("a", 100) . "')"… 18 $res = odbc_exec($conn,"SELECT VARCHAR_COL FROM bug69354"); 34 odbc_exec($conn, 'DROP TABLE bug69354');
|
H A D | odbc_fetch_into_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE fetch_into (foo INT)'); 15 odbc_exec($conn, 'INSERT INTO fetch_into VALUES (1), (2)'); 17 $res = odbc_exec($conn, 'SELECT * FROM fetch_into'); 37 odbc_exec($conn, 'DROP TABLE fetch_into');
|
H A D | odbc_fetch_row_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE fetch_row (test INT)'); 16 odbc_exec($conn, 'INSERT INTO fetch_row VALUES (1), (2)'); 18 $res = odbc_exec($conn, 'SELECT * FROM fetch_row'); 40 odbc_exec($conn, 'DROP TABLE fetch_row');
|
H A D | odbc_field_num_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE field_num (foo INT, bar REAL, baz VARBINARY(50))'); 16 $res = odbc_exec($conn, 'SELECT * FROM field_num'); 27 odbc_exec($conn, 'DROP TABLE field_num');
|
H A D | bug80592.phpt | 12 odbc_exec($conn,"CREATE TABLE bug80592 (f1 float not null, f2 float not null, f3 float not null)"); 15 $res = odbc_exec($conn, "SELECT f1, f2, f3 from bug80592"); 23 odbc_exec($conn, "DROP TABLE bug80592");
|
H A D | odbc_free_result_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE free_result (TEST INT NOT NULL)'); 16 odbc_exec($conn, 'INSERT INTO free_result VALUES (1), (2)'); 18 $res = odbc_exec($conn, 'SELECT * FROM free_result'); 55 odbc_exec($conn, 'DROP TABLE free_result');
|
H A D | odbc_field_len_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE field_len (foo INT, bar TEXT, baz VARBINARY(50))'); 16 $res = odbc_exec($conn, 'SELECT * FROM field_len'); 33 odbc_exec($conn, 'DROP TABLE field_len');
|
H A D | odbc_field_name_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE field_name (foo INT, bar INT, baz INT)'); 16 $res = odbc_exec($conn, 'SELECT * FROM field_name'); 32 odbc_exec($conn, 'DROP TABLE field_name');
|