how to set mysql database connection name

Question

I'm trying to figure out how can I put two differents MYSQL database connections name on the same page, one is for local PC and one is for hosting server.

Does is possible to have two different databases servers name on the same page so that way not to change connection database name in a script before upload.

I have code like this for local PC

<?php
$username = "your_name";
$password = "your_password";
$hostname = "localhost"; 

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password) 
  or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
?>

Can can i add another connection name in the server in same page without changing the connection database!

alidad

Warning: You are using an obsolete database API which has been removed entirely from the latest version of PHP. You should use a modern replacement. — Quentin
– Quentin, Commented May 18, 2016 at 18:09
What exactly are you trying to do? To connect to 2 different databases on the same server? Your wording is kind of confusing — Miguel Guerreiro
– Miguel Guerreiro, Commented May 18, 2016 at 18:10

wallyk · Accepted Answer · 2016-05-18 18:28:52Z

2

Yes, a single page may query as many different servers as needed:

<?php
$server1 = new mysqli("server1.example.com", "user1", "password1", "database1");    
$server2 = new mysqli("server2.example.com", "user2", "password2", "database2");

$result = $server1->query("SELECT 'Hello user' AS _message FROM DUAL");
$row = $result->fetch_assoc();
echo htmlentities($row['_message']);

$result = $server2->query("SELECT 'Hello user' AS _message FROM DUAL");
$row = $result->fetch_assoc();
echo htmlentities($row['_message']);

answered May 18, 2016 at 18:28

wallyk

58.1k17 gold badges92 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Felippe Duarte · Accepted Answer · 2016-05-18 18:11:42Z

0

The way is to have a config.ini file in your localhost, and a different one in your production environment. This way you will parse this file and get your credentials.

A better way to do that is using this library: https://github.com/vlucas/phpdotenv

It works basically on the same way, but is easy to maintain.

answered May 18, 2016 at 18:11

Felippe Duarte

15.2k2 gold badges27 silver badges29 bronze badges

Collectives™ on Stack Overflow

how to set mysql database connection name

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related