php登录系统选择数据库

Question

I'm making a login system with php but I'm getting this error:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/a9356103/public_html/login.php on line 13

and the code is:

<?php
    $mysql_host = 'localhost';
    $mysql_database = 'a9356103_web';
    $mysql_user = 'a9356103_web';
    $mysql_password = 'password';

    if (isset($_REQUEST['attempt'])) {
      $user = $_POST['user'];
      $pass = $_POST['pass'];

      $con=mysqli_connect($mysql_host, $mysql_user, $mysql_password);
      mysql_select_db($mysql_database, $con);
    }
?>

I'm new to php and the forms so any help would be very helpful.

Answer 1

You're mixing mysqli and mysql functions:

$con=mysqli_connect($mysql_host, $mysql_user, $mysql_password); <-- WRONG FUNCTION
mysql_select_db($mysql_database, $con);

should be

$con=mysql_connect($mysql_host, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $con);

Actually, you should be using mysqli since mysql is deprecated.

$con = mysqli_connect($mysql_host, $mysql_user, $mysql_password, $mysql_database);