get data from mysql database to use in javascript

Question

I have a javascript that dynamically builds an html page   In the html page there are textarea boxes for the user to type information in   The information already exists in a database   I would like to populate the textarea boxes with the database in the mysql database  I have php code that will connect to the database and build an html table with the data  so I know how to do this with php  but I don t know how to do this from the javascrip  I ve studied ajax get requests  etc   but I m still not sure of how to do this

User · Answer

You can t do it with only Javascript  You ll need some server-side code  PHP  in your case  that serves as a proxy between the DB and the client-side code

User · Answer

Probably the easiest way to do it is to have a php file return JSON  So let s say you have a file query php    result   mysql query  SELECT field name  field value                        FROM the table     to encode   array    while  row   mysql fetch assoc  result        to encode      row    echo json encode  to encode     If you re constrained to using document write  as you note in the comments below  then give your fields an id attribute like so   lt input type  text  id  field1    gt   You can reference that field with this jQuery      field1   val     Here s a complete example with the HTML  If we re assuming your fields are called field1 and field2  then   lt  DOCTYPE html gt   lt html gt     lt head gt       lt title gt That s about it lt  title gt     lt  head gt     lt body gt       lt form gt         lt input type  text  id  field1    gt         lt input type  text  id  field2    gt       lt  form gt     lt  body gt     lt script src  http   ajax googleapis com ajax libs jquery 1 5 1 jquery min js  gt  lt  script gt     lt script gt        getJSON  data php   function data            each data  function fieldName  fieldValue                    fieldName  val fieldValue                        lt  script gt   lt  html gt    That s insertion after the HTML has been constructed  which might be easiest  If you mean to populate data while you re dynamically constructing the HTML  then you d still want the PHP file to return JSON  you would just add it directly into the value attribute

User · Answer

Do you really need to  build  it from javascript or can you simply return the built HTML from PHP and insert it into the DOM    Send AJAX request to php script PHP script processes request and builds table PHP script sends response back to JS in form of encoded HTML JS takes response and inserts it into the DOM

User · Answer

To do with javascript you could do something like this    lt script type  Text javascript  gt  var text    lt     text from db    gt   lt  script gt    Then you can use whatever you want in your javascript to put the text var into the textbox

[javascript] get data from mysql database to use in javascript

Examples related to javascript

Examples related to mysql

Examples related to database

Examples related to ajax