<?php
try{
$hostname = 'localhost';
$dbname = 'employees';
$username = 'root';
$password = 'mysql';
$DBH = new PDO("mysql:host=$hostname; dbname=$dbname; charset=utf8mb4", $username, $password);
echo 'Connected';
}
catch(PDOException $e){
echo $e->getMessage();
}
?>;
<?php
try{
$stmt = $DBH->prepare("select *from employees where gender = ?");
$stmt->bindParam(1, $gen);
$gen = 'M';
$stmt->execute();
while($row = $stmt->fetch())
{
print_r($row);
}
}
catch(PDOException $e){
echo $e->getMessage();
}
?>