DB connection problem

I'm having a problem with my db connection include code. It is returning the following error message

Warning: mysql_select_db() expects parameter 1 to be string, resource given in G:\xampp\htdocs\academy\includes\dbconn.inc.php on line 13

Unable to locate the database.

Line 13 is, of course, referring to the second if statement.

DB connection page contains the following code:

Language: PHP
<?php
 
$conn = mysql_connect(';localhost';, ';acuser';, ';db555#';);
 
if (!$conn)
 
{
$error = ';Unable to connect to the database server.';;
include ';error.inc.html.php';;
exit();
}
 
if (!mysql_select_db($conn, ';academy';))
{
$error = ';Unable to locate the database.';;
include ';error.inc.html.php';;
exit();
}
?>

The connection to the server is definitely being made because I am not receiving an 'Unable to connect to the database server' error but it's simply not finding the database itself and I have no idea why. And yes, I have checked the name of the database and have also tried using the default username and password i.e. root and no password. I cannot, for the life of me, figure out why it is not finding the database.

Assuming 'academy' is the name of your database, change the order of the arguments in line 13 of your code and see if it will work:

Language: PHP
if (!mysql_select_db(';academy';, $conn))

Hi fionam,

when using MySQL, you don't need to specify a connection resource like:

Language: PHP
if (!mysql_select_db(';academy';, $conn))

This should work:

Language: PHP
if (!mysql_select_db(';academy';))

student no: 77315138

Thanks guys, but I also tried both of those solutions - that's why I'm stumped. Beginning to wonder if it's a Xampp issue .....

Am going to try the 'long' way of doing it directly in the code and see what happens.

<?php

$servername='127.0.0.1'; // Your MySql Server Name or IP address here

$dbIDNumber='root'; // Login user id here

$dbpassword=''; // Login password here(i didnt set a password for me...

$dbname='registration'; // database name



connecttodb($servername,$dbname,$dbIDNumber,$dbpassword); //connection

function connecttodb($servername,$dbname,$dbuser,$dbpassword) //its function

{

global $link;

$link=mysql_connect ("$servername","$dbuser","$dbpassword";

if(!$link){die("Could not connect to MySQL";}

mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());

}





?>