Cannot access database

Question

Hi i need some help in coding php to connect database my source code is

$host="127.0.0.1"; // Host name 

$username="root"; // Mysql username 

$password=""; // Mysql password 

$db_name="test"; // Database name 

$tbl_name="forum_question"; // Table name 

// Connect to server and select databse.
`mysqli_connect("$host", "$username", "$password")or die("cannot connect"); 
mysqli_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name ORDER BY id DESC";`

But it display error

Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\123\tryforum\main_forum.php on line 11 cannot select DB

How to solve it

Have you read the error message and the respective documentation? — John Dvorak, Oct 31 '15 at 12:18

score 0 · Answer 1 · answered Oct 31 '15 at 12:18

You need to pass connection variable to mysqli_select_db. See this link

$host="127.0.0.1"; // Host name 

$username="root"; // Mysql username 

$password=""; // Mysql password 

$db_name="test"; // Database name 

$tbl_name="forum_question"; // Table name 

// Connect to server and select databse.
$con = mysqli_connect("$host", "$username", "$password") or die("cannot connect"); 
mysqli_select_db($con, "$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name ORDER BY id DESC";`

Saty · Answer 2 · 2015-10-31T12:24:19.420

0

mysqli_select_db()

needs two parameter first your database connection and second your database name

$conn=mysqli_connect("$host", "$username", "$password")or die("cannot connect"); 
mysqli_select_db($conn,"$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name ORDER BY id DESC";
$result=mysqli_query($conn,$sql);

edited Oct 31 '15 at 12:24

answered Oct 31 '15 at 12:19

Saty

22,443
7
33
51

$result=mysqli_query($sql); – Mohd Akmal Oct 31 '15 at 12:23
Use `$result=mysqli_query($conn,$sql);` check updated answer – Saty Oct 31 '15 at 12:24

Cannot access database

2 Answers2