Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $_POST = $_SESSION;
- $servername = "localhost";
- $username = "****";
- $password = "****";
- $dbname = "****";
- $data = array('name' => $_POST['name'], 'email' => $_POST['email'], 'age' => $_POST['age'], 'gender' => $_POST['gender'], 'optIn' => $_POST['optIn']);
- try {
- $dbh = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
- $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $query = "INSERT INTO patientInfo (pfirstName, pemail, page, pgender, poptIn) VALUES (:name, :email, :age, :gender, :optIn)";
- $sth = $dbh->prepare($query);
- $sth->execute($data);
- }
- catch(PDOException $e)
- {
- echo $sql . "<br>" . $e->getMessage();
- }
- $dbh = null;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement