function CheckLogin($login)
{
$err;
if (strlen($login) < 3) {
$err .= "Niks nedrīkst būt mazāks par 3 simboliem\n";
}
if (strlen($login) > 25) {
$err .= "Niks nedrīkst būt lielāks par 25 simboliem\n";
}
$link = DBConnect::GetConnection();
$sql = "SELECT * FROM users WHERE `login`='{$login}'";
$result = $link->query($sql);
if ($result->num_rows > 0) {
$err .= "Niks jau ir aizņemts";
}
mysqli_close($link);
return $err;
}
<?php
session_start();
require_once "../system.php";
User::CheckLogin();
$id = $_SESSION["id"];
$link = DBConnect::GetConnection();
$sql = "SELECT * FROM users WHERE `id`='{$id}'";
$result = $link->query($sql);
$row = $result->fetch_array(MYSQLI_ASSOC);
?>
<section>
<h1 class="win-h1">Čau, <?php
echo $row["vards"] . " " . $row["uzvards"];
?>
<a class="logoff" href="Content/logoff.php">(Iziet)</a></h1>
<h2 class="win-h3">Tavi dati</h2>
<address>
<p>Tavs niks ir <?php
echo $row["login"];
?>
</p>
<p>Tavs tālrunis ir <?php
echo $row["talrunis"];
?>
</p>
<p>Tavs e-pasts ir <?php
echo $row["epasts"];
?>
</p>
</address>
public function RegisterUserModules()
{
$link = DBConnect::GetConnection();
$sql = "SELECT * FROM modules";
$result = $link->query($sql);
while ($row = $result->fetch_assoc()) {
$name = $row["name"];
$url = "Content/page.php?name=" . $row["name"];
$fn = $row["friendly_name"];
$icon = $row["icon"];
$gv = (bool) $row["guest_visible"] ? true : false;
$uv = true;
$system = false;
$editable = true;
$mod = new Module($url, $name, $fn, $icon, $gv, $uv, $system, $editable);
$this->menu[] = $mod;
}
mysqli_close($link);
}
