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 vote104 views1 answer
Put woocommerce orders on pending payment automatically
PHP
0 vote234 views1 answer
Laravel find or fail exception
PHP Laravel
13 votes111 views5 answers
Zsh: command not found: laravel
PHP
1 vote113 views1 answer
How send parameter with command in laravel
PHP
2 votes124 views1 answer
Php chunk array
PHP
0 vote139 views1 answer
/usr/local/bin/php /home/tbmholdingltd/public_html/tugent/php artisan schedule:run >> /dev/null 2>&1
PHP
0 vote138 views4 answers
Share var in a maser layout laravel
PHP Laravel
23 votes132 views6 answers
Laravel 6 auth
PHP Laravel
1 vote113 views1 answer
Set subject for mail inlaravel
PHP
6 votes109 views2 answers
Show date php by letters
PHP