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 vote347 views1 answer
Laravel eloquent pass to next element
PHP Laravel
7 votes344 views3 answers
Laravel append array to array
PHP Laravel
0 vote338 views1 answer
Laravel uuid not showing in query
PHP Laravel
32 votes280 views6 answers
Php if else
PHP
0 vote278 views1 answer
Beautify var_dump
PHP
0 vote282 views1 answer
Call to a member function delete() on null laravel 8
PHP
0 vote305 views1 answer
Get the user detail inside the constructor Laravel
PHP
0 vote306 views1 answer
Append a text string to WooCommerce single product title
PHP
0 vote298 views1 answer
"customer" attribute not getting saved from admin magento 2
PHP
2 votes289 views2 answers
Laravel eloquent randomise data from database
PHP