Running loop from javascript to save in Mysql

Question

Hello i am currently running a javascript on my php page (below) and it comes out with each data that i need is there any way i can connect this through to mysql database? (i am new to javascript)

<script>
 var allItems = JSON.parse(localStorage.getItem('itemsArray')) || [];
for(var i = 0; i < allItems.length; i++) {
  var item = allItems[i];
  console.log('Current item: %o', item);

}
</script>

'itemsArray comes from a save function'

function save(){

var oldItems = JSON.parse(localStorage.getItem('itemsArray')) || [];

var newItem = {};
var num = document.getElementById("num").value;

newItem[num] = {
    "methv": document.getElementById("methv").value
    ,'q1': document.getElementById("q1").value,
    'q2':document.getElementById("q2").value,
    'q3':document.getElementById("q3").value,
    'q4':document.getElementById("q4").value,
    'comm':document.getElementById("comm").value
};


oldItems.push(newItem);

localStorage.setItem('itemsArray', JSON.stringify(oldItems));


});

Thanks

PS I already have the connection for the database setup

JavaScript executes on the client side. Usually, MySQL resides on the server. So to do that, you would have to do an AJAX request to the server to store/retrieve data. Unless this is a very weird scenario where MySQL would reside on the client machine, in which case I have no idea if it's possible with JavaScript, but I would guess that it is not. — Travesty3
– Travesty3, Commented Mar 15, 2013 at 14:42

marc_s · Accepted Answer · 2016-05-04 21:03:27Z

1

Post your data with ajax/json request to a php function and do all database related work with php. Next return successful or failure status which will be catch in this called js function, and then you can display the success or failure message with javascript.

Example:

Include jQuery library:

<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>

Script for ajax request with jQuery:

    var path = 'http:/your_url/your_php_script_file.php';
    var data = 'json_data=' + JSON.stringify(newItem[num]);
        $.ajax({
            url: path,
            type: "POST",
            data: data,
            cache: false,
            success: function ($returm_msg){
                alert($returm_msg);
            }
        });

PHP for save/update in database:

$receive_value = json_decode($_POST['json_data'], true));

You will get values like

$receive_value['methv'],$receive_value['q1'],....,$receive_value['comm'];

Now do save operation in database.

$result = mysql_query("INSERT INTO .....") or die(mysql_error());
if($result){
    return "Success!"; // if not function then simply echo "Success!";
}else{
    return "Failure!"; // if not function then simply echo "Failure!";
}

Helpful links:

edited May 4, 2016 at 21:03

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 15, 2013 at 14:45

Tahmina Khatoon

1,0913 gold badges11 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2162768 Over a year ago

Sorry i am kinda new with Ajax/Json could you show an example or a link please?

Amareswar Over a year ago

Learn about Ajax what it is and how it helps. Search for Ajax and you will find lots of sources to learn from. This community not for suggesting links to external sites

Oliver Spryn Over a year ago

I would recommend against using the mysql_* function library, since it is deprecated.

Collectives™ on Stack Overflow

Running loop from javascript to save in Mysql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related