Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!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">
- <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>
Add Comment
Please, Sign In to add comment