Gecko [ www.finalhopeacademy.com ]

Name	Size	Permission
Rich	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
focus	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
textbox	[ DIR ]	drwxr-xr-x
Capture111.JPG	81.98 KB	-rw-r--r--
Certificate-record.php	19.89 KB	-rw-r--r--
address.php	14.92 KB	-rw-r--r--
addressupdate.php	15 KB	-rw-r--r--
admin-login.php	3.48 KB	-rw-r--r--
afflication.php	11.59 KB	-rw-r--r--
afflicationupdate.php	13.37 KB	-rw-r--r--
all-fee-detail.php	26.34 KB	-rw-r--r--
bank.php	15.61 KB	-rw-r--r--
bankupdate.php	20.6 KB	-rw-r--r--
batch.php	12.74 KB	-rw-r--r--
batchupdate.php	14.68 KB	-rw-r--r--
blog.php	13.38 KB	-rw-r--r--
blogupdate.php	16.45 KB	-rw-r--r--
certificate-print.php	9.1 KB	-rw-r--r--
certificate.php	12.03 KB	-rw-r--r--
connection.php	97 B	-rw-r--r--
contact.php	11.05 KB	-rw-r--r--
converted.php	30.22 KB	-rw-r--r--
course-admin-update.php	24.76 KB	-rw-r--r--
course-admin.php	21.15 KB	-rw-r--r--
course-content-update.php	14.67 KB	-rw-r--r--
course-content.php	12.73 KB	-rw-r--r--
course-description.php	12.52 KB	-rw-r--r--
course.php	16.01 KB	-rw-r--r--
courseupdate.php	19 KB	-rw-r--r--
create-certificate.php	17.71 KB	-rw-r--r--
create-fee.php	32.9 KB	-rw-r--r--
dashed.jpeg	24.22 KB	-rw-r--r--
data.php	622 B	-rw-r--r--
data2.php	704 B	-rw-r--r--
data3.php	641 B	-rw-r--r--
data4.php	634 B	-rw-r--r--
data5.php	801 B	-rw-r--r--
data6.php	708 B	-rw-r--r--
data7.php	801 B	-rw-r--r--
data8.php	564 B	-rw-r--r--
demo.php	11.79 KB	-rw-r--r--
descriptionupdate.php	14.37 KB	-rw-r--r--
document-records.php	21.95 KB	-rw-r--r--
document.php	14.68 KB	-rw-r--r--
due-fees.php	23.45 KB	-rw-r--r--
enquiry.php	11.89 KB	-rw-r--r--
event.php	14.05 KB	-rw-r--r--
eventupdate.php	16.92 KB	-rw-r--r--
fee.php	18.17 KB	-rw-r--r--
form.php	14.59 KB	-rw-r--r--
format.jpg	296.43 KB	-rw-r--r--
formm1.html	9.58 KB	-rw-r--r--
gallery.php	11.3 KB	-rw-r--r--
galleryupdate.php	12.92 KB	-rw-r--r--
header.php	1.19 KB	-rw-r--r--
id.php	6.59 KB	-rw-r--r--
idcard-update.php	27.39 KB	-rw-r--r--
idcard.php	23.12 KB	-rw-r--r--
index.php	410 B	-rw-r--r--
inquiry-report.php	33.63 KB	-rw-r--r--
inquiry.php	31.86 KB	-rw-r--r--
link.php	12.58 KB	-rw-r--r--
linkupdate.php	15.19 KB	-rw-r--r--
login.php	13.27 KB	-rw-r--r--
loginupdate.php	13.82 KB	-rw-r--r--
logo.png	26.75 KB	-rw-r--r--
microsoft.png	2.25 KB	-rw-r--r--
not-converted.php	30.31 KB	-rw-r--r--
numbertowordconvert.js	1.83 KB	-rw-r--r--
offer.php	12.29 KB	-rw-r--r--
offerupdate.php	14.05 KB	-rw-r--r--
online-exam-course.php	12.44 KB	-rw-r--r--
online-exam-update.php	14.44 KB	-rw-r--r--
palacement.php	12.87 KB	-rw-r--r--
personal.php	23.38 KB	-rw-r--r--
personalupdate.php	39.74 KB	-rw-r--r--
placement.php	12.63 KB	-rw-r--r--
placementupdate.php	14.96 KB	-rw-r--r--
print-certi.php	2.12 KB	-rw-r--r--
print-certificate.php	30.53 KB	-rw-r--r--
print-fees-slip.php	7.57 KB	-rw-r--r--
print-fees.php	38.43 KB	-rw-r--r--
print.php	8.97 KB	-rw-r--r--
register.php	13.06 KB	-rw-r--r--
slip.php	10.65 KB	-rw-r--r--
softwarelink.php	11.36 KB	-rw-r--r--
softwarelinkupdate.php	12.94 KB	-rw-r--r--
team.php	12.06 KB	-rw-r--r--
teamupdate.php	13.8 KB	-rw-r--r--
testimonial.php	11.78 KB	-rw-r--r--
testimonialupdate.php	13.84 KB	-rw-r--r--
try.php	12.15 KB	-rw-r--r--
try1.php	35.33 KB	-rw-r--r--
try2.php	6.02 KB	-rw-r--r--
try3.php	1.25 KB	-rw-r--r--
try4	0 B	-rw-r--r--
try4.php	2.29 KB	-rw-r--r--
try5.php	4.66 KB	-rw-r--r--
videolink.php	11.55 KB	-rw-r--r--
videolinkupdate.php	13.13 KB	-rw-r--r--

Code Editor : personalupdate.php

<?php
$values = $_GET['branch'];
  include 'connection.php';
  
  //address
if(isset($_POST['update']))
{
   $id = isset($_POST['address_sno'])?$_POST['address_sno']:null;
  $location = isset($_POST['location'])?$_POST['location']:null;
    $landmark = isset($_POST['landmark'])?$_POST['landmark']:null;
    $country =  isset($_POST['country'])?$_POST['country']:null;
    $email_id_1 = isset($_POST['email_id_1'])?$_POST['email_id_1']:null;
   $long = $_FILES['long']['name'];
    $tempimgname2= $_FILES['long']['tmp_name']; 
    move_uploaded_file($tempimgname2,"images/$long");
    $admission = isset($_POST['admission'])?$_POST['admission']:null;
    $branch = isset($_POST['branch'])?$_POST['branch']:null;
    $date = isset($_POST['date'])?$_POST['date']:null;
    $time = isset($_POST['time'])?$_POST['time']:null;
    $batchtime = isset($_POST['batchtime'])?$_POST['batchtime']:null;
    $father = isset($_POST['father'])?$_POST['father']:null;
    $gender = isset($_POST['gender'])?$_POST['gender']:null;
    $birth = isset($_POST['birth'])?$_POST['birth']:null;
    $married = isset($_POST['marital'])?$_POST['marital']:null;

$result = mysqli_query($sql_con,"UPDATE `personal` SET `Name`='$location',`PhoneNo`='$landmark',`Emailid`='$country',`Address`='$email_id_1',`Image`='$long', `AdmissionNo`='$admission',`BranchName`='$branch', `AdmissionDate`='$date',`AdmissionTime`='$time', `Batchtime`='$batchtime', `FatherName`='$father', `Gender`='$gender', `DateOfBirth`='$birth', `MaritalStatus`='$married' WHERE Sno ='$id'");
}

if(isset($_POST['delete']))
{
  //$sql_con=mysqli_connect('localhost','root','','hospital_management_website');

$id = isset($_POST['address_sno'])?$_POST['address_sno']:null;
$result1 = mysqli_query($sql_con,"DELETE FROM `personal` WHERE Sno='$id'");
}
  
?>

<?php 
 $date3 = date('m-d-Y');
                $due = mysqli_query($sql_con, "SELECT count(Sno) as snos From personal");
                while($row4 = mysqli_fetch_array($due))
                {
                    $sno = $row4["snos"];
                }

$due = mysqli_query($sql_con, "SELECT count(AdmissionDate) as dates FROM `personal` where MONTH(AdmissionDate)=MONTH(now()) and YEAR(AdmissionDate)=YEAR(now()) and BranchName='Ashram'");
                while($row4 = mysqli_fetch_array($due))
                {
                    $dates = $row4["dates"];
                }

$due6 = mysqli_query($sql_con, "SELECT count(AdmissionDate) as dates FROM `personal` where MONTH(AdmissionDate)=MONTH(now()) and YEAR(AdmissionDate)=YEAR(now()) and BranchName='Govindpuri'");
                while($row6 = mysqli_fetch_array($due6))
                {
                    $dates2 = $row6["dates"];
                }

$due3 = mysqli_query($sql_con, "SELECT count(Sno) as ash From personal where AdmissionDate='$date3' and BranchName='Ashram'");
                while($row5 = mysqli_fetch_array($due3))
                {
                    $ashram = $row5["ash"];
                }

$due3 = mysqli_query($sql_con, "SELECT count(Sno) as gov From personal where AdmissionDate='$date3' and BranchName='Govindpuri'");
                while($row5 = mysqli_fetch_array($due3))
                {
                    $govind = $row5["gov"];
                }

$due3 = mysqli_query($sql_con, "SELECT count(Sno) as dues From personal where BranchName='Govindpuri'");
                while($row5 = mysqli_fetch_array($due3))
                {
                    $due = $row5["dues"];
                }

$due3 = mysqli_query($sql_con, "SELECT count(AdmissionDate) as admission from personal where BranchName='Ashram'");
                while($row5 = mysqli_fetch_array($due3))
                {
                    $due1 = $row5["admission"];
                }

$due3 = mysqli_query($sql_con, "SELECT count(AdmissionDate) as admis from personal where BranchName='Govindpuri'");
                while($row5 = mysqli_fetch_array($due3))
                {
                    $due2 = $row5["admis"];
                }
                ?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Modi Traning Institute</title>
    
    
    <link rel="shortcut icon" href="http://placehold.it/64.png/000/fff">
    
    <link rel="apple-touch-icon" sizes="144x144" href="http://placehold.it/144.png/000/fff">
    
    <link rel="apple-touch-icon" sizes="114x114" href="http://placehold.it/114.png/000/fff">
    
    <link rel="apple-touch-icon" sizes="72x72" href="http://placehold.it/72.png/000/fff">
    
    <link rel="apple-touch-icon" sizes="57x57" href="http://placehold.it/57.png/000/fff">
    
    <link href="assets/css/lib/select2/select2.min.css" rel="stylesheet">
    <link href="assets/css/lib/font-awesome.min.css" rel="stylesheet">
    <link href="assets/css/lib/themify-icons.css" rel="stylesheet">
    <link href="assets/css/lib/menubar/sidebar.css" rel="stylesheet">
    <link href="assets/css/lib/bootstrap.min.css" rel="stylesheet">
    <link href="assets/css/lib/helper.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">

</head>

<body>
    
	        <div class="sidebar sidebar-hide-to-small sidebar-shrink sidebar-gestures">
            <div class="nano">
                <div class="nano-content">
                   <div class="logo"><a href="address.php?BranchName=<?php echo $values; ?>"><span>Modi Traning Institute</span></a></div>
                    <ul>
                        <li class="label">Main</li>
                        <li><a class="sidebar-sub-toggle"><i class="ti-layout"></i>Website Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                               <li><a href="online-exam-course.php?branch=<?php echo $values; ?>">Online Exam Course Master</a></li>
                         <li><a href="contact.php?branch=<?php echo $values; ?>">Contact Form</a></li>
                          <li><a href="demo.php?branch=<?php echo $values; ?>">Demo Form</a></li>
                          <li><a href="register.php?branch=<?php echo $values; ?>">REG by Website</a></li>
                          <li><a href="enquiry.php?branch=<?php echo $values; ?>">Enquiry Form</a></li>
                         <li><a href="idcard.php?branch=<?php echo $values; ?>">Student Id Card Master</a></li>
                        <li><a href="address.php?BranchName=<?php echo $values; ?>">Address Master</a></li>
                        <li><a href="link.php?branch=<?php echo $values; ?>"> Link Master</a></li>
                        <li><a href="testimonial.php?branch=<?php echo $values; ?>">Testimonial Master</a></li>
                        <li><a href="team.php?branch=<?php echo $values; ?>">Team Master</a></li>
                         <li><a href="gallery.php?branch=<?php echo $values; ?>">Gallery Master</a></li>
                        <li><a href="blog.php?branch=<?php echo $values; ?>">Blog Master</a></li>
                        <li><a href="event.php?branch=<?php echo $values; ?>">Event Master</a></li>
                        <li><a href="course.php?branch=<?php echo $values; ?>">Course Master</a></li>
                        <li><a href="course-content.php?branch=<?php echo $values; ?>">Course Content Master</a></li>
                        <li><a href="batch.php?branch=<?php echo $values; ?>">Batch Master</a></li>
                        <li><a href="course-description.php?branch=<?php echo $values; ?>">Course Description Master</a></li>
                        <li><a href="offer.php?branch=<?php echo $values; ?>">Offer Master</a></li>
                        <li><a href="afflication.php?branch=<?php echo $values; ?>">Afflication Master</a></li>
                        <li><a href="placement.php?branch=<?php echo $values; ?>">Placement Master</a></li>
                            </ul>
                        </li>
                        <li><a class="sidebar-sub-toggle"><i class="ti-layout"></i>Admission Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="personal.php?branch=<?php echo $values; ?>">Personal Info</a></li>
                                <li><a href="bank.php?branch=<?php echo $values; ?>">Bank Detail</a></li>
                                
                                <li><a href="course-admin.php?branch=<?php echo $values; ?>">Course Detail</a></li>
                                <li><a href="fee.php?branch=<?php echo $values; ?>">Fees Detail</a></li>
                            </ul>
                        </li>
                        <li><a class="sidebar-sub-toggle"><i class="ti-panel"></i>Inquiry <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="inquiry.php?branch=<?php echo $values; ?>">Inquiry Form</a></li>
                                <li><a href="inquiry-report.php?branch=<?php echo $values; ?>">All Inquiry Report</a></li>
                                <li><a href="converted.php?branch=<?php echo $values; ?>">Converted</a></li>
                                <li><a href="not-converted.php?branch=<?php echo $values; ?>">Not Converted</a></li>
                            </ul>
                        </li>
                        <li><a class="sidebar-sub-toggle"><i class="ti-layout-grid4-alt"></i>Fees Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="create-fee.php?branch=<?php echo $values; ?>">Fees Form</a></li>
                               
                                <li><a href="print-fees.php?branch=<?php echo $values; ?>">All Fees Detail</a></li>
                                <li><a href="due-fees.php?branch=<?php echo $values; ?>">Due Fees Detail</a></li>
                            </ul>
                        </li>
                        <li><a class="sidebar-sub-toggle"><i class="ti-heart"></i>Document Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="document.php?branch=<?php echo $values; ?>">Document</a></li>
                                <li><a href="certificate.php?branch=<?php echo $values; ?>">Certificate</a></li>
                                <li><a href="document-records.php?branch=<?php echo $values; ?>">All Document Records</a></li>
                                <li><a href="Certificate-record.php?branch=<?php echo $values; ?>">All Certificate Records</a></li>
                            </ul>
                        </li>
                         <li><a class="sidebar-sub-toggle"><i class="ti-heart"></i>Certificate Master <span class="sidebar-collapse-icon ti-angle-down"></span></a>
                            <ul>
                                <li><a href="create-certificate.php?branch=<?php echo $values; ?>">Certificate Create</a></li>
                                <li><a href="print-certificate.php?branch=<?php echo $values; ?>">All Certificate Records</a></li>
                            </ul>
                        </li>
                        <li><a href="../HRMS/HRMS/security.php?branch=<?php echo $values; ?>" target="_blank"><i class="ti-user"></i> HRMS Login</a></li>
                        <li><a href="../admin-dashboard.php"><i class="ti-close"></i> Logout</a></li>
                    </ul>
                </div>
            </div>
        </div>

<div class="content-wrap">
        <div class="main">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-lg-12">
                         <table class="table table-responsive-lg table-bordered table-active" style="border: 2px solid black;" align="left" >
         <tr>
             <td colspan="3" style="color: black; font-weight: bolder; text-align: center; text-transform: uppercase;">Total Admission: <?php echo $sno; ?></td>
         </tr>
         <tr>
             <td style="color: black; font-weight: bolder; text-align: left; text-transform: uppercase;">Ashram Total Admission: <?php echo $due1; ?></td>
             
               <td style="color: black; font-weight: bolder; text-align: left; text-transform: uppercase;">Ashram Daily Admission: <?php echo $ashram; ?></td>
         </tr>
         <tr>
            <td style="color: black; font-weight: bolder; text-align: left; text-transform: uppercase;">Govindpuri Total Admission: <?php echo $due2; ?></td>
             
             <td style="color: black; font-weight: bolder; text-align: left; text-transform: uppercase;">Govindpuri Daily Admission: <?php echo $govind; ?></td>
         </tr>
     </table>
                    </div>
                    
                </div>
                
                <section id="main-content">
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-body">
                                     <div class="bootstrap-data-table-panel">
                                    <div class="table-responsive">
                                    <form method="post">
                                        <div class="row">
                    <div class="col-md-8">
                        <div class="row">
                            <div class="col-4">
                        <input type="text" name="search1" class="form-control" placeholder="Search Here .....">
                    </div>
                    <div class="col-4">
                        <input type="date" name="start" class="form-control rounded" placeholder="Search" />
                    </div>
                    <div class="col-4">
                        <input type="date" name="end" class="form-control rounded" placeholder="Search" />
                    </div>
                </div>
            </div>
                    <div class="col-md-4">
                     <input type="submit" class="btn btn-info" name="search" value="Search">    <button onclick="ExportToExcel('xlsx')" class="btn btn-success">Excel File</button>
             <input type="button" value="Create PDF" id="btPrint" onclick="createPDF()" class="btn btn-success" />     
                    </div>
                    
                </div>
                 
            </form>
          
         
 
                                        <div id="tab">
                                   
                                    <table class="table table-bordered" id="tblData">
    <thead class="thead-light">
      <tr class="d-flex">
        <th class="col-1" style="color: black;">Sno</th>
        <th class="col-1" style="color: black; ">Branch</th>
        <th class="col-1" style="color: black;">Adm. No</th>
        <th class="col-1" style="color: black;">Admi. Time</th>
        <th class="col-1" style="color: black;">Adm. Date</th>
        <th class="col-1" style="color: black;">Batch Time</th>
        <th class="col-2" style="color: black; width: 250px;">Student Name</th>
       <th class="col-2" style="color: black; width: 250px;">Course Name</th>
       <th class="col-2" style="color: black;">Duration</th>
        <th class="col-2" style="color: black;">Phone No</th>
        <th class="col-2" style="color: black;">Email ID</th>
        <th class="col-1" style="color: black;">Gender</th>
        <th class="col-1" style="color: black;">Image</th>
        <th class="col-1" style="color: black;">Action</th>
      </tr>
    </thead>
    <tbody>
 <?php
 $search = isset($_POST['search1'])?$_POST['search1']:null;

if($search==null && isset($_POST['search']))
{
 $original_date = isset($_POST['start'])?$_POST['start']:null;
$timestamp = strtotime($original_date);
$new_date = date("m-d-Y", $timestamp);

$original_date1 = isset($_POST['end'])?$_POST['end']:null;
$timestamp1 = strtotime($original_date1);
$new_date1 = date("m-d-Y", $timestamp1);

$oquery = mysqli_query($sql_con,"SELECT * FROM personal WHERE AdmissionDate BETWEEN '$new_date' AND '$new_date1'");
 while($row21 = mysqli_fetch_array($oquery))
{
  $no= $row21["Sno"];
  $location = $row21["Name"];
  $landmark = $row21["PhoneNo"];
  $email = $row21["EmailId"];
  $email1 = $row21["Address"];
  $phone = $row21["Image"];
  $add = $row21["AdmissionNo"];
  $branch = $row21["BranchName"];
  $admission = $row21["AdmissionDate"];
  $time = $row21["AdmissionTime"];
  $batchtime = $row21["Batchtime"];
  $father = $row21["FatherName"];
  $gender = $row21["Gender"];
  $birth = $row21["DateOfBirth"];
  $marital = $row21["MaritalStatus"];
  $rela = $row21["Relation"];
?>    
<tr class="d-flex">
   <td class="col-1" style="color: black;"><?php echo $no;?></td>
   <td class="col-1" style="color: black;"><?php echo $branch; ?></td>
   <td class="col-1" style="color: black;"><?php echo $add; ?></td> 
   <td class="col-1" style="color: black;"><?php echo $batchtime;?></td>
   <td class="col-1" style="color: black;"><?php echo $admission; ?></td>
   <td class="col-1" style="color: black;"><?php echo $time; ?></td>
   <td class="col-2" style="color: black; width: 250px;"><?php echo $location;?></td>
   <td class="col-2" style="color: black;">
   <?php 
   $cources = mysqli_query($sql_con, "SELECT * FROM student_course where AdmissionNo='$add'");
   while($rowes4 = mysqli_fetch_array($cources))
   {
       $cour = $rowes4["CourseName"];
       echo $cour; 
       }
       ?></td>
       <td class="col-2" style="color: black;">
   <?php 
   $cources = mysqli_query($sql_con, "SELECT * FROM student_course where AdmissionNo='$add'");
   while($rowes4 = mysqli_fetch_array($cources))
   {
       $cour = $rowes4["Duration"];
       echo $cour; 
       }
       ?></td>
        <td class="col-2" style="color: black;"><?php echo $landmark;?></td>
        <td class="col-2" style="color: black;"><?php echo $email;?></td>
        <td class="col-1" style="color: black;"><?php echo $gender; ?></td>
   
        <td class="col-1"><a href="images/<?php echo $phone;?>" target="_blank"><img src="images/<?php echo $phone;?>" style="height: 70px; width: 70px;"></a></td>
        <td class="col-1"><button type="button" class="btn btn-primary" data-toggle="modal" onclick="document.getElementById('address_id').value = '<?php echo $no; ?>';document.getElementById('admission').value = '<?php echo $add; ?>';document.getElementById('branch').value = '<?php echo $branch; ?>';document.getElementById('batchtiming').value = '<?php echo $batchtime; ?>';document.getElementById('add').value = '<?php echo $admission; ?>';document.getElementById('time').value = '<?php echo $time; ?>';document.getElementById('gender').value = '<?php echo $gender; ?>';document.getElementById('marital').value = '<?php echo $marital; ?>';document.getElementById('birth').value = '<?php echo $birth; ?>';document.getElementById('location').value = '<?php echo $location; ?>';document.getElementById('landmark').value = '<?php echo $landmark; ?>';document.getElementById('email1').value = '<?php echo $email; ?>';document.getElementById('email2').value = '<?php echo $email1; ?>';document.getElementById('father').value = '<?php echo $father; ?>';document.getElementById('email3').value = '<?php echo $phone; ?>';"data-target="#myModal" style="font-size: 12px;">Details
  </button></td></tr>
  <?php
}
}
else if(isset($_POST['search']))
        { 
$result2 = mysqli_query($sql_con,"SELECT * FROM `personal` where Name like '%$search%' or PhoneNo like '%$search%' or EmailId like '%$search%' or Address like '%$search%' or Image like '%$search%' or AdmissionNo like '%$search%' or BranchName like '%$search%' or AdmissionDate like '%$search%' or AdmissionTime like '%$search%' or Batchtime like '%$search%' or FatherName like '%$search%' or Gender like '%$search%' or DateOfBirth like '%$search%' or MaritalStatus like '%$search%' or Relation='%$search%'");
   while($sub1 = mysqli_fetch_array($result2))
{
  $no= $sub1["Sno"];
  $location = $sub1["Name"];
  $landmark = $sub1["PhoneNo"];
  $email = $sub1["EmailId"];
  $email1 = $sub1["Address"];
  $phone = $sub1["Image"];
  $add = $sub1["AdmissionNo"];
  $branch = $sub1["BranchName"];
  $admission = $sub1["AdmissionDate"];
  $time = $sub1["AdmissionTime"];
  $batchtime = $sub1["Batchtime"];
  $father = $sub1["FatherName"];
  $gender = $sub1["Gender"];
  $birth = $sub1["DateOfBirth"];
  $marital = $sub1["MaritalStatus"];
  $rela = $sub1["Relation"];
?>    
<tr class="d-flex">
   <td class="col-1" style="color: black;"><?php echo $no;?></td>
   <td class="col-1" style="color: black;"><?php echo $branch; ?></td>
   <td class="col-1" style="color: black;"><?php echo $add; ?></td> 
   <td class="col-1" style="color: black;"><?php echo $batchtime;?></td>
   <td class="col-1" style="color: black;"><?php echo $admission; ?></td>
   <td class="col-1" style="color: black;"><?php echo $time; ?></td>
   <td class="col-2" style="color: black; width: 250px;"><?php echo $location;?></td>
   <td class="col-2" style="color: black;">
   <?php 
   $cources = mysqli_query($sql_con, "SELECT * FROM student_course where AdmissionNo='$add'");
   while($rowes4 = mysqli_fetch_array($cources))
   {
       $cour = $rowes4["CourseName"];
       echo $cour; 
       }
       ?></td>
       <td class="col-2" style="color: black;">
   <?php 
   $cources = mysqli_query($sql_con, "SELECT * FROM student_course where AdmissionNo='$add'");
   while($rowes4 = mysqli_fetch_array($cources))
   {
       $cour = $rowes4["Duration"];
       echo $cour; 
       }
       ?></td>
        <td class="col-2" style="color: black;"><?php echo $landmark;?></td>
        <td class="col-2" style="color: black;"><?php echo $email;?></td>
        <td class="col-1" style="color: black;"><?php echo $gender; ?></td>
   
        <td class="col-1"><a href="images/<?php echo $phone;?>" target="_blank"><img src="images/<?php echo $phone;?>" style="height: 70px; width: 70px;"></a></td>
        <td class="col-1"><button type="button" class="btn btn-primary" data-toggle="modal" onclick="document.getElementById('address_id').value = '<?php echo $no; ?>';document.getElementById('admission').value = '<?php echo $add; ?>';document.getElementById('branch').value = '<?php echo $branch; ?>';document.getElementById('batchtiming').value = '<?php echo $batchtime; ?>';document.getElementById('add').value = '<?php echo $admission; ?>';document.getElementById('time').value = '<?php echo $time; ?>';document.getElementById('gender').value = '<?php echo $gender; ?>';document.getElementById('marital').value = '<?php echo $marital; ?>';document.getElementById('birth').value = '<?php echo $birth; ?>';document.getElementById('location').value = '<?php echo $location; ?>';document.getElementById('landmark').value = '<?php echo $landmark; ?>';document.getElementById('email1').value = '<?php echo $email; ?>';document.getElementById('email2').value = '<?php echo $email1; ?>';document.getElementById('father').value = '<?php echo $father; ?>';document.getElementById('email3').value = '<?php echo $phone; ?>';"data-target="#myModal" style="font-size: 12px;">Details
  </button></td></tr>
  <?php
}
}
else
{
$result = mysqli_query($sql_con,"SELECT * FROM `personal` where BranchName='$values'");
while($row = mysqli_fetch_array($result))
{
  $no= $row["Sno"];
  $location = $row["Name"];
  $landmark = $row["PhoneNo"];
  $email = $row["EmailId"];
  $email1 = $row["Address"];
  $phone = $row["Image"];
  $add = $row["AdmissionNo"];
  $branch = $row["BranchName"];
  $admission = $row["AdmissionDate"];
  $time = $row["AdmissionTime"];
  $batchtime = $row["Batchtime"];
  $father = $row["FatherName"];
  $gender = $row["Gender"];
  $birth = $row["DateOfBirth"];
  $marital = $row["MaritalStatus"];
  $rela = $row["Relation"];
?>    
<tr class="d-flex">
   <td class="col-1" style="color: black;"><?php echo $no;?></td>
   <td class="col-1" style="color: black;"><?php echo $branch; ?></td>
   <td class="col-1" style="color: black;"><?php echo $add; ?></td> 
   <td class="col-1" style="color: black;"><?php echo $batchtime;?></td>
   <td class="col-1" style="color: black;"><?php echo $admission; ?></td>
   <td class="col-1" style="color: black;"><?php echo $time; ?></td>
   
   <td class="col-2" style="color: black; width: 250px;"><?php echo $location;?></td>
   <td class="col-2" style="color: black;">
   <?php 
   $cources = mysqli_query($sql_con, "SELECT * FROM student_course where AdmissionNo='$add'");
   while($rowes4 = mysqli_fetch_array($cources))
   {
       $cour = $rowes4["CourseName"];
       echo $cour; 
       }
       ?></td>
       <td class="col-2" style="color: black;">
   <?php 
   $cources = mysqli_query($sql_con, "SELECT * FROM student_course where AdmissionNo='$add'");
   while($rowes4 = mysqli_fetch_array($cources))
   {
       $cour = $rowes4["Duration"];
       echo $cour; 
       }
       ?></td>
        <td class="col-2" style="color: black;"><?php echo $landmark;?></td>
        <td class="col-2" style="color: black;"><?php echo $email;?></td>
        <td class="col-1" style="color: black;"><?php echo $gender; ?></td>
   
        <td class="col-1"><a href="images/<?php echo $phone;?>" target="_blank"><img src="images/<?php echo $phone;?>" style="height: 70px; width: 70px;"></a></td>
        <td class="col-1"><button type="button" class="btn btn-primary" data-toggle="modal" onclick="document.getElementById('address_id').value = '<?php echo $no; ?>';document.getElementById('admission').value = '<?php echo $add; ?>';document.getElementById('branch').value = '<?php echo $branch; ?>';document.getElementById('batchtiming').value = '<?php echo $batchtime; ?>';document.getElementById('add').value = '<?php echo $admission; ?>';document.getElementById('time').value = '<?php echo $time; ?>';document.getElementById('gender').value = '<?php echo $gender; ?>';document.getElementById('marital').value = '<?php echo $marital; ?>';document.getElementById('birth').value = '<?php echo $birth; ?>';document.getElementById('location').value = '<?php echo $location; ?>';document.getElementById('landmark').value = '<?php echo $landmark; ?>';document.getElementById('email1').value = '<?php echo $email; ?>';document.getElementById('email2').value = '<?php echo $email1; ?>';document.getElementById('father').value = '<?php echo $father; ?>';document.getElementById('email3').value = '<?php echo $phone; ?>';"data-target="#myModal" style="font-size: 12px;">Details
  </button></td></tr>
  <?php
}
}
       ?>
        
      
      
    </tbody>
  </table></div>
<div class="container">

<div class="modal fade" id="myModal">
    <div class="modal-dialog modal-lg">
      <div class="modal-content">
      
        
        <div class="modal-header">
          <h4 class="modal-title">Student Personal Information</h4>
          <button type="button" class="close" data-dismiss="modal">&times;</button>
        </div>
        
        
        <div class="modal-body">
          <div class="container">

<form method="POST" enctype="multipart/form-data">
              
              <div class="form-group row" style="height: 20px;">
                                                <label class="col-lg-4 col-form-label" >Sno<span class="text-danger">*</span></label>
                                                <div class="col-lg-8">
                                                    <input type="name" class="form-control" id="address_id" placeholder="Location" name="address_sno" style="height: 20px;">
                                                </div>
                                            </div>
                                            
  <div class="form-group row" style="height: 20px;">
                                                <label class="col-lg-4 col-form-label" >Branch Name<span class="text-danger">*</span></label>
                                                <div class="col-lg-8">
                                                    <input type="text" class="form-control" name="branch" placeholder="Branch Name" id="branch" style="height: 20px;">
                                                </div>
                                            </div>
                                            <div class="form-group row" style="height: 20px;">
                                                <label class="col-lg-4 col-form-label" >Admission No<span class="text-danger">*</span></label>
                                                <div class="col-lg-8">
                                                    <input type="text" class="form-control" name="admission" placeholder="Admission No" id="admission" style="height: 20px;">
                                                </div>
                                            </div>
                                            <div class="form-group row" style="height: 20px;">
                                                <label class="col-lg-4 col-form-label" >Admission Date<span class="text-danger">*</span></label>
                                                <div class="col-lg-8">
                                                    <input type="text" class="form-control" name="date" placeholder="Admission Date" id="add" style="height: 20px;">
                                                </div>
                                            </div>
                      <div class="form-group row" style="height: 20px;">
                                                <label class="col-lg-4 col-form-label" for="val-email">Batch Timing<span class="text-danger">*</span></label>
                                                <div class="col-lg-8">
                                                    <input type="text" class="form-control" id="batchtiming" placeholder="Batch Timing" name="batch" style="height: 20px;">
                                                </div>
                                            </div>
<div class="form-group row" style="height: 20px;">
                                                <label class="col-lg-4 col-form-label" >Admission Time<span class="text-danger">*</span></label>
                                                <div class="col-lg-8">
                                                    <input type="text" class="form-control" name="time" placeholder="Admission Time" id="time" style="height: 20px;">
                                                </div>
                                            </div>
                                           
  <div class="form-group row" style="height: 20px;">
    <label for="Name" class="col-lg-4 col-form-label">Name </label>
    <div class="col-lg-8">
    <input type="name" class="form-control" id="location" placeholder="Name" name="location" style="height: 20px;">
</div>
  </div>

<div class="form-group row" style="height: 20px;">
    <label for="Name" class="col-lg-4 col-form-label">Father Name </label>
    <div class="col-lg-8">
     <input type="text" id="father" class="form-control" name="father" placeholder="Father Name" style="height: 20px;">
 </div>
  </div>

<div class="form-group row" style="height: 20px;">
    <label for="landmark" class="col-lg-4 col-form-label">Phone No</label>
    <div class="col-lg-8">
    <input type="landmark" class="form-control" id="landmark" placeholder="Phone No" name="landmark" style="height: 20px;">
</div>
  </div>

<div class="form-group row" style="height: 20px;">
    <label for="country" class="col-lg-4 col-form-label">Email Id</label>
    <div class="col-lg-8">
     <input type="text" class="form-control" id="email1" placeholder="Email Id" name="country" style="height: 20px;">
 </div>
  </div>
  <div class="form-group row" style="height: 20px;">
    <label for="country" class="col-lg-4 col-form-label">Gender</label>
    <div class="col-lg-8">
     <input type="text" class="form-control" id="gender" placeholder="Gender" name="gender" style="height: 20px;">
 </div>
  </div>
  <div class="form-group row" style="height: 20px;">
    <label for="country" class="col-lg-4 col-form-label">Marital Status</label>
    <div class="col-lg-8">
     <input type="text" class="form-control" id="marital" placeholder="Marital Status" name="marital" style="height: 20px;">
 </div>
  </div>  
  <div class="form-group row" style="height: 20px;">
    <label for="country" class="col-lg-4 col-form-label">Date Of Birth</label>
    <div class="col-lg-8">
     <input type="text" class="form-control" id="birth" placeholder="Date of Birth" name="birth" style="height: 20px;">
 </div>
  </div>  
  <div class="form-group row" style="height: 20px;">
    <label for="country" class="col-lg-4 col-form-label">Address</label>
    <div class="col-lg-8">
     <input type="text" class="form-control" id="email2" placeholder="Address" name="email_id_1" style="height: 20px;">
 </div>
  </div>  
  <div class="form-group row" style="height: 20px;">
    <label for="country" class="col-lg-4 col-form-label">Image</label>
    <div class="col-lg-8">
     <input type="file" class="form-control" id="email3" placeholder="Email ID 2" name="long" style="height: 40px;">
  </div> 
</div>
<br><br>
  
  <button type="submit" class="btn btn-info" name="update" style="font-size: 12px;">Update Information</button>
  <button type="submit" class="btn btn-info" name="delete" style="font-size: 12px;">Delete Information</button>
  
  
</form>
<br>
</div>
        </div>
        
        
        <div class="modal-footer" style="padding: 5px;">
          <button type="button" class="btn btn-danger" data-dismiss="modal" style="font-size: 12px;">Close</button>
        </div>
        
      </div>
    </div>
  </div>
  
</div>

</div>
                            </div>
                        </div>
                    </div>
                </div>
                    <div class="row">
                        <div class="col-lg-6">
                            <div class="footer">
                                <p>All right reserved by- <a href="">Modi Training Institute</a> 
                            </div>
                        </div>
                        <div class="col-lg-6">
                            <div class="footer" style="text-align: right;">
                                <p style="text-align: right;">Managed By- <a href="https://www.kiyanchsolutions.com/" target="_blank">Kiyan Ch Solutions</a> 
                            </div>
                        </div>
                    </div>
                </section>
            </div>
        </div>
    </div>
    
    
    <script src="assets/js/lib/jquery.min.js"></script>
    <script src="assets/js/lib/jquery.nanoscroller.min.js"></script>
    
    <script src="assets/js/lib/menubar/sidebar.js"></script>
    <script src="assets/js/lib/preloader/pace.min.js"></script>
    
    
    
    
    <script src="assets/js/lib/select2/select2.full.min.js"></script>
    <script src="assets/js/lib/form-validation/jquery.validate.min.js"></script>
    <script src="assets/js/lib/form-validation/jquery.validate-init.js"></script>
    <script src="assets/js/lib/bootstrap.min.js"></script><script src="assets/js/scripts.js"></script>

var style = "<style>";
        style = style + "table {width: 100%;font: 17px Calibri;}";
        style = style + "table, th, td {border: solid 1px #DDD; border-collapse: collapse;";
        style = style + "padding: 2px 3px;text-align: center;}";
        style = style + "</style>";

// CREATE A WINDOW OBJECT.
        var win = window.open('', '', 'height=700,width=700');

win.document.write('<html><head>');
        win.document.write('<title>Profile</title>');   // <title> FOR PDF HEADER.
        win.document.write(style);          // ADD STYLE INSIDE THE HEAD TAG.
        win.document.write('</head>');
        win.document.write('<body>');
        win.document.write(sTable);         // THE TABLE CONTENTS INSIDE THE BODY TAG.
        win.document.write('</body></html>');

win.document.close();   // CLOSE THE CURRENT WINDOW.

win.print();    // PRINT THE CONTENTS.
    }
</script>
    
 <script>

</script>

var today = new Date();
var dd = String(today.getDate()).padStart(2, '0');
var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!
var yyyy = today.getFullYear();

today = mm + '-' + dd + '-' + yyyy;
document.getElementById('currentdate').value = today;

</script>

</body>

</html>

${this.title}

Code Editor : personalupdate.php