Пример PHP-скрипта с использованием PDO-интерфейса
< ?php $dbh = new PDO("linter:node=;dbname=DEMO","SYSTEM","MANAGER8"); $dbh- >exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))'); $select = $dbh- >prepare('SELECT COUNT(id) FROM test'); $data = array( array('10', 'Abc', 'zxy'), array('20', 'Def', 'wvu'), array('30', 'Ghi', 'tsr'), array('40', 'Jkl', 'qpo'), array('50', 'Mno', 'nml'), array('60', 'Pqr', 'kji'), ); // Insert using question mark placeholders $stmt = $dbh- >prepare("INSERT INTO test VALUES(?, ?, ?)"); foreach ($data as $row) { $stmt- >execute($row); } $select- >execute(); $num = $select- >fetchColumn(); echo 'There are ' . $num . " rows in the table.\n"; $select- >closeCursor(); // Insert using named parameters $stmt2 = $dbh- >prepare("INSERT INTO test VALUES(:first, :second, :third)"); foreach ($data as $row) { $stmt2- >execute(array(':first'= >($row[0] + 5), ':second'= >$row[1], ':third'= >$row[2])); } $select- >execute(); $num = $select- >fetchColumn(); echo 'There are ' . $num . " rows in the table.\n"; $dbh = null; ? >