How to call sql command in php without submitting a form?

Question

I want to execute sql command such as

$query_run = mysql_query($query);

in php. But the only way I can find to trigger php event is to submit a form using:

if(isset$POST['submit']) {
    $query_run = mysql_query($query);
}

But this would refresh the page and wipe off every thing that dynamically created on the page.

What I want is to have a button, press which to trigger sql commands without reloading the page like onclick in js. However, sql command cannot be run inside js function (as I can find).

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — John Conde
– John Conde, Commented Dec 20, 2012 at 1:46
Thanks for the tutorial, it helps a lot. I've just replaced the old code with PDO. So, I can use PDO inside js now? — Kyle Xie
– Kyle Xie, Commented Dec 20, 2012 at 2:23

Ilion · Accepted Answer · 2012-12-20 01:51:28Z

1

PHP is parsed server side which means you can't have it run code without making a server request. Once the page is delivered to the client any php parsing is complete.

You can create a button or link that will send off an http request through javascript, an AJAX call, to a small php script that does the database work you want done. You wouldn't have it call your whole page again. The output from this gets returned to the javascript and can be used to update a CSS block element with success or failure notices.

Here's the W3C Ajax tutorial http://www.w3schools.com/ajax/default.asp

answered Dec 20, 2012 at 1:51

Ilion

6,8923 gold badges28 silver badges47 bronze badges

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

Comments

staticsan · Accepted Answer · 2012-12-20 01:48:22Z

1

What you need to do is an AJAX call. This requires Javascript (preferably with the help of a library such as jQuery) to assemble the date from the page, make the call to the PHP page, and to present the results onto the page.

answered Dec 20, 2012 at 1:48

staticsan

30.6k5 gold badges64 silver badges72 bronze badges

Collectives™ on Stack Overflow

How to call sql command in php without submitting a form?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related