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 : applicant_editor.php

<?php
 include("../homepage/header.php");
 include("../homepage/headermenu.php");
?>

<div class="container fullheight">
    <div class="row">
        <div class="col-md-8 col-md-offset-2">
           <br/>
           <br/>
           <br/>
  
              <form name="frm_applicantselection" method="post"  enctype="multipart/form-data" class="form-inline" action="applicant_callingpage.php">
			           
			   <div class="form-group">
              <label class="col-md-3 control-label">ব্যাচ শিরোনাম</label>
              <div class="col-md-6">						   
							 <?php
                  // prepare and bind
                  $stmt = $conn->prepare("SELECT * FROM trevent");
                  $stmt->execute();

//Result
                  $result = $stmt->get_result();								
							 ?>
						 <select  name="trevent_id" id="trevent_id" class="form-control" onchange="showUser(this.value)">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$trevent_id){ echo "selected"; }?>><?=$row["trevnID"]?>-<?=$row["subject"]?>
							 </option>
								<?php
								      }
								$stmt->close();                                  
								?> 
						</select>                        
          </div>
       </div>

<div class="form-group">
          <div class="col-md-6 col-md-offset-4">
            <input type="hidden" name="cmd" value="add">
                <input type="hidden" name="id" value="<?=$Id?>">	
                  <button type="submit" class="btn btn-primary">
                  <i class="fa fa-btn fa-sign-in"></i>Submit
          </div>
       </div>
    </form>

</div>
    </div>
</div>

<?php
if(isset($_POST)){

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

$trevent_id= $_REQUEST["trevent_id"];

$stmt = $conn->prepare("SELECT 
                       th.thlinelistName,
                       te.trevnID                     	             
                      FROM trevent te
                      LEFT JOIN thlinelist th ON(te.thlinelist_id=th.id)                                            
                      WHERE te.id=?");

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

$slno=0;			 
//Result
$result1 = $stmt->get_result();
 while($row = $result1->fetch_assoc())
 {
  $thlinelistName = $row["thlinelistName"]; 
  $trevnID = $row["trevnID"];   
 }
 echo 'শিরোনাম : '. $thlinelistName;
 echo ',  ব্যাচ নং : ',$trevnID ;
?>

<tr>   
    <td><b>ক্রম নং</b></td>
    <td><b>PIMS আইডি</b></td>
    <td><b>নাম</b></td>
    <td><b>এনআইডি</b></td>
    <td><b>পদবি</b></td>
    <td><b>জেলা</b></td>
    <td><b>কর্মস্থল</b></td>
    <td><b>ঠিকানা</b></td>
    <td><b>মোবাইল</b></td>
    <td><b>ই-মেইল</b></td>
   
 </tr>

<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=? ORDER BY d.desigslno,ap.srlno");

$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"];
         $slno = $slno+1;
         $trevent_id = $row["trevent_id"];
         $trevnID = $row["trevnID"];
         $GovtId = $row["GovtId"];
         $apname = $row["apname"];
         $DesignationName = $row["DesignationName"];
         $OfficeName = $row["OfficeName"];

$DistrictName = $row["DistrictName"];
         $nidcard = $row["nidcard"];
         $address = $row["address"];
         $mobileno = $row["mobileno"];
         $email = $row["email"];
         $comment = $row["comment"];
                      
?>
 <tr>
    <td class="text-center"><?=bangladate($slno) ?></td>
     <td><?=bangladate($GovtId) ?></td>
     <td><?=$apname ?></td>
     <td><?=$nidcard ?></td>
     <td><?=$DesignationName ?></td>    
     <td><?=$DistrictName ?></td>
     <td><?=$OfficeName ?></td>
     <td><?=$address ?></td>
     <td><?=$mobileno ?></td>
     <td><?=$email ?></td>
     <td><?=$comment ?></td>

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

</table>

<?php
}
?>

<?php
 include("../homepage/footer.php");
?>

${this.title}

Code Editor : applicant_editor.php