প্রশিক্ষণার্থীর তথ্য এন্ট্রি
prepare("SELECT
ap.id,
ap.GovtId,
ap.trevent_id,
ap.district_id,
ap.apname,
ap.designation_id,
ap.office_id,
ap.address,
ap.mobileno,
ap.email,
ap.comment,
ap.nidcard,
tr.subject,
d.DesignationName,
o.OfficeName,
dis.DistrictName,
ap.srlno
FROM applicantlist ap
LEFT JOIN trevent tr ON(ap.trevent_id=tr.id)
LEFT JOIN designation d ON(ap.designation_id=d.id)
LEFT JOIN office o ON (ap.office_id=o.id)
LEFT JOIN district dis ON (ap.district_id=dis.id)
WHERE ap.trevent_id = ? ORDER BY ap.GovtId ASC");
$stmt->bind_param("i",$_SESSION["trevent_id"]);
$stmt->execute();
$result = $stmt->get_result();
$numrows=$result->num_rows;
?>
fetch_assoc())
{
$id = $row["id"];
$GovtId = $row["GovtId"];
$trevent_id = $row["trevent_id"];
$district_id = $row["district_id"];
$apname = $row["apname"];
$designation_id = $row["designation_id"];
$office_id = $row["office_id"];
$address = $row["address"];
$mobileno = $row["mobileno"];
$email = $row["email"];
$comment = $row["comment"];
$subject = $row["subject"];
$DesignationName = $row["DesignationName"];
$OfficeName = $row["OfficeName"];
$DistrictName = $row["DistrictName"];
$nidcard = $row["nidcard"];
$srlno = $row["srlno"];
$slno=$slno+1;
IF ($slno==1){
?>
শিরোনাম :
| PIMS আইডি |
জেলা |
নাম |
পদবি |
অফিস |
মোবাইল |
ই-মেইল |
সংশোধন |
ডিলিট |
|
|
|
|
|
|
|
|
|