CODEWITHSUNDEEP
phpmysql
Gianluca Pin
Gianluca Pin

Reputation: 93

Database connection phpmyadmin

I'm working for an e-commerce that has the db on phpmyadmin. In another website I'd like to connect to that database. I have password, username and db name, so I'm using this "connection string":

<?php
$nomehost = "localhost";    
$nomeuser = "user";         
$password = "pass";
// connection
$conn=mysql_connect($nomehost,$nomeuser,$password);
if (!$conn) exit ("Error connection<br>");

// db name
if (!mysql_select_db("db_name",$conn)) exit("Error db name<br>");
?>

The result is "Error db name". What can I do? Have I to set some oprion in the phpmyadmin?

Upvotes: 0

Views: 495

Answers (1)

Lelio Faieta
Lelio Faieta

Reputation: 6663

First of all: this error is caused by the fact that you are selecting the wrong database in your MySql server. Is your db called db_name???

EDIT: based on the comments you are making: is the server that hosts the php page the same as the mysql server?

Then: phpmyadmin is just a tool to connect and handle MySql databases and is not a database server itself.

Last but most important: you are using a deprecated library (mysql) in php to connect to a MySql server. Please consider moving to mysqli or better to PDO

Upvotes: 1

Related Questions