Run MySQL Query From Button Click

Question

How can I run a MySQL query from the onclick event of an HTML button on my site?

For example if my button is created like so, how could I use this to run a MySQL query titled AddInfo

<p><button type="button">Run A SQL Stored Procedure</button></p>

saibbyweb · Accepted Answer · 2016-04-17 05:10:02Z

2

You need PHP for that. Here's an example :

<html>
<form action='' method='POST'>
<input type='submit' name='submit' />
</form>
</html>

and then

if(isset($_POST['submit'])){
//execute mysql query
}

Use Sourcerer to include PHP scripts inside a custom HTML module.

EDIT :

How to use Sourcerer ?

After the plugin is installed, a button (CODE) is added below the WYSIWYG editor :

Clicking on Code button opens a pop-up, enter your code between {source} and {/source} tags like this:

Hit the green Insert button to add this code to your Article or Custom HTML module :)

answered Apr 16, 2016 at 17:48

saibbyweb

2,2994 gold badges23 silver badges50 bronze badges

1

You don't need to include html tags ;) they already exist in the template
– Lodder
Commented Apr 16, 2016 at 19:55
I have installed this extension, how to use it in my article so that I can use the syntax? Does Joomla auto-detect that the extension is installed and can use PHP?
– NadineSmithJonesPicard
Commented Apr 17, 2016 at 2:33
1

@NadineSmithJonesPicard Answer updated with Sourcerer tutorial ;)
– saibbyweb
Commented Apr 17, 2016 at 5:10

Add a comment |