<?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); } }