troubleshooting Question
jQuery EasyUI datagrid, problems getting data via ajax from PHP/ JSON
Tablecloth asked on
Greetings,
This is the scenario, and I thank you in advance for your patience:
It pertains to a person's dog's details (colour, breed etc).
Via a querystring to make things easy, (?PersonID=4849) I want to fill the datagrid with that person's dog data from a local PHP file. (DogsDetailsPHP.php)
I can't get it to work.
A second problem is with one of the elements of the grid is a combo box which I was hoping to fill via an Ajax call to another PHP file. (A dropdown of a list of breeds). This is not happening either.
The two PHP files actually faithfully return JSON data from the querying of a MySQL database. The problem is unlikely to be here for I have tested them both.
In order to facilitate you in helping me I've put the output that the PHP files give in a hardcoded array (commented out) and the other JSON data in a separate JSON file.
When I edit the main file to point to the JSON file and the hardcoded array, everything works.
I suspect that my JQuery / javascript / is erroneous.
I enclose the relevant files.
Many thanks for your help.
BreedsJSON.txt
BreedsPHP.php
DogsDetailsPHP.php
Dogs2.php
This is the scenario, and I thank you in advance for your patience:
It pertains to a person's dog's details (colour, breed etc).
Via a querystring to make things easy, (?PersonID=4849) I want to fill the datagrid with that person's dog data from a local PHP file. (DogsDetailsPHP.php)
I can't get it to work.
A second problem is with one of the elements of the grid is a combo box which I was hoping to fill via an Ajax call to another PHP file. (A dropdown of a list of breeds). This is not happening either.
The two PHP files actually faithfully return JSON data from the querying of a MySQL database. The problem is unlikely to be here for I have tested them both.
In order to facilitate you in helping me I've put the output that the PHP files give in a hardcoded array (commented out) and the other JSON data in a separate JSON file.
When I edit the main file to point to the JSON file and the hardcoded array, everything works.
I suspect that my JQuery / javascript / is erroneous.
I enclose the relevant files.
Many thanks for your help.
BreedsJSON.txt
BreedsPHP.php
DogsDetailsPHP.php
Dogs2.php
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.