The code example from this page shows how to make a MySQL SELECT with JOIN table of different database, using PDO.
The trick is to specify both the database name and table in the SQL query, by using the syntax: database_name.table_name.
- This method works if you use an user and password for connecting to MySQL that has access to both databases.

Complete code example

// Data for connecting to MySQL
$mysql =['host'=>'localhost', 'dbname'=>'db_1', 'user'=>'root', 'pass'=>'password'];

//connects with PDO 
try {
  $conn = new PDO('mysql:host='. $mysql['host'] .'; dbname='. $mysql['dbname'], $mysql['user'], $mysql['pass']);
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //set the PDO error mode to exception
}
catch(PDOException $e){ exit('Connection failed: '. $e->getMessage());}

$sql ="SELECT t1.id, t1.name, t2.col_db2 FROM db_1.table1 AS t1
 LEFT JOIN db_2.table2 AS t2 ON t1.id = t2.id";
$stmt = $conn->query($sql);

if($stmt !== false) {
  //shows selected data
  foreach($stmt as $row) {
    echo $row['id'] .'--'. $row['name'] .'--'. $row['col_db2'] .'<br>';
  }
}
else {
  echo '0 results';
}
- In this way you can join multiple tables from different databases.

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which attribute specifies the HTTP method (GET, POST) used to submit the form-data?
action method value
<form action="script.php" method="post"> ... </form>
Which CSS property allows to add shadow to boxes?
background-image box-shadow border-radius
#id {
  background-color: #bbfeda;
  box-shadow: 11px 11px 5px #7878da;
}
Which function removes the first element from an array?
pop() push() shift()
var fruits = ["apple", "apricot", "banana"];
fruits.shift();
alert(fruits.length);           // 2
Indicate the function that can be used to check if a PHP extension is instaled.
function() filetype() extension_loaded()
if(extension_loaded("PDO") === true) echo "PDO is available."
Mysql SELECT JOIN tables on two different Databases

Last accessed pages

  1. Understanding Events (142)
  2. Node.js Move and Copy file (18318)
  3. RegExp - Regular Expressions in ActionScript (3593)
  4. Read Excel file data in PHP - PhpExcelReader (76326)
  5. Zodiac Signs JavaScript code (6314)

Popular pages this month

  1. Making DIV Contents Scroll Horizontally, with multiple Div`s inside (491)
  2. Contact page - CoursesWeb (476)
  3. Tabs effect with CSS (476)
  4. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (172)
  5. PHP-MySQL free course, online tutorials PHP MySQL code (99)