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

2 votes132 views1 answer
Php trim array to certain length
PHP
19 votes129 views6 answers
Unset session in php
PHP
1 vote146 views1 answer
Jetstream seed user with team
PHP
0 vote126 views1 answer
Symfony set content type
PHP
6 votes144 views3 answers
Php server request method
PHP
0 vote133 views3 answers
Install php pdo mysql PHP5.6 alpine-apache
PHP
0 vote152 views2 answers
Laravel General error: 1215 Cannot add foreign key constraint"
PHP Laravel
0 vote127 views1 answer
Make a global php function in laravel so that accessed anywhere
PHP
0 vote133 views1 answer
How can we send attached file with notification in gmail in laravel 8
PHP Laravel
2 votes151 views1 answer
Create migration, controller, model and seeder laravel
PHP Laravel