ContactManagerRepo/AddContact.php at master · patrickswain/ContactManagerRepo · GitHub

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
<?php
session_start();

	$inData = getRequestInfo();

	$userID = $inData["User_ID"];
	$firstName = $inData["FirstName"];
	$lastName = $inData["LastName"];
	$phoneNumber = $inData["PhoneNumber"];
	$email = $inData["Email"];
	$address = $inData["Address"];
	$contactID = "";

	$conn = new mysqli("198.71.225.55:3306", "User", "Password1!", "Contacts");
	if ($conn->connect_error)
	{
		returnWithError( $conn->connect_error );
	}
	else
	{
	  //$userID = $_SESSION["User_ID"];
		$sql = "INSERT INTO `ContactInfo` (`FirstName`, `LastName`, `User_ID`, `PhoneNumber`, `Email`, `Address` ) VALUES ('" . $firstName . "','" . $lastName . "','" . $userID. "','" . $phoneNumber . "','" . $email . "','" . $address . "')";
		if( $result = $conn->query($sql) != TRUE )
		{
			returnWithError( $conn->error );
		}

		$sql = "SELECT * FROM ContactInfo where (User_ID= $userID) and (FirstName= $firstName) and (LastName= $lastName)";
		$result = $conn->query($sql);
		$result = mysqli_query($conn, $sql);
    $contacts = array();
		if (mysqli_num_rows($result) > 0)
		{
      while($row = mysqli_fetch_assoc($result))
      {
        $contacts[] = $row;
      }
      returnWithInfo($contacts);
    }
		$conn->close();
	}

	function getRequestInfo()
	{
		return json_decode(file_get_contents('php://input'), true);
	}

	function sendResultInfoAsJson( $obj )
	{
		header('Content-type: application/json');
		echo $obj;
	}

	function returnWithError( $err )
	{
		$retValue = '{"error":"' . $err . '"}';
		sendResultInfoAsJson( $retValue );
	}

	// function returnWithInfo($contact)
	// {
	// 	sendResultInfoAsJson( json_encode($contact) );
	// }
	function     returnWithInfo($contacts)
	{
	  sendResultInfoAsJson( json_encode($contacts) );
	}

?>