After conducting tests using the function below, I have come across a strange issue. When testing with the name "admin", it correctly returns an associative array with all the appropriate columns and values. However, for any other name entered, the query seems to return 0, indicating that nothing is being found in the database (the names are being inputted correctly).
I suspect this could be related to a security feature of PDO or something similar, but I am unsure why it is behaving this way.
The database system being used is MySQL.
If anyone has insights into what might be causing this problem and how to resolve it, I would greatly appreciate your help. Thank you!
function getUserDetailsByName($name, $fields = "*")
{
$db = connect_db();
$query = "SELECT $fields FROM UserDetails WHERE userName=:username";
$result = $db->prepare($query);
$result->bindParam(":username", $name);
if (!($result->execute())) {
sendMessage (1,1,'Query failed',$query);
$db = null;
return;
}
if (!($result->fetch(PDO::FETCH_NUM) > 0)) {
$db = null;
return 0;
}else{
$result = $result->fetch();
$db = null;
return $result;
}
}
EDIT: In response to a request for information on how I call the function:
$user = getUserDetailsByName($_POST['value']);
if($user == 0)
{
print "user = 0";
}
print_r($user);