₦airaland Forum

holla. Please if you're quite handy with PHP help out.
see this code

//create database
$connection = mysqli_connect("localhost","root","";
if (!$connection){
die("Database connection failed: " . mysql_error());
}
//databas select code
$db_select = mysqli_select_db("alm",$connection);
if (!$db_select){
die("Database connection failed: " .mysql_error());
}
?>

Its a php file, l'm trying to connect to a database named alm. my localhost password is null so thats not the problem. My browser gives the following error;
Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\wamp\www\alimi\databases.php on line 8
Database connection failed:

Can solve it for a fee

seunzone:
holla. Please if you're quite handy with PHP help out.
see this code

//create database
$connection = mysqli_connect("localhost","root","";
if (!$connection){
die("Database connection failed: " . mysql_error());
}
//databas select code
$db_select = mysqli_select_db("alm",$connection);
if (!$db_select){
die("Database connection failed: " .mysql_error());
}
?>

Its a php file, l'm trying to connect to a database named alm. my localhost password is null so thats not the problem. My browser gives the following error;
Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\wamp\www\alimi\databases.php on line 8
Database connection failed:

The order of ur arguments to mysqli_select_db() is wrong. $connection should come before db name.

should be:
mysqli_select_db($connection,"alm"

It's shown clearly from the error msg.

Forget That Mysqli_select_db() i.e cancel it.
and use only
$CONNECTION = mysqli_connect("host","username","password","databasename"; i.e ur database name is within the mysqli_connect()

In this order.

<?php
$hostname ="127.0.0.1";
$dbuser = "root";
$dbpass = "";
$db = "Salemdb";

$con = mysqli_connect($hostname, $dbuser, $dbpass, $db) or die ( 'cannot connect ') ;

// other queries go here 
?>

ANTONINEUTRON:
Forget That Mysqli_select_db() i.e cancel it.

and use only

$CONNECTION = mysqli_connect("host","username","password","databasename";
i.e ur database name is within the mysqli_connect()

It can be outside. it depends on what he's trying to achieve.

Noordean is right, mysqli resource is suppose to be the first parameter pass, while the other is dbname.

The mighty PDO.. .

noordean:
It can be outside. it depends on what he's trying to achieve.

yea the 'USE' command i think??

noordean:
It can be outside. it depends on what he's trying to achieve.

yea the 'USE' command i think??

noordean:
It can be outside. it depends on what he's trying to achieve.

yea the 'USE' command i think??