使用Login调用未定义的函数mysql_query() [英] Call to undefined function mysql_query() with Login

问题描述

当我执行下面的 PHP 代码时，出现致命错误，并且不确定如何解决.

When i execute my PHP code below i get a Fatal error and i'm not sure how to resolve it.

谢谢您的帮助

错误

PHP致命错误:未捕获错误:调用/Applications/MAMP/htdocs/lprapp/config.php中未定义的函数mysql_query():23 堆栈跟踪:#0 {main} 在第23行的/Applications/MAMP/htdocs/lprapp/config.php中抛出

PHP Fatal error: Uncaught Error: Call to undefined function mysql_query() in /Applications/MAMP/htdocs/lprapp/config.php:23 Stack trace:#0 {main} thrown in /Applications/MAMP/htdocs/lprapp/config.php on line 23

代码

    <?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 ";
    }

    ?>

推荐答案

您正在混合mysql和mysqli

You are mixing mysql and mysqli

更改这些行:

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

到

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

这篇关于使用Login调用未定义的函数mysql_query()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！