Inserting data into MySQL using PDO for PHP Xcode
I'm really trying to figure out why the code below doesn't insert the date I'm posting?
<?php
$servername = "servername";
$username = "username";
$password = "passwrd";
$dbname = "dbname";
$conn = new PDO ("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$Name = $_POST['Name'];
$Last = $_POST['Last'];
$email = $_POST['email'];
$pwd = $_POST['pwd'];
$userID = $_POST['userID'];
$sql = "INSERT INTO Users (Name, Last, email, password, userID) VALUES (:var1, :var2, :var3, :var4, :var5) ";
$q = $conn -> prepare($sql);
$q -> execute (array(':var1' => $Name,
':var2' => $Last,
':var3' => $email,
':var4' => $pwd,
':var5' => $userID));
?>
If instead of
$Name = $_POST['Name'];
etc. I am hardcoding the values, so I could:
$Name = 'Jane';
It adds data to the database, but with $ _POST it doesn't work in the execution line.
My Xcode looks like this:
NSString *strURL = [NSString stringWithFormat:@"http://www.myserver/AddUser.php?Name=%@&Last=%@&email=%@&pwd=%@&userID=%@", Name, Last, email, pwd, userID];
NSData *dataURL = [NSData dataWithContentsOfURL:[NSURL URLWithString:strURL]];
NSString *strResult = [[NSString alloc] initWithData:dataURL encoding:NSUTF8StringEncoding];
I have looked through a lot of tutorials and questions on SO and I can't see what the problem is.
Your HTTP request is sent using the GET protocol, but you are accessing your data using the POST protocol. You have three possible fixes,
-
Change PHP to read data with GET
$ email = $ _GET ['email'];
-
Change PHP to be mode agnostic (my preference)
$ email = $ _REQUEST ['email'];
-
Change the iPhone app to send by message.
You seem to be issuing a request get
, not a request post
, which means yours $_POST
is undefined, which is probably causing PDO errors. Instead, you should get values from a global variable $_GET
:
$Name = $_GET['Name'];
$Last = $_GET['Last'];
$email = $_GET['email'];
$pwd = $_GET['pwd'];
$userID = $_GET['userID'];