Lines Matching refs:sql

42         $sql = "SELECT * FROM testdata WHERE keyword=?";
44         $stmt = $db->query($sql, ['music']);
55         $sql = "SELECT ? AS first, ? AS second, ? AS third";
57         $result = $db->queryRecord($sql, ['one', 'two', 'three']);
60         $result = $db->queryRecord($sql, 'one', 'two', 'three');
63         $sql = "SELECT :first AS first, :second AS second, :third AS third";
65         $result = $db->queryRecord($sql, ['first' => 'one', 'second' => 'two', 'third' => 'three']);
73         $sql = "INSERT INTO testdata (keyword, value) VALUES (?, ?)";
74         $insid = $db->exec($sql, ['test', 'test']);
77         $sql = "UPDATE testdata SET value=? WHERE keyword=?";
78         $affected = $db->exec($sql, ['test2', 'music']);
86         $sql = "SELECT * FROM testdata WHERE keyword=?";
88         $result = $db->queryAll($sql, ['music']);
97         $sql = "SELECT * FROM testdata WHERE tid=?";
99         $result = $db->queryRecord($sql, [4]);
130         $sql = "SELECT value FROM testdata WHERE tid=?";
132         $result = $db->queryValue($sql, [4]);
141         $sql = "SELECT keyword, value FROM testdata ORDER BY tid";
142         $result = $db->queryKeyValueList($sql);
147         $sql = "SELECT value, keyword FROM testdata";
148         $result = $db->queryKeyValueList($sql);