Re: [DB mysql]Multiple connection (bug 13232)
| From: | Pierre-Alain Joye | Date: | Mon, 31 Dec 2001 11:26:00 +0000 |
| Subject: | Re: [DB mysql]Multiple connection (bug 13232) | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-3728@lists.php.net to get a copy of this message | ||
The script :
<?php
require_once 'DB.php';
require_once "DB_Pager/Pager.php";
$user = 'user1';
$pass = '';
$host = 'localhost';
$db_name = 'source';
// Don't work if you keep the same user
// $user_dest = 'user1';
$user_dest = 'user2';
$pass_dest = '';
$db_name_dest = 'dest';
$dsn = "mysql://$user:$pass@$host/$db_name";
$dsn_dest = "mysql://$user_dest:$pass_dest@$host/$db_name_dest";
$dbwrapper = new DB();
$db = $dbwrapper->connect( $dsn );
$dbwrapper_dest = new DB();
$db_dest = $dbwrapper_dest->connect( $dsn_dest );
// Print out the ressource ID
echo $db_dest->connection."/".$db->connection;
if(DB::isError($db_dest)){
die( $db_dest->getMessage() );
}
if(DB::isError($db)){
die ($db->getMessage());
}else{
$db->setFetchMode(DB_FETCHMODE_ASSOC);
if( DB::isError( $res ) ){
die ( DB::ErrorMessage( $res ) );
}else{
$sql = 'SELECT grp AS vig FROM items';
$rows = $db->getAll($sql);
while ( list(,$row) = each($rows) ){
$dest_name = $row['vig'];
$dest_id = $db_dest->nextID('vig_items');
$sql = "INSERT INTO vig_items (vig_id,vig_name)
VALUES('$dest_id','$dest_name')";
$res_dest = $db_dest->query($sql);
if( DB::isError( $res_dest ) ){
die( $db_dest->getMessage() );
}else{
echo "Insert OK";
}
}
}
}
$db->disconnect();
$db_dest->disconnect();
?>