| Server IP : 68.178.161.82 / Your IP : 216.73.216.141 Web Server : Microsoft-IIS/10.0 System : Windows NT 82-161-178-68 10.0 build 20348 (Windows Server 2016) AMD64 User : IWAM_plesk(default) ( 0) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Inetpub/vhosts/lpsc.co.in/gomtinagar.lpsc.co.in/ |
Upload File : |
<?php
include('admin/includes/config.php');
?>
<?php
if(isset($_POST['search']))
{
$valueToSearch = $_POST['valueToSearch'];
// search in all table columns
// using concat mysql function
$query = "SELECT * FROM `tcgomtinagar` WHERE CONCAT(`id`, `VehiclesTitle`, `ModelYear`, `FuelType`) LIKE '%".$valueToSearch."%'";
$search_result = filterTable($query);
}
else {
$query = "SELECT * FROM `tcgomtinagar`";
$search_result = filterTable($query);
}
// function to connect and execute the query
function filterTable($query)
{
$connect = mysqli_connect("localhost:3306", "lpsclucknow", "lpsc@@@123", "lps");
$filter_Result = mysqli_query($connect, $query);
return $filter_Result;
}
?>
<!DOCTYPE html>
<html lang="en">
<!-- Mirrored from demo1.lucknowpublicschoolsandcolleges.com/result.aspx by HTTrack Website Copier/3.x [XR&CO'2014], Thu, 14 May 2020 14:45:46 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8" /><!-- /Added by HTTrack -->
<head><meta charset="utf-8" /><meta http-equiv="x-ua-compatible" content="ie=edge" /><meta name="description" /><meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" /><title>
Lucknow Public Schools and Colleges
</title><link rel="icon" href="assets/images/logo.png" sizes="32x32" /><link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"><link href="assets/css/animate.min.css" rel="stylesheet" type="text/css" /><link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" /><link href="assets/css/all.css" rel="stylesheet" type="text/css" /><link href="assets/css/magnific-popup.css" rel="stylesheet" type="text/css" /><link href="assets/css/owl.carousel.min.css" rel="stylesheet" type="text/css" /><link href="assets/css/nice-select.css" rel="stylesheet" type="text/css" /><link href="assets/css/slick.css" rel="stylesheet" type="text/css" /><link href="assets/css/default.css" rel="stylesheet" type="text/css" /><link href="assets/css/style.css" rel="stylesheet" type="text/css" />
<style>
.faq-area
{
padding-top: 20px;
}
.faq-area .faq-accordion
{
padding-top: 0px;
}
.panel-default
{
border-color: #ddd;
}
.panel
{
margin-bottom: 20px;
background-color: #fff;
border: 1px solid transparent;
border-radius: 4px;
-webkit-box-shadow: 0 1px 1px rgba(0, 0, 0, .05);
box-shadow: 0 1px 1px rgba(0, 0, 0, .05);
}
*
{
-webkit-box-sizing: border-box;
-moz-box-sizing: border-box;
box-sizing: border-box;
}
user agent stylesheet div
{
display: block;
}
.panel-default > .panel-heading
{
color: #333;
background-color: #f5f5f5;
border-color: #ddd;
}
.panel-heading
{
padding: 10px 15px;
border-bottom: 1px solid transparent;
border-top-left-radius: 3px;
border-top-right-radius: 3px;
}
.panel-body:before, .panel-body:after
{
display: table;
content: " ";
}
.table-responsive
{
min-height: .01%;
overflow-x: auto;
}
.table-bordered
{
border: 1px solid #ddd;
}
.table
{
width: 100%;
max-width: 100%;
margin-bottom: 20px;
}
table
{
background-color: transparent;
}
table
{
border-spacing: 0;
border-collapse: collapse;
}
thead
{
display: table-header-group;
vertical-align: middle;
border-color: inherit;
}
tr
{
display: table-row;
vertical-align: inherit;
border-color: inherit;
}
tbody
{
display: table-row-group;
vertical-align: middle;
border-color: inherit;
}
.table-striped > tbody > tr:nth-of-type(odd)
{
background-color: #f9f9f9;
}
.table-bordered > thead > tr > th, .table-bordered > tbody > tr > th, .table-bordered > tfoot > tr > th, .table-bordered > thead > tr > td, .table-bordered > tbody > tr > td, .table-bordered > tfoot > tr > td
{
border: 1px solid #ddd;
}
.table > thead > tr > th, .table > tbody > tr > th, .table > tfoot > tr > th, .table > thead > tr > td, .table > tbody > tr > td, .table > tfoot > tr > td
{
padding: 8px;
line-height: 1.42857143;
vertical-align: top;
border-top: 1px solid #ddd;
}
.panel-body
{
padding: 15px;
}
.panel-default
{
border-color: #ddd;
}
</style>
<style>
.text-center
{
color: wheat;
}
table,tr,th,td
{
border: 1px solid black;
}
body {
font-family: Arial;
}
* {
box-sizing: border-box;
}
form.example input[type=text] {
padding: 10px;
font-size: 17px;
border: 1px solid grey;
float: left;
width: 80%;
background: #f1f1f1;
}
form.example button {
float: left;
width: 20%;
padding: 10px;
background: #2196F3;
color: white;
font-size: 17px;
border: 1px solid grey;
border-left: none;
cursor: pointer;
}
form.example button:hover {
background: #0b7dda;
}
form.example::after {
content: "";
clear: both;
display: table;
}
</style>
</head>
<body>
<div id="preloader">
<div id="status">
<div class="spinner">
<div class="rect1">
</div>
<div class="rect2">
</div>
<div class="rect3">
</div>
<div class="rect4">
</div>
<div class="rect5">
</div>
</div>
</div>
</div>
<header class="header-area">
<div class="header-top">
<div class="container-fluid">
<div class="row">
<div class="col-lg-6 col-md-7 col-sm-5">
<div class="header-logo d-flex align-items-center justify-content-center justify-content-sm-start">
<div class="logo"><a href="index.php"><img src="assets/images/logo.png" alt="logo"></a></div>
<!--<form class="d-none d-md-inline-block" action="#">
<div class="input-box">
<i class="fal fa-search"></i>
<input type="text" placeholder="Search Your keyword">
</div>
</form>-->
</div>
</div>
<div class="col-lg-6 col-md-5 col-sm-7">
<div class="header-btns d-flex align-items-center justify-content-center justify-content-sm-end">
<ul>
<li><a href="#"><i class="fal fa-phone"></i>TOLL FREE NUMBER :- 1800-1232-22226</a></li>
</ul>
<div class="trial-btns d-none d-lg-block">
<a href="contact.php">Contact us</a>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="header-menu">
<div class="navigation">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<nav class="navbar navbar-expand-lg">
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarFive" aria-controls="navbarFive" aria-expanded="false" aria-label="Toggle navigation">
<span class="toggler-icon"></span>
<span class="toggler-icon"></span>
<span class="toggler-icon"></span>
</button> <!-- navbar toggler -->
<div class="collapse navbar-collapse sub-menu-bar" id="navbarFive">
<ul class="navbar-nav mr-auto">
<li class="nav-item active">
<a class="page-scroll" href="index.php">Home </a>
</li>
<li class="nav-item">
<a class="page-scroll" href="" >About <i class="fal fa-angle-down"></i></a>
<ul class="sub-menu">
<li><a href="about.php">About</a></li>
<li><a href="Rules.php">Rules</a></li>
<li><a href="correspondent.php">Correspondent details</a></li>
<li><a href="areaofsch.php">Area of school</a></li>
<li><a href="fees.php">Fees Structure</a></li>
<li><a href="abpayment.php">Details of Payment</a></li>
<li><a href="ablibrary.php">Library Facilities</a></li>
<li><a href="abvarious.php">Various Sessional Detail</a></li>
</ul>
</li>
<li class="nav-item">
<a class="page-scroll" href="#">Admissions <i class="fal fa-angle-down"></i></a>
<ul class="sub-menu">
<li><a href="whylps.php">Why LPS</a></li>
<li><a href="faq.php">FAQ</a></li>
</ul>
</li>
<li class="nav-item">
<a class="page-scroll" href="#">Academics <i class="fal fa-angle-down"></i></a>
<ul class="sub-menu">
<li><a href="result.php">Result At A Glance</a></li>
<li><a href="Toppers.php">Toppers</a></li>
</ul>
</li>
<li class="nav-item">
<a class="page-scroll" href="#">Downloads <i class="fal fa-angle-down"></i></a>
<ul class="sub-menu">
<li><a href="#">*click to go main page*</a></li>
<li><a href="http://demo1.lucknowpublicschoolsandcolleges.com/scheme.aspx">Schemes</a></li>
<li><a href="http://demo1.lucknowpublicschoolsandcolleges.com/Syllabus.aspx">Syllabus</a></li>
<li><a href="http://demo1.lucknowpublicschoolsandcolleges.com/admission.aspx">Admission Form</a></li>
<li><a href="http://demo1.lucknowpublicschoolsandcolleges.com/uploads/files/PROSPECTUS%202020-21.pdf">Prospectus</a></li>
<li><a href="http://demo1.lucknowpublicschoolsandcolleges.com/uploads/files/PLANNER202021.pdf">School calender</a></li>
</ul>
</li>
<li class="nav-item">
<a class="page-scroll" href="our-events.php">Events</a>
<ul class="sub-menu">
</ul>
</li>
<li class="nav-item active">
<a class="page-scroll" href="gallery.php">Gallery </a>
</li>
<li class="nav-item active">
<a class="page-scroll" href="tc.php">TC </a>
</li>
<li class="nav-item active">
<a class="page-scroll" href="notice.php">Notice </a>
</li>
</ul>
</div>
<div class="navbar-item d-flex align-items-center">
<div class="menu-btns">
<ul>
<!-- <li><a href="#">Popular Courses</a></li>
<li><a href="#">Mentors</a></li>-->
</ul>
</div>
<?php $sql = "SELECT * from link ";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{ ?>
<div class="menu-icon d-none d-lg-block">
<ul>
<li><a href="<?php echo htmlentities($result->facebook);?>"><i class="fab fa-facebook-f"></i></a></li>
<li><a href="<?php echo htmlentities($result->twitter);?>"><i class="fab fa-twitter"></i></a></li>
<li><a href="<?php echo htmlentities($result->instagram);?>"><i class="fab fa-instagram"></i></a></li>
<li><a href="<?php echo htmlentities($result->linkedin);?>"><i class="fab fa-linkedin"></i></a></li>
<li><a href="<?php echo htmlentities($result->youtube);?>"><i class="fab fa-youtube"></i></a></li>
</ul>
</div>
<?php }} ?>
</div>
</nav> <!-- navbar -->
</div>
</div> <!-- row -->
</div> <!-- container -->
</div>
</div>
</header>
<!--====== PAGE TITLE PART START ======-->
<div class="page-title bg_cover mt-80 pt-140 pb-140" style="background-image: url(assets/images/page-bg.jpg)">
<div class="container">
<div class="row justify-content-center">
<div class="col-lg-12">
<div class="page-title-item text-center">
<h3 class="title">
SEARCH TRANSFER CERTIFICATE (TC)</h3>
<nav aria-label="breadcrumb">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="Default.html">Home</a></li>
<li class="breadcrumb-item active" aria-current="page">SEARCH TRANSFER CERTIFICATE (TC)</li>
</ol>
</nav>
</div>
</div>
</div>
</div>
</div>
<!--====== PAGE TITLE PART ENDS ======-->
<br>
<br>
<form class="example" method="post" style="margin:auto;max-width:300px">
<input type="text" name="valueToSearch" placeholder="Value To Search">
<button type="submit" name="search" value="Filter"><i class="fa fa-search"></i></button>
</form>
<!--====== FAQ PART START ======-->
<section class="faq-area pb-120">
<div class="container">
<div class="row">
<div class="col-md-12">
<!-- Kitchen Sink -->
<div class="panel panel-default">
<div class="panel-heading">
TC
</div>
<div class="panel-body">
<div class="table-responsive">
<table class="table table-striped table-bordered table-hover">
<thead>
<tr>
<th>
Sr No.
</th>
<th>
Student Name
</th>
<th>
Father Name
</th>
<th>
Image
</th>
</tr>
</thead>
<thead>
<tr>
<!-- populate table from mysql database -->
<?php while($row = mysqli_fetch_array($search_result)):?>
<tr>
<td><?php echo $row['ModelYear'];?></td>
<td><?php echo $row['VehiclesTitle'];?></td>
<td><?php echo $row['FuelType'];?></td>
<td><a href="admin/img/vehicleimages/<?php echo $row['Vimage1'];?>" download><img src="admin/img/vehicleimages/<?php echo $row['Vimage1'];?>" width="50" height="50"> <h8 class="fal fa-download"></a></h8></td>
</tr>
<?php endwhile;?>
</tr>
</thead>
<thead>
<tr>
<th>
Sr No.
</th>
<th>
Student Name
</th>
<th>
Father Name
</th>
<th>
Image
</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
<!-- End Kitchen Sink -->
</div>
</div>
</div>
</section>
<!--====== FAQ PART ENDS ======-->
<?php Include('footer.php') ?>
<div class="back-to-top">
<a href="#"><i class="fal fa-chevron-double-up"></i></a>
</div>
<script src="Scripts/modernizr-3.6.0.min.js" type="text/javascript"></script>
<script src="Scripts/jquery-1.12.4.min.js" type="text/javascript"></script>
<script src="Scripts/bootstrap.min.js" type="text/javascript"></script>
<script src="Scripts/popper.min.js" type="text/javascript"></script>
<script src="Scripts/slick.min.js" type="text/javascript"></script>
<script src="Scripts/isotope.pkgd.min.js" type="text/javascript"></script>
<script src="Scripts/imagesloaded.pkgd.min.js" type="text/javascript"></script>
<script src="Scripts/owl.carousel.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.nice-select.min.js" type="text/javascript"></script>
<script src="Scripts/wow.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.counterup.min.js" type="text/javascript"></script>
<script src="Scripts/waypoints.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.magnific-popup.min.js" type="text/javascript"></script>
<script src="Scripts/main.js" type="text/javascript"></script>
<script>
$(document).ready(function () {
var url = window.location;
var element = $('#navbarFive li a').filter(function () {
return this.href.toString().toLowerCase() == url.toString().toLowerCase() || url.href.toString().toLowerCase().indexOf(this.href.toString().toLowerCase()) == 0;
}).parent().addClass('active');
if (element.is('li')) {
element.addClass('active').parentsUntil('ul.list', 'li').addClass('active')
}
});
</script>
</body>
<!-- Mirrored from demo1.lucknowpublicschoolsandcolleges.com/result.aspx by HTTrack Website Copier/3.x [XR&CO'2014], Thu, 14 May 2020 14:45:46 GMT -->
</html>