}
require_once "../includes/funksionet.php";
$connection = krijo_lidhje();
elementi_selektuar();
//Ne kete rast kthen gjithmone degen e selektuar
?>
<?php
if (isset($_POST['1submit'])) {
$lenda = $_GET['lenda'];
$var = $lenda . "file";
$user = $_SESSION['id'];
$myFile = $_FILES["{$var}"]['name'];
$tmp = explode(".", $_FILES["{$var}"]["name"]);
$extension = end($tmp);
$date = date('Y-m-d H:i:s');
$path = $_SESSION['id'] . ";" . str_replace(":", "_", $date) . "." . $extension;
$path = str_replace(" ", ";", $path);
$size = $_FILES["{$var}"]["size"] / 1024 . "kB";
if (file_exists("documents/" . $path)) {
echo $path . " already exists. ";
} elseif (isset($myFile)) {
$sql = "INSERT INTO dokument(emer_dok, path_dok, date_dok, size_dok, dok_id_lenda, dok_id_user) \n\t\t\t\t\tVALUES ( '{$myFile}', '{$path}', '{$date}', '{$size}', '{$lenda}', '{$user}')";
$result = mysqli_query($connection, $sql);
konfirmo_query($result);
copy($_FILES["{$var}"]["tmp_name"], 'documents/' . $path);
if ($result > 0) {
header("location:index.php");
}
}
}
<?php
$dega_set = mysqli_query($connection, "SELECT * FROM dega");
konfirmo_query($dega_set);
while ($dega = mysqli_fetch_array($dega_set)) {
echo "<div id=\"shpallje_dega" . $dega['id_dega'] . "\" data-role=\"page\" data-title=\"Shpallje\">";
echo "<div data-role=\"header\" data-position=\"fixed\" data-id=\"un_header\">";
echo "<h1>Shpallje</h1>";
echo "<a href=\"#fq_fillim\" class=\"ui-btn-left\" data-icon=\"home\" data-iconpos=\"notext\"></a>";
echo "<a href=\"#profil\" data-rel=\"dialog\" class=\"ui-btn-right\">Profil</a>";
echo "</div>";
//--header
echo "<div data-role=\"content\">";
echo "<h3>" . utf8_encode($dega['emer_dega']) . "</h3>";
echo "<div data-role=\"collapsible-set\">";
$postim_set = mysqli_query($connection, "SELECT * FROM postim WHERE postim_id_dega = {$dega['id_dega']} ORDER BY postim_date DESC;");
konfirmo_query($postim_set);
while ($postim = mysqli_fetch_array($postim_set)) {
if ($postim['tipi'] == 1) {
echo "<div data-role=\"collapsible\">";
echo "<h3>" . utf8_encode($postim['postim_titull']) . "</h3>";
echo "<p>" . utf8_encode($postim['postim_text']) . "</p>";
echo "</div>";
}
}
echo "</div></div>";
//mbyllet content dhe collapsible-set
echo "<div data-role=\"footer\"\tdata-position=\"fixed\" data-id=\"un_footer\">";
echo "<div data-role=\"navbar\">";
echo "<ul>" . "<li><a href=\"#post_dega" . $dega['id_dega'] . "\" data-transition=\"flip\" data-role=\"button\" data-icon=\"grid\">Postime</a></li>" . "<li><a href=\"\" data-role=\"button\" data-icon=\"star\">Shpallje</a></li>" . "<li><a data-ajax=\"false\" href=\"fotot/index.php?dega=" . $dega['id_dega'] . "\" data-role=\"button\" data-icon=\"arrow-r\">Foto</a></li>" . "</ul>";
echo "</div></div>";
// mbyllja e navbar dhe footer
function mund_te_shpalle()
{
global $connection;
global $sel_uni;
global $sel_fak;
global $sel_dega;
if (!isset($_SESSION['id'])) {
return false;
} else {
$sql = "SELECT `id_user`, `roli`, `id_dega`, `id_fak`, `id_uni`\n\t\t\t\t\tFROM `user` \n\t\t\t\t\tINNER JOIN `dega` ON (`user`.`user_id_dega`=`dega`.`id_dega`)\n\t\t\t\t\tINNER JOIN `fakultet` ON (`dega`.`dega_id_fak`=`fakultet`.`id_fak`)\n\t\t\t\t\tINNER JOIN `universitet` ON (`fakultet`.`fak_id_uni`=`universitet`.`id_uni`)\n\t\t\t\t\tWHERE id_user={$_SESSION['id']};";
$user_set = mysqli_query($connection, $sql);
konfirmo_query($user_set);
$user = mysqli_fetch_array($user_set);
if ((isset($sel_uni) || isset($sel_fak) || isset($sel_dega)) && ($user['id_uni'] == $sel_uni['id_uni'] || $user['id_fak'] == $sel_fak['id_fak'] || $user['id_dega'] == $sel_dega['id_dega']) && $user['roli'] == 1) {
return true;
} else {
return false;
}
}
}
<hr/>
<div class="nentitull">Universitetet:</div>
<div class="universitet">
<?php
$uni_set = mysqli_query($connection, "SELECT * FROM universitet");
konfirmo_query($uni_set);
while ($uni = mysqli_fetch_array($uni_set)) {
echo "<div class= \"uni\"><img class=\"logo\" id=\"" . $uni['id_uni'] . "\" src=\"elements/" . $uni['logo_uni'] . "\"/>\n\t\t\t\t\t\t<a href=\"index.php?uni=" . urlencode($uni['id_uni']) . "\">\n\t\t\t\t\t\t" . $uni['emer_shkurt_uni'] . "</a></div>";
echo "<div id=\"fakultetet\" class=\"fakultet" . $uni['id_uni'] . "\">";
$fak_set = mysqli_query($connection, "SELECT * FROM fakultet WHERE fak_id_uni = {$uni['id_uni']}");
konfirmo_query($fak_set);
while ($fak = mysqli_fetch_array($fak_set)) {
echo "<div class=\"fak\"><img class=\"logo2\" id=\"" . $fak['id_fak'] . "\" src=\"elements/" . $fak['logo_fak'] . "\"/>\n\t\t\t\t\t\t\t<a href=\"index.php?fak=" . urlencode($fak['id_fak']) . "\">" . $fak['emer_shkurt_fak'] . "</a></div>";
echo "<div id=\"dega" . $fak['id_fak'] . "\" class=\"deget\">";
$dege_set = mysqli_query($connection, "SELECT * FROM dega WHERE dega_id_fak = {$fak['id_fak']}");
konfirmo_query($dege_set);
while ($dega = mysqli_fetch_array($dege_set)) {
echo "<div><a href=\"index.php?dega=" . urlencode($dega['id_dega']) . "\">{$dega['emer_dega']}</a></div>";
}
echo "</div>";
}
echo "</div>";
}
?>
</div>
</div>
</div>
<div id="kontent">
<?php
echo "<div id=\"subtitull\">";
if (!is_null($sel_uni)) {
</head>
<body>
<?php
$sql = "SELECT *\n\t\t\t\tFROM lenda \n\t\t\t\tWHERE lenda_id_dega={$sel_dega['id_dega']} \n\t\t\t\tORDER BY emer_lenda ASC";
$lenda_set = mysqli_query($connection, $sql);
konfirmo_query($lenda_set);
while ($lenda = mysqli_fetch_array($lenda_set)) {
echo "<hr /><hr />";
echo $lenda['emer_lenda'];
if (mund_te_postoje()) {
echo "<form name=\"{$lenda['id_lenda']}ngarkim\" action=\"upload.php?lenda={$lenda['id_lenda']}\" method=\"post\" enctype=\"multipart/form-data\">";
echo "<p>Posto nje file te ri</p>";
echo "Titulli <input name=\"titull\" type=\"text\"></input> ";
echo "<span class=\"pseudobuton\" id=\"{$lenda['id_lenda']}pseudobuton\" onclick=\"getFile(this.id)\">Zgjidh File</span><br />";
echo "<input id=\"{$lenda['id_lenda']}file\" name=\"{$lenda['id_lenda']}file\" type=\"file\" onchange=\"sub(this)\"></input>";
echo "Teksti <textarea name=\"text\" rows=\"5\" cols=\"50\"></textarea>";
echo "<input id=\"button\" name=\"{$lenda['id_lenda']}submit\" type=\"submit\" value=\"Ngarko\" style='padding:1px;'>";
echo "</form><hr />";
}
$sql = "SELECT *\n\t\t\t\t\tFROM dokument\n\t\t\t\t\tWHERE dok_id_lenda={$lenda['id_lenda']}";
$dok_set = mysqli_query($connection, $sql);
konfirmo_query($dok_set);
echo "<table>";
while ($dok = mysqli_fetch_array($dok_set)) {
echo "<tr>\n\t\t\t\t\t<td>{$dok['emer_dok']}</td>\n\t\t\t\t\t<td>{$dok['date_dok']}</td>\n\t\t\t\t\t<td>{$dok['size_dok']}</td>\n\t\t\t\t\t</tr>";
}
echo "</table>";
}
?>
</body>
echo "<div class=\"thumbnail_container\">";
//shfaqen fotot fakultetit te selektuar bashke me fotot e degeve te tij
$query = "SELECT `foto`.*\n \t\t\t\t, `fakultet`.`id_fak`\n \t\t\t\t, `dega`.`emer_dega`\n\t\t\t\tFROM `rrjet_social_db`.`dega`\n \t\t\tRIGHT JOIN `rrjet_social_db`.`fakultet` \n \t\tON (`dega`.`dega_id_fak` = `fakultet`.`id_fak`)\n \t\t\tRIGHT JOIN `rrjet_social_db`.`foto` \n \t\tON (`foto`.`foto_id_dega` = `dega`.`id_dega`)\n \t\tWHERE `fakultet`.`id_fak`={$sel_fak['id_fak']} OR `foto`.`foto_id_fak`={$sel_fak['id_fak']};";
$foto_set = mysqli_query($connection, $query);
konfirmo_query($foto_set);
while ($foto = mysqli_fetch_array($foto_set)) {
echo "<a class=\"thumbnail\" title=\"{$foto['pershkrim_foto']}\" href=\"foto/" . $foto['path_foto'] . "\" \n\t\t\tdata-keywords=\"{$foto['emer_dega']}\">\n\t\t\t<img src=\"foto/thumb/" . $foto['path_foto'] . "\"/></a>";
}
}
//mbyllet if(!is_null($sel_fak))
if (!is_null($sel_dega)) {
echo "<div href=\"index.php?dega={$sel_dega['id_dega']}\" class=\"title\">{$sel_dega['emer_dega']}</div>";
echo "<div class=\"photos\">";
echo "<div class=\"thumbnail_container\">";
//shfaqen te gjitha fotot e nje dege
$query = "SELECT `foto`.*\n\t\t\t\tFROM `rrjet_social_db`.`foto`\n \t\t\tINNER JOIN `rrjet_social_db`.`dega` \n \t\tON (`foto`.`foto_id_dega` = `dega`.`id_dega`)\n\t\t\t\tWHERE `dega`.`id_dega` = {$sel_dega['id_dega']};";
$foto_set = mysqli_query($connection, $query);
konfirmo_query($foto_set);
while ($foto = mysqli_fetch_array($foto_set)) {
echo "<a class=\"thumbnail\" title=\"{$foto['pershkrim_foto']}\" href=\"foto/" . $foto['path_foto'] . "\">\n\t\t\t<img src=\"foto/thumb/" . $foto['path_foto'] . "\"/></a>";
}
}
//mbyllet if(!is_null($sel_dega))
?>
</div>
</div>
</div>
</body>
</html>
<?php
mbyll_lidhjen();
if (isset($_POST['pershkrim']) && jo_bosh($_POST['pershkrim'])) {
$pershkrim = $_POST['pershkrim'];
}
$select_uni = "NULL";
$select_fak = "NULL";
$select_dega = "NULL";
if (isset($_GET['uni'])) {
$select_uni = $_GET['uni'];
} else {
if (isset($_GET['fak'])) {
$select_fak = $_GET['fak'];
} else {
if (isset($_GET['dega'])) {
$select_dega = $_GET['dega'];
}
}
}
$data = date("Y-m-d H:i:s");
$query = "insert into foto(foto_id_user, foto_datetime, path_foto, foto_id_uni, foto_id_fak, foto_id_dega, pershkrim_foto) \n\t\t\tvalues ( " . $_SESSION['id'] . ", '" . $data . "', '" . $newFileName . "', " . $select_uni . ", " . $select_fak . ", " . $select_dega . ", '" . $pershkrim . "' );";
echo $query;
$res = mysqli_query($connection, $query);
konfirmo_query($res);
copy($_FILES['fileField']['tmp_name'], 'foto/' . $newFileName);
$src = "foto/" . $newFileName;
$dest = "foto/thumb/" . $newFileName;
krijo_thumb($src, $dest, 75);
if ($res > 0) {
header("location:upload_file.php?mesazh=1");
}
}
}
