Update MY SQL DB Table from jQuery

Question

Based on the user input's, i calculate some values on my submit action of my form. I have to persist these values in my backend DB. I use PHP for my server side scripting. Please let me know the best practice for doing this. It is a single page application and i use .load("Report.html"); to show the summary page.

Just thinking aloud, can i fetch the row(to be updated) from DB, json_encode, update the json object in jQuery, decode it, then update in DB?

Please help...

My submit button code...

$('form').on('submit', function(event)
    {
        event.preventDefault();

        //CALCULATE SCORE
        var noOfCorrectAnswers = 0;
        var noOfQuestionsViewed = 0;
        $.each(questionsArray, function(i, item)
        {
            if(item.correctOption == item.selectedAnswer)
            {
                noOfCorrectAnswers++;
            }

            if(item.isQuestionViewed == 'YES')
            {
                noOfQuestionsViewed++;
            }

        }); 

        alert(noOfQuestionsViewed);
        $('#sampleDiv').load("UserReport.html");        
    });

Bilal Akil · Accepted Answer · 2014-01-03 04:18:54Z

Run some AJAX passing all of the information you need (which may even be none depending on your use case) from the client-side to your server-side PHP. Your PHP script can fetch things from the database if necessary, make any calculations and/or manipulations and then store the information back in the DB.

If you need to return information to your client-side after updating the database then try returning a JSON object (by just printing the code out in the proper format) from your PHP script before exiting with whatever your JS needs.

Do note that this should be all done asynchronously, so you need to setup your AJAX callback function to handle any information that's returned from your PHP script. If you want to do it synchronously, go for it - but you asked for best practices :P

Looks like you're using jQuery - here's the documentation on AJAX

Raunak Kathuria's answer provides some same code

Raunak Kathuria · Accepted Answer · 2014-01-03 04:08:29Z

On form submit make ajax call to set database in the db and access the json

$('form').on('submit', function(event)
{ ...
 alert(noOfQuestionsViewed);

$.ajax({
    url: "yourphp.php", // php to set the data
    type: 'POST',
    data: 'yourparams', // all the input selected by users
    dataType: json
    success: function(json){

        //here inside json variable you've the json returned by your PHP
        // access json you can loop or just access the property json['sample']
         $('#sampleDiv').load("UserReport.html", function () {
            // its callback function after  html is loaded
            $('#someid').html(json['sample'));
         });

    }
})

You can also use the done callback of ajax

PHP

yourphp.php

Set the values here in db running the desired query and return values using

<?php

// your db ooperations will come here

// fetch the db record 

// return the db records in json

$responseVar = array(
       'message'=>$message,
       'calculatedValue'=>$calculated
  );
echo (json_encode($responseVar)); 
?>

many Thanks sir. The ajax call is established successfully. But when i try to get some response from the php there is a problem. In the .php file i have, <?php echo 'hello'; ?>. When i alert the parameter in the success function, it gives me the entire php file. The datatype requested in the ajax call is "text". Please let me know where i am making a mistake.
Are your running php on server and is php enabled on server? Check stackoverflow.com/questions/19731157/…

Collectives™ on Stack Overflow

Update MY SQL DB Table from jQuery

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related