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

16 votes105 views4 answers
Wherenotnull laravel
PHP
0 vote89 views1 answer
Age date de naissance php
PHP
0 vote132 views1 answer
Use wordpress functions in external php file
PHP Wordpress
0 vote109 views1 answer
Laravel vue build production
PHP
0 vote100 views1 answer
Nova resource title function
PHP
1 vote171 views2 answers
Laravel check if email is real
PHP Laravel
0 vote95 views1 answer
Symfony header token authorization
PHP
3 votes132 views1 answer
Codeigniter form_validation email
PHP CodeIgniter
0 vote135 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP Laravel
0 vote104 views1 answer
Laravel move file from local to s3
PHP