--TEST-- PDO Common: bindValue --EXTENSIONS-- pdo --SKIPIF-- --FILE-- exec('CREATE TABLE test028(id int NOT NULL PRIMARY KEY, val1 VARCHAR(10), val2 VARCHAR(10), val3 VARCHAR(10))'); $stmt = $db->prepare('INSERT INTO test028 values (1, ?, ?, ?)'); $data = array("one", "two", "three"); foreach ($data as $i => $v) { $stmt->bindValue($i+1, $v); } $stmt->execute(); $stmt = $db->prepare('SELECT * from test028'); $stmt->execute(); var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); ?> --CLEAN-- --EXPECT-- array(1) { [0]=> array(4) { ["id"]=> string(1) "1" ["val1"]=> string(3) "one" ["val2"]=> string(3) "two" ["val3"]=> string(5) "three" } }