PHPize Online / SQLize Online  /  SQLtest Online

<?php $order_data = array( ":date" => date("j m Y G:i"), ":montant" => $_POST["total_amount"]*100, ":description" => $_POST["item_details"], ":email" => $_POST['email_address'], ":nom" => $_POST["customer_name"], ":prenom" => "John", ":adresse1" => $_POST['customer_address'], ":adresse2" => "---", ":ville" => $_POST['customer_city'], ":CP" => 99999, ); $query = "INSERT INTO commandes (date, montant, description, email, nom, prenom, adresse1, adresse2, ville, CP) VALUES (:date, :montant, :description, :email, :nom, :prenom, :adresse1, :adressse2, :ville, :CP)"; $statement = $pdo->prepare($query); //var_dump($order_data); $statement->execute($order_data);