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 vote287 views1 answer
How to get all the records with same ID in laravel
PHP
9 votes267 views4 answers
Composer require laravel/ui for laravel 6
PHP Laravel
7 votes274 views1 answer
Laravel eloquent date range
PHP
0 vote313 views1 answer
How do I display logged-in username IF logged-in? site:wordpress.stackexchange.com
PHP Wordpress
0 vote266 views1 answer
Create fake users on click laravel
PHP
-1 vote288 views1 answer
How to print any string in double quotes in php
PHP
1 vote368 views1 answer
Save error cakephp 2
PHP CakePHP
0 vote247 views1 answer
Php echo html response code 200
PHP
0 vote245 views1 answer
How can we check in the table in comma separated values in laravel
PHP Laravel
0 vote268 views1 answer
Php check if variable is resource
PHP