<?php
$title = 'Университет';
include '/includes/headerout.php';
$id = $_GET['name'];
data_from_users($id, $con);
$stm = $con->prepare("SELECT date, date_name, date_descript FROM imp_dates WHERE user_id='" . $id . "' AND is_active=1 ORDER BY date ASC");
view_imp_dates($stm);
$stm = $con->prepare("SELECT note_txt FROM imp_notes WHERE user_id='" . $id . "' AND is_active=1");
view_imp_notes($stm);
$k = "";
if (!isset($_GET['sort'])) {
$_GET['sort'] = 1;
}
$sort = sortit($_GET['sort']);
$page = data_for_userspec($id, $con, $sort);
if (isset($_GET['k'])) {
$k = $_GET['k'];
$query = "SELECT spec_id, spec_name, tax, durt, last_date FROM spec_list WHERE user_id=" . $id . " AND is_active=1 AND (";
$searchcol = "spec_name";
$page = search_spec_out($query, $searchcol, $con);
}
/* if (isset($_GET['name'])) {
$page = data_from_name($con);
} */
/* if (isset($_GET['k'])) {
$id = ">0";
$page = search_spec_in($con, $id, 'unipage.php');
$val = $_GET['k'];
} */
?>
function search_spec_out($query, $searchcol, $con)
{
$k = $_GET['k'];
$terms = explode(" ", $k);
foreach ($terms as $each) {
$j = 0;
$j++;
if ($j == 1) {
$query .= $searchcol . " LIKE '%{$each}%' ";
} else {
$query .= "OR " . $searchcol . " LIKE '%{$each}%' ";
}
}
$query .= sortit($_GET["sort"]);
$stm = $con->prepare($query);
if ($stm) {
$stm->execute();
$res = $stm->get_result();
$numrows = mysqli_num_rows($res);
global $specuni_data, $i;
$i = 0;
if ($numrows < 1) {
error($con);
$specuni_data[$i] = "<tr><td colspan='4'>Няма намерени резултати.</td></tr>";
$p = 0;
return $p;
}
while ($row = $res->fetch_assoc()) {
$p = (int) ($i / 20 + 1);
$specuni_data[$i] = '<tr class="c a' . $p . '"><td><a href="/page.php?name=' . $row["spec_id"] . '" target="_blank">' . $row["spec_name"] . '</a></td><td>' . $row["tax"] . '</td><td>' . $row["durt"] . ' Семестъра</td><td>' . $row["last_date"] . '</td></tr>';
$i++;
}
$p++;
return $p;
} else {
error($con);
}
}
