jQuery ajax request of dataType json will not retrieve data from PHP script

Question

I ve been looking all over for the solution but I cannot find anything that works  I am trying to get a bunch of data from the database and then via AJAX autocomplete input fields in a form  To do this I ve decided to use json  because why not  right  Alternatively I ve been thinking to just send back a delimited string and then tokenise it  which in hind-sight would ve been much easier and spared me the headache    Since I ve decided to use json though  I guess I should stick with it and find out what went wrong   What happens is that when the get member function   is executed  an error pops up in an alert dialogue and reads   object Object    I ve tried this also using the GET request  and by setting the contentType to    application json  charset utf-8   Alas  no dice  Can anyone please suggest what I am doing wrong  Take care  Piotr   My javascript jQuery function is as follows   function get member info            var url    contents php scripts admin scripts php       var id       select  name   member   option selected    val          ajax              type   POST         dataType   json         url  url        data    get member  id          success  function  response                            input  name   type   eq      response type          attr   checked    checked                   input  name   name      val  response name                  input  name   fname      val  response fname                  input  name   lname      val  response lname                  input  name   email      val  response email                  input  name   phone      val  response phone                  input  name   website      val  response website                   admin member img    attr   src    images member images     response image                    error  function  error                     alert  error                           and the relevant code in  contents php scripts admin scripts php  is as follows      if  isset    POST   get member                     member id     POST   get member            query    select   from members where id     member id            result   mysql query   query            row   mysql fetch array   result            type    row   type            name    row   name            fname    row   fname            lname    row   lname            email    row   email            phone    row   phone            website    row   website            image    row   image             json arr   array   type    gt   type   name    gt   name   fname    gt   fname   lname    gt   lname   email    gt   email   phone    gt   phone   website    gt   website   image    gt   image           echo json encode   json arr

User · Answer

Try this         lt script type  text javascript  gt         document  ready function             find   click function            var username        username   val                  ajax               type   POST               dataType   json               url   includes find php               data   username   username              success  function  data                   in data you result will be available                response   jQuery parseJSON data     further code                       error  function xhr  status  error            alert status                  dataType   text                                        lt  script gt        lt form name  Find User  id  userform  class  invoform  method  post    gt        lt div id   userdiv  gt         lt p gt Name  Lastname  firstname   lt  p gt         lt  label gt         lt input type  text  name  username  id  username  class  inputfield    gt         lt input type  button  name  find  id  find  class  passwordsubmit  value  find    gt       lt  div gt       lt  form gt       lt div id  userinfo  gt  lt b gt info will be listed here  lt  b gt  lt  div gt

User · Answer

In addition to McHerbie s note  try json encode   json arr  JSON FORCE OBJECT    if you are on PHP 5 3

User · Answer

I think I know this one     Try sending your JSON as JSON by using PHP s header   function          Send as JSON     header  Content-Type  application json   true     Though you are passing valid JSON  jQuery s   ajax doesn t think so because it s missing the header   jQuery used to be fine without the header  but it was changed a few versions back   ALSO  Be sure that your script is returning valid JSON  Use Firebug or Google Chrome s Developer Tools to check the request s response in the console   UPDATE  You will also want to update your code to sanitize the   POST to avoid sql injection attacks  As well as provide some error catching   if  isset   POST  get member             member id   mysql real escape string    POST  get member           query    SELECT   FROM  members  WHERE  id          member id              if   result   mysql query   query               row   mysql fetch array  result            type    row  type            name    row  name            fname    row  fname            lname    row  lname            email    row  email            phone    row  phone            website    row  website            image    row  image               JSON Row            json   array   type    gt   type   name    gt   name   fname    gt   fname   lname    gt   lname   email    gt   email   phone    gt   phone   website    gt   website   image    gt   image           else               Your Query Failed  use mysql error to report why             json   array  error    gt   MySQL Query Error                    Send as JSON         header  Content-Type  application json   true           Return JSON        echo json encode  json           Stop Execution        exit

User · Answer

session start    include  connection php        function msg  subjectname  coursename  sem            return    subjectname     subjectname   coursename     coursename   sem     sem                title id   POST  title id     result mysql query  SELECT   FROM  video  WHERE id   title id    or die mysql error      qr mysql fetch array  result    subject  qr  subject     course  qr  course     resultes mysql query  SELECT   FROM course JOIN subject ON course id   course  AND subject id   subject      qqr mysql fetch array  resultes    subjectname  qqr  subjectname     coursename  qqr  coursename     sem  qqr  sem     json   array  subjectname    gt   subjectname   coursename    gt   coursename   sem    gt   sem    header  Content-Type  application json   true   echo json encode   json arr         ajax  type  POST                         dataType   json                          url  select-title php                      data     studey-form   serialize                       contentType   application json  charset utf-8                      beforeSend  function x            if x  amp  amp  x overrideMimeType                x overrideMimeType  application j-son charset UTF-8                                        success function response                                          var response   parseJSON response                      alert response subjectname                           course   html   lt option gt   response coursename   lt  option gt                              subject   html   lt option gt   response subjectname   lt  option gt                                             error  function  error x y                                         alert  x y

User · Answer

Well  it might help someone  I was stupid enough to put var dump  testing    in the function I was requesting JSON from to be sure the request was actually received  This obviously also echo s as part for the expected json response  and with dataType set to json defined  the request fails

User · Answer

Try using jQuery parseJSON when you get the data back   type   POST   dataType   json   url  url  data    get member  id    success  function data         response   jQuery parseJSON data          input  name   type   eq     response type                  attr  checked    checked           input  name   name     val  response name          input  name   fname     val  response fname          input  name   lname     val  response lname          input  name   email     val  response email          input  name   phone     val  response phone          input  name   website     val  response website           admin member img            attr  src    images member images     response image      error  function error        alert error

User · Answer

The   ajax error function takes three arguments  not one   error  function xhr  status  thrown    You need to dump the 2nd and 3rd parameters to find your cause  not the first one

User · Answer

If you are using a newer version  over 1 3 x  you should learn more about the function parseJSON  I experienced the same problem  Use an old version  or change your code  success function data       something like this   jQuery parseJSON data

[php] jQuery $.ajax request of dataType json will not retrieve data from PHP script

Examples related to php

Examples related to jquery

Examples related to ajax

Examples related to json