<div id="frontpage-location-listing">
<div class="row">
<div class="col-md-12">
<h3>Recent technical skills on offer</h3>
<table class="table table-striped table-condensed table-list" id="list_main">
</table>
<!-- Larger pagination -->
<ul class="pagination pull-right">
<?php
require "globals.php";
require "lib.php";
$total_pages = get_page_no($con, $config["listings"]["per_page"], $_GET["q"]);
$page_no = $_GET["p"];
$query = urlencode($_GET["q"]);
$pagination_links = 5;
if (!is_numeric($page_no)) {
$page_no = 1;
} else {
if ($page_no > $total_pages) {
$page_no = 1;
}
if ($page_no < 1) {
$page_no = 1;
}
}
echo '<input id="current_page" type="hidden" value="' . $page_no . '">';
echo '<ul class="pagination pull-right">';
break;
case "list":
//Get listings.
$per_page_unsafe = $config["listings"]["per_page"];
$per_page = mysql_real_escape_string($per_page_unsafe);
$query = $_GET["q"];
$query_unsafe = $_GET["q"];
if (!empty($query)) {
$query = mysql_real_escape_string(strtolower($query));
$where = "AND `sell_skill` LIKE '%{$query}%'";
} else {
$where = "";
}
//Pagination.
$page_no = $_POST["p"];
$total_pages = get_page_no($con, $per_page, $query_unsafe);
if (empty($page_no)) {
$page_no = 1;
}
if (!is_numeric($page_no)) {
$page_no = 1;
}
if ($page_no > $total_pages) {
$page_no = 1;
}
if ($page_no < 1) {
$page_no = 1;
}
$start = ($page_no - 1) * $per_page;
$start = mysql_real_escape_string($start);
$sql = "SELECT * FROM `listings` WHERE `visible`=1 {$where} ORDER BY `timestamp` DESC LIMIT {$start},{$per_page}";
