PHP file to recive data from iOS code isnt working

Question

I am having problems getting my post from my iOS app. I think it is the PHP file. I know it is connecting to the database ok, but it is not inserting the values into the SQL database.

Here is my PHP file in full:

<?php
$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';


$name =$_GET["name"];
$message = $_GET["message"];

mysqli_query INSERT INTO "test" ("", "name", "message",)
mysql_query($query) or die(mysql_error());


mysql_close();

?>

My iOS app is fine, as I am aware and sending the info out fine. But this is the first time i have used PHP.

I'm showing an error on line

       mysqli_query INSERT INTO "test" ("", "name", "message",)

but not sure, how to solve.

My IOS Code IS as Follows

-(void) postMessage: (NSString*) message withName: (NSString *) name{

if (name != nil && message != nil){

    NSMutableString *postString = [NSMutableString stringWithString:kPostURL];

    [postString appendString:[NSString stringWithFormat:@"?%@=%@", kName, name]];
    [postString appendString:[NSString stringWithFormat:@"&%@=%@", kMessage, message]];
    [postString appendString:[postString    stringByAddingPercentEscapesUsingEncoding:NSUTF8StringEncoding]];

    NSMutableURLRequest *request = [[NSMutableURLRequest alloc] initWithURL:[NSURL  URLWithString:postString]];


    [request setHTTPMethod:@"POST"];

    postConnection = [[NSURLConnection alloc] initWithRequest:request delegate:self];


}


}


-(IBAction)post:(id)sender{

[self postMessage:messageText.text withName:nameText.text];
[messageText resignFirstResponder];
messageText.text = nil;

nameText.text = nil;



}

new php code

$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

$name =$_GET["name"];
$message = $_GET["message"];

mysql_query("INSERT INTO test ('', $name, $message)") or die(mysql_error()); 


mysql_close();

?>

extra info

the app is just a view controller with a TextField , TextView, and a button as in the .h file

#define kPostURL @"http://www.dmk-media.com/taxi/tuttest.php"
#define kName @"name"
#define kMessage @"message"




@interface DMKFirstViewController : UIViewController{


IBOutlet UITextField *nameText;
IBOutlet UITextView  *messageText;
NSURLConnection *postConnection;


}

-(IBAction)post:(id)sender;

and then to post the message

-(void) postMessage: (NSString*) message withName: (NSString *) name{

if (name != nil && message != nil){

    NSMutableString *postString = [NSMutableString stringWithString:kPostURL];

    [postString appendString:[NSString stringWithFormat:@"?%@=%@", kName, name]];
    [postString appendString:[NSString stringWithFormat:@"&%@=%@", kMessage, message]];
    [postString appendString:[postString stringByAddingPercentEscapesUsingEncoding:NSUTF8StringEncoding]];

    NSMutableURLRequest *request = [[NSMutableURLRequest alloc] initWithURL:[NSURL  URLWithString:postString]];


    [request setHTTPMethod:@"POST"];

    postConnection = [[NSURLConnection alloc] initWithRequest:request delegate:self];


}


}

and then the button action

-(IBAction)post:(id)sender{

[self postMessage:messageText.text withName:nameText.text];
[messageText resignFirstResponder];
messageText.text = nil;

nameText.text = nil;



}

thats all the is in the code its just a basic app to try and test posting to my sql server

First: you are mixing mysql and mysqli. Second: does your iOS app call a GET or POST request? — Rok Jarc
– Rok Jarc, Commented Dec 17, 2013 at 13:26
So you do get data from iOS app but can't store it to database? Leonardo's answer should help. The problem is you are mixing mysql and mysqli: this are two different APIs — Rok Jarc
– Rok Jarc, Commented Dec 17, 2013 at 14:19

Leonardo · Accepted Answer · 2013-12-19 21:07:20Z

5

Remove:

$name =$_GET["name"];
$message = $_GET["message"];

...

mysqli_query INSERT INTO "test" ("", "name", "message",)
mysql_query($query) or die(mysql_error());

It should be:

$name = $_POST["name"];
$message = $_POST["message"];
mysql_select_db('DATABASE_NAME', $conn) or die(mysql_error());

...

mysql_query("INSERT INTO test(name, mesage) VALUES ('$name', '$message');", $conn) or die(mysql_error());

edited Dec 19, 2013 at 21:07

answered Dec 17, 2013 at 13:26

Leonardo

7364 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Leonardo Over a year ago

@MikeAsp check my updated answer, I changed this line: mysql_query("INSERT INTO test ('', $name, $message)", $conn) or die(mysql_error());

MikeAsp Over a year ago

that got rid of the errors. but im still getting no data going in to the SQL database. the iphone seems to be posting ok but the data is getting lost somewhere

Leonardo Over a year ago

use a DBMS like MySQL Workbench or phpMyAdmin and execute this query: SHOW COLUMNS FROM test and post that response in your question. What I want to see is the data types and keys of your columns

Leonardo Over a year ago

@MikeAsp see my updated answer: I changed this line: mysql_query("INSERT INTO test(name, mesage) VALUES ($name, $message)", $conn) or die(mysql_error()); . This should definitely work...

Leonardo Over a year ago

@MikeAsp I updated the last line of my answer..it should work!

|

Joe · Accepted Answer · 2013-12-17 15:13:10Z

0

-(void) postMessage: (NSString*) message withName: (NSString *) name{

    if (name != nil && message != nil){
        NSMutableString *postString = [NSMutableString stringWithString:kPostURL];
        NSMutableURLRequest *request = [[NSMutableURLRequest alloc] initWithURL:[NSURL URLWithString:postString]];
        NSString *param = [NSString stringWithFormat:@"%@=%@&%@=%@",kName, name, kMessage, message];
        request.HTTPBody = [param dataUsingEncoding:NSUTF8StringEncoding];
        request.HTTPMethod = @"POST";
        postConnection = [[NSURLConnection alloc] initWithRequest:request delegate:self];
    }
}

edited Dec 17, 2013 at 15:13

Joe

2,1051 gold badge18 silver badges28 bronze badges

answered Dec 17, 2013 at 14:46

immmfei

1

2 Comments

Joe Over a year ago

you should add a quick description of what was changed and what your doing for more clarity

MikeAsp Over a year ago

added extra details at the bottom of my post

Collectives™ on Stack Overflow

PHP file to recive data from iOS code isnt working

2 Answers 2

11 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related