参见英文答案 >
Can I mix MySQL APIs in PHP?4个
当我执行下面的PHP代码时,我得到致命错误,我不知道如何解决它.
当我执行下面的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
原文链接:https://www.f2er.com/php/133099.html改变这些行:
$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);