Lines Matching refs:db
13 $db = MySQLPDOTest::factory();
15 function pdo_mysql_stmt_bindparam_types_do($db, $offset, $native, $sql_type, $value) {
17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
19 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
22 if ((!$stmt = $db->prepare($sql)) || (!$stmt->execute()))
26 $stmt = $db->prepare('INSERT INTO test_stmt_bindparam_types(id, label) VALUES (1, ?)');
38 $stmt = $db->query('SELECT id, label FROM test_stmt_bindparam_types');
87 $db->exec('DROP TABLE IF EXISTS test_stmt_bindparam_types');
91 function pdo_mysql_stmt_bindparam_types($db, $offset, $sql_type, $value) {
92 pdo_mysql_stmt_bindparam_types_do($db, $offset, true, $sql_type, $value);
93 pdo_mysql_stmt_bindparam_types_do($db, $offset, false, $sql_type, $value);
97 // pdo_mysql_stmt_bindparam_types($db, 2, 'BIT(8)', 1);
98 pdo_mysql_stmt_bindparam_types($db, 3, 'TINYINT', -127);
99 pdo_mysql_stmt_bindparam_types($db, 4, 'TINYINT UNSIGNED', 255);
100 pdo_mysql_stmt_bindparam_types($db, 5, 'BOOLEAN', 1);
101 pdo_mysql_stmt_bindparam_types($db, 6, 'SMALLINT', -32768);
102 pdo_mysql_stmt_bindparam_types($db, 7, 'SMALLINT UNSIGNED', 65535);
103 pdo_mysql_stmt_bindparam_types($db, 8, 'MEDIUMINT', -8388608);
104 pdo_mysql_stmt_bindparam_types($db, 9, 'MEDIUMINT UNSIGNED', 16777215);
105 pdo_mysql_stmt_bindparam_types($db, 10, 'INT', -2147483648);
106 pdo_mysql_stmt_bindparam_types($db, 11, 'INT UNSIGNED', 4294967295);
107 pdo_mysql_stmt_bindparam_types($db, 12, 'BIGINT', -1000);
108 pdo_mysql_stmt_bindparam_types($db, 13, 'BIGINT UNSIGNED', 1000);
109 pdo_mysql_stmt_bindparam_types($db, 14, 'REAL', -1000);
110 pdo_mysql_stmt_bindparam_types($db, 15, 'REAL UNSIGNED', 1000);
111 pdo_mysql_stmt_bindparam_types($db, 16, 'REAL ZEROFILL', '0000000000000000000000');
112 pdo_mysql_stmt_bindparam_types($db, 17, 'REAL UNSIGNED ZEROFILL', '0000000000000000000010');
113 pdo_mysql_stmt_bindparam_types($db, 18, 'DOUBLE', -1000);
114 pdo_mysql_stmt_bindparam_types($db, 19, 'DOUBLE UNSIGNED', 1000);
115 pdo_mysql_stmt_bindparam_types($db, 20, 'DOUBLE ZEROFILL', '000000000000');
116 pdo_mysql_stmt_bindparam_types($db, 21, 'DOUBLE ZEROFILL UNSIGNED', '000000001000');
117 pdo_mysql_stmt_bindparam_types($db, 22, 'FLOAT', -1000);
118 pdo_mysql_stmt_bindparam_types($db, 23, 'FLOAT UNSIGNED', 1000);
119 pdo_mysql_stmt_bindparam_types($db, 24, 'FLOAT ZEROFILL', '000000000000');
120 pdo_mysql_stmt_bindparam_types($db, 25, 'FLOAT ZEROFILL UNSIGNED', '000000001000');
121 pdo_mysql_stmt_bindparam_types($db, 26, 'DECIMAL', -1000);
122 pdo_mysql_stmt_bindparam_types($db, 27, 'DECIMAL UNSIGNED', 1000);
123 pdo_mysql_stmt_bindparam_types($db, 28, 'DECIMAL ZEROFILL', '000000000000');
124 pdo_mysql_stmt_bindparam_types($db, 29, 'DECIMAL ZEROFILL UNSIGNED', '000000001000');
125 pdo_mysql_stmt_bindparam_types($db, 30, 'NUMERIC', -1000);
126 pdo_mysql_stmt_bindparam_types($db, 31, 'NUMERIC UNSIGNED', 1000);
127 pdo_mysql_stmt_bindparam_types($db, 32, 'NUMERIC ZEROFILL', '000000000000');
128 pdo_mysql_stmt_bindparam_types($db, 33, 'NUMERIC ZEROFILL UNSIGNED', '000000001000');
129 pdo_mysql_stmt_bindparam_types($db, 34, 'DATE', '2008-04-23');
130 pdo_mysql_stmt_bindparam_types($db, 35, 'TIME', '16:43:12');
131 pdo_mysql_stmt_bindparam_types($db, 36, 'TIMESTAMP', '2008-04-23 16:44:53');
132 pdo_mysql_stmt_bindparam_types($db, 37, 'DATETIME', '2008-04-23 16:44:53');
133 pdo_mysql_stmt_bindparam_types($db, 38, 'YEAR', '2008');
134 pdo_mysql_stmt_bindparam_types($db, 39, 'CHAR(1)', 'a');
135 pdo_mysql_stmt_bindparam_types($db, 40, 'CHAR(255)', 'abc');
136 pdo_mysql_stmt_bindparam_types($db, 41, 'VARCHAR(255)', str_repeat('a', 255));
137 pdo_mysql_stmt_bindparam_types($db, 42, 'BINARY(255)', str_repeat('a', 255));
138 pdo_mysql_stmt_bindparam_types($db, 43, 'VARBINARY(255)', str_repeat('a', 255));
139 pdo_mysql_stmt_bindparam_types($db, 44, 'TINYBLOB', str_repeat('a', 255));
140 pdo_mysql_stmt_bindparam_types($db, 45, 'BLOB', str_repeat('b', 300));
141 pdo_mysql_stmt_bindparam_types($db, 46, 'MEDIUMBLOB', str_repeat('b', 300));
142 pdo_mysql_stmt_bindparam_types($db, 47, 'LONGBLOB', str_repeat('b', 300));
143 pdo_mysql_stmt_bindparam_types($db, 48, 'TINYTEXT', str_repeat('c', 255));
144 pdo_mysql_stmt_bindparam_types($db, 49, 'TINYTEXT BINARY', str_repeat('c', 255));
145 pdo_mysql_stmt_bindparam_types($db, 50, 'TEXT', str_repeat('d', 300));
146 pdo_mysql_stmt_bindparam_types($db, 51, 'TEXT BINARY', str_repeat('d', 300));
147 pdo_mysql_stmt_bindparam_types($db, 52, 'MEDIUMTEXT', str_repeat('d', 300));
148 pdo_mysql_stmt_bindparam_types($db, 53, 'MEDIUMTEXT BINARY', str_repeat('d', 300));
149 pdo_mysql_stmt_bindparam_types($db, 54, 'LONGTEXT', str_repeat('d', 300));
150 pdo_mysql_stmt_bindparam_types($db, 55, 'LONGTEXT BINARY', str_repeat('d', 300));
151 pdo_mysql_stmt_bindparam_types($db, 56, "ENUM('yes', 'no') DEFAULT 'yes'", "no");
152 pdo_mysql_stmt_bindparam_types($db, 57, "SET('yes', 'no') DEFAULT 'yes'", "no");
155 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
163 $db = MySQLPDOTest::factory();
164 $db->exec('DROP TABLE IF EXISTS test_stmt_bindparam_types');
