Gecko [ 43.229.15.234 ]

Name	Size	Permission
111ajaxview.php	1.24 KB	-rw-r--r--
222report_indproduct_sale.php	4.05 KB	-rw-r--r--
ajaxapplicant.php	4.72 KB	-rw-r--r--
ajaxselection.php	2.88 KB	-rw-r--r--
applicant_callingpage.php	419 B	-rw-r--r--
applicant_editor.php	5.83 KB	-rw-r--r--
applicantselection.php	3.7 KB	-rw-r--r--
applicantselection_editor.php	2.9 KB	-rw-r--r--
applicantselection_list.php	6.14 KB	-rw-r--r--

Code Editor : ajaxselection.php

<?php
    session_start();
    include("../common/config.php");
    include("../common/functions.php");

$trevent_id= $_REQUEST["q"];
?>
 <table class="table table-bordered table-striped table-condensed">

<tbody>
 <?php

$stmt = $conn->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,		
                            tr.trevnID,
                            d.DesignationName,
                            o.OfficeName,
                            dis.DistrictName                         	             
                        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)  
                        LEFT JOIN applicantselection aps ON (aps.applicantlist_id=ap.id)                      
                        WHERE ap.trevent_id=?");

$stmt->bind_param("i",$trevent_id);
$stmt->execute();

$slno=0;			 
//Result
  $result = $stmt->get_result();	
  $numrows=$result->num_rows;

if($numrows==0) exit("No rows");						
  $slno=0;

while($row = $result->fetch_assoc())
   {
         $id = $row["id"];
         $trevent_id = $row["trevent_id"];
         $trevnID = $row["trevnID"];
         $GovtId = $row["GovtId"];
         $apname = $row["apname"];
         $DesignationName = $row["DesignationName"];
         $OfficeName = $row["OfficeName"];
              
?>
 <tr>
 
     <td>                    
        <input type="checkbox" name="slflag<?=$id?>" id="slflag<?=$id?>" value="1"  <?php if($row["slflag"]==1){echo "checked";}?>>      
     </td>

<td>
          <?=bangladate($trevnID)?>         
          <input type="hidden" name="applicantlist_id<?=$id?>" id="applicantlist_id<?=$id?>" value="<?=$id?>" >
     </td>

</tr>
 <?php
 }
 ?>
</tbody>

</table>

${this.title}

Code Editor : ajaxselection.php