PHP & JSON : Trying to write JSON to Mysql

Question

I am having an issue where my PHP script opens a file with JSON code and needs to insert it into a MySQL database.

For some reason it only displays some of the output from the JSON.

Here is my code

 $json = json_decode(file_get_contents('data.json'), true);
  $data = $json;
  // VAR's
  $system = $data['System'];
  $cid_from = $data["From"];
  $cid_to = $data['To'];

  //DEBUG USAGES
  $array = print_r($data, true);


  ////// THIS ONE WORKS FINE
  echo $data["System"];

  ////// THIS ONE DOESN'T WORK
  echo $data["To"];  

  file_put_contents('output/json-local.txt',$array . "\r\n", FILE_APPEND);

  ////// BUT HERE IT ACTUALLY WORKS
  file_put_contents('output/cli-from.txt',$data['From']. "\r\n", FILE_APPEND);
  file_put_contents('output/cli-to.txt',$data['To']. "\r\n", FILE_APPEND);
  // file_put_contents('json-sysid-local.txt',$systemid . "\r\n", FILE_APPEND);

Here is the contents of data.json

{"action":"call-data-record",
"System":"48130b83e2232f0ecd366a92d4d1261d",
"PrimaryCallID":"[email protected]_1",
"CallID":"0440b807@pbx",
"From":"<sip:[email protected]>",
"To":"<sip:[email protected]>",
"Direction":"O",
"RemoteParty":"",
"LocalParty":"",
"TrunkName":"",
"TrunkID":"",
"Cost":"",
"CMC":"",
"Domain":"xxx.co.za",
"TimeStart":"2018-08-14 16:03:21",
"TimeConnected":"",
"TimeEnd":"2018-08-14 16:03:23",
"LocalTime":"2018-08-14 18:03:21",
"DurationHHMMSS":"0:00:00",
"Duration":"0",
"RecordLocation":"",
"RecordUsers":"",
"Type":"hunt",
"Extension":"100",
"ExtensionName":"100",
"IdleDuration":"",
"RingDuration":"2",
"HoldDuration":"0",
"IvrDuration":"0",
"AccountNumber":"400",
"IPAdr":"",
"Quality":"VQSessionReport: CallTerm\r\nLocalMetrics:\r\nCallID:0440b807@pbx\r\nFromID:<sip:[email protected]>\r\nToID:<sip:[email protected]>;tag=1460166964\r\nx-UserAgent:Vodia-PBX/57.0\r\nx-SIPmetrics:SVA=RG SRD=91\r\nx-SIPterm:SDC=OK SDR=OR\r\n"}

Your "To" data is encapsulated in <>. This potentially causes your browser to interpret it as an HTML tag and not display any content. Try "View page source", does it display there? — Tobias K.
– Tobias K., Commented Aug 14, 2018 at 18:54
Hi I also just noticed as I posted it here.. Is there a solution to this as I cannot edit what is received. — Quinten Rowland
– Quinten Rowland, Commented Aug 14, 2018 at 18:58

Tobias K. · Accepted Answer · 2018-08-14 19:07:18Z

1

Your "To" data is encapsulated in <>. This causes your browser to interpret it as an HTML tag and not display any content.

You can (should!) escape the special HTML control characters:

echo htmlspecialchars($data["To"]);

See http://php.net/htmlspecialchars

Edit: It doesn't hurt to precautionary add this to your other outputs aswell. If the string doesn't contain such characters, it will simply be returned onchanged. You eliminate possible XSS attack vectors this way.

edited Aug 14, 2018 at 19:07

answered Aug 14, 2018 at 19:02

Tobias K.

3,1222 gold badges15 silver badges30 bronze badges

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

1 Comment

Quinten Rowland Over a year ago

Thanks you are a legend

Jay Blanchard · Accepted Answer · 2018-08-14 19:07:54Z

0

The browser source clearly shows "To":"" is being written by PHP to the browser output correctly but the browser is interpreting as an HTML opening tag hence ignoring the rest of the content.

Wrap your output in the PHP htmlspecialchars() function to see the output as in the file.

Add - echo "TO : ".htmlspecialchars($data["To"]);

edited Aug 14, 2018 at 19:07

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

answered Aug 14, 2018 at 19:00

Venkat D

1391 silver badge10 bronze badges

2 Comments

Jay Blanchard Over a year ago

Nice problem identification, with no solution.

Venkat D Over a year ago

Added the solution too but I guess a tad too late.

Collectives™ on Stack Overflow

PHP & JSON : Trying to write JSON to Mysql

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related