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;
<!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>
<?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;
}
}
}
?>
<?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 !";
}
}
?>