StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POThe most basic way to retrieve a JSON array in objective-c?
text
Body
copied!<p>Basically I have a JSON array on a webpage, the array works fine on the webpage and I can pull it into objective-c as a string, but I need to pull it into objective-c as an array. Can anybody tell me the most basic way to do this? I've seen some tutorials that do this but most of them are arrays of objects in JSON.</p> <p>Here's my objective-c code to pull the information as a string is:</p> <pre><code>//create string to contain URL address for PHP file, the file name is index.php and the parameter: name is passed to the file NSString *strURL = [NSString stringWithFormat:@"http://localhost:8888/page4.php?name=%@", _txtName.text]; //to execute PHP code NSData *dataURL = [NSData dataWithContentsOfURL:[NSURL URLWithString: strURL]]; //to recieve the returned value NSString *strResult = [[NSString alloc] initWithData:dataURL encoding:NSUTF8StringEncoding]; NSLog(@"%@", strResult); </code></pre> <p>Here is the PHP/JSON code for my webpage.</p> <pre><code><?php if (isset ($_GET["name"])) $name = $_GET["name"]; else $name = "NULL"; // Make a MySQL Connection mysql_connect("localhost", "root", "root") or die(mysql_error()); mysql_select_db("test") or die(mysql_error()); // Retrieve all the data from the "example" table $result = mysql_query("SELECT * FROM user WHERE name = '$name'") or die(mysql_error()); // store the record of the "example" table into $row $row = mysql_fetch_array( $result ); $array = array( "0" => $row['id'], "1" => $row['name'], ); $json_array = json_encode($array); echo $json_array; ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload