Editing Javascript to Call MySQL [duplicate]

Question

I have this function that fires when a checkbox form is submitted:

function report_build() {
   var checked_count = 0;
   var where = ""
   $('.peer:checked').each(function (i) {
   checked_count++;
   var label = $(this).parent().next().html();
   where +=  "'" + label + "', "   
                });
   $('#tabs-1').html(where);
   $('#ui-id-6').click();

            }

I want to send the where variable to a PHP script to use in the where clause of a select list. What's the easiest way to do that?

Thanks!

Check these out: stackoverflow.com/questions/25395395/… | stackoverflow.com/questions/16834138/… | stackoverflow.com/questions/5306479/… — mariocatch
– mariocatch, Commented May 7, 2017 at 23:09
There's no php or mysql code here, which IMHO automatically makes this question both unclear and too broad. There's also no HTML to support the code posted. — Funk Forty Niner
– Funk Forty Niner, Commented May 7, 2017 at 23:47
Your acceptance record is questionable, regarding past questions with possible solutions given. — Funk Forty Niner
– Funk Forty Niner, Commented May 7, 2017 at 23:49
I will go back and accept the answers that solved my issues. I apologize for neglecting to do that. — superblowncolon
– superblowncolon, Commented May 8, 2017 at 0:57

Nathan van Jole · Accepted Answer · 2017-05-07 23:45:29Z

0

You will have to use AJAX for that.

A simple post should do the job:

$.post('handle-sql.php', {where: where}, function(data) {
    // In the handle-sql.php script, use $_POST['where'];
    // Callback function: called after php script is completed
    // Where 'data' is the echo'ed data from the PHP script
});

answered May 7, 2017 at 23:45

Nathan van Jole

5214 silver badges10 bronze badges

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

Comments

user7977875 · Accepted Answer · 2017-05-07 23:10:41Z

0

You should try to POST or GET it with an HTML <form>. They send to PHP, but otherwise javascript is run client-side.

answered May 7, 2017 at 23:10

user7977875

Comments

Ümit Aparı · Accepted Answer · 2017-05-07 23:12:03Z

0

I'm not quite sure about what you're asking but if I'm not mistaken you want to send a variable from javascript to php. You can easily do that with ajax. Here's an example;

$.ajax(
{
    type: "POST",
    url: "your_php_name.php",
    data: { 
        'where' : where
    },
    dataType: "html",
    success: function(answer)
    {
        //fires when php finishes it job.           
    }
});

And on php side, you can read the variable with $_POST['where'];

answered May 7, 2017 at 23:12

Ümit Aparı

5782 gold badges7 silver badges25 bronze badges

Collectives™ on Stack Overflow

Editing Javascript to Call MySQL [duplicate]

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related