Unable to save data from javascript to MySql using PHP

Question

I have a problem that I unable to save data that are parsed from Javascript into PHP. The problem came when I implement WordPress. On single index.html it is working and data able to store in the database.

On Javascript file : (send data)

        var dbParam = JSON.stringify(data);
        console.log(dbParam);
        var obj, dbParam, xxmlhttp;
        xxmlhttp = new XMLHttpRequest();
        xxmlhttp.onreadystatechange = function () {
            if (this.readyState == 4 && this.status == 200) {
                // document.getElementById("demo").innerHTML = this.responseText;
            }
        };
        xxmlhttp.open("GET", "http://localhost/trackpage/dummy-data/saveDB.php?x=" + dbParam, true);
        xxmlhttp.send();
        console.log("send");

On PHP file: (get data)

header("Content-Type: application/json; charset=UTF-8");
$obj = json_decode($_GET["x"], false);
$conn = new mysqli ("localhost", "root", "", "laravelcrudwebapp");
$stmt = $conn->prepare("INSERT INTO tracks (data1,data2) VALUES (?, ?, )");
$stmt->bind_param("ss",$obj->data1,$obj->data2);
$stmt->execute();
$stmt->close();
$conn->close();

What is the output when you var_dump($obj); exit; ? Did you check it? — Sider Topalov
– Sider Topalov, Commented May 23, 2018 at 8:50
how to check the var_dump($obj) i try using echo to send data to test. Because i use wordpress — Abdul Rahim
– Abdul Rahim, Commented May 23, 2018 at 9:03

Máté Safranka · Accepted Answer · 2018-05-23 08:52:28Z

1

If you're going to send your data as a GET parameter, you have to URL-encode it first:

var dbParam = encodeURIComponent(JSON.stringify(data));

However, I will point out that it is extremely bad practice to perform write operations via GET requests. You're leaving yourself wide open for all sorts of abuse and cross-side scripting attacks. For starters, you can read this post, as well as do some research on Google:

https://softwareengineering.stackexchange.com/questions/188860/why-shouldnt-a-get-request-change-data-on-the-server

answered May 23, 2018 at 8:52

Máté Safranka

4,1061 gold badge12 silver badges22 bronze badges

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

1 Comment

Abdul Rahim Over a year ago

this is the answer for the question. Thank you

Collectives™ on Stack Overflow

Unable to save data from javascript to MySql using PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related