php - insert data into two tables of different databases on same instance and same user -

i inserting below data in brokers3_finalmain database in phpfox_user , phpfox_user_custom want insert data full_name , country_iso in other database mobile @ same time .

public function delete_mobile($data) {     $params = array( ':mobile' => $data);     $sql = "delete mobile mobile=:mobile";     $stmt = parent::query($sql, $params);  }  public function update_profile($data) {     $sql = 'update phpfox_user set full_name=:full_name, email=:email user_id=:user_id';     $params =(array(         ':full_name' => $data['full_name'],         ':email' => $data['email'],         ':user_id' => $data['user_id']                   ));     //print_array($params);      parent::query($sql, $params, '', 'main') or die(parent::$dbh->errorinfo()); }  public function register_user($data) {     //print_r($data);     //$data=$data[0];     //print_r($data);     $params = array( ':email' => $data['email'], ':cf_mobile' => $data['mobile']);     $sql = "select * phpfox_user, phpfox_user_custom phpfox_user.email=:email , phpfox_user_custom.cf_mobile=:cf_mobile";     $stmt = parent::query($sql, $params, '', 'main');     while($row = $stmt->fetch(pdo::fetch_assoc)) :         $res=$row;     endwhile;      if(count($res)>=1)     {         $result['status']='fail';         $result['message']='user exits';         $result['user_id']=$res['user_id'];     } else {         $pass=md5(md5($data['password']).md5('78>'));         $sql = 'insert phpfox_user (full_name, email, password, password_salt, user_group_id, country_iso)          values(:full_name, :email, :password, :password_salt, :user_group_id, :country_iso)';          $params =(array(             ':full_name' => $data['full_name'],             ':email' => $data['email'],             ':password' => $pass,             ':password_salt' => '"q>',             ':user_group_id' => $data['user_group_id'],             ':country_iso' => $data['location']                      ));         //print_array($params);          parent::query($sql, $params, '', 'main') or die(parent::$dbh->errorinfo());         # affected rows?         $user_id=parent::$dbh->lastinsertid();          $sql = 'insert phpfox_user_custom (user_id, cf_mobile)          values(:user_id, :cf_mobile)';         $params =(array(             ':user_id' => $user_id,             ':cf_mobile' => $data['mobile']         ));         //print_array($params);          parent::query($sql, $params, '', 'main') or die(parent::$dbh->errorinfo());         # affected rows?         //return parent::$dbh->lastinsertid();         //return $user_id;         $result['status']='success';         $result['message']='registeration successfully';         $result['user_id']=$user_id;     }     return $result; } 

if both db reside on same mysql server , establish connection without picking database, put name of database in front of tablename like

insert mydbname.mytablename (mykey) values (:mykey); 

if have connection 1 db can change before inserting.

$pdoconnetion->select_db('mydbname'); insert mytablename (mykey) values (:mykey);