Javascript AJAX jQuery HTML OOPS PHP PHP Example MORE

Insert Data Into MySQL Using PHP OOPS Concept

For insert data in MySQL first we have to create a table in data base.

Here we using 3 file for insert data in MySQL:

Crud.php:For connecting data base and function

index.php:for getting the values from the user

process.php:A PHP file that process the request

CREATE TABLE `employee` (
	`userid` int(8) NOT NULL AUTO_INCREMENT,
	`first_name` varchar(55) NOT NULL,
	`last_name` varchar(55) NOT NULL,
	`city_name` varchar(55) NOT NULL,
	`email` varchar(50) NOT NULL,
	`datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

index.php

<!DOCTYPE html>
<html>
  <body>
	<form method="post" action="process.php">
		First name:<br>
		<input type="text" name="first_name">
		<br>
		Last name:<br>
		<input type="text" name="last_name">
		<br>
		City name:<br>
		<input type="text" name="city_name">
		<br>
		Email Id:<br>
		<input type="email" name="email">
		<br><br>
		<input type="submit" name="submit" value="submit">
	</form>
  </body>
</html>

Crud.php

<?php
    class Crud
    {
        private $servername = "localhost";
		private $username   = "root";
		private $password   = "";
		private $dbname = "oops_db";
        public $con;
        public $employeeTable = "employee";
		public function __construct()
		{
			try {
				$this->con = new mysqli($this->servername, $this->username, $this->password, $this->dbname);	
			} catch (Exception $e) {
				echo $e->getMessage();
			}
		}
        public function save($first_name, $last_name,$city_name,$email,$insertdate)
        {
            $sql = "INSERT INTO $this->employeeTable(first_name,last_name,city_name,email,datetime) VALUES('$first_name', '$last_name','$city_name','$email','$insertdate')";
            $query = $this->con->query($sql);
			if ($query) {
				return true;
			}else{
				return false;
			}
        }
        
    }
?>

process.php

<?php
include_once("Crud.php");
$insertdata=new Crud();
if(isset($_POST['submit']))
{
    $first_name = $_POST['first_name'];
    $last_name = $_POST['last_name'];
    $city_name = $_POST['city_name'];
    $email = $_POST['email'];
    date_default_timezone_set("Asia/Calcutta");
    $insertdate = date("Y-m-d H:i:s");
    $sql=$insertdata->save($first_name, $last_name,$city_name,$email,$insertdate);
    if($sql)
    {
       echo "Data inserted successfully !";
    }
    else
    {
        echo "Data inserted error !";
    }
}
 ?>