1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
define('DB_USER', 'root');
define('DB_PASSWORD', '');
define('DB_CONNECTION_STRING', 'mysql:host=localhost;dbname=test');
function insertdb($email) {
global $db;
$sql = 'INSERT INTO duplicate (email) VALUES (:email)';
$statement = $db->prepare($sql);
$statement->bindValue(':email', $email);
if ( $statement->execute() ) return $db->lastInsertId();
else return $statement->errorInfo();
}
$db = new PDO(DB_CONNECTION_STRING, DB_USER, DB_PASSWORD);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->query('SET NAMES utf8');
$email = 'bmw@yahoo.fr';
$user = insertdb($email);
$erreur =& $user; |