This is a common problem faced by many PHP/MySQL Developers.Sometimes you need to retreive data from 2 different databases and save them in a file.But the main problem here is that Config file points to only one database.So how do you join the two databases with your query.The below given PHP Code just does that for you.It shows you, how you can write a query to Join 2 separate database and fetch the required information.
Note that the above given PHP code is tried and tested.So you can use it straightaway.Just replace the Database Name, Username,Password and SELECT Queries (represented in BLUE color) as required.
Like this Stuff! Subscribe to our blog and we will email you working solutions of all common problems faced by a PHP Developer.
<?php include "/home/db1/connections.php";?>
<?php
$db = "DATABASE1 NAME"; // name of the db
$host = $_SERVER[secret_db_host]; // db host name
$user = "DATABASE1 USERNAME"; // db username
$password = "DATABASE1 PASSWORD"; // db password
$object= new mysql($host, $user, $password, $db);
$object->connect();
$object->select();
$sql = "SELECT email, first_name, last_name FROM em_subscriber ORDER BY first_name";
$object->query($sql);
while($object_res = $object->fetchObject())
{
$emails[]=$object_res->email;
$contents.=$object_res->first_name." ";
$contents.=$object_res->last_name." ";
$contents.=$object_res->email." ";
$contents.=$answer." ";
}
$db = "DATABASE2 NAME"; // name of the db
$host = $_SERVER[secret_db_host]; // db host name
$user = "DATABASE2 USERNAME"; // db username
$password = "DATABASE2 PASSWORD"; // db password
$object= new mysql($host, $user, $password, $db);
$object->connect();
$object->select();
$sql = "SELECT firstname,
lastname,
emailaddress,
date_of_birth,
postcode,
new_bookings.checkin_date AS booking_date,
new_bookings.id AS b_id
FROM customers
LEFT OUTER JOIN new_bookings
ON new_bookings.customer_id = customers.customer_id
GROUP BY customers.customer_id
ORDER BY lastname";
$object->query($sql);
while($object_res = $object->fetchObject())
{
if (!in_array($object_res->emailaddress, $emails))
{
$contents.=$object_res->firstname." ";
$contents.=$object_res->lastname." ";
$contents.=$object_res->emailaddress." ";
$contents.=$object_res->postcode." ";
$contents.=$object_res->date_of_birth." ";
$contents.=$object_res->booking_date." ";
$contents.=$answer." ";
$not_found++;
echo "<span style="color:green">".$object_res->emailaddress." Not Found In Database</span><br />";
}
else
{
$found++;
echo "<span style="color:red">".$object_res->emailaddress." Found In Database</span><br />";
}
}
$contents = strip_tags($contents); // remove html and php tags etc.
//header(Content-type: application/ms-excel);
//header("Content-Disposition: attachment; filename=both.xls");
//print $contents;
echo $found."Found<br />";
echo $not_found."Not Found<br />";
?>
Note that the above given PHP code is tried and tested.So you can use it straightaway.Just replace the Database Name, Username,Password and SELECT Queries (represented in BLUE color) as required.
Like this Stuff! Subscribe to our blog and we will email you working solutions of all common problems faced by a PHP Developer.
