Lines Matching refs:id

19         $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
26 $id = $label = null;
28 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
37 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
39 var_export($id, true), gettype($id),
45 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
47 var_export($id, true), gettype($id),
52 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (100, ?)');
63 $stmt = $db->prepare('SELECT id, NULL AS _label FROM test WHERE label IS NULL');
66 $id = $label = 'bogus';
67 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
76 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
78 var_export($id, true), gettype($id),
127 in = 0 -> id = 1 (integer) / label = 'a' (string)
128 in = 0 -> id = 2 (integer) / label = 'b' (string)
130 in = 0 -> id = 1 (integer) / label = 'a' (string)
131 in = 0 -> id = 2 (integer) / label = 'b' (string)
133 in = 0 -> id = 100 (integer) / label = NULL (NULL)
135 in = 0 -> id = 1 (integer) / label = 'a' (string)
136 in = 0 -> id = 2 (integer) / label = 'b' (string)
138 in = 0 -> id = 1 (integer) / label = 'a' (string)
139 in = 0 -> id = 2 (integer) / label = 'b' (string)
141 in = 0 -> id = 100 (integer) / label = NULL (NULL)
144 in = 0 -> id = 1 (integer) / label = 'a' (string)
145 in = 0 -> id = 2 (integer) / label = 'b' (string)
147 in = 0 -> id = 1 (integer) / label = 'a' (string)
148 in = 0 -> id = 2 (integer) / label = 'b' (string)
150 in = 0 -> id = 100 (integer) / label = NULL (NULL)
152 in = 0 -> id = 1 (integer) / label = 'a' (string)
153 in = 0 -> id = 2 (integer) / label = 'b' (string)
155 in = 0 -> id = 1 (integer) / label = 'a' (string)
156 in = 0 -> id = 2 (integer) / label = 'b' (string)
158 in = 0 -> id = 100 (integer) / label = NULL (NULL)