<?php $db = new PDO("sqlite::memory:"); $db->setAttribute( # raise exceptions PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->query( # you already have a table "CREATE TABLE data (one INT, two INT, three INT, four INT, five INT);"); $stmt = $db->prepare( # prepare query, one placeholding ? for each column left of VALUES "INSERT INTO data (one, two, three, four, five) VALUES(?, ?, ?, ?, ?);"); foreach ([ [1,2,3,4,5], # a row from csv [6,7,8,9,0] # another row from csv ] as $row) { $stmt->execute($row); } $result = $db->query("SELECT * FROM data"); # show it was inserted while ($row = $result->fetch(PDO::FETCH_ASSOC)) { var_dump($row); } ?>
You have javascript disabled. You will not be able to edit any code.