Lines Matching refs:stmt
32 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)');
33 $stmt->bindValue(1, 1);
34 $stmt->bindValue(2, $value);
35 if (!$stmt->execute()) {
37 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true));
41 $stmt = $db->query('SELECT id, label FROM test');
43 $stmt->bindColumn(1, $id, PDO::PARAM_INT);
44 $stmt->bindColumn(2, $label, PDO::PARAM_LOB);
46 if (!$stmt->fetch(PDO::FETCH_BOUND)) {
48 $offset, $stmt->errorCode(), var_export($stmt->errorInfo(), true));
70 $stmt = $db->query('SELECT id, label FROM test');
71 $ret = $stmt->fetch(PDO::FETCH_ASSOC);