This article explains how to connect multiple MySQL databases into a single webpage. It is useful to access data from multiple databases.
There are two methods to connect multiple MySQL databases into a single webpage which are:
- Using MySQLi (Improved version of MySQL)
- Using PDO (PHP Data Objects)
- MySQLi Procedural syntax:
$link = mysqli_connect( “host_name”, “user_name”, “password”, “database_name” );
- MySQLi Object Oriented syntax:
$link = new mysqli( “host_name”, “user_name”, “password”, “database_name” );
- PDO (PHP Data Objects) syntax:
$pdo = new PDO( “mysql:host=host_name; dbname=database_name”, “user_name”, “password” );
Program: This program uses MySQLi to connect multiple databases on a single webpage.
- Nodejs – Connect Mysql with Node app
- How to Add Google Charts on a Webpage?
- How to redirect to another webpage in HTML?
- Reader's View of a GeeksforGeeks webpage
- How To Add Google Translate Button On Your Webpage?
- Reading selected webpage content using Python Web Scraping
- Nodejs - Connect MongoDB with Node app using MongooseJS
- MySQL | BIN() Function
- How to get ID of the last updated row in MySQL?
- MongoDB vs MySQL
- PHP | MySQL WHERE Clause
- IFNULL in MySQL
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.