|
Server IP : 162.214.80.37 / Your IP : 216.73.216.173 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/skyispatudyog/sym/Users/0-imyrqtmy/zugadu/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!DOCTYPE html>
<html lang="en">
<head>
<?php include'include/head.php'; ?>
<?php include"AdminPanel/include/connection.php"; ?>
</head>
<body>
<?php include'include/color.php'; ?>
<div class="r-wrapper">
<header>
<div class="r-header r-header-inner r-header-strip-02">
<?php include'include/header.php'; ?>
<?php //include'include/slider.php'; ?>
<?php //include'include/searchform.php'; ?>
<div class="r-header-inner-banner">
<div class="r-header-in-over">
<h1><b>Search</b> Result </h1>
<div class="r-breadcrum">
<!-- <ul>
<li><a href="#">HOME</a></li>
<li><span>ABOUT US</span></li>
</ul> -->
</div>
</div>
</div>
</div>
</header>
<section class="r-advantages-part">
<div class="r-advantage-main-part r-advantage-main-part-white">
<div class="container clearfix">
<div class="advantage-head">
<span>OUR VEHICLES BRANDS & TYPE</span>
<h2>Find Your <b>Result.</b></h2>
</div>
<div class="clearfix r-car-tabs">
<div class="tab-content" id="myTabContent">
<div class="tab-pane fade show active" id="business" role="tabpanel" aria-labelledby="business-tab">
<div class="r-car-whole-info">
<?php
if(isset($_POST['find']))
{
$type=$_POST['type'];
$brand=$_POST['brand'];
$make=$_POST['model'];
$year=$_POST['year'];
$city=$_POST['city'];
//echo "SELECT * FROM windshield_data WHERE Brand='$brand' AND Model='$make' AND Year='$year' AND City='$city'";
if($type=="windshield")
{
$sql=mysqli_query($db,"SELECT * FROM windshield_data WHERE Brand='$brand' AND Model='$make' AND Year='$year' AND City='$city'") or die(mysqli_error($db));
$num=mysqli_num_rows($sql);
if($num>=1)
{
while($aa=mysqli_fetch_assoc($sql))
{
$idd=$aa['Id'];
$title=$aa['Title'];
$desc=$aa['Description'];
$original=$aa['Original'];
$local=$aa['Local'];
$bid=$aa['Brand'];
$mid=$aa['Model'];
$yid=$aa['Year'];
$cid=$aa['City'];
$img=$aa['Image'];
$image="AdminPanel/".$img;
$b1=mysqli_query($db,"SELECT * FROM brand WHERE id='$bid'") or die(mysqli_error($db));
$ba=mysqli_fetch_assoc($b1);
$bname=$ba['brand_name'];
$m1=mysqli_query($db,"SELECT * FROM model WHERE id='$mid'") or die(mysqli_error($db));
$ma=mysqli_fetch_assoc($m1);
$mname=$ma['model_name'];
$y1=mysqli_query($db,"SELECT * FROM year WHERE id='$yid'") or die(mysqli_error($db));
$ya=mysqli_fetch_assoc($y1);
$yname=$ya['year'];
$c1=mysqli_query($db,"SELECT * FROM city WHERE city_id='$cid'") or die(mysqli_error($db));
$ca=mysqli_fetch_assoc($c1);
$cname=$ca['city_name'];
$cstate=$ca['city_state'];
?>
<div class="row">
<div class="col-lg-6 col-md-12 col-sm-12 col-xs-12">
<div class="r-car-product-carousel-wrapper">
<div class="r-car-product-carousel owl-carousel" style="display:block;" data-slider-id="r-product-slider" id="productSlider">
<div class="item">
<img src="<?php echo $image; ?>" alt="" class="img-fluid" />
</div>
</div>
</div>
</div>
<div class="col-lg-6 col-md-12 col-sm-12 col-xs-12">
<div class="r-car-info-content">
<span class="r-reg-year">Registered <?php echo $yname; ?></span>
<h2 class="r-product-name"> <?php echo $title; ?> <span></span> </h2>
<p class="r-product-description"><?php echo $desc; ?></p>
<div class="table-responsive">
<table class="table table-bordered">
<tr>
<td>Brand</td>
<td><?php echo $bname; ?></td>
</tr>
<tr>
<td>Model</td>
<td><?php echo $mname; ?></td>
</tr>
<tr>
<td>Original Price</td>
<td><?php echo $original; ?> ₹</td>
</tr>
<tr>
<td>Imported (ISI)</td>
<td><?php echo $local; ?> ₹</td>
</tr>
</table>
<!-- <ul class="pl-0 mb-0 text-left mb-4">
<li><i class="fa fa-car"></i><span>2017</span></li>
<li><i class="fa fa-cogs"></i><span>MANUAL</span></li>
<li><i class="fa fa-beer"></i><span>PETROL</span></li>
<li><i class="fa fa-road"></i><span>2.3k CC</span></li>
</ul> -->
</div>
<a href="enquiry.php?id=<?php echo $idd; ?>&t=1" class="btn btn-full">Book Now</a>
</div>
</div>
</div>
<?php
}
}
else
{
echo"<script>location.href='notfound.php';</script>";
}
}
else if($type=="service")
{
$sql=mysqli_query($db,"SELECT * FROM service_data WHERE Brand='$brand' AND Model='$make' AND Year='$year' AND City='$city'") or die(mysqli_error($db));
$num=mysqli_num_rows($sql);
if($num>=1)
{
while($aa=mysqli_fetch_assoc($sql))
{
$idd=$aa['Id'];
$title=$aa['Title'];
$desc=$aa['Description'];
$img=$aa['Image'];
$image="AdminPanel/".$img;
$bid=$aa['Brand'];
$mid=$aa['Model'];
$yid=$aa['Year'];
$cid=$aa['City'];
$price=$aa['Price'];
$b1=mysqli_query($db,"SELECT * FROM brand WHERE id='$bid'") or die(mysqli_error($db));
$ba=mysqli_fetch_assoc($b1);
$bname=$ba['brand_name'];
$m1=mysqli_query($db,"SELECT * FROM model WHERE id='$mid'") or die(mysqli_error($db));
$ma=mysqli_fetch_assoc($m1);
$mname=$ma['model_name'];
$y1=mysqli_query($db,"SELECT * FROM year WHERE id='$yid'") or die(mysqli_error($db));
$ya=mysqli_fetch_assoc($y1);
$yname=$ya['year'];
$c1=mysqli_query($db,"SELECT * FROM city WHERE city_id='$cid'") or die(mysqli_error($db));
$ca=mysqli_fetch_assoc($c1);
$cname=$ca['city_name'];
$cstate=$ca['city_state'];
?>
<div class="row">
<div class="col-lg-6 col-md-12 col-sm-12 col-xs-12">
<div class="r-car-product-carousel-wrapper">
<div class="r-car-product-carousel owl-carousel" style="display:block;" data-slider-id="r-product-slider" id="productSlider">
<div class="item">
<img src="<?php echo $image; ?>" alt="" class="img-fluid" />
</div>
</div>
</div>
</div>
<div class="col-lg-6 col-md-12 col-sm-12 col-xs-12">
<div class="r-car-info-content">
<span class="r-reg-year">Registered <?php echo $yname; ?></span>
<h2 class="r-product-name"> <?php echo $title; ?> <span></span> </h2>
<p class="r-product-description"><?php echo $desc; ?></p>
<div class="table-responsive">
<table class="table table-bordered">
<tr>
<td>Brand</td>
<td><?php echo $bname; ?></td>
</tr>
<tr>
<td>Model</td>
<td><?php echo $mname; ?></td>
</tr>
<tr>
<td>Price</td>
<td><?php echo $price; ?> ₹</td>
</tr>
</table>
<ul class="pl-0 mb-0 text-left mb-4">
<li><i class="fa fa-car"></i><span><?php echo $yname; ?></span></li>
<li><i class="fa fa-cogs"></i><span>MANUAL</span></li>
<!--<li><i class="fa fa-beer"></i><span>PETROL</span></li>-->
<!--<li><i class="fa fa-road"></i><span>2.3k CC</span></li>-->
</ul>
</div>
<a href="enquiry.php?id=<?php echo $idd; ?>&t=2" class="btn btn-full">Book Now</a>
</div>
</div>
</div>
<?php
}
}
else
{
echo"<script>location.href='notfound.php';</script>";
}
}
else
{
echo"<script>location.href='notfound.php';</script>";
}
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- <section class="r-advantages-part">
<div class="r-advantage-main-part r-advantage-main-part-white">
<div class="container clearfix">
<div class="advantage-head">
<span>OUR VEHICLES BRANDS & TYPE</span>
<h2>Find Your <b>Best Vehicles.</b></h2>
</div>
<div class="clearfix r-car-tabs">
<div class="tab-content" id="myTabContent">
<div class="tab-pane fade show active" id="business" role="tabpanel" aria-labelledby="business-tab">
<div class="r-car-whole-info">
<div class="row">
<div class="col-lg-7 col-md-12 col-sm-12 col-xs-12">
<div class="r-car-product-carousel-wrapper">
<div class="r-car-product-carousel owl-carousel" data-slider-id="r-product-slider" id="productSlider">
<div class="item">
<img src="assets/images/car-slider-img-1.jpg" alt="" class="img-fluid" />
</div>
<div class="item">
<img src="assets/images/car-slider-img-2.jpg" alt="" class="img-fluid" />
</div>
<div class="item">
<img src="assets/images/car-slider-img-3.jpg" alt="" class="img-fluid" />
</div>
<div class="item">
<img src="assets/images/car-slider-img-4.jpg" alt="" class="img-fluid" />
</div>
</div>
<ul class="owl-thumbs r-car-product-carousel-thumb" data-slider-id="r-product-slider">
<li class="owl-thumb-item"> <img src="assets/images/car-slider-img-1.jpg" alt="" class="img-fluid" /> </li>
<li class="owl-thumb-item"> <img src="assets/images/car-slider-img-2.jpg" alt="" class="img-fluid" /> </li>
<li class="owl-thumb-item"> <img src="assets/images/car-slider-img-3.jpg" alt="" class="img-fluid" /> </li>
<li class="owl-thumb-item"> <img src="assets/images/car-slider-img-4.jpg" alt="" class="img-fluid" /> </li>
</ul>
</div>
</div>
<div class="col-lg-5 col-md-12 col-sm-12 col-xs-12">
<div class="r-car-info-content">
<span class="r-reg-year">Registered 2016</span>
<h2 class="r-product-name"> Mercedes Benz <span>GTR</span> </h2>
<p class="r-product-description">This was our first time renting from Royal Cars and we were very pleased with the whole experience. Your price was lower than other companies.</p>
<div class="table-responsive">
<table class="table table-bordered">
<tr>
<td>Make Lamborghini</td>
<td>Style SUV Premium </td>
</tr>
<tr>
<td>Model M-Class Sport</td>
<td>Engine V-6 Cylinder</td>
</tr>
</table>
<ul class="pl-0 mb-0 text-left mb-4">
<li><i class="fa fa-car"></i><span>2017</span></li>
<li><i class="fa fa-cogs"></i><span>MANUAL</span></li>
<li><i class="fa fa-beer"></i><span>PETROL</span></li>
<li><i class="fa fa-road"></i><span>2.3k CC</span></li>
</ul>
</div>
<a href="#" class="btn btn-full">RENT THIS CAR</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section> -->
<?php include'include/footer.php'; ?>
</div>
<div id="r-to-top" class="r-to-top"><i class="fa fa-angle-up"></i></div>
<!-- JQUERY:: JQUERY.JS -->
<?php include'include/js.php'; ?>
</body>
</html>