-
Notifications
You must be signed in to change notification settings - Fork 0
/
addcustjson.php
74 lines (55 loc) · 2.49 KB
/
addcustjson.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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
<?
require 'include/connect.php';
session_start();
date_default_timezone_set('America/Los_Angeles');
header('Content-type:application/json');
$date = date('Y-m-d');
$email = ($_POST["email"]);
$firstname = ($_POST["first"]);
$lastname = ($_POST["last"]);
$phone = ($_POST["phoneNumber"]);
$gender = ($_POST["gender"]);
$age = ($_POST["age"]);
$beauty= $fitness = $wellness = "";
$pfirst = ($_POST["preferredFirst"]);
$plast = ($_POST["preferredLast"]);
$referral = ($_POST["referral"]);
if (isset($_POST['beauty']))
$beauty= ($_POST["beauty"]);
if(isset($_POST['fitness']))
$fitness = ($_POST["fitness"]);
if(isset($_POST['wellness']))
$wellness = ($_POST["wellness"]);
$setstring = $beauty.",".$fitness.",".$wellness;
$sqlCheckEmail = "SELECT email from Customers WHERE email= '$email'";
$resultCheckEmail= $conn->query($sqlCheckEmail);
$sqlCheckName = "SELECT cid FROM Customers WHERE firstName = '$firstname' AND lastname = '$lastname' ";
$resultCheckName = $conn->query($sqlCheckName);
if ($resultCheckEmail->num_rows >= 1) {
die("!ERROR: That email already exists");
}
$q = "INSERT INTO Customers (firstname, lastname, phoneNumber, age, gender, referral, email, interest, dateadded, preferredFirstName,
preferredLastName) values ('$firstname',
'$lastname', '$phone', '$age' , '$gender', '$referral' , '$email', '$setstring', '$date', '$pfirst', '$plast' )";
$res = mysqli_query($conn, $q);
if (!$res)
{
die("Error Occured while inserting customer");
}
else
{
$sqlquery = "SELECT cid FROM Customers ORDER BY cid DESC LIMIT 1";
if ($result = $conn->query($sqlquery)) {
$row = $result->fetch_assoc();
$id = $row['cid'];
$response["success"] = 1;
$response["message"] = $id;
echo json_encode($response);
}
else {
$response["success"] = 0;
$response["message"] = "Error occured while creating customer";
echo json_encode($response);
}
}
?>