Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- try{
- $pdo = new PDO('mysql:host=localhost;dbname=ajax','root','');
- $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
- }catch(PDOException $e){
- echo 'Page not connected';
- }
- $name = $_POST['name'];
- $age = $_POST['age'];
- try{
- $sql = 'INSERT INTO user(name,age) VALUES (:nme,:ag) ';
- $data = $pdo->prepare($sql);
- $data->bindValue(':nme',$name);
- $data->bindValue(':ag',$age);
- $data->execute();
- }catch(PDOException $e){
- echo $e->getMessage();
- }
- if($data->rowCount() > 0){
- echo 'Data Inserted';
- }
- else{
- echo 'Data cannot be inserted';
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement