Call undefined function mysql_query () with login name

Question

When I execute the PHP code below, I get a fatal error , and I'm not sure how to resolve it.

thanks for the help

Error

PHP Fatal error: Failed to get error: call to undefined function mysql_query () in /Applications/MAMP/htdocs/lprapp/config.php:23 Stack trace: # 0 {main} in / 23 /.

the code

    <?php

    $user = 'root';
    $password = 'root';
    $db = 'inventory';
    $host = 'localhost';
    $port = 8888;

    $link = mysqli_init();
    $success = mysqli_real_connect(
       $link,
       $host,
       $user,
       $password,
       $db,
       $port
    );

    ?>
    <?php
    $username = $_POST['username'];
    $password = $_POST['password'];
    $sql = mysql_query("SELECT * FROM login WHERE username = '".$_POST['username']."' and password = '".md5($_POST['password'])."'");
    $row = mysql_num_rows($sql);
    if($rom > 0 )
    {
      session_start();
      $_SESSION['username'] = $_POST['username'];
      $_SESSION['password'] = $_POST['password'];
      echo "login done";
    }else {
      echo "fail login ";
    }

    ?>

Answer 1

You mix mysql and mysqli

Change these lines:

$sql = mysql_query("SELECT * FROM login WHERE username = '".$_POST['username']."' and password = '".md5($_POST['password'])."'");
$row = mysql_num_rows($sql);

to

$sql = mysqli_query($success, "SELECT * FROM login WHERE username = '".$_POST['username']."' and password = '".md5($_POST['password'])."'");
$row = mysqli_num_rows($sql);

Answer 2

You are mixing legacy mysql extension with mysqli .

Try something like:

$sql = mysqli_query($success, "SELECT * FROM login WHERE username = '".$_POST['username']."' and password = '".md5($_POST['password'])."'");
$row = mysqli_num_rows($sql);

Answer 3

PHP? "Mysql" PHP 5.5.0. Mysqli (, mysqli_query).

Answer 4

mysqli_() mysql _()

:

   PHP 5.5.0, PHP 7.0.0. MySQLi PDO_MySQL . . MySQL: API . : mysqli_affected_rows() PDOStatement:: rowCount()

mysqli_() PDO