ZMwMWQrv

1          $conn = new PDO("mysql:host=$servername;dbname=LandingPage", $username, $password);
2          $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
3    //      //$sql = "CREATE TABLE IF NOT EXISTS messages_received (id INT NOT NULL AUTOINCREMENT, from_name VARCHAR(300), from_email VARCHAR(256), domain_name VARCHAR(500), offer FLOAT, message VARCHAR(5000), date DATE)";
4    //      //$conn->prepare($sql)->execute();
5    ///      //$sql_result = $conn->query($sql);
6          //$sql = "INSERT INTO messages_received (id,from_name,from_email,domain_name,offer,message,date) VALUES (?,?,?,?,?,?,?)";
7          $stmt = $conn->prepare("INSERT INTO messages_received (id,from_name,from_email,domain_name,offer,message,date) VALUES (?,?,?,?,?,?,?)");
8          $stmt->bind_param(0,$name,$clientEmail,$domain_name,$offer,$message,now());
9          $stmt->execute();