· 8 years ago · Dec 10, 2017, 05:00 AM
1 # insert into database
2 $conn = new PDO("mysql:host=$servername;dbname=LandingPage", $username, $password);
3 $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
4 $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)";
5 echo $sql;
6 $pdo->prepare($sql)->execute();