Lines Matching refs:id

20         $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
27 $id = $label = null;
29 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
38 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
40 var_export($id, true), gettype($id),
46 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
48 var_export($id, true), gettype($id),
53 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (100, ?)');
64 $stmt = $db->prepare('SELECT id, NULL AS _label FROM test WHERE label IS NULL');
67 $id = $label = 'bogus';
68 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
77 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
79 var_export($id, true), gettype($id),
128 in = 0 -> id = 1 (integer) / label = 'a' (string)
129 in = 0 -> id = 2 (integer) / label = 'b' (string)
131 in = 0 -> id = 1 (integer) / label = 'a' (string)
132 in = 0 -> id = 2 (integer) / label = 'b' (string)
134 in = 0 -> id = 100 (integer) / label = NULL (NULL)
136 in = 0 -> id = 1 (integer) / label = 'a' (string)
137 in = 0 -> id = 2 (integer) / label = 'b' (string)
139 in = 0 -> id = 1 (integer) / label = 'a' (string)
140 in = 0 -> id = 2 (integer) / label = 'b' (string)
142 in = 0 -> id = 100 (integer) / label = NULL (NULL)
145 in = 0 -> id = 1 (integer) / label = 'a' (string)
146 in = 0 -> id = 2 (integer) / label = 'b' (string)
148 in = 0 -> id = 1 (integer) / label = 'a' (string)
149 in = 0 -> id = 2 (integer) / label = 'b' (string)
151 in = 0 -> id = 100 (integer) / label = NULL (NULL)
153 in = 0 -> id = 1 (integer) / label = 'a' (string)
154 in = 0 -> id = 2 (integer) / label = 'b' (string)
156 in = 0 -> id = 1 (integer) / label = 'a' (string)
157 in = 0 -> id = 2 (integer) / label = 'b' (string)
159 in = 0 -> id = 100 (integer) / label = NULL (NULL)