Using the same counter for a javascript function and a php query

Question

I am seeking to increment a variable (counter) each time a DIV is clicked. The variable of the counter is used to select a question_id in another table so I need to reference it both in JAVASCRIPT and PHP .

Here is my code:

     <script type="text/javascript">
           var i= 1;
           $(document).ready(function(){
           $("#input01, #input02, #input03, #input04, #input05").click(function(){
         var value01 = $(this).attr('value'); 
         var value02 = i;                   
         $.post('input_answers.php',{value:value01,id_question:value02});
         var value02 = i+1;
         });    
});          
    </script>

Below is the query to insert the data ('input_answer.php')

mysqli_query($connect, "INSERT INTO `answers` VALUES ('".$_POST['id_question']."' , '".$_POST['value']."' ) ");

My problem is that I'd like to incremen a variable to display a new question each time one of the DIV is clicked.

Thank you for your help.

Why are you using '1' in the VALUES clause of the answers table? Please show your create table syntaxes for both tables. Also, where and how do you imagine to run the query for displaying the question(s)? Show the select statement (as you think it should look like) please. — PajuranCodes
– PajuranCodes, Commented Mar 13, 2018 at 17:36
I used the '1' just to 'lock 'another value. This is not relevant to my pb. — SamanthaAlexandria
– SamanthaAlexandria, Commented Mar 13, 2018 at 18:16

u_mulder · Accepted Answer · 2018-03-13 17:34:26Z

1

Correct way to pass mutliple values to server is:

$.post('input_answers.php',{value:value01, id_question:value02});

Your case:

$.post(
    'input_answers.php',   // URL
    {value:value01},       // data passed to server
    {id_question:value02}  // third argument, which is NOT passed to server
);

Update: correct way to increase your counter is to wait until request is over and add 1 in a callback:

$.post(
    'input_answers.php',
    {value:value01, id_question:value02},
    function () {
        // as your i is a global variable you can increase it here
        i += 1
    }
);

edited Mar 13, 2018 at 17:34

answered Mar 13, 2018 at 17:12

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

5 Comments

SamanthaAlexandria Over a year ago

Thank you u_mulder I corrected the syntax and the data is passed. Any idea about the counter issue?

u_mulder Over a year ago

What is the counter issue?

SamanthaAlexandria Over a year ago

I have updated my code. I would like value02 to increment after each click and be able to use this variable when selecting my question such as in: SELECT label_question WHERE id_question=value02.

Steve Padmore Over a year ago

You are only setting value02 to i + 1 (i is always 1, plus 1 is always 2). Just change 'var value02 = i+1;' to 'value02 = ++i;' (or better still 'var value02 = i; ' to 'var value02 = i++;' and remove 'var value02 = i+1;'.

u_mulder Over a year ago

Ask another question, I don't understand how clicking and selecting are connected.

Collectives™ on Stack Overflow

Using the same counter for a javascript function and a php query

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related