Ajax and mysql

[eluser]xwero[/eluser]
Ajax provides javascript with the opportunity to call other urls to manipulate or fetch data. It's like using an api.

So you can call any controller method want. You can create an ajax specific controller or you can add the ajax methods to the 'normal' controller. That is for you to decide.

A basic example. You have a controller and method user/update. With jQuery you do

Code:

$.ajax({
   type: "POST",
   url: "index.php/user/update",
   data: $("form").serialize(), // get all the form field values
   success: function(msg){
     alert( "Data Saved: " + msg );
   }
});

msg is a string that is echoed by the method. you can send a plaintext string or a formatted string (json,xml). If you send success and error strings in plain text you can prefix them with error : and success : .

I suggest you read as much as you can about ajax and learn to use the methods of the library you are going to use.