Advertisement
Shashi27

process.php

Jul 14th, 2014
230
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.57 KB | None | 0 0
  1. <?php
  2.  
  3. try{
  4.     $pdo = new PDO('mysql:host=localhost;dbname=ajax','root','');
  5.     $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
  6. }catch(PDOException $e){
  7.     echo 'Page not connected';
  8. }
  9. $name = $_POST['name'];
  10. $age = $_POST['age'];
  11.  
  12. try{
  13.     $sql = 'INSERT INTO user(name,age) VALUES (:nme,:ag) ';
  14.     $data = $pdo->prepare($sql);
  15.     $data->bindValue(':nme',$name);
  16.     $data->bindValue(':ag',$age);
  17.     $data->execute();
  18. }catch(PDOException $e){
  19.     echo $e->getMessage();
  20. }
  21.  
  22. if($data->rowCount() > 0){
  23.     echo 'Data Inserted';
  24. }
  25. else{
  26.     echo 'Data cannot be inserted';
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement