ICTtask works best with JavaScript enabled.

 

PHP OOP with AJAX CRUD using PDO - Insert or Create

Live Demo
post thumbnail
Source Code
Hi there, From this post you can learn How to make AJAX CRUD using PHP OOP PDO - Insert or Add or Create. So In this tutorial we have discuss how can we Insert data into Database table. If you are looking for more CRUD system by using procedural form on more important topic like PHP Object Oriented Crud system by using Ajax Jquery Response. Our Previous tutorials we show crud system just simple Dynamic database query in this CURD system we will learn full Dynamically. So now create a file DB.php in this file we will make database connnction by using PDO class on constructor load host Name,database name,user name and password. We define a property in this property we set object of pdo class. Then we will access method and property of PDO class for makeing database query. We have create a Database name is 'office_employee' I have also provide sql file in this tutorial please see. Now We create a method in DB class it's name is insert, this insert method will be try to insert data daynamically just fellow my video tutorial you understand how to do this. We have already create a index.php file for html markup. so now need a create form for this.We used to bootstrap collapse with propeller framework. Then if submit form so we will be validation each field by using jquery with validation image file format. Then we will be try to send data without page refresh by using ajax reponse.Now we make a file action.php to insert data into maysql table. action file will be task to insert data. so we can use our DB class for must be include in acction.php file. Now we pass data of form to insert method by DB class object refer. If will successfull insert so return a string then we can get string from ajax call back function and can show a alert in this we not use browser default alert we use sweet alert, so If you can use so sweet alert js file by using ofline Download or CDN link. 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 execute query
    • action.php
    • //This file will handle for Insert data to get for insert into Database Table
    • index.php
    • //This file for insert form

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 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)