Lines Matching refs:id
22 $stmt = $db->prepare("SELECT id, label FROM {$table} WHERE id > ? ORDER BY id ASC LIMIT 2");
29 $id = $label = null;
31 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
40 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
42 var_export($id, true), gettype($id),
48 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
50 var_export($id, true), gettype($id),
55 $stmt = $db->prepare("INSERT INTO {$table}(id, label) VALUES (100, ?)");
66 $stmt = $db->prepare("SELECT id, NULL AS _label FROM {$table} WHERE label IS NULL");
69 $id = $label = 'bogus';
70 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
79 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
81 var_export($id, true), gettype($id),
131 in = 0 -> id = 1 (integer) / label = 'a' (string)
132 in = 0 -> id = 2 (integer) / label = 'b' (string)
134 in = 0 -> id = 1 (integer) / label = 'a' (string)
135 in = 0 -> id = 2 (integer) / label = 'b' (string)
137 in = 0 -> id = 100 (integer) / label = NULL (NULL)
139 in = 0 -> id = 1 (integer) / label = 'a' (string)
140 in = 0 -> id = 2 (integer) / label = 'b' (string)
142 in = 0 -> id = 1 (integer) / label = 'a' (string)
143 in = 0 -> id = 2 (integer) / label = 'b' (string)
145 in = 0 -> id = 100 (integer) / label = NULL (NULL)
148 in = 0 -> id = 1 (integer) / label = 'a' (string)
149 in = 0 -> id = 2 (integer) / label = 'b' (string)
151 in = 0 -> id = 1 (integer) / label = 'a' (string)
152 in = 0 -> id = 2 (integer) / label = 'b' (string)
154 in = 0 -> id = 100 (integer) / label = NULL (NULL)
156 in = 0 -> id = 1 (integer) / label = 'a' (string)
157 in = 0 -> id = 2 (integer) / label = 'b' (string)
159 in = 0 -> id = 1 (integer) / label = 'a' (string)
160 in = 0 -> id = 2 (integer) / label = 'b' (string)
162 in = 0 -> id = 100 (integer) / label = NULL (NULL)