ICTtask works best with JavaScript enabled.

 

PHP OOP with AJAX CRUD using PDO - Edit or update

Live Demo
post thumbnail
Source Code
Hi there, In previous part we have already made discussing on how to create and select data using Ajax method with Object Oriented PHP script and we have made daynamic database query into DB class. So now we make a method into DB class for update query then go to index.php file and make query for fetch single row for update by useing ajax response without refresh. When we click edit or update button then we will get a id from button data attribute value it is our condition for fetch data from database table. Now we send id to action.php file then action file will be trying to get single row data. Ajax call back function will get single row data by id then we show data on form each field. When we fetch data then our hidden action field value change create to update that means we change action now we when submit form will update. So same form using for update single row data our previous video we make create form. Same functionality for update data by request to action.php file then successfull update so return a string and now ajax call back function get this string after trim for match, if this string will match so show successfull alert. At the same time we update image from upload folder how to do this you can learn by using php unlink function. I hope you understand. Now do this and Fellow our video tutorial We have also provide youtube Video in this post. In next video tutorial we will make discussing on how to select rows from Mysql table by using AJAX response. So please share my post and go to my youtube channel and subscribe and share videos with your friends. Thanks Next Tutorilas Link these:
    Files structure Fellow:
  • Application root folder
    • upload
    • //This Folder into upload image
    • DB.php
    • //This file will handle for database connection and Select, upadte ,insert execute query
    • action.php
    • //This file will handle for update,Select, Insert data into Database Table
    • index.php
    • //This file for upadte , insert form, view data

Sourse Code:

  • DB.php - database connection and query Execute

  • <?php
      
      class DB{
        public $DBconnect;
        private $hostName = "localhost";
        private $userName = "root";
        private $userPass = "";
        private $DBName = "office_employee";
    
        public function __construct(){
          $this->DBConnection();
        }
    
        public function DBConnection(){
          try{
            $this->DBconnect = new PDO('mysql:host='.$this->hostName.';dbname='.$this->DBName,$this->userName,$this->userPass);
          }catch(PDOException $e){
            echo 'Connection Fail..'.$e->getMessage();
          }
        }
        public function insert($table,$data){
          $keys = implode(',', array_keys($data));
          $values = ":".implode(",:", array_keys($data));
    
          $sql = "INSERT INTO $table($keys) VALUES($values)";
          $stmt = $this->DBconnect->prepare($sql);
    
          foreach ($data as $key => $value) {
            $stmt->bindValue(":$key",$value);
          }
          return $stmt->execute(); 
    
    
        } 
        
        public function select($sql){
          $stmt = $this->DBconnect->prepare($sql);
          $stmt->execute();
          return $stmt->fetchAll(PDO::FETCH_ASSOC);
        }
    
        public function update($table,$data,$cond){
          $keys = '';
          foreach ($data as $key => $value) {
            $keys .= "$key=:$key,";
          }
          $keys = rtrim($keys,",");
    
          $sql = "UPDATE $table SET $keys WHERE $cond ";
          $stmt = $this->DBconnect->prepare($sql);
          foreach ($data as $key => $value) {
            $stmt->bindValue(":$key",$value);
          }
    
          return $stmt->execute(); 
        }
    
        public function upload($file){
          $extention = explode('.', $file['name']);
          $newName = rand().'.'.$extention[1];
          $destination = './upload/'.$newName;
          move_uploaded_file($file['tmp_name'], $destination);
          return $newName;
    
        }
        
    
      }
    
    ?>
    
  • action.php

  • 
    
  • index.php

  • 
    
  • Database file sql

  • 
    
    --
    -- Database: `office_employee`
    --
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `tbl_employee_info`
    --
    
    CREATE TABLE `tbl_employee_info` (
      `id` int(11) NOT NULL,
      `image` varchar(255) NOT NULL,
      `name` varchar(255) NOT NULL,
      `designation` varchar(255) NOT NULL,
      `sex` varchar(255) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    --
    -- Dumping data for table `tbl_employee_info`
    --
    
    INSERT INTO `tbl_employee_info` (`id`, `image`, `name`, `designation`, `sex`) VALUES
    (19, '6955.jpg', 'Roman Mondol', 'Teacher', '1'),
    (49, '31792.jpg', 'Programmer Rayhan', 'Software Engineer (JAVA and PHP)', '1'),
    (50, '12457.png', 'Aslam Khan', 'Telecommunication Enginner', '1'),
    (53, '11100.jpg', 'Cara Stevens', 'Software Engineer', '2');
    
    --
    -- Indexes for dumped tables
    --
    
    --
    -- Indexes for table `tbl_employee_info`
    --
    ALTER TABLE `tbl_employee_info`
      ADD PRIMARY KEY (`id`);
    
    --
    -- AUTO_INCREMENT for dumped tables
    --
    
    --
    -- AUTO_INCREMENT for table `tbl_employee_info`
    --
    ALTER TABLE `tbl_employee_info`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    
    
    

    Browse by Category

    php Ajax jQuery Codeigniter html css javascript

    Hi there! I am Rayhan Mondol, a PHP & JAVA Developer and ICT task is my programming blog. I'm fond of developing modern web applications. Contact me, I accept the paid task

    Latest Article

    post thumbnail

    Ajax Shopping Cart Customer Order View & account Update by using PHP OOP PDO(E-Commerce website-part 10)

    post thumbnail

    customer accout logout by using PHP OOP, PDO,COOKIE,AJAX(E-Commerce website-part 9)

    post thumbnail

    Customer Account Login by using PHP OOP PDO,AJAX (E-Commerce website-part 8)

    post thumbnail

    Customer Account Create by using PHP OOP PDO (E-Commerce website-part 7)

    post thumbnail

    Remove product from cart by using PHP OOP PDO(E-Commerce website-part 6)

    post thumbnail

    Ajax Shopping Cart update or Edit by using PHP OOP PDO (E-Commerce website-part 5)

    post thumbnail

    Ajax Shopping Cart View and calculate by using PHP OOP PDO (E-Commerce website-part 4)

    post thumbnail

    Drag and Drop Product Add to Cart by using PHP OOP PDO Ajax Jquery - E-Commerce project- (part-3)

    post thumbnail

    Product Add to Cart using PHP OOP PDO Ajax JQuery - E-Commerce project- (part-2)

    post thumbnail

    Create Dynamic Tabs using PHP OOP PDO - E-Commerce project- (part-1)

    post thumbnail

    CodeIgniter AJAX CRUD using Bootstrap Modal - Delete

    post thumbnail

    CodeIgniter AJAX CRUD using Bootstrap Modal Edit or Update

    post thumbnail

    CodeIgniter AJAX CRUD using Bootstrap Modal Read or view

    post thumbnail

    CodeIgniter AJAX CRUD using Bootstrap Modal-Create

    post thumbnail

    CodeIgniter AJAX CRUD(setup removing index.php from url)