search.php

<?php

session_start();

require_once("db.php");

$limit = 20;

if (isset($_GET["page"])) {
  $page = $_GET['page'];
} else {
  $page = 1;
}

$start_from = ($page - 1) * $limit;


if (isset($_GET['filter']) && $_GET['filter'] == 'city') {

  $sql = "SELECT * FROM company WHERE city='$_GET[search]'";

  $result = $conn->query($sql);
  if ($result->num_rows > 0) {
    while ($row1 = $result->fetch_assoc()) {
      $sql1 = "SELECT * FROM job_post WHERE id_company>='$row1[id_company]' LIMIT $start_from, $limit";
      $result1 = $conn->query($sql1);
      if ($result1->num_rows > 0) {
        while ($row = $result1->fetch_assoc()) {
?>

          <div class="attachment-block clearfix">
            <?php
            if ($row1['logo'] > 0) {
              $image = $row1['logo'];
            } else {
              $image = "2x2.jpg";
            }
            ?>
            <img class="attachment-img" src="uploads/logo/<?php echo $image; ?>" alt="Attachment Image">
            <div class="attachment-pushed">
              <h4 class="attachment-heading"><a href="view-job-post.php?id=<?php echo $row['id_jobpost']; ?>"><?php echo $row['jobtitle']; ?></a></h4>

              <div class="attachment-text" style="margin-top:5px;">
                <div>
                  <strong>
                    <?php echo $row1['companyname']; ?> | <?php echo $row1['city']; ?>, <?php echo $row1['state']; ?><br />
                    Experience <?php echo $row['experience']; ?> Years <br />
                  </strong>

                  <span class="attachment-heading pull-right" style="font-size:15px;"><i class="fa fa-calendar-check-o" aria-hidden="true"></i><em><strong> Till: </strong><?php echo date("F-d-Y", strtotime($row['applyBy'])); ?></em>
                </div>
              </div>

            </div>
          </div>

        <?php
        }
      }
    }
  }
} else {

  if (isset($_GET['filter']) && $_GET['filter'] == 'searchBar') {

    $search = $_GET['search'];
    $sql = "SELECT * FROM job_post INNER JOIN company ON job_post.id_company=company.id_company WHERE job_post.jobtitle LIKE '%$search%' OR job_post.jobtype LIKE '%$search%' OR company.city LIKE '%$search%' OR company.state LIKE '%$search%' LIMIT $start_from, $limit";
  } else if (isset($_GET['filter']) && $_GET['filter'] == 'experience') {

    $sql = "SELECT * FROM job_post WHERE experience = '$_GET[search]' LIMIT $start_from, $limit";
  }

  $result = $conn->query($sql);
  if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
      $sql1 = "SELECT * FROM company WHERE id_company='$row[id_company]'";
      $result1 = $conn->query($sql1);
      if ($result1->num_rows > 0) {
        while ($row1 = $result1->fetch_assoc()) {
        ?>

          <div class="attachment-block clearfix">
            <?php
            if ($row1['logo'] > 0) {
              $image = $row1['logo'];
            } else {
              $image = "2x2.jpg";
            }
            ?>
            <img class="attachment-img" src="uploads/logo/<?php echo $image; ?>" alt="Attachment Image">
            <div class="attachment-pushed">
              <h4 class="attachment-heading"><a href="view-job-post.php?id=<?php echo $row['id_jobpost']; ?>"><?php echo $row['jobtitle']; ?></a></h4>

              <div class="attachment-text" style="margin-top:5px;">
                <div>
                  <strong>
                    <?php echo $row1['companyname']; ?> | <?php echo $row1['city']; ?>, <?php echo $row1['state']; ?><br />
                    Experience <?php echo $row['experience']; ?> Years <br />
                  </strong>

                  <span class="attachment-heading pull-right" style="font-size:15px;"><i class="fa fa-calendar-check-o" aria-hidden="true"></i><em><strong> Till: </strong><?php echo date("F-d-Y", strtotime($row['applyBy'])); ?></em>
                </div>
              </div>

            </div>
          </div>

<?php
        }
      }
    }
  }
}




$conn->close();