Yes, BobRay, i think it will do the job.
But i want be clear, so i rewrite my script to work with Pdo. But it doesn't work for me, maybe you can help me with some corrects on it. Code looks like this:
$xpdo = new xPDO($dsn,'root','');
echo $o=($xpdo->connect()) ? 'Connected' : 'Not Connected';
$xpdo->addPackage('csvcars','C:/xampplite/htdocs/atlanticauto/core/model/');
$manager = $xpdo->getManager();
$manager->removeObjectContainer('csvCar') ? 'Removed' : 'Not removed';
$manager->createObjectContainer('csvCar') ? 'Created' : 'Not created';
$table = $xpdo->getTableName('csvCar');
$sql = "INSERT INTO {$table} (lot, vin, image, saledata, year, make, model, place, odometer, bid, damage, repair, bodystyle, color, engine, drive, fuel, cylinders, acv, secdamage, keys, note, facility, saletime, salezone, salestatus, titlestate, titletype) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$q = $xpdo->prepare($sql);
$fp = fopen("C:/xampplite/htdocs/atlanticauto/salesdata_250.csv", "r");
$k = 0;
while (($line = fgets($fp, 4096)) !== false) {
$fields = explode(',', $line);
$q->execute(array(
$fields[7],
$fields[21],
$fields[40],
$fields[2],
$fields[9],
$fields[10],
$fields[12],
$fields[35],
$fields[22],
$fields[33],
$fields[15],
$fields[25],
$fields[13],
$fields[14],
$fields[26],
$fields[27],
$fields[29],
$fields[30],
$fields[24],
$fields[16],
$fields[19],
$fields[34],
$fields[1],
$fields[4],
$fields[5],
$fields[32],
$fields[17],
$fields[18],
));
echo $fields[7];
echo "
";
}
fclose($fp);
No errors, only empty database. I allready try with q->bindValue() and rewrite it to q->execute(array()), but still the same. Thx.
