-
Notifications
You must be signed in to change notification settings - Fork 0
/
crudmodel.php
49 lines (42 loc) · 1.58 KB
/
crudmodel.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<?php
class ModelCrud
{
private $server = "localhost";
private $username = "root";
private $password;
private $db = "php_crud";
private $conn;
function __construct()
{
try {
$this->conn= new mysqli($this->server,$this->username,$this->password,$this->db);
} catch (Exception $e) {
die('connection faile'.$e->getMessage());
}
}
public function insert(){
if (isset($_POST['btn'])) {
if (isset($_POST['name']) && isset($_POST['email']) && isset($_POST['mobile']) && isset($_POST['address'])) {
if (!empty($_POST['name']) && !empty($_POST['email']) && !empty($_POST['mobile']) && !empty($_POST['address'])) {
$name = $_POST['name'];
$email = $_POST['email'];
$mobile = $_POST['mobile'];
$address = $_POST['address'];
$query = "INSERT INTO users(name,email,mobile,address) VALUES ('$name','$email','$mobile','$address')";
if ($sql = $this->conn->query($query)) {
echo "<script>alert('Record Added Successfully');</script>";
echo "<script>window.location.href='crud.php';</script>";
}else{
echo "<script>alert('faild');</script>";
echo "<script>window.location.href='crud.php';</script>";
}
}
else{
echo "<script>alert('empty');</script>";
echo "<script>window.location.href='crud.php';</script>";
}
}
}
}
}
?>