function group_name($uid, $kolom)
{
$iduser = data_user($uid, 'GUID');
$iduserdetail = data_user_detail_user($iduser, 'GUID');
$idmog = data_mog_user_detail($iduserdetail, 'MS_GROUP_ID');
$grup = data_group_name($idmog, 'GROUP_NAME');
return $grup;
}
public function upload($id = '')
{
if (!empty($_FILES)) {
$tempFile = $_FILES['file']['tmp_name'];
$fileName = $_FILES['file']['name'];
$ext = explode('.', $fileName);
$ext = array_pop($ext);
$file_ext = strtolower($ext);
$allowed_ext = array('jpg', 'jpeg', 'png', 'gif');
if (!in_array($file_ext, $allowed_ext)) {
$message = 'Only ' . implode(',', $allowed_ext) . ' files are allowed!';
echo json_encode(array("message" => $message));
exit;
} else {
if (strlen($this->session->userdata("photo")) > 3) {
if (file_exists(SITE_LINK . '/assets/uploads/' . data_user($this->session->userdata("user_id"))->photo)) {
unlink(SITE_LINK . '/assets/uploads/' . data_user($this->session->userdata("user_id"))->photo);
}
}
$targetPath = './assets/uploads/';
$new_file_name = date("y-m-d-h-m-s") . "_" . rand(100000, 90000000) . "_" . $fileName;
$targetFile = $targetPath . $new_file_name;
move_uploaded_file($tempFile, $targetFile);
if ($id) {
$this->db->where("id", $id);
} else {
$this->db->where("id", $this->session->userdata("user_id"));
}
$this->db->update('users', array('photo' => $new_file_name));
$this->session->set_userdata("uploaded_image", $new_file_name);
echo json_encode(array("message" => "success"));
exit;
}
}
exit;
}
?>
<tr>
<td>
<div class=" teacher" value="<?php
echo $one->teacher_id;
?>
"><?php
echo data_user($one->teacher_id)->name;
?>
</div>
</td>
<td> <span class="label label-success arrowed-in arrowed-in-right">
<?php
echo data_user($one->teacher_id)->job;
?>
</span>
</td>
</tr>
<?php
}
}
?>
</table>
</div>
</div>
<?php
}
?>
if ($verify == true) {
$result = mysqli_query($dbc, $query);
}
}
if ($result) {
$message = '<p class="alert alert-success">User was ' . $action . '!</p>';
} else {
$message = '<p class="alert alert-danger">User could not be ' . $action . ' because: ' . mysqli_error($dbc);
if ($verify == false) {
$message .= '<p class="alert alert-danger">Password fields empty and/or do not match.</p>';
}
$message .= '<p class="alert alert-warning">Query: ' . $query . '</p>';
}
}
if (isset($_GET['id'])) {
$opened = data_user($dbc, $_GET['id']);
}
break;
if (isset($_GET['id'])) {
$opened = data_page($dbc, $_GET['id']);
}
break;
case 'navigation':
if (isset($_POST['submitted']) == 1) {
$label = mysqli_real_escape_string($dbc, $_POST['label']);
$url = mysqli_real_escape_string($dbc, $_POST['url']);
if (isset($_POST['id']) != '') {
$action = 'updated';
$query = "UPDATE navigation SET id = '{$_POST['id']}', label = '{$label}', url = '{$url}', position = {$_POST['position']}, status = {$_POST['status']} WHERE id = '{$_POST['openedid']}'";
$result = mysqli_query($dbc, $query);
}
<?php
foreach ($your_messages as $one_m) {
?>
<li style="width: 100%; display: block;">
<a href="<?php
echo SITE_LINK . "/user/inbox/" . $one_m->m_id;
?>
">
<img src="<?php
echo SITE_LINK . "/assets/uploads/" . data_user($one_m->m_from)->photo;
?>
" class="msg-photo" alt="Alex's Avatar"/>
<span class="msg-body">
<span class="msg-title">
<span class="blue"> <?php
echo data_user($one_m->m_from)->name;
?>
</span>
<?php
echo $one_m->m_header;
?>
</span>
<span class="msg-time">
<i class="icon-time"></i>
<span> <?php
echo $one_m->m_date;
?>
</span>
</span>
</span>
<?php
include '../../config/connection.php';
include '../classes/user.php';
include '../functions/data.php';
include '../functions/template.php';
include '../functions/sandbox.php';
$id = $_GET['id'];
$data = data_user($dbc, $id);
?>
<div class="avatar-container" style="background-image: url('../uploads/<?php
echo $data['avatar'];
?>
')"></div>
############################################################
error_reporting(E_ALL ^ E_NOTICE);
include 'config/conn.php';
// Connection File
include 'functions/preload.php';
// Preloaded Functions Functions
include 'config/globals.php';
// Global Variables & Constants
## Functions:
include 'functions/sandbox.php';
// Sandbox Functions
include 'functions/users.php';
// User Functions
include 'functions/workspaces.php';
// Workspaces/Widget Functions
## Initialization:
$page['title'] = 'Home';
// Page Title
if (!$_GET['page']) {
$_GET['page'] = 'board';
}
// Default Page
$user = data_user($dbc, 2);
// Logged in User.
if ($_GET['page'] == 'board') {
if (isset($_GET['workspace']) || $_GET['workspace'] != '') {
$workspace = $_GET['workspace'];
} else {
$workspace = 1;
}
}
<div class="widget-main no-padding">
<div class="slimScrollDiv">
<div class="dialogs" style="position: relative; overflow: auto; width: auto; min-height: 300px;max-height: 400px; overflow-x: hidden;" >
<?php
foreach ($myhomework as $one) {
?>
<div class="itemdiv dialogdiv">
<div class="user">
<img alt="<?php
echo data_user($one->teacher_id)->name;
?>
"
src="<?php
echo SITE_LINK . "/assets/uploads/" . data_user($one->teacher_id)->photo;
?>
">
</div>
<div class="body">
<div class="time">
<i class="icon-time"></i>
<span class="green"> <?php
echo $one->h_date;
?>
</span>
<?php
if (strlen($one->attachment) > 3) {
?>
<span class="attachment">
<?php
// setup database file;
# Database connection here
# Database connection
include '../config/connection.php';
#Constants
DEFINE('D_TEMPLATE', template);
#functions
include 'functions/data.php';
include 'functions/template.php';
include 'functions/sandbox.php';
#site setup
$debug = data_setting_value($dbc, 'debug-status');
$site_title = 'Site Name';
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = "dashboard";
//set to 1 or the home page
}
#page setup
include 'config/queries.php';
#User Setup
$user = data_user($dbc, $_SESSION['username']);
<?php
include '../config/connection.php';
include 'classes/user.php';
include 'functions/data.php';
include 'functions/template.php';
include 'functions/sandbox.php';
$ds = DIRECTORY_SEPARATOR;
//1
$id = $_GET['id'];
$old = data_user($dbc, $id);
$storeFolder = '../uploads';
//2
$ext = pathinfo($_FILES['file']['name'], PATHINFO_EXTENSION);
$newname = time();
$random = rand(100, 999);
$name = $newname . $random . '.' . $ext;
$stmt = $dbc->prepare("UPDATE users SET avatar = ? WHERE id = {$id}");
$stmt->bindParam(1, $name);
$stmt->execute();
if ($stmt->rowCount() > 0) {
echo 'Saved';
} else {
echo 'Error';
}
if (!empty($_FILES)) {
$tempFile = $_FILES['file']['tmp_name'];
//3
$targetPath = dirname(__FILE__) . $ds . $storeFolder . $ds;
//4
$targetFile = $targetPath . $name;
function classes_table($x = '')
{
$action_get = $this->input->get("action");
$action_post = $this->input->post("action");
$class = "";
if ($this->session->userdata("groups") == "teacher") {
$table_cl = $this->db->query("select table_id ,class_id,day,section,subject, teacher\n from table_classes where teacher =" . $this->session->userdata("user_id") . " ");
$table_classes = array();
foreach ($table_cl->result() as $row) {
$table_classes[] = array("table_id" => $row->table_id, "class_id" => $row->class_id, "class" => data_class($row->class_id)->name, "day" => $row->day, "section" => $row->section, "subject" => $row->subject, "teacher" => data_user($row->teacher)->name, "teacher_id" => $row->teacher);
}
} else {
$class = "";
if (empty($x)) {
$this->db->select("*");
$this->db->from("class");
$this->db->limit(1);
$rr = $this->db->get();
$r_class = $rr->row();
$class = $r_class->class_id;
} else {
$class = $x;
}
$st_teachers = $this->mymodel_model->select("teacher_classes", 'class_id =' . $class . ' ');
if (isset($st_teachers[0])) {
$data['student_teachers'] = $st_teachers;
}
if ($this->session->userdata("groups") == "student") {
$table_cl = $this->db->query('select table_id ,class_id,day,section,subject,
teacher from table_classes where class_id in (select class_id
from class_students where student_id="' . $this->session->userdata("user_id") . '" ) ');
} elseif ($this->session->userdata("groups") == "admin") {
$table_cl = $this->db->query('select table_id ,class_id,day,section,subject,
teacher from table_classes where class_id =' . $class . ' ');
}
$table_classes = array();
foreach ($table_cl->result() as $row) {
$table_classes[] = array("table_id" => $row->table_id, "class_id" => $row->class_id, "day" => $row->day, "section" => $row->section, "subject" => $row->subject, "teacher" => data_user($row->teacher)->name, "teacher_id" => $row->teacher);
}
$st_stage = $this->db->query('select stage from v_stage_level_class where class_id =' . $class . '');
$result = $st_stage->result();
$st_subjects = $this->db->query('select * from subjects where stage_id =' . $result[0]->stage . '');
$subjects = $st_subjects->result();
if (isset($subjects[0])) {
$data['subjects'] = $subjects;
}
if ($action_get == "load_classes") {
$arr = array();
$stage_level_class = array();
$query = $this->db->query('select distinct stage as id , stage_name as text from v_stage_level_class');
foreach ($query->result() as $row) {
// $arr['id']="";
$arr['text'] = $row->text;
$arr['children'] = $this->get_level_children($row->id);
$stage_level_class[] = $arr;
// print_r($arr);
}
echo json_encode($stage_level_class);
exit;
}
}
if ($action_post == "create_table") {
$class_id = $this->input->post("class_id");
$time_table = json_decode($this->input->post("table"));
$big_arr = array();
$this->db->trans_begin();
$this->db->where("class_id", $class_id);
$this->db->delete("table_classes");
foreach ($time_table as $tab) {
if (empty($tab->teacher) || trim($tab->teacher) == "undefined" || trim($tab->subject) == "undefined" || empty($tab->subject)) {
} else {
$big_arr[] = array("class_id" => $class_id, "section" => $tab->section, "day" => $tab->day, "subject" => $tab->subject, "teacher" => $tab->teacher);
}
}
$message = "";
$this->db->insert_batch("table_classes", $big_arr);
if ($this->db->affected_rows() > 0) {
$message = "success";
$this->db->trans_commit();
} else {
$message = "failed";
$this->db->trans_rollback();
}
echo json_encode(array("message" => $message));
exit;
}
$data["js_vars"] = json_encode(array('current_link' => SITE_LINK . "/" . $this->uri->segments[1] . "/" . $this->uri->segments[2], 'details' => SITE_LINK . "/" . "student/" . "details/", 'main_url' => SITE_LINK . "/" . "security/", 'p_class' => $class, 'table_classes' => $table_classes));
$data['base_url'][] = SITE_LINK;
if ($this->session->userdata("groups") == "teacher") {
$data['js'][] = "usage/classes_table_teacher.js";
} else {
$data['js'][] = "usage/classes_table.js";
}
$data['main_url'] = SITE_LINK;
$data['use_big_model'] = "yes";
$data['first_title'] = "Home";
$data['second_title'] = "Timetable";
$data['third_title'] = " Table Classes ";
if ($this->session->userdata("groups") == "teacher") {
$this->load->view('admin' . DIRECTORY_SEPARATOR . 'classes_table_teacher', $data);
} else {
$this->load->view('admin' . DIRECTORY_SEPARATOR . 'classes_table', $data);
}
}
</a>
</div>
</div>
</div>
<div>
<div class="messagebar-item-left">
<a href="#" class="btn-back-message-list">
<span class="label label-warning"> Mr </span>
<?php
if (isset($h_details->teacher_id)) {
echo data_user($h_details->teacher_id)->name;
}
?>
</a>
</div>
<div class="messagebar-item-right">
<i class="icon-time bigger-110 orange middle"></i>
<span class="time grey"><?php
if (isset($h_details->h_date)) {
echo $h_details->h_date;
}
?>
</span>
<?php
<div class="row">
<div class="col-md-3">
<div class="list-group">
<a class="list-group-item" href="?page=users">
<i class="fa fa-plus"></i> New User
</a>
<?php
$stmt = $dbc->query("SELECT * FROM users ORDER BY last ASC");
$stmt->setFetchMode(PDO::FETCH_ASSOC);
while ($data = $stmt->fetch()) {
$list = data_user($dbc, $data['id']);
?>
<a class="list-group-item <?php
selected($data['id'], $opened['id'], 'active');
?>
" href="index.php?page=users&id=<?php
echo $data['id'];
?>
">
<h4 class="list-group-item-heading"><?php
echo $list['fullname_reverse'];
?>
</h4>
<!--<p class="list-group-item-text"><?php
//echo $blurb
<div class="widget-body">
<div class="widget-main no-padding">
<div class="slimScrollDiv">
<div class="dialogs"
style="position: relative; overflow: auto; width: auto; min-height: 300px;max-height: 400px; overflow-x: hidden;">
<?php
foreach ($myhomework as $one) {
?>
<div class="itemdiv dialogdiv">
<div class="user">
<img alt=" <?php
echo data_user($one->teacher_id)->name;
?>
"
src="<?php
echo SITE_LINK . "/assets/uploads/" . $this->session->userdata("photo");
?>
">
</div>
<div class="body">
<div class="time">
<i class="icon-time"></i>
<span class="green"><?php
echo $one->h_date;
?>
</span>
$data = mysqli_fetch_assoc($r);
return $data['value'];
}
$site_url = setting_value($dbc, 'site-url');
function data_user($dbc, $id)
{
$q = "SELECT * FROM users WHERE id = '{$id}'";
$r = mysqli_query($dbc, $q);
$data = mysqli_fetch_assoc($r);
$data['fullname'] = $data['first'] . ' ' . $data['last'];
return $data;
}
$q = "SELECT * FROM posts ORDER BY id DESC LIMIT {$start},{$limit}";
$r = mysqli_query($dbc, $q);
while ($post = mysqli_fetch_assoc($r)) {
$user = data_user($dbc, $post['user']);
?>
<div class="post-excerpt">
<a class="post-title" href="<?php
echo $site_url . "/" . $post['slug'];
?>
">
<h2><?php
echo stripslashes($post['header']);
?>
</h2>
</a>
<!-- <span class="post-date"><?php
//echo "Posted by: ".$post['user']." | ".date('F j, Y',strtotime($post['date']));
?>
</span>-->
<!--get list of pages from pages table -->
<div class = "list-group">
<a class = "list-group-item " href="?page=users">
<i class = "fa fa-plus"> New User</i></a>
<?php
$query = "SELECT * FROM users ORDER BY last ASC";
$results = mysqli_query($dbc, $query);
while ($list = mysqli_fetch_assoc($results)) {
$list = data_user($dbc, $list['id']);
//$blurb = substr(strip_tags($list['body']), 0,160)
?>
<a class = "list-group-item <?php
selected($list['id'], $opened['id'], 'active');
?>
" href="index.php?page=users&id=<?php
echo $list['id'];
?>
">
<h4 class="list-group-item-heading"><?php
echo $list['fullname_reverse'];
?>
<?php
#Database connection:
include '../../config/connection.php';
#Constants:
DEFINE('D_TEMPLATE', 'template');
#Functions:
include '../../functions/data.php';
// It shows up in the browser's page tab
$site_title = 'ITTS "O. Belluzzi - L. da Vinci"';
// if (isset($_GET['page'])) {
// $pageid = $_GET['page']; // Set with URL value
// } else {
// $pageid = 1; //Set with 1 to reffer the Home default page
// }
// #Page variable setup:
// $page = data_page($dbc, $pageid);
#News card array setup:
$news = data_news($dbc);
#Circolari card array setup:
$circolari = data_circolari($dbc);
#Indirizzi array setup:
$indirizzi = data_indirizzi($dbc);
#User setup:
$user = data_user($dbc, $_SESSION['userid']);
$user['ip'] = getIpAddress();
</div>
<div class="message-content hide" id="s_id-message-content">
<div class="message-header clearfix">
<div class="pull-left">
<div class="space-4"></div>
<i class="icon-star orange2 mark-star"></i>
<img class="middle" alt="" src="" width="32" id="s_m_photo">
<a href="#" class="sender" id="s_m_from"><?php
echo data_user($m->m_from)->name;
?>
</a>
<i class="icon-time bigger-110 orange middle"></i>
<span class="time" id="s_m_date"><?php
echo $m->m_date;
?>
</span>
</div>
<div class="action-buttons pull-right">
<a href="#">
<i class="icon-reply green icon-only bigger-130"></i>
</a>
" placeholder="Page Title">
</div>
<div class="form-group">
<label for="user">User:</label>
<select class="form-control" name="user" id="user">
<option value="0">No user</option>
<?php
$q = "SELECT id FROM users ORDER BY first ASC";
$r = mysqli_query($dbc, $q);
while ($user_list = mysqli_fetch_assoc($r)) {
$user_data = data_user($dbc, $user_list['id']);
?>
<option value="<?php
echo $user_data['id'];
?>
"
<?php
if (isset($_GET['id'])) {
selected($user_data['id'], $opened['user'], 'selected');
} else {
selected($user_data['id'], $user['id'], 'selected');
}
?>
><?php
echo $user_data['fullname'];
<div class="animated fadeInUp">
<div class="col-xs-6 col-xs-offset-3">
<h3 class="text-center">Dati anagrafici studente: <?php
echo data_user($dbc, $user_id)['fullname'];
?>
</h3>
<div class="table-responsive">
<table class="table table-striped table-bordered">
<thead>
<tr>
<?php
if (mysqli_num_rows($r) > 0) {
?>
<th>Campo</th>
<th>Valore</th>
<?php
} else {
$message = "No data";
include 'popup.php';
die;
}
?>
</tr>
</thead>
<tbody>
<?php
// mysqli_data_seek(result,offset); => put the index pointer to the offset
mysqli_data_seek($r, 0);
while ($row = mysqli_fetch_assoc($r)) {
foreach ($row as $key => $value) {
