Saturday, March 24, 2012

Multiple mysql connection with different servers

If you want to connect with different server with different credentials, then you need to connect with all the different servers and for each handle, you need to select the database and the queries.
$handle_db1 = mysql_connect("localhost","myuser","apasswd"); 
$handle_db2 = mysql_connect("127.0.0.1","myuser","apasswd"); 
$handle_db3 = mysql_connect("localhost:3306","myuser","apasswd"); 
$handle_db4 = mysql_connect("localhost","otheruser","apasswd"); 

We select the databases with each handle.
// give each handle it's own database to work with, permanently. 
mysql_select_db("db1",$handle_db1); 
mysql_select_db("db2",$handle_db2); 
mysql_select_db("db3",$handle_db3); 
mysql_select_db("db4",$handle_db4); 

And for querying the databases, we also set the handlers here.
//do a query from db1: 
$query = "select * from test"; $which = $handle_db1; 
mysql_query($query,$which); 
The below is for our second database.
//do a query from db2 : 
$query = "select * from test"; $which = $handle_db2; 
mysql_query($query,$which);

See the book OpenCart 1.4 Template Design Cookbook.
See the book Joomla Mobile Development Beginners Guide




List of my works:

Opencart Extensions:

  1. Product Based Quantity Wise Shipping: Find it here.
  2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
  3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
  4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
  5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
  6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

  1. OpenCart 1.4 Template Design Cookbook.
  2. Joomla Mobile Development Beginners Guide

No comments: