codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Multiple MySQL databases on a single webpage

    27th June 2014

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
     
    $db1 = mysql_connect($hostname, $username, $password);
    $db2 = mysql_connect($hostname, $username, $password, true);
     
    mysql_select_db('database1', $db1);
    mysql_select_db('database2', $db2);
     
    //Then to query database 1, do this:
     
    mysql_query('select * from tablename', $db1);
     
    //and for database 2:
     
    mysql_query('select * from tablename', $db2);
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN