Untitled

<?php
  @include 'config.php';

  session_start();

  if(isset($_POST['submit'])){
    $sort_by = $_POST['sort_by'];
    $sort_type = $_POST['sort_type'];
    $queryItems = "SELECT brand, model, make_year, power, engine_type, price, vehicle_type, main_image_source, mileage, id FROM motorcycles ORDER BY $sort_by $sort_type";
  }
  else{
    $queryItems = "SELECT brand, model, make_year, power, engine_type, price, vehicle_type, main_image_source, mileage, id FROM motorcycles ORDER BY id DESC";
  }

  $result = mysqli_query($conn, $queryItems);

  ?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">
    <link href="https://fonts.googleapis.com/css?family=Poppins:100,200,300,400,500,600,700,800,900&display=swap" rel="stylesheet">
    <title>PHPJabbers.com | Free Car Dealer Website Template</title>
    <!-- Bootstrap core CSS -->
    <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
    <!-- Additional CSS Files -->
    <link rel="stylesheet" href="assets/css/fontawesome.css">
    <link rel="stylesheet" href="assets/css/style.css">
    <link rel="stylesheet" href="assets/css/owl.css">
  </head>
  <body>
    <!-- ***** Preloader Start ***** -->
    <div id="preloader">
      <div class="jumper">
        <div></div>
        <div></div>
        <div></div>
      </div>
    </div>
    <!-- ***** Preloader End ***** -->
    <!-- Header -->
    <?php include($header); ?>
    <!-- Page Content -->
    <!-- Banner Starts Here -->
    <div class="main-banner header-text" id="top">
      <div class="Modern-Slider">
        <!-- Item -->
        <div class="item item-1">
          <div class="img-fill">
            <div class="text-content">
              <h6>The latest motorcycles</h6>
              <h4>Be ready to make <br> your dreams come true</h4>
              <p></p>
            </div>
          </div>
        </div>
        <!-- // Item -->
        <!-- Item -->
        <div class="item item-2">
          <div class="img-fill">
            <div class="text-content">
              <h6>Get in touch</h6>
              <h4>We are ready<br>  to answer your questions</h4>
              <p>Don't hesitate, go to our contact page</p>
              <a href="contact.php" class="filled-button">Contact Us</a>
            </div>
          </div>
        </div>
        <!-- // Item -->
      </div>
    </div>
    <!-- Banner Ends Here -->
    <div class="services">
      <div class="container">
        <form action="" method="POST">
          <div class="row">
            <div class="col-lg-2 col-md-4 col-sm-6 col-xs-12 offset-lg-4">
              <div class="form-group">
                <label>Sort by:</label>
                <select class="form-control" name="sort_by">
                  <option value="brand">Brand</option>
                  <option value="make_year">Year</option>
                  <option value="power">Power</option>
                  <option value="price">Price</option>
                  <option value="mileage">Mileage</option>
                </select>
              </div>
            </div>
            <div class="col-lg-2 col-md-4 col-sm-6 col-xs-12 ">
              <div class="form-group">
                <label>Type:</label>
                <select class="form-control" name="sort_type">
                  <option value="ASC">Ascending</option>
                  <option value="DESC">Descending</option>
                </select>
              </div>
            </div>
          </div>
          <div class="row">
            <div class="col-sm-4 offset-sm-4">
              <div class="main-button text-center">
                <button type="submit" name="submit">Sort</button>
              </div>
            </div>
          </div>
        </form>
        <div class="row">
          <div class="col-md-12">
            <div class="section-heading">
              <h2>Featured <em>Motorcycles</em></h2>
              <span>View all the listings</span>
            </div>
          </div>
          <?php
            while($row = $result -> fetch_row()){

            ?>
          <div class="col-md-4">
            <div class="service-item">
              <img src="assets/listings_images/<?php echo $row[7]?>" alt="">
              <div class="down-content">
                <h4> <?php echo $row[0].'<span>'.$row[1].'</span>';?> </h4>
                <div style="margin-bottom:10px;">
                  <span>
                  <?php echo $row[5]?>lv.
                  </span>
                </div>
                <p>
                  <i class="fa fa-dashboard"></i> <?php echo $row[8]?>km &nbsp;&nbsp;&nbsp;
                  <i class="fa fa-calendar"></i>&nbsp;&nbsp;<?php echo $row[2]?>&nbsp;&nbsp;&nbsp;
                  <i class="fa fa-cog"></i> <?php echo $row[4]?> strokes &nbsp;&nbsp;&nbsp;<br>
                  <i class="fa fa-tachometer"></i>  <?php echo $row[3]?>HP&nbsp;&nbsp;&nbsp;
                  <i class="fa fa-motorcycle"></i> <?php echo $row[6]?> &nbsp;&nbsp;&nbsp;
                </p>
                <a href="car-details.php?id=<?php echo $row[9]?>" class="filled-button">View More</a>
                <?php if(isset($_SESSION['admin_name'])){
                  echo
                  ' <a href="edit.php?id='.$row[9].'" class="filled-button">Edit</a>';
                  }?>
              </div>
            </div>
          </div>
          <?php }?>
        </div>
      </div>
    </div>
    <div class="fun-facts">
      <div class="container">
        <div class="more-info-content">
          <div class="row">
            <div class="col-md-6">
              <div class="left-image">
                <img src="assets/images/about-1-570x350.jpg" class="img-fluid" alt="">
              </div>
            </div>
            <div class="col-md-6 align-self-center">
              <div class="right-content">
                <h2>We are <em>hiring!</em></h2>
                <h3>Join the motorcycle family now!</h3>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
    <div class="more-info">
      <div class="container">
        <div class="section-heading">
          <h2>Прочетете последните<em> новини</em></h2>
        </div>
        <div class="row" id="tabs">
          <div class="col-md-4">
            <ul>
              <li><a href='#tabs-1'>Мотоциклетно изложение в София: Любителите ще видят нови мотори и екипировка<br> <small>Александър Николов &nbsp;|&nbsp; 27.04.2022 10:10</small></a></li>
              <li><a href='#tabs-2'>Традиционното откриване на мотосезона в пловдив ще се проведе навръх ... <br> <small>Александър Николов &nbsp;|&nbsp; 21.04.2022 12:20</small></a></li>
            </ul>
            <br>
            <br>
          </div>
          <div class="col-md-8">
            <section class='tabs-content'>
              <article id='tabs-1'>
                <img src="assets/images/991-ratio-motor.jpg" alt="">
                <h4><a href="blog-details.html">В края на март официално беше открит Мото сезон 2022.</a></h4>
                <p>След края на зимата, любителите на високите скорости на две гуми, са щастливи от факта, че сезонът е открит, а сега ще могат да видят и последните новости при моторите и екипировката на мотоциклетното изложение в София. Такова ще има, след като поради пандемията, то бе отлагано цели две години. </p>
              </article>
              <article id='tabs-2'>
                <img src="assets/images/mnogo-muzika-rev-motori-i-atraktivno-527.jpg" alt="">
                <h4><a href="blog-details.html">Традиционното разкриване на мотосезона в Пловдив ще се организира точно на Първа пролет.</a></h4>
                <p> След двугодишна пауза, феновете на моторите под тепетата още веднъж ще се съберат, за обичайно шествие из пловдивските улици. Тази година мероприятието ще премине под наслов: " Нека бъдем толерантни на пътя!!! "</p>
              </article>
            </section>
          </div>
        </div>
      </div>
    </div>
    </div>
    <!-- Footer Starts Here -->
    <?php include($footer); ?>
  </body>
</html>