lundi 21 décembre 2015

Insert data in SQLite database with PDO PHP

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