Originally Posted by Fou-Lu
$dt = new DateTime($dateInCSV);
print $dt->format('Y-m-d h:i:s');
INSERT IGNORE INTO table (field1, field2) VALUES (val1_1, val2_1), (val1_2, val2_2), ...
for insert ignore. Insert ignore is not necessary with prepared statements as you can ignore the execute result.
Agreed on insert Ignore rather I have assigned unique key in my table for email ....I hope that solves my problem.....any suggestions on this?