<?php
$servername = "";
$user_n = "";
$p_word = "";
$dbname = "";

// Create connection
$con = mysqli_connect($servername, $user_n, $p_word, $dbname);

// Check connection
if (mysqli_connect_errno())
{echo nl2br("Failed to connect to MySQL:".mysqli_connect_error()."n ");}
else
{ echo nl2br("Established Database Connection n");}

$sanemail = mysqli_real_escape_string($con,$_POST['email']);
$sanfname= mysqli_real_escape_string($con,$_POST['firstName']);


//insert query to insert from data into the capstone table
$sql = "UPDATE user_info SET fname = '$sanfirstName' WHERE email='$sanemail'"

//check for error on insert
if (!mysqli_query($con,$sql))
{ die('Error:' .mysqli_error($con));}

echo "1 record added";
mysqli_close($con);
?>

import UIKit

class userInformation: UIViewController {
    let URL_SAVE_TEAM = ""

    // these three just added ----> you may need to add them down the line
    @IBOutlet weak var email: UITextField!
    @IBOutlet weak var password: UITextField!
    @IBOutlet weak var repeatPassword: UITextField!
    @IBOutlet weak var firstName: UITextField!
    @IBOutlet weak var lastName: UITextField!
    @IBOutlet weak var phoneNumber: UITextField!
    @IBOutlet weak var organization: UITextField!
    @IBOutlet weak var job: UITextField!
    @IBOutlet weak var website: UITextField!
    @IBOutlet weak var phoneNumberTwo: UITextField!
    @IBOutlet weak var emailNumberTwo: UITextField!

    @IBAction func saveButtonTapped(_ sender: AnyObject) {
        //created NSURL
        let requestURL = NSURL(string: URL_SAVE_TEAM)

        //creating NSMutableURLRequest
        let request = NSMutableURLRequest(url: requestURL! as URL)

        //setting the method to post
        request.httpMethod = "POST"

        //getting values from text fields
        let email = self.email.text
        let password = self.password.text
        let firstName = self.firstName.text
        let lastName = self.lastName.text
        let phoneNumber = self.phoneNumber.text
        let organization = self.organization.text
        let job = self.job.text
        let website = self.website.text
        let phoneNumberTwo = self.phoneNumberTwo.text
        let emailNumberTwo = self.emailNumberTwo.text

        //Display Alert Messages
        func displayAlertMessage(userMessage:String)
        {
            let myAlert = UIAlertController(title: "Alert", message: userMessage, preferredStyle: UIAlertControllerStyle.alert);

            let okAction = UIAlertAction(title: "OK", style: UIAlertActionStyle.default, handler:nil)

            myAlert.addAction(okAction);

            self.present(myAlert, animated: true, completion:nil)
        }

        //If all the required fields are not filled out create an error message to the user

        if(firstName!.isEmpty || lastName!.isEmpty)
        {
            displayAlertMessage(userMessage: "All fields are required fields to fill in")
            return
        }

        //creating the post parameter by concatenating the keys and values from text field
        let postParameters = "email="+email!+"&password="+password!+"&firstName="+firstName!+"&lastName="+lastName!+"&phoneNumber="+phoneNumber!+"&organization="+organization!+"&job="+job!+"&website="+website!+"&phoneNumberTwo="+phoneNumberTwo!+"&emailNumberTwo="+emailNumberTwo!;

        //adding the parameters to request body
        request.httpBody = postParameters.data(using: String.Encoding.utf8)
        let task = URLSession.shared.dataTask(with: request as URLRequest){
            data, response, error in

            if error != nil{
                print("error is (error)")
                return;
            }
            //parsing the response
            do {
                //converting resonse to NSDictionary
                let myJSON =  try JSONSerialization.jsonObject(with: data!, options: .mutableContainers) as? NSDictionary

                //parsing the json
                if let parseJSON = myJSON {

                    //creating a string
                    var msg : String!

                    //getting the json response
                    msg = parseJSON["message"] as! String?

                    //printing the response
                    print(msg)

                }
            } catch {
                print(error)
            }

        }
        //executing the task
        task.resume()