ds3016
2015-02-03 21:55
浏览 84

在AJAX调用期间接收JSON解析错误

I have a PHP script that is creating my JSON needed for my web app. I am using jQuery's Ajax capabilities to fetch the JSON from my PHP page that is creating the JSON. I am finding a weird quirk though. If I simply run my PHP file in the web browser and output the JSON and then I copy that JSON into a file named myJSON.json which is linked to my Ajax URL call, my code works. However, If I link directly to my PHP file in the Ajax URL call, I get the following error: Requested JSON parse failed. So here is my relevant PHP Code:

<?php

$groupArray = array();

// Setup the beginning of the json file
$json = '
{
    "emails": [';

 // Loop through the request results
foreach ($contextIORequest->getData() as $message) {

  // `date_received` is in Unix time. Begin converting this to a readable date and convert it to the users timezone
  $newTZ = new DateTimeZone("America/Chicago"); // This will be based on the users location during production
  $currentTime = new DateTime();
  $currentTime = DateTime::createFromFormat('U', $message['date_received']);
  $currentTime->setTimezone($newTZ);
  $formattedDateReceived = $currentTime->format('F j, Y');

  // The JSON structure is organized by date (group). Each unique date will be placed in its own group in the JSON file. So we need to check if a date is already in the $groupArray. If it is, then we simply add the email data to the current date group. If the date is not already in the $groupArray, then we will need to create a new group and add the email data to the new group.
  if (!in_array($formattedDateReceived, $groupArray)) {

    // This date is not yet in the $groupArray

    // Check if this is the first group being added to the $groupArray. If it is, the first group added requires different formatting than all other groups that will be added
    if (count($groupArray) == 0) {

      // This is the first group being added
      $json .= '{
            "group": "'.$formattedDateReceived.'",
            "list": [';

    } else {

      // This is not the first group being added. Close the previous "group" and "list" objects and then create new "group" and "list" objects.

      // Before closing the previous "group" and "list" objects, we need to remove the trailing comma ',' from the last "list" item in the previous "group"
      $json = rtrim($json, ',');

      // ']' is closing the previous "list" object. '},' is closing the previous "group" object
      $json .= ']
        },{
            "group": "'.$formattedDateReceived.'",
            "list": [';

    }

    // Now we need to add this date to the $groupArray
    $groupArray[] = $formattedDateReceived;


    // The body of the email cannot have unescaped quotes or apostrophies. It also cannot have line breaks or multiple spaces between words.
    $body = addslashes($message['body'][0]['content']); // Escapes quotes and apostrophies
    $body = str_replace(array("
","
"),"", $body); // Removes all line breaks causing the body string to be all on one line
    $newBody = preg_replace('!\s+!', ' ', $body); // Remove any multiple spaces between words

    // Add the email to the JSON structure
    $json .= '
    {
      "id": "'.$message['message_id'].'",
      "subject": "'.addslashes($message['subject']).'",
      "to": ["David Nester", "Jane Smith"],
      "body": "'.$newBody.'",
      "time": "'.$formattedDateReceived.'",
      "datetime" : "'.$formattedDateReceived.'",
      "from": "'.$message['addresses']['from']['name'].'",
      "dp": "assets/img/profiles/avatar.jpg",
      "dpRetina": "assets/img/profiles/avatar2x.jpg"
    },';

//    echo "<h1>New Group</h1>";
//    echo "Date: ".$message['date_received']." ($formattedString)
<br>";
//    echo "From: ".$message['addresses']['from']['email']."
<br>";
//    echo "Subject: ".$message['subject']."
<br>";
//    echo "Thread Size: ".$message['thread_size']."
<br>";
//    echo "Message ID: ".$message['message_id']."
<br>";
//    echo "Flags: ".$message['flags'][0]."
<br>";

  } else {

    // This date is already in the $groupArray

    // The body of the email cannot have unescaped quotes or apostrophies. It also cannot have line breaks or multiple spaces between words.
    $body = addslashes($message['body'][0]['content']); // Escapes quotes and apostrophies
    $body = str_replace(array("
","
"),"", $body); // Removes all line breaks causing the body string to be all on one line
    $newBody = preg_replace('!\s+!', ' ', $body); // Remove any multiple spaces between words

    // Add the email to the JSON structure
    $json .= '
    {
      "id": "'.$message['message_id'].'",
      "subject": "'.addslashes($message['subject']).'",
      "to": ["David Nester", "Jane Smith"],
      "body": "'.$newBody.'",
      "time": "'.$formattedDateReceived.'",
      "datetime" : "'.$formattedDateReceived.'",
      "from": "'.$message['addresses']['from']['name'].'",
      "dp": "assets/img/profiles/avatar.jpg",
      "dpRetina": "assets/img/profiles/avatar2x.jpg"
    },';

  }
} // end foreach loop

// Before closing the very last "group" and "list" objects, we need to remove the trailing comma ',' from the last "list" item in the last "group"
$json = rtrim($json, ',');

// Complete the JSON structure
$json .= ']
        }
    ]
}';

// Output the JSON
file_put_contents('emails.json', $json);
header('Content-type: application/json; charset=utf-8');
echo $json;

?>

So if I run this PHP file in my web browser, it outputs the JSON. I then copied and pasted the JSON into a JSON file. I then link my AJAX call to the JSON file and everything is parsed correctly. But I need to link to the PHP file that creates the JSON in my AJAX call. However, when I do this, I get a parse error even though it is the exact same code I copied and pasted in my JSON file that works perfectly. I am really stumped on this one. Here is my relevant AJAX code as well:

$.ajax({
    dataType: "json",
    url: "create-json.php",
    success: function(data) {

        $.each(data.emails, function(i) {
            var obj = data.emails[i];
            var list = obj.list;

            $.each(list, function(j) {
                var $this = list[j];
                var id = $this.id;
            });

        });

    },
    error: function(jqXHR, exception) {
        if (jqXHR.status === 0) {
            alert('Not connect.
 Verify Network.');
        } else if (jqXHR.status == 404) {
            alert('Requested page not found. [404]');
        } else if (jqXHR.status == 500) {
            alert('Internal Server Error [500].');
        } else if (exception === 'parsererror') {
            alert('Requested JSON parse failed.');
        } else if (exception === 'timeout') {
            alert('Time out error.');
        } else if (exception === 'abort') {
            alert('Ajax request aborted.');
        } else {
            alert('Uncaught Error.
' + jqXHR.responseText);
        }
    }
}
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongtuo4132 2015-02-03 23:07
    已采纳

    Instead of trying to create a JSON string from scratch, build your data structure using associative arrays (key => value), and just json_encode() it, it will save you a lot of trouble on formatting.

    Also note that this function escapes strings for you.

    Revised code

    $groupArray = array();
    
    $json = array( 'emails' => array() );
    
    foreach ($contextIORequest->getData() as $message) {
    
      $newTZ = new DateTimeZone("America/Chicago");
      $currentTime = new DateTime();
      $currentTime = DateTime::createFromFormat('U', $message['date_received']);
      $currentTime->setTimezone($newTZ);
      $formattedDateReceived = $currentTime->format('F j, Y');
    
      if (!in_array($formattedDateReceived, $groupArray)) {
          array_push( $json['emails'],
              array(
                   'group' => $formattedDateReceived,
                   'list' => array()
              )
          );
          $groupArray[] = $formattedDateReceived;
      }
    
      $body = str_replace(array("
    ","
    "),"", $message['body'][0]['content']);
      $newBody = preg_replace('!\s+!', ' ', $body);
    
      array_push($json['emails'][array_search($formattedDateReceived,$groupArray)]['list'],
          array(
            'id' => $message['message_id'],
            'subject'=> addslashes($message['subject']),
            'to' => array("Me"),
            'body' => $newBody,
            'time' => $formattedDateReceived,
            'datetime' => $formattedDateReceived,
            'from' => $message['addresses']['from']['name'],
            'dp' => "assets/img/profiles/avatar.jpg",
            'dpRetina' => "assets/img/profiles/avatar2x.jpg"
          )
      );
    
    } // end foreach loop
    
    // Output the JSON
    header('Content-Type: application/json');
    echo json_encode($json);
    
    已采纳该答案
    打赏 评论

相关推荐 更多相似问题