Php on page query

$lid=intval($_GET['leaveid']);
$sql = "SELECT erf.id as rid,tblemployees.FirstName,tblemployees.LastName,tblemployees.EmpId,tblemployees.id,tblemployees.Gender,tblemployees.Phonenumber,tblemployees.EmailId,erf.RDEPT,erf.NNEED,erf.PSTN,erf.DNEED,erf.RREQ,erf.NREQ,erf.ELVL,erf.CLNT,erf.SLRY,erf.BSIC,erf.TNPO,erf.QLTY,erf.EJBD from erf 
join tblemployees on erf.empid=tblemployees.id 
join dealer on erf.DEALER_ID=erf.DEALER_ID
where erf.id=:rid";
$query = $dbh -> prepare($sql);
$query->bindParam(':lid',$lid,PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)

Similar codes

0 vote95 views1 answer
Vault create/enable secret engine
PHP
0 vote118 views1 answer
Magento 2 laravel valet 502 bad gateway
PHP
0 vote117 views1 answer
Wp mail
PHP Wordpress
-1 vote127 views1 answer
Laravel remove index.php from url
PHP Laravel
7 votes107 views2 answers
How do I check if a string contains a specific word?
PHP
-1 vote105 views1 answer
Php ajouter += ou =+
PHP
0 vote125 views1 answer
Laravel retry failed transactions
PHP
0 vote101 views2 answers
Update pdo mysql php
PHP
0 vote151 views1 answer
Current date in codeigniter
PHP CodeIgniter
0 vote136 views1 answer
Access to XMLHttpRequest at 'http://localhost/MySQL_pracs/InsertUser.php' from origin 'http://localhost:4200' has been blocked by CORS policy: Request header field content-type is not allowed by Access-Control-Allow-Headers in preflight response.
PHP