Home
last modified time | relevance | path

Searched refs:odbc_exec (Results 1 – 25 of 39) sorted by relevance

12

/php-src/ext/odbc/tests/
H A Dodbc_exec_001.phpt2 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 Dbug60616.phpt2 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 Dodbc_exec_002.phpt2 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 Dodbc_primarykeys_001.phpt10 $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 Dodbc_num_rows_001.phpt14 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 Dodbc_num_fields_001.phpt14 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 Dodbc_cursor_001.phpt13 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 Dodbc_commit_001.phpt13 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 Dodbc_rollback_001.phpt13 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 Dodbc_longreadlen_001.phpt13 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 Dbug80147.phpt13 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 Dbug69975.phpt12 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 Dbug68087.phpt2 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 Dodbc_fetch_array_001.phpt14 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 Dbug44618.phpt18 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 Dbug71171.phpt14 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 Dodbc_fetch_object_001.phpt14 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 Dbug69354.phpt14 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 Dodbc_fetch_into_001.phpt14 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 Dodbc_fetch_row_001.phpt14 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 Dodbc_field_num_001.phpt14 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 Dbug80592.phpt12 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 Dodbc_free_result_001.phpt14 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 Dodbc_field_len_001.phpt14 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 Dodbc_field_name_001.phpt14 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');

Completed in 14 milliseconds

12