Lines Matching refs:idx
23 $db->exec('CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))');
28 $stmt1 = $db->prepare('SELECT COUNT(idx) FROM test');
29 $stmt2 = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
41 $stmt2->bindColumn('idx', $idx);
46 var_dump(array($idx=>$txt));
51 $stmt3 = $db->prepare('SELECT txt FROM test WHERE idx=:inp');
52 $stmt3->bindParam('inp', $idx); /* by foreign name */
54 $stmt4 = $db->prepare('SELECT idx FROM test WHERE txt=:txt');
57 foreach($cont as $idx => $txt)
59 var_dump(array($idx=>$txt));
62 if ($idx == 0) {
71 if ($idx == 0) {
74 $stmt4->bindColumn('idx', $col2);
83 $stmt4->bindColumn('idx', $col1);
85 foreach($cont as $idx => $txt)
87 var_dump(array($idx=>$txt));
100 $stmt2->bindColumn('idx', $col1);
