1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / nh19cars /
Filename : details.php
back
<?php include ("template/header.php"); ?>


<!-- slick css -->
<link rel="stylesheet" type="text/css" href="<?php echo $base_url;?>site/css/slick/slick.css" />
<link rel="stylesheet" type="text/css" href="<?php echo $base_url;?>site/css/slick/slick-theme.css" />


<?php

$id = $_GET['id'];
$sql = "select c.*, (select m1.name from car_make m1, car_model m2 where m2.id = c.model_id and m2.make_id = m1.id) as make, (select m2.name from car_make m1, car_model m2 where m2.id = c.model_id and m2.make_id = m1.id) as model, (select image from car_images i where i.car_id = c.id limit 0,1) as image from cars c where c.status = 1 and c.id = '".$id."'";
$result = $conn->query($sql);


$sql = "select * from  features f, car_features cf where f.id = cf.feature_id and cf.car_id = $id";
$feature_result = $conn->query($sql);


$sql = "select * from car_images where car_id = '".$id."'";
$image_result = $conn->query($sql);


if($result->num_rows > 0){
  $car = $result->fetch_assoc();
}else{
  exit;
}
?>



<!--=================================
 inner-intro -->

 <section class="inner-intro bg-1 bg-overlay-black-70">
  <div class="container">
     <div class="row text-center intro-title">
       <div class="col-md-6 text-md-start d-inline-block">
         <h1 class="text-white"><?php echo $car['make'];?> - <?php echo $car['model'];?></h1>
       </div>
       <div class="col-md-6 text-md-end float-end">
         <ul class="page-breadcrumb">
            <li><a href="#"><i class="fa fa-home"></i> Home</a> <i class="fa fa-angle-double-right"></i></li>
            <li><a href="#">Cars</a> <i class="fa fa-angle-double-right"></i></li>
            <li><span><?php echo $car['make'];?> - <?php echo $car['model'];?></span> </li>
         </ul>
       </div>
     </div>
  </div>
</section>

<!--=================================
 inner-intro -->


<!--=================================
car-details  -->

<section class="car-details page-section-ptb">
  <div class="container">
    <div class="row">
     <div class="col-md-9">
       <h3><?php echo $car['make'];?> - <?php echo $car['model'];?></h3>
       <p><?php echo $car['history'];?></p>
      </div>
     <div class="col-md-3">
        <!--
      <div class="car-price text-lg-end">
         <strong>Rs 69,995</strong>
         <span>Plus Taxes & Licensing</span>
       </div>
-->
      </div>
    </div>

    <div class="row">
     <div class="col-md-8">
        <div class="slider-slick">
          <div class="slider slider-for detail-big-car-gallery">
                
          <img class="img-fluid" src="<?php echo $base_url;?>uploads/<?php echo $car['featured_image'];?>" alt="">

                <?php
                while($image = $image_result->fetch_assoc()){
                ?>
                  <img class="img-fluid" src="<?php echo $base_url;?>uploads/<?php echo $image['image'];?>" alt="">
                <?php
                }
                ?>
                
            </div>
            <div class="slider slider-nav">
            <img class="img-fluid" src="<?php echo $base_url;?>uploads/<?php echo $car['featured_image'];?>" alt="">
                <?php
                $image_result->data_seek(0);
                while($image = $image_result->fetch_assoc()){
                ?>
                  <img class="img-fluid" src="<?php echo $base_url;?>uploads/<?php echo $image['image'];?>" alt="">
                <?php
                }
                ?>

            </div>
         </div>

        
        <?php
        if($feature_result->num_rows > 0){
        ?>
        <div class="extra-feature">
          <h6> extra feature</h6>

        
          <div class="row">

            <div class="">
              <ul class="list-style-1 row">
                <?php
                while($feature = $feature_result->fetch_assoc()){
                ?>
                <li class="col-lg-4 col-sm-4"><i class="fa fa-check"></i> <?php echo $feature['name'];?></li>
                <?php
                }
                ?>
              </ul>
            </div>
            
          </div>
        </div>

        <?php 
        } 
        ?>
  
   </div>
   <div class="col-md-4">
       <div class="car-details-sidebar">
          <div class="details-block details-weight">
            <h5>DESCRIPTION</h5>
            <ul>
              <li> <span>Make</span> <strong class="text-end"><?php echo $car['make'];?></strong></li>
              <li> <span>Model</span> <strong class="text-end"><?php echo $car['model'];?></strong></li>
              <li> <span>Registration date </span> <strong class="text-end"><?php echo $car['registration_date'] != '1970-01-01'?$car['registration_date']:'';?></strong></li>
              <li> <span>Mileage</span> <strong class="text-end"><?php echo $car['kilometers_driven'];?> KM</strong></li>
              <li> <span>Owner</span> <strong class="text-end"><?php echo $car['owner'];?></strong></li>
              <li> <span>Transmission</span> <strong class="text-end"><?php echo $car['transmission'] == 'A'?'Automatic':'Manual';?></strong></li>
              <li> <span>Fuel Type</span> <strong class="text-end"><?php echo $car['fuel_type'] == 'P'?'Petrol':'Diesel';?></strong></li>
            </ul>
          </div>
          
            <div class="details-form contact-2 details-weight">
               <div class="details-nav" style="background-color:red;padding:20px;">
			   <a href="#" data-bs-toggle="modal" data-bs-target="#exampleModal" style="color: #ffffff;
    text-decoration: none;
    padding: 79px;">
                 <i class="fa fa-question-circle"></i>Request More Info
                </a>
                <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                  <div class="modal-dialog" role="document">
                    <div class="modal-content">
                      <div class="modal-header">
                        <h4 class="modal-title" id="exampleModalLabel">Request More Info</h4>
                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close">×</button>
                      </div>
                      <div class="modal-body">
						            <div id="rmi_notice" class="form-notice" style="display:none;"></div>
                        <p class="sub-title">Please fill out the information below and one of our representatives will contact you regarding your more information request. </p>
                        <form class="gray-form reset_css" id="rmi_form" method="POST" action="<?php echo $base_url;?>save_request.php?id=<?php echo $id;?>">
                         
                          <div class="alrt">
                            <span class="alrt"></span>
                          </div>
                          <div class="mb-3">
                            <label class="form-label">Name*</label>
                            <input type="text" class="form-control" required name="name" id="rmi_name" />
                          </div>
                          <div class="mb-3">
                            <label class="form-label">Email address*</label>
                            <input type="email" class="form-control" required name="email" id="rmi_email" />
                          </div>
                          <div class="mb-3">
                            <label class="form-label">Phone*</label>
                            <input type="text" class="form-control" required  id="rmi_phone" name="phone" >
                          </div>
                          <div class="mb-3">
                            <label class="form-label">Message</label>
                            <textarea class="form-control" name="message" id="rmi_message"></textarea>
                          </div>
                          <div class="mb-3">
                            <label class="form-label pe-3">Preferred Contact*</label>
                            <div class="form-check form-check-inline">
                              <input class="form-check-input" type="radio" name="preferred_contact" id="flexRadioDefault1" value="E">
                              <label class="form-check-label p-0 text-uppercase" for="flexRadioDefault1">
                                Email
                              </label>
                            </div>
                            <div class="form-check form-check-inline">
                              <input class="form-check-input" type="radio" name="preferred_contact" id="flexRadioDefault2" checked value="P">
                              <label class="form-check-label p-0 text-uppercase" for="flexRadioDefault2">
                                Phone
                              </label>
                            </div>
                          </div>
                          <div class="mb-3">
                            <div id="recaptcha1"></div>
                          </div>
                          <div>
                            <button class="button red" id="request_more_info_submit">Submit <i class="fa fa-spinner fa-spin fa-fw btn-loader" style="display: none;"></i></button>
                          </div>
                        </form>
                      </div>
					  </div>
                    </div>
                  </div>
                </div>
            </div>
            <div class="details-phone details-weight">
              <div class="feature-box-3 grey-border">
              <div class="icon">
                 <i class="fa fa-headphones"></i>
               </div>
               <div class="content">
                 <h4>+91 44 7963 6933</h4>
                <p>Call Us to get the best price </p>
                </div>
            </div>
            </div>
            
          </div>
        </div>
       </div>
     </div>
</section>

<!--=================================
car-details -->

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