Warning: mysqli_select_db() expects parameter 1 to be mysqli

Question

I am new to php and try to make login form but their will be error while make a connection.i didn't get it.

<?php

 // this will avoid mysql_connect() deprecation error.
 error_reporting( ~E_DEPRECATED & ~E_NOTICE );
 // but I strongly suggest you to use PDO or MySQLi.

define('DBHOST', 'localhost');
define('DBUSER', 'root');
define('DBPASS', '');
define('DBNAME', 'simple_login');

$conn = mysqli_connect(DBHOST,DBUSER,DBPASS);
$dbcon = mysqli_select_db(DBNAME,$conn);

if ( !$conn ) {
 die("Connection failed : " . mysqli_error());
 }

if ( !$dbcon ) {
 die("Database Connection failed : " . mysqli_error());
 }

please if anybody know help me.thanks in advance.

echo after each line and comment after which it fails. – Ria Sen Apr 19 '17 at 06:17 — Ria Sen, Apr 19 '17 at 06:17
answered by two people below. – Ria Sen Apr 19 '17 at 06:18 — Ria Sen, Apr 19 '17 at 06:18

Saty · Answer 1 · 2017-04-19T06:22:51.950

1

Need to pass first parameter as connection then your database name

mysqli_select_db ($conn, DBNAME );

Read http://php.net/manual/en/mysqli.select-db.php

Check connection error as

 /* check connection */
     if (mysqli_connect_errno()) {
            printf("Connect failed: %s\n", mysqli_connect_error());
            exit();
        }

edited Apr 19 '17 at 06:22

answered Apr 19 '17 at 06:15

Saty

22,443
7
33
51

mageDev0688 · Accepted Answer · 2017-04-19T08:39:53.730

Try This below code:

You have to pass first $conn when select the DB, you have changed the parameter order.

<?php

 // this will avoid mysql_connect() deprecation error.
 error_reporting( ~E_DEPRECATED & ~E_NOTICE );
 // but I strongly suggest you to use PDO or MySQLi.

define('DBHOST', 'localhost');
define('DBUSER', 'root');
define('DBPASS', '');
define('DBNAME', 'simple_login');

$conn = mysqli_connect(DBHOST,DBUSER,DBPASS);
$dbcon = mysqli_select_db($conn,DBNAME);

if ( !$conn ) {
 die("Connection failed : " . mysqli_connect_errno());
 }

if ( !$dbcon ) {
 die("Database Connection failed : " . mysqli_connect_errno());
 }

Hope this help!!

Warning: mysqli_select_db() expects parameter 1 to be mysqli

2 Answers2