Best practice to handel ajax jquery database queries?

Question

Hi,

I have a "little" problem because I dont know whats the best way to handle ajax jquery databeas request?

So far I've done it this way: For ever (single) database request I created a new .php file like:

newbill.php
newcosumer.php
listallbills.php
updatecostumer.php

..and so on and pull the data via:

$.ajax({
 type: "POST",
    url: "ajax/newbill.php",
    data: "..."
    success: function(msg){    
    ...
    }
 }); 

..what I dont like is all the .php files for only ONE! database request!? There must be a better way to handle this??

Answer 1

You could create a single file called ie. dbrequest.php and pass it parameters, that you then read from php and make the appropriate request to the database..

But it would depend on what exactly you are doing inside your pages, and if it is easy to maintain in a single file..

Answer 2

I would do it in this way.

Create a php file for each entity (Ex : consumerajax.php , billajax.php,etc...) then have seperate functions for each of your database queries.When calling from the javascript pass a querystring variable to determine which function to be executed in the ajax server page

Ex : In consumerajax.php

 <?php

    $mode= $_GET["mode"] ;
    if($mode=="getconsumerdet")
    {
       $consumerId=$_GET["cid"];
       GetConsumerDetails($consumerId)
    }
    else if($mode=="updateconsumer")
    {
      $consumerId=$_GET["cid"];
      $name=$_GET["name"];
      UpdateConsumerInfo($consumerId, $name)
    }

    function GetConsumerDetails($consumerId)
    {
       // execute query the table here and return the result from here
      echo"Have the data and return"
    } 
    function UpdateConsumerInfo($consumerId,$name)
    {
      //execute query to update
     echo "updated";
    }

?>

and from your scrip call like

  $.ajax({ type: "POST", url: "ajax/consumerajax.php?mode=getconsumerdet&cid=34", data: "..." success: function(msg){   });

or

  $.ajax({ type: "POST", url: "ajax/consumerajax.php?mode=updateconsumer&cid=34&name=shyju", data: "..." success: function(msg){   });