Lines Matching refs:stmt
13 $stmt = $db->query('SELECT VERSION() as _version');
14 $row = $stmt->fetch(PDO::FETCH_ASSOC);
39 $stmt = $db->prepare('INSERT INTO test(id, mybool) VALUES (?, ?)');
40 $stmt->bindParam(1, $id);
41 $stmt->bindParam(2, $mybool, PDO::PARAM_BOOL);
44 $stmt->execute();
47 $stmt = $db->query('SELECT * FROM test');
48 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
50 $stmt = $db->prepare('INSERT INTO test(id, mybool) VALUES (?, ?)');
51 $stmt->bindParam(1, $id);
53 $stmt->bindParam(2, $mybool, PDO::PARAM_INT);
54 $stmt->execute();
56 $stmt = $db->query('SELECT * FROM test');
57 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));