MySQL Query not returning a row value in PHP

Question

I don't know why this query won't return a value because when I copy the "echoed" portion into phpmyadmin I do get a record returning:

echo $_GET["cname"];

// Query template
$sql =  'SELECT C.cid FROM `Contact` C WHERE C.email="'.$_GET["cname"].'"';
echo $sql;

// Prepare statement
$stmt = $conn->prepare($sql);

$stmt->execute();
$stmt->bind_result( $res_cid);

echo $res_cid;

$res_cid is apparently 0, but I don't know why because when I paste that query manually into phpmyadmin I do get a value... So why doesn't it return anything?

can you try to remove quote near contact ? and i dont know what you plan to do but your code is totally unsecure, you'd better use bindparam with PDO — t0mpl
– t0mpl, Commented Jul 15, 2015 at 21:55
I agree with @ThomasP1988 . Putting user input directly into the query string defeats the purpose of prepared statement. — frz3993
– frz3993, Commented Jul 15, 2015 at 21:58
Guys, this is a project for one of my classes, so I am not concerned with security because once my application works then it is never used agian. — Kelbe
– Kelbe, Commented Jul 15, 2015 at 22:00
So you're taking a class, but not interested in learning the proper way to program? Why are you taking the class then? — Barmar
– Barmar, Commented Jul 15, 2015 at 22:14

Dekel · Accepted Answer · 2015-07-15 22:03:29Z

1

As already mentioned in the comments - you should make sure your code is secured. You better use the bindparam for that.

As for your question - after you execute your query and bind_result you should also fetch to get the actual value from the database, based on your query:

// Prepare statement
$stmt = $conn->prepare($sql);

$stmt->execute();
$stmt->bind_result( $res_cid);

// Fetch to get the actual result
$stmt->fetch();
echo $res_cid;

answered Jul 15, 2015 at 22:03

Dekel

62.9k12 gold badges109 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Query not returning a row value in PHP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related