I try to insert an e-mail adress into SQLite database with PDO in PHP but the query return false. The code is:
define('ADRESSESTABLE', 'destinatars');
define('EMAILCOLUMN', 'mail_adress');
function subscribe($emailAdress) {
if(filter_var($emailAdress, FILTER_VALIDATE_EMAIL)) {
$db=new PDO('sqlite:/newsletter.db');
$emailAdress=$db->quote($emailAdress);
if($db->query("INSERT INTO ADRESSESTABLE (EMAILCOLUMN) VALUES ($emailAdress);")) {
return true;
} else {
return false;
}
} else {
return false;
}
} // end function validateSubscription
Aucun commentaire:
Enregistrer un commentaire