Advertisement
Guest User

Untitled

a guest
Apr 8th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. <?php
  2. session_start();
  3. $_POST = $_SESSION;
  4.  
  5. $servername = "localhost";
  6. $username = "****";
  7. $password = "****";
  8. $dbname = "****";
  9.  
  10. $data = array('name' => $_POST['name'], 'email' => $_POST['email'], 'age' => $_POST['age'], 'gender' => $_POST['gender'], 'optIn' => $_POST['optIn']);
  11.  
  12. try {
  13.     $dbh = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  14.     $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  15.     $query = "INSERT INTO patientInfo (pfirstName, pemail, page, pgender, poptIn) VALUES (:name, :email, :age, :gender, :optIn)";  
  16.     $sth = $dbh->prepare($query);
  17.     $sth->execute($data);
  18.     }
  19. catch(PDOException $e)
  20.     {
  21.     echo $sql . "<br>" . $e->getMessage();
  22.     }
  23. $dbh = null;
  24.  
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement