/
Using native PHP mysql functions in HostBill

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);
 }


 

Related content

Adding Contract details to Emails and Invoice Templates
Adding Contract details to Emails and Invoice Templates
Read with this
System requirements
System requirements
More like this
Support Tickets: Removing tickets older than 3 years
Support Tickets: Removing tickets older than 3 years
Read with this
Configure HostBill to use Mysql over SSL
Configure HostBill to use Mysql over SSL
More like this
How To Articles
How To Articles
Read with this
MoneyBookers
MoneyBookers
More like this