Using Jquery Ajax to retrieve data from Mysql

Question

list php  A simple ajax code that I want to display only records of the Mysql table              lt html gt    lt head gt       lt script src  jquery-1 9 1 min js  gt       lt  script gt       lt script gt        document  ready function             var response                 ajax               type   GET               url   Records php               async  false              success  function text                    response   text                                     alert response                lt  script gt   lt  head gt    lt body gt       lt div id  div1  gt           lt h2 gt Let jQuery AJAX Change This Text lt  h2 gt       lt  div gt       lt button gt Get Records lt  button gt   lt  body gt    lt  html gt    Records php is the file to fetch records from Mysql  In the Database are only two fields   Name    Address     lt  php       database name    simple ajax        table name    users       con   mysql connect  localhost   root            dbs   mysql select db  simple ajax   con        result  mysql query  select   from users         array   mysql fetch row  result     gt   lt tr gt       lt td gt Name   lt  td gt       lt td gt Address   lt  td gt   lt  tr gt   lt  php     while   row   mysql fetch array  result                 echo   lt tr gt            echo   lt td gt  row 1  lt  td gt            echo   lt td gt  row 2  lt  td gt            echo   lt  tr gt               gt    This code is not working

User · Answer

Please make sure your  row 1     row 2  contains correct value  we do assume here that 1   Name   and 2 here is your Address field    Assuming you have correctly fetched your records from your Records php  You can do  something like this         document  ready function             getRecords   click function                 var response                 ajax   type   POST                       url   Records php                       async  false                   success   function text                                      table1   html text                                                            In your HTML   lt table id  table1  gt         Let jQuery AJAX Change This Text    lt  table gt   lt button id  getRecords  gt Get Records lt  button gt    A little note   Try learing PDO http   php net manual en class pdo php since mysql   functions are no longer encouraged

User · Answer

This answer was for   Neha Gandhi but I modified it for  people who use pdo and mysqli sing mysql functions are not supported  Here is the new answer        lt html gt   lt  --Save this as index php-- gt         lt script src  quot   code jquery com jquery-1 9 1 js quot  gt  lt  script gt           lt script src  quot   ajax aspnetcdn com ajax jquery validate 1 9 jquery validate min js quot  gt  lt  script gt             lt script type  quot text javascript quot  gt              document  ready function                     quot  display quot   click function                                      ajax        create an ajax request to display php             type   quot GET quot               url   quot display php quot                            dataType   quot html quot       expect html to be returned                             success  function response                                          quot  responsecontainer quot   html response                      alert response                                                            lt  script gt            lt body gt       lt h3 align  quot center quot  gt Manage Student Details lt  h3 gt       lt table border  quot 1 quot  align  quot center quot  gt          lt tr gt              lt td gt   lt input type  quot button quot  id  quot display quot  value  quot Display All Data quot    gt   lt  td gt          lt  tr gt       lt  table gt       lt div id  quot responsecontainer quot  align  quot center quot  gt            lt  div gt       lt  body gt       lt  html gt    lt  php    save this as display php          show errors  error reporting E ALL   ini set  display errors   1         errors ends here     call the page for connecting to the db require once  dbconnector php      gt   lt  php  get member   quot  SELECT  empid  lastName  firstName  email  usercode  companyid  userid  jobTitle  cell  employeetype  address  initials   FROM employees quot    user coder1    con- gt prepare  get member    user coder1 - gt execute     echo  quot  lt table border  1   gt   lt tr gt   lt td align center gt   lt b gt Roll No lt  b gt  lt  td gt   lt td align center gt  lt b gt Name lt  b gt  lt  td gt   lt td align center gt  lt b gt Address lt  b gt  lt  td gt   lt td align center gt  lt b gt Stream lt  b gt  lt  td gt  lt  td gt   lt td align center gt  lt b gt Status lt  b gt  lt  td gt  quot    while  row   user coder1- gt fetch PDO  FETCH ASSOC     firstName    row  firstName     empid    row  empid     lastName       row  lastName     cell       row  cell         echo  quot  lt tr gt  quot       echo  quot  lt td align center gt  firstName lt  td gt  quot       echo  quot  lt td align center gt  empid lt  td gt  quot       echo  quot  lt td align center gt  lastName  lt  td gt  quot       echo  quot  lt td align center gt  cell lt  td gt  quot       echo  quot  lt td align center gt  cell lt  td gt  quot       echo  quot  lt  tr gt  quot     echo  quot  lt  table gt  quot     gt    lt  php    save this as dbconnector php function connected Db          dsn     mysql host localhost dbname mydb charset utf8        opt    array          PDO  ATTR ERRMODE              gt  PDO  ERRMODE EXCEPTION          PDO  ATTR DEFAULT FETCH MODE   gt  PDO  FETCH ASSOC             echo  quot Yes we are connected quot       return new PDO  dsn  username   password    opt           con   connected Db    if  con     echo  quot me  is connected  quot     else     echo  quot Connection faid  quot   exit        gt

User · Answer

For retrieving data using Ajax   jQuery  you should write the following code         lt html gt    lt script type  text javascript  src  jquery-1 3 2 js  gt   lt  script gt     lt script type  text javascript  gt      document  ready function              display   click function                              ajax        create an ajax request to display php         type   GET           url   display php                        dataType   html       expect html to be returned                         success  function response                                       responsecontainer   html response                  alert response                                lt  script gt    lt body gt   lt h3 align  center  gt Manage Student Details lt  h3 gt   lt table border  1  align  center  gt      lt tr gt          lt td gt   lt input type  button  id  display  value  Display All Data    gt   lt  td gt      lt  tr gt   lt  table gt   lt div id  responsecontainer  align  center  gt    lt  div gt   lt  body gt   lt  html gt    For mysqli connection  write this    lt  php   con mysqli connect  localhost   root          For displaying the data from database  you should write this     lt  php include  connection php    mysqli select db  samples   con    result mysqli query  select   from student   con    echo   lt table border  1   gt   lt tr gt   lt td align center gt   lt b gt Roll No lt  b gt  lt  td gt   lt td align center gt  lt b gt Name lt  b gt  lt  td gt   lt td align center gt  lt b gt Address lt  b gt  lt  td gt   lt td align center gt  lt b gt Stream lt  b gt  lt  td gt  lt  td gt   lt td align center gt  lt b gt Status lt  b gt  lt  td gt     while  data   mysqli fetch row  result            echo   lt tr gt        echo   lt td align center gt  data 0  lt  td gt        echo   lt td align center gt  data 1  lt  td gt        echo   lt td align center gt  data 2  lt  td gt        echo   lt td align center gt  data 3  lt  td gt        echo   lt td align center gt  data 4  lt  td gt        echo   lt  tr gt      echo   lt  table gt      gt

User · Answer

document  ready function        var response             ajax   type   GET               url   Records php               async  false           success   function text                          response   text                          alert response         needs to be     document  ready function            ajax   type   GET               url   Records php               async  false           success   function text                          alert text

User · Answer

You can t return ajax return value  You stored global variable store your return values after return  Or Change ur code like this one      AjaxGet   function  url        var result     ajax           type   POST           url  url         param                contentType   application json  charset utf-8           dataType   json          async  false          success  function  data                   nothing needed here                 responseText       return  result

[php] Using Jquery Ajax to retrieve data from Mysql

Examples related to php

Examples related to mysql

Examples related to ajax

Examples related to jquery