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

13 votes115 views6 answers
Named route with parameter laravel
PHP Laravel
1 vote123 views1 answer
Check if url is https laravel
PHP Laravel
0 vote94 views2 answers
Php get post json data
PHP
0 vote94 views1 answer
Php json string to associative array
PHP
0 vote116 views1 answer
Call to a member function setcookie() on null laravel middleware
PHP
0 vote98 views1 answer
The "App\Entity\ entity has a repositoryClass set to but this is not a valid class.
PHP
6 votes102 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP
1 vote123 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
0 vote124 views1 answer
Get am pm 12 hour timee laravel
PHP Laravel
1 vote101 views1 answer
Php session get data
PHP