On click INSERT INTO mySQL without updating the current page

I am working with PHP and mySQL. On page1.php there will be an image th开发者_StackOverflow社区at when the user clicks on it there will be a query that inserts into mysql some data. How can I do this without reloading the page or transferring the user someone else and change the image?

What I did so far is to do this but with reloading the page.

Thanks for your ideas/examples.

It is as simples as executing the post method of jQuery library.

Here is an example that calls a PHP script when clicking any image.

$(document).ready(function() {
    $("img").click(function() {
        $.post("executequery.php");
    });
});

In the "executequery.php" you would need to build the SQL and execute it.

Here is the documentation of the method. http://api.jquery.com/jQuery.post/

Using jquery, add an ajax call to a php script which should be able to run the insert script and return a success message.