Send data to database when click on a link without page refresh

Is there a way to send data to database when click on a link without page refresh?

I u开发者_开发问答se php/mysql...

---

I will give you an example using jQuery.

Let's say that we have a link with an attribute id="button_id" (you have to learn the jQuery selectors ).

    $("#button_id").click(function(){
    var var_data = 5;
    $.ajax({
            url: "my_script.php",
            data: { var_PHP_data: var_data };
            success: function(data) {
                // do something;
                                  alert(data);
            },
     });
});

Explanation: you will send the variable var_data with the name var_PHP_data to a my_script.php without page refresh using an ajax call (using GET method).

This is very simple example of what you have to write on your PHP script.

<?php
$var_name = $_GET['var_PHP_data'];
echo 'This is what you have send'.$var_name;

?>

Because the default method to send variables in the ajax function in jQuery is GET.

We have to use the $_GET function in PHP.

This php script will print a message and this message will be handled in the success: function in the Ajax call and just for example we will alert this message returned from PHP.

---

You'd have to use JavaScript. When a user clicks a link, if you don't use JavaScript, then you need to go user -> server -> user and they get a whole new page.

HTTP is stateless.

---

It's not possible without a page refresh but this is the classic use-case for AJAX requests. If you're not familiar with AJAX then there are various methods of doing this using all the popular JavaScript frameworks such as Prototype and jQuery

---

You can't send data directly to a database, but you can use AJAX to send data to a php page that will save them to the database, without reloading the page or following the link in the browser..

Have a look at http://api.jquery.com/jQuery.post/

---

Not using PHP because it is server side - you need JavaScript / AJAX for this.

Check out frameworks like dojo (http://www.dojotoolkit.org/) , mootools (http://mootools.net/) or jQuery ( http://jquery.com/ ).

---

Yes, you can use AJAX.

This is a very big topic, but I'd recommend you do some research on AJAX and jquery (javascript).

Here are some tutorials:

http://www.ajaxf1.com/tutorial/ajax-php.html

http://www.talkphp.com/vbarticles.php?do=article&articleid=58&title=simple-ajax-with-jquery

Do a search in google for more info.