forked from Kalana777/VocationalTraining
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsert.php
27 lines (24 loc) · 1015 Bytes
/
insert.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
<?php
$connect = mysqli_connect("localhost", "root", "", "vocational training institute");
$data=json_decode(file_get_contents("php://input"));
if(count($data) > 0)
{
$full_name = mysqli_real_escape_string($connect, $data->fullname);
$name = mysqli_real_escape_string($connect, $data->name);
$email = mysqli_real_escape_string($connect, $data->email);
$mobile_num = mysqli_real_escape_string($connect, $data->mobile);
$birthday = mysqli_real_escape_string($connect, $data->birthday);
$address = mysqli_real_escape_string($connect, $data->address);
$gender = mysqli_real_escape_string($connect, $data->gender);
$approval="unapproved";
$query = "INSERT INTO registration(full_name, name, email, mobile, birthday, address, gender, approval) VALUES ('$full_name', '$name' ,'$email', '$mobile_num', '$birthday', '$address', '$gender', '$approval')";
if(mysqli_query($connect, $query))
{
echo "DATA INSERTED...";
}
else
{
echo 'ERROR';
}
}
?>