Using native PHP mysql functions in HostBill

HostBill use PDO to perform database operations. Even if it allows for awesome programming techniques its still not that popular method of database operations in PHP. If you find using standard PHP mysql functions more easy to use, you can now use them in HostBill modules you're working on!

 

  1. Add this code at the top of your custom module:

     NativeMySQL::connect();
  2. Thats it, you can use standard mysql functions now!

Examples


PDO-approach:

 $q=$this->db->query("SELECT * FROM hb_client_details");
 while($row = $q->fetch(PDO::FETCH_ASSOC) {
    print_r($row);
 }

Standard mysql functions

 NativeMySQL::connect();
 $q=mysql_query("SELECT * FROM hb_client_details");
 while ($row = mysql_fetch_array($q)) {
     print_r($row);
 }