Json Call can't interpret PHP variable in Jquery Mobile App

Question

I want to load event calendar from Database, I got this code on line and is working perfectly.

My javascript:

$('#mycalendar').monthly({
    mode: 'event',
    jsonUrl: 'http://localhost/acadasuite_mobile/www/calendar.php',
    dataType: 'json'
});

My PHP

   $startdate = "2016-10-6";
   echo '{
    "monthly": [
       {
         "id": 2,
         "name": "This is a JSON event",
         "startdate": "2016-10-6",
         "enddate": "",
         "starttime": "12:00",
         "endtime": "2:00",
         "color": "#EF44EF",
         "url": ""
      }
    ]
  }';

ABOVE WORK WELL. But if I change the "2016-10-6" to '.$startdate.', it will not work again

ie. "startdate": '.$startdate.',

Please, what can be the problem; Is it the the javascript does not interpret the variable $startdate or PHP?

Read up on json_encode() Never try and build a JSONString yourself — RiggsFolly
– RiggsFolly, Commented Oct 18, 2016 at 18:33
You should create that object as an associative array and then use json_encode() to format the response. — Jbird
– Jbird, Commented Oct 18, 2016 at 18:33

Blazemonger · Accepted Answer · 2016-10-18 18:34:22Z

2

PHP will not interpret variables inside strings denoted with single quotes. Switch to double quotes on the outside and escape your double quotes on the inside.

Alternatively, use string concatenation:

$startdate = "2016-10-6";
echo '{
"monthly": [
   {
     "id": 2,
     "name": "This is a JSON event",
     "startdate": "'.$stardate.'",
     "enddate": "",
     "starttime": "12:00",
     "endtime": "2:00",
     "color": "#EF44EF",
     "url": ""
  }
]
}';

edited Oct 18, 2016 at 18:34

answered Oct 18, 2016 at 18:33

Blazemonger

93.3k28 gold badges147 silver badges181 bronze badges

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

1 Comment

RiggsFolly Over a year ago

BUT Read up on json_encode() Never try and build a JSONString yourself

Marc B · Accepted Answer · 2016-10-18 18:36:51Z

0

You forgot quotes:

"startdate": "2016-10-6", etc...

becomes

"startdate": ' . $stardate . ', etc..

which generates

 "startdate":2016-10-6, etc...

which is NOT valid JSON. Json can only represent VALUES, not expressions. And even if expressions were supported, that'd be a mathematical subtraction, and you'd be putting the value 2000 into startdate.

You need quotes:

     "startdate": "' . $startdate . '",
                  ^------------------^

To show where the (j)son/(p)hp delineation is:

     "startdate": "' . $startdate . '",
     jjjjjjjjjjjjjjppppppppppppppppppjj

answered Oct 18, 2016 at 18:36

Marc B

362k44 gold badges433 silver badges508 bronze badges

Collectives™ on Stack Overflow

Json Call can't interpret PHP variable in Jquery Mobile App

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related