CODEWITHSUNDEEP
phpsql
Tiago Oliveira
Tiago Oliveira

Reputation: 1602

MySql query not working with variables weird bug

I have a list of users ids and my goal is to get the name of each user using the id

the sql variable prints: SELECT name FROM users WHERE unique_id = '56d4814fb37cf3.17691034 '

If i copy paste the query the name is returned and works as well with other ids, but i don't want the function to allways return the same name, i want to add the variable $userID to my query and return the name

But this only works when i hardcode de id

public function returnNameByID($userID){
 //User ID: 56d4814fb37cf3.17691034 
	
    $sql =  "SELECT name FROM users WHERE unique_id = '$userID'";
	
  echo $sql; // Prints SELECT name FROM users WHERE unique_id = '56d4814fb37cf3.17691034 '
	
//Doesn't work $name returns Null
//  $stmt = $this->conn->prepare("SELECT name FROM users WHERE unique_id = '$userID'"); 

//Doesn't work $name returns Null
	$stmt = $this->conn->prepare($sql); 

// Works $name returns name of the user
   $stmt = $this->conn->prepare(" SELECT name FROM users WHERE unique_id = '56d4814fb37cf3.17691034 ' "); 

    $stmt->execute();
	
    $result = $stmt->get_result()->fetch_assoc();
	
    $name = $result["name"];

    return $name;

EDIT

require_once 'db_functons.php';
$db = new db_functions();

$userID = $_GET['userID'];
$mArray =  array();

$mArray = $db->getFriendsList($userID);
//Printing the array Prints the correct id's

$name = $db->returnNameByID($mArray[0]);
echo $name;

Upvotes: 0

Views: 82

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133380

Seems you have some space around your code try using a trim 

$sql =  "SELECT name FROM users WHERE trim(unique_id) = '" . trim($userID) . "';";

Upvotes: 2

Related Questions