php – 使用Login调用未定义的函数mysql_query()

前端之家收集整理的这篇文章主要介绍了php – 使用Login调用未定义的函数mysql_query()前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
参见英文答案 > Can I mix MySQL APIs in PHP?4个
当我执行下面的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 ";
    }

    ?>
你正在混合MysqLMysqLi

改变这些行:

$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);
原文链接:https://www.f2er.com/php/133099.html

猜你在找的PHP相关文章