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) {