Untitled


 <!DOCTYPE html>
 <html>
      <head>
           <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
           <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
           <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
      </head>
      <body>
           <br />
           <div class="container" style="width:500px;">
                <form method="post">

                     if(isset($error))
                     {
                          echo $error;
                     }
                     ?>
                     <br />
                     <label>Name</label>
                     <input type="text" name="user_name" class="form-control" /><br />
                     <label>Email</label>
                     <input type="text" name="user_email" class="form-control" /><br />
                     <div class="form-group">
					<label>Message</label>
					<textarea class="form-control" rows="4" name="user_message"/></textarea>
			</div>
                     <input type="submit" name="submit" value="Submit" class="btn btn-info" /><br />

                </form>
           </div>
		   <br />
		  <!--end of form, post to sql start-->
		  <?php
		  if(isset($POST["submit"])){
		  $hostname='localhost';
		  $username='root';
		  $password='';

		  try {
		$dbh = new PDO("mysql:host=$hostname;dbname=messages",$username,$password);

		$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line
		$sql = "INSERT INTO contact(user_name, user_email, user_message)
		VALUES ('".$POST["user_name"]."','".$_POST["user_email"]."','".$_POST["user_message"]."')";
		if ($dbh->querty($sql)) {
		echo "<script type= 'text/javascript'>alert('New Record Inserted Succesfully');</script>";
		}
		else{
		echo "<script type= 'text/javascript'>alert('Data not succesfully Inserted.');</script>;
		}
		$dbh = null;
		 }
		catch(PDOException $e)
		{
		echo $e->GetMessage();
		}

		}
		 ?>
      </body>
	</html>