Lines Matching refs:st

33 $st = $db->prepare("INSERT INTO test (uid, some_bool_1, some_bool_2, some_int) VALUES (?, ?, ?, ?)"…
41 $st->bindParam(1, $values['uid'], PDO::PARAM_INT);
42 $st->bindParam(2, $values['some_bool_1'], PDO::PARAM_BOOL);
43 $st->bindParam(3, $values['some_bool_2'], PDO::PARAM_BOOL);
44 $st->bindParam(4, $values['some_int'], PDO::PARAM_INT);
46 $result = $st->execute();
49 var_dump($st->errorInfo());
58 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
67 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
68 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
69 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
70 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
72 $result = $st->execute();
75 var_dump($st->errorInfo());
84 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
93 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
94 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
95 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
96 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
98 $result = $st->execute();
101 var_dump($st->errorInfo());
111 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
120 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
121 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
122 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
123 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
125 $result = $st->execute();
128 var_dump($st->errorInfo());
138 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
147 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
148 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
149 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
150 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
152 $result = $st->execute();
155 var_dump($st->errorInfo());
165 $st = $db->prepare("UPDATE test SET some_bool_1=?, some_bool_2=?, some_int=? WHERE uid=?");
174 $st->bindParam(1, $values['some_bool_1'], PDO::PARAM_BOOL);
175 $st->bindParam(2, $values['some_bool_2'], PDO::PARAM_BOOL);
176 $st->bindParam(3, $values['some_int'], PDO::PARAM_INT);
177 $st->bindParam(4, $values['uid'], PDO::PARAM_INT);
179 $result = $st->execute();
182 var_dump($st->errorInfo());