Lines Matching refs:idx
22 $db->exec('CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))');
27 $stmt1 = $db->prepare('SELECT COUNT(idx) FROM test');
28 $stmt2 = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
40 $stmt2->bindColumn('idx', $idx);
45 var_dump(array($idx=>$txt));
50 $stmt3 = $db->prepare('SELECT txt FROM test WHERE idx=:inp');
51 $stmt3->bindParam(':inp', $idx); /* by foreign name */
53 $stmt4 = $db->prepare('SELECT idx FROM test WHERE txt=:txt');
56 foreach($cont as $idx => $txt)
58 var_dump(array($idx=>$txt));
61 if ($idx == 0) {
70 if ($idx == 0) {
73 $stmt4->bindColumn('idx', $col2);
82 $stmt4->bindColumn('idx', $col1);
84 foreach($cont as $idx => $txt)
86 var_dump(array($idx=>$txt));
99 $stmt2->bindColumn('idx', $col1);
