Mysql_fetch_assoc 运行不正常 [英] Mysql_fetch_assoc not functioning correctly

问题描述

无论如何，我都无法弄清楚为什么我的代码会出现此错误:

I cannot, not matter what, figure out why I am getting this error in my code:

mysql_fetch_assoc(): 提供的参数不是有效的 MySQL 结果资源

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

这是我的 PHP 代码:

Here is my PHP code:

<?php

$session_id = $_SESSION['id'];

$getall = mysql_query("SELECT * FROM users WHERE id='' . $dbuser_id . ''");
$row = mysql_fetch_assoc($getall);

$fullnameDB         = $row['name'];
$emailDB            = $row['email'];
$usernameDB         = $row['username'];

$fullname           = strip_tags($_POST['fullname']);
$username           = strip_tags($_POST['username']);
$email              = strip_tags($_POST['email']);


if ($_POST['submit']) {

    $namecheck = mysql_query("SELECT username FROM users WHERE username='' . $username . ''");

    $count = mysql_num_rows($namecheck);

    if ($count !=0) {

        echo 'That username is already taken!';

    } else {

        mysql_query("UPDATE users SET username=' . $username . ' WHERE id='' . $dbuser_id . ''");

        echo 'Your UN has been updated';

    }

}                        

?>

推荐答案

"SELECT username FROM users WHERE username='" . $username . "'"

不是

"SELECT username FROM users WHERE username='' . $username . ''"

但考虑使用 mysqli 或 pdo 切换到参数化语句

But consider switching to parameterised statements with mysqli or pdo

这篇关于Mysql_fetch_assoc 运行不正常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！