Javascript function post and call php script

Question

In html I have several buttons which are automatically made for each object in the database with a particular status. Each button gets its own id.

echo '<Button id="button'.$counter.'" onClick="clickedbutton('.$counter.', '.$row['OrderID'].')" >'."<center>".$row['OrderID']."<br>"."</center>".'</Button>';

The button calls the javascript function clickedbutton and gives it the number of the button and the orderid of that button.

function clickedbutton(buttonid,orderid){
buttonid = "button" + buttonid;

}

This function loads in the number of the button and makes it button0, button1 etc. The orderid is also succesfully passed through. Now in the function I want to call an external php script, but also orderid must be passed through to the script.

<?php
    //connect to database
    include_once('mysql_connect.php');

    // Select database
    mysql_select_db("test") or die(mysql_error());

    // SQL query
    $strSQL = "update orders set OrderStatus = 'In Progress' where OrderID = '" + orderid + "'";

    mysql_close();
?>

I know about the mysqli protection and all, I will adjust that later. Now I want to focus on the question above, how to call and pass through the variable orderid to the phpscript.

Savas Vedova · Accepted Answer · 2018-05-03 14:24:50Z

23

EDIT 2018

Yeah, I am still alive. You can use the fetch API instead of jQuery. It is widely supported except (guess who?...) IE 11 and below but there is a polyfill for that. Enjoy modern coding.

Support for fetch API

OLD ANSWER

You will have to use AJAX.

Javascript alone cannot reach a php script. You will have to make a request, pass the variable to PHP, evaluate it and return a result. If you'are using jQuery sending an ajax request is fairly simple:

$.ajax({
    data: 'orderid=' + your_order_id,
    url: 'url_where_php_is_located.php',
    method: 'POST', // or GET
    success: function(msg) {
        alert(msg);
    }
});

and your php script should get the order id like:

echo $_POST['orderid'];

The output will return as a string to the success function.

EDIT

You can also use the shorthand functions:

$.get('target_url', { key: 'value1', key2: 'value2' }).done(function(data) {
    alert(data);
});

// or eventually $.post instead of $.get

edited May 3, 2018 at 14:24

answered May 30, 2013 at 10:54

Savas Vedova

5,7023 gold badges30 silver badges45 bronze badges

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

2 Comments

DaViDa Over a year ago

DaViDa Over a year ago

$strSQL = "update orders set OrderStatus = 'In Progress' where OrderID = '" + $_POST['buttonid'] + "'";

Jesús Carrera · Accepted Answer · 2013-05-30 10:57:18Z

1

Assuming you don't want to use AJAX, you can do something like this in your clickedbutton function:

window.location.replace('path/to/page.php?orderid=' + orderid);

and then in your page.php

"...where OrderID = '" . $_GET('orderid') . "'";

(note the dots to join strings)

answered May 30, 2013 at 10:57

Jesús Carrera

11.5k4 gold badges66 silver badges55 bronze badges

Comments

Ivo Pereira · Accepted Answer · 2019-08-22 14:50:51Z

1

By using Ajax.

function clickedbutton(buttonid,orderid){

    $.post("page.php", { buttonid: buttonid })
    .done(function(data) {
        alert("Data Loaded: " + data);
    });

}

In php you get it with $_POST.

//[..] previous php code
$strSQL = "update orders set OrderStatus = 'In Progress' where OrderID = '" + $_POST['buttonid'] + "'";
//[..] rest of php code

Watch out for SQL injection. Don't take this advice as written.

edited Aug 22, 2019 at 14:50

answered May 30, 2013 at 10:51

Ivo Pereira

3,5101 gold badge22 silver badges24 bronze badges

Comments

sAnS · Accepted Answer · 2013-05-30 10:53:00Z

0

you can try like this

var url = myurl +'?id=' + orderid;
window.location.href = url;

and in php page

 $strSQL = "update orders set OrderStatus = 'In Progress' where OrderID = '".mysql_real_escape_string($_GET['id'])."'";

Edit

If you want to load the php file without page refresh then you can try as fellow friends suggested..

answered May 30, 2013 at 10:53

sAnS

1,1631 gold badge8 silver badges10 bronze badges

Comments

HarryFink · Accepted Answer · 2013-05-30 11:00:27Z

0

The easiest way is to build a query string and attach it to the end of the php script's url.

function clickedbutton(buttonid,orderid){
    var url = 'script.php?';
    var query = 'buttonid=' + buttonid + '&orderid=' + orderid;

    window.location.href = url + query
}

In the php script you can access the parameters via like this:

<?php
echo $_GET['buttonid'];
echo $_GET['orderid'];

answered May 30, 2013 at 11:00

HarryFink

1,0001 gold badge6 silver badges6 bronze badges

Collectives™ on Stack Overflow

Javascript function post and call php script

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related