pdo example

pdo.php

<?php

//..

$foo = "foofoo";
$bar = "barbar";

$conn = new PDO('mysql:host=yourserverip;dbname=yourdatabasename', 'username', 'password');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

foreach (...) {
    $sth = $conn->prepare("INSERT INTO db (foo,bar) VALUES (:foo, :bar)");
    $sth->bindParam(':foo', $foo);
    $sth->bindParam(':bar', $bar);
    $sth->execute();
}