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

10 votes309 views1 answer
Return redirect back laravel
PHP
0 vote394 views2 answers
Laravel call controller method from view
PHP Laravel
4 votes386 views2 answers
Mix is not recognized
PHP
0 vote364 views1 answer
Undefined index: $fileName = basename($_FILES["file"]["name"]);file in D:\xampp\htdocs\upload.php on line 12
PHP
4 votes359 views2 answers
Get permalink by id wordpress
PHP
0 vote353 views1 answer
12 months service expiary in php
PHP
10 votes336 views3 answers
Check count in laravel
PHP
3 votes333 views2 answers
Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.
PHP
0 vote388 views1 answer
Laravel parse markdown
PHP
2 votes403 views2 answers
Laravel get public path url
PHP Laravel