如何解析数组PHP-> JSON-> XCODE中的数组

问题描述：

我正在编写一个简单的php/mysql脚本，该脚本获取数据库中所有的广告"并以JSON格式返回它们.如果我仅返回一行，那么十个解析器会将每个字符串拆分为数组的索引，这将非常有用.但是现在我有了这个PHP代码:

I'm writing a simple php/mysql script that gets all "ads" I have in my database and returns them in JSON format. This works great if I'm only returning one row, ten the parser will split each string into an index om the array. But now I have this PHP code:

    <?php
   // Database credentials
   $host = 'localhost'; 
   $db = 'project'; 
   $uid = 'root'; 
   $pwd = '';

   $SSN = $_GET['ssn'];

    // Connect to the database server   
    $link = mysql_connect($host, $uid, $pwd) or die("Could not connect");

   //select the json database
   mysql_select_db($db) or die("Could not select database");

   // Create an array to hold our results
   $arr = array();

   //Execute the query
   $rs = mysql_query("SELECT * FROM all_ads WHERE SSN = $SSN ORDER BY datePosted");



   // Add the rows to the array 
   while($obj = mysql_fetch_row($rs)) {
   $arr[] = $obj;
   }

   echo json_encode($arr);

?>

它返回以下格式:

[["4","Hyr ut i natt","321654987","couch_surfing_ads","2011-05-16 13:49:58"],["5","Maybe not","456893214","vacation_resident_ads","2011-05-16 14:22:34"]]

(包含两个单独的广告)

(CONTAINING TWO SEPARATE ADS)

xcode取回该数组时，会将整个第一个广告放入数组的一个索引中. 如何将每个数组也像JSON输出一样放入数组中?

When xcode gets this array back it puts the entire first ad in one index of the array. How do I to also put each array in an array like the JSON output does?

我的核心问题是如何处理/反序列化此数据！

How do I process/deserialize this data is my core question!

谢谢！

答

我认为您只需要一个两层引用(下面的最后一行)，除非我误会了某些东西:

I think you just need to have a two layer reference (last line below) unless I'm misunderstanding something:

NSString *response = [[NSString alloc] initWithContentsOfURL:yourSourceUrl];
const char *convert = [response UTF8String];
NSString *responseString = [NSString stringWithUTF8String:convert];
NSArray *ads = [responseString JSONValue];
NSLog(@"%@",[[ads objectAtIndex:0] objectAtIndex:1]); //Hyr ut i natt

如何解析数组PHP-> JSON-> XCODE中的数组

相关推荐