Lines Matching refs:st

31 $st = $db->prepare("INSERT INTO test (uid, some_bool_1, some_bool_2, some_int) VALUES (?, ?, ?, ?)"…
39 $st->bindParam(1, $values['uid'], PDO::PARAM_INT);
40 $st->bindParam(2, $values['some_bool_1'], PDO::PARAM_BOOL);
41 $st->bindParam(3, $values['some_bool_2'], PDO::PARAM_BOOL);
42 $st->bindParam(4, $values['some_int'], PDO::PARAM_INT);
44 $result = $st->execute();
47 var_dump($st->errorInfo());
56 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
65 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
66 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
67 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
68 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
70 $result = $st->execute();
73 var_dump($st->errorInfo());
82 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
91 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
92 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
93 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
94 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
96 $result = $st->execute();
99 var_dump($st->errorInfo());
109 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
118 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
119 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
120 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
121 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
123 $result = $st->execute();
126 var_dump($st->errorInfo());
136 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
145 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
146 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
147 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
148 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
150 $result = $st->execute();
153 var_dump($st->errorInfo());
163 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
172 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
173 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
174 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
175 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
177 $result = $st->execute();
180 var_dump($st->errorInfo());