_class_store.php

<?php
class person
{
        private $name;
        private $address;
        private $dob;
        private $id;
        public function __construct($_name,$_address,$_dob)
        {
        $this->name=$_name;
        $this->address=$_address;
        $this->dob = $_dob;
        }

        /*public function GetInfo()
        {
                echo 'Name - '.$this->name.'Address - '.$this->address.'Contact Info - '.$this->ContactNo;
        }*/

        public function add(){
                $db_user = 'root';
                $db_password = '';
                        try{
                                $con = new PDO('mysql:host=localhost;dbname=sdglhm',$db_user,$db_password);
                                $con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

                                $query = 'INSERT INTO `user`(`usr_id`, `usr_name`, `usr_dob`, `usr_addr`) VALUES (NULL,:in_usr_name,:in_usr_dob,:in_usr_addr)';
                                $buld = $con->prepare($query);
                                $array = array(':in_usr_name'=>$this->name,':in_usr_dob'=>$this->dob,':in_usr_addr'=>$this->address);
                                $buld->execute($array);
                                return 'Table update success !';
                                }
                        catch(PDOExeption $e){
                                return 'Database connection error. : '.$e;
                                }
                }

        public function update($_id){
                        $db_user = 'root';
                        $db_password = '';
                        $this->id = $_id;
                        try{
                                $con = new PDO('mysql:host=localhost;dbname=sdglhm',$db_user,$db_password);
                                $con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

                                $query = 'UPDATE `user` SET `usr_name`=:in_usr_name,`usr_dob`=:in_usr_dob,`usr_addr`=:in_usr_addr WHERE `usr_id` = :usr_id LIMIT 1';
                                $buld = $con->prepare($query);
                                $array = array(':in_usr_name'=>$this->name,':in_usr_dob'=>$this->dob,':in_usr_addr'=>$this->address,':usr_id'=>$this->id);
                                $buld->execute($array);

                                return 'Table update success !';
                                }
                        catch(PDOExeption $e){
                                return 'Database connection error. : '.$e;
                                }
                }
}