PHP - mysql_fetch_assoc（）错误[重复]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

I try this for view single row data:

include("../engine/setconnect.php");

$sql = "SELECT id_member,username FROM account WHERE id_member=".$_GET['id_member'];

$result = mysql_query($sql);
$data  = mysql_fetch_assoc($result);

echo "$data['id_member']";
echo "$data['name']";

But the result always:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in

Data in 'id_member' is alphanumeric

How to fix this? :(

</div>

Answer 1

If that field is indeed alpha numeric, then you should include quotes:

id_member = '".$_GET['id_member'] . "'";

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

_{Ref: https://stackoverflow.com/a/12860140/3859027}

Here is a simple example using PDO with prepared statements:

if(isset($_GET['id_member'])) {

    $db = new PDO('mysql:host=localhost;dbname=DATABASE_NAME', 'username', 'password');

    $sql = "SELECT id_member,username FROM account WHERE id_member = :id_member";

    $select = $db->prepare($sql);
    $select->bindParam(':id_member', $_GET['id_member']);
    $select->execute();

    $result = $select->fetch(PDO::FETCH_ASSOC);
    echo $result['username'];
}