Kumar Akshay Kumar Akshay - 5 months ago 14
SQL Question

Variable calling does not work in sql statement

if i put

$sql1 = 'Select * from follow WHERE followmak = $usid';


it does not work

and whenever I put

$sql1 = 'Select * from follow WHERE followmak = 1';


1 or any cardinal number it works out. I tries to echo $usid and it works and but I wonder why it does not work in sql statement , please help me I am noob in PHP

My Full Code is given below :


try {
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);

$sql = 'SELECT * from follow';


$q = $pdo->query($sql);

$q->setFetchMode(PDO::FETCH_ASSOC);
$usid = ($row7['userID']);
$sql1 = 'Select * from follow WHERE followmak = $usid';



$q1 = $pdo->prepare($sql1);
$q1->execute([$usid]);
$q1->setFetchMode(PDO::FETCH_ASSOC);






} catch (PDOException $e) {
die("Could not connect to the database $dbname :" . $e->getMessage());
}

?>

Answer

Try this

$sql1 = "Select * from follow WHERE followmak = '$usid'";