<?php //Including database.php File From includes/database Directory require_once '../includes/database/dbconfig.php'; if (!$user->is_loggedin()) { $user->redirect('index.php?page=login'); } require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; //Connecting to the Database $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $api = new databaseAPI(); $page = null; $forumId = null; $pageType = null; $deleted = false; $suspended = false; $valid = true; $forum = null; //Getting $page From Global _GET Variable if (!empty($_GET['page'])) { $page = $_REQUEST['page']; } //Getting forum from global $_GET variable if (!empty($_GET['forum'])) { $forum = $_REQUEST['forum']; } //Getting $forumId From Global _GET Variable if (!empty($_GET['forumId'])) { $forumId = $_REQUEST['forumId']; }
<?php //Including database.php File From includes/database Directory require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; //Connecting To The Database $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $api = new databaseAPI(); $page = null; //getting $page from global _GET Variable if (!empty($_GET['page'])) { $page = $_REQUEST['page']; //Reading the page variable form global GET } //Getting $startrow from Global _GET Variable if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) { $startrow = 0; } else { $startrow = (int) $_GET['startrow']; } //Fetching all new Exercises from database if ($page == "new") { $sql = 'SELECT * FROM Exercises where Exercise_Status = ?'; $q = $pdo->prepare($sql); $q->execute(array('New')); $sql1 = 'SELECT * FROM Exercises where Exercise_Status = "New" LIMIT ' . $startrow . ', 5'; $data = $q->fetch(PDO::FETCH_ASSOC); //converting the fetched data into associated array $count = $q->rowCount(); //counting the number of fetched rows }
<?php //Including databse.php file from includes/database directory require_once '../includes/database/dbconfig.php'; if (!$user->is_loggedin()) { $user->redirect('index.php?page=login'); } require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; //Connecting to the database $pdo = Database::connect(); $api = new databaseAPI(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $page = null; $type = null; $discussionNo = null; //Getting $startrow from gloabl _GET variable if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) { $startrow = 0; $sql = 'SELECT * FROM Lab_Discussion_Topics where Topic_Status = ?'; $q = $pdo->prepare($sql); $q->execute(array('Accepted')); $sql1 = 'SELECT * FROM Lab_Discussion_Topics where Topic_Status = "Accepted" LIMIT ' . $startrow . ', 5'; $data = $q->fetch(PDO::FETCH_ASSOC); $count = $q->rowCount(); } else { $startrow = (int) $_GET['startrow']; $sql = 'SELECT * FROM Lab_Discussion_Topics where Topic_Status = ?'; $q = $pdo->prepare($sql); $q->execute(array('Accepted')); $sql1 = 'SELECT * FROM Lab_Discussion_Topics where Topic_Status = "Accepted" LIMIT ' . $startrow . ', 5'; $data = $q->fetch(PDO::FETCH_ASSOC);
<?php require_once '../includes/database/dbconfig.php'; require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; //Connecting to the database $pdo = Database::connect(); $api = new databaseAPI(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $page = null; $message = null; //Getting $page from global $_GET variable if (!empty($_GET['page'])) { $page = $_REQUEST['page']; } //Getting post Variables if (!empty($_POST)) { $userName = trim($_POST['username']); $password = trim($_POST['password']); if ($user->login($userName, $password) == 1) { if ($api->User_Status($userName, $pdo) == "Confirmed") { if ($api->User_Type_Using_User_Id($api->User_Id($userName, $pdo), $pdo) == "Student") { $user->redirect("students.php?page=labs"); } else { $user->redirect("instructors.php?page=new"); } } else { unset($_SESSION['user_session']); $message = "This account is blocked."; } } else {
<?php include '../includes/database/database.php'; include "../includes/layouts/header.php"; require '../includes/functions/databaseFunctions.php'; //connecting database $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $api = new databaseAPI(); $page = null; $message = null; $id = null; //getting $startrow from global $_GET variable if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) { $startrow = 0; } else { $startrow = (int) $_GET['startrow']; } //getting $page from global $_GET variable if (!empty($_GET['page'])) { $page = $_REQUEST['page']; } //getting $id from global $_GET variable if (!empty($_GET['User_Id'])) { $id = $_REQUEST['User_Id']; } //getting $message from gloabl $_GET variable if (!empty($_GET['message'])) { $message = $_REQUEST['message']; } $sql = 'SELECT * FROM Registered_Users where User_Status = ?';
<?php //Including database.php File From includes/database Directory require_once '../includes/database/dbconfig.php'; if (!$user->is_loggedin()) { $user->redirect('index.php?page=login'); } require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; //Connecting to the Database $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $api = new databaseAPI(); $currentVideoNo = null; if (!empty($_GET['currentVideoNo'])) { $currentVideoNo = $_REQUEST['currentVideoNo']; $sql1 = "SELECT * FROM Videos WHERE Video_No = ?"; $q1 = $pdo->prepare($sql1); $q1->execute(array($currentVideoNo)); $currentVideo = $q1->fetch(PDO::FETCH_ASSOC); } else { $sql1 = "SELECT * FROM Videos"; $q1 = $pdo->prepare($sql1); $q1->execute(); $currentVideo = $q1->fetch(PDO::FETCH_ASSOC); } $sql = "SELECT * FROM Videos"; //Getting Values From Global $_POST Variable if (!empty($_POST)) { $valid = true; if (empty(trim($_POST['comment']))) { $valid = false;
<!-- By Efriem Desalew --> <?php require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; //Connecting to the database $pdo = Database::connect(); $api = new databaseAPI(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $message = null; if (!empty($_POST)) { // keep track validation errors $userNameError = null; $iDError = null; $passwordError = null; // keep track post values $userName = trim($_POST['userName']); $iD = trim($_POST['iD']); $password = trim($_POST['password']); $cPassword = trim($_POST['cPassword']); // validate input $valid = true; if (empty($userName)) { $userNameError = 'Please enter User Name'; $valid = false; } if (empty($iD)) { $iDError = 'Please enter ID'; $valid = false; }
<?php //Including databse.php file from includes/database directory require_once '../includes/database/dbconfig.php'; if (!$user->is_loggedin()) { $user->redirect('index.php?page=login'); } require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; //Connecting to the database $pdo = Database::connect(); $api = new databaseAPI(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $forumNo = null; //Getting $page From Global _GET Variable if (!empty($_GET['forumNo'])) { $forumNo = $_REQUEST['forumNo']; } if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) { $startrow = 0; $sql = 'SELECT * FROM Forums where Forum_Status = ?'; $q = $pdo->prepare($sql); $q->execute(array('Confirmed')); $sql1 = 'SELECT * FROM Forums where Forum_Status = "Confirmed" LIMIT ' . $startrow . ', 5'; $data = $q->fetch(PDO::FETCH_ASSOC); $count = $q->rowCount(); } else { $startrow = (int) $_GET['startrow']; $sql = 'SELECT * FROM Forums where Forum_Status = ?'; $q = $pdo->prepare($sql); $q->execute(array('Accepted'));
<?php require_once '../includes/database/dbconfig.php'; if (!$user->is_loggedin()) { $user->redirect('index.php?page=login'); } //Including databse.php file from includes/database directory require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; //Connecting to the database $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $api = new databaseAPI(); $page = null; $labNo = null; $valid = true; $message = null; //Getting $page From Global _GET Variable if (!empty($_GET['page'])) { $page = $_REQUEST['page']; } //Getting $message from global $_GET variable if (!empty($_GET['message'])) { $message = $_REQUEST['message']; } //Getting $labNo from Global _GET variable if (!empty($_GET['labNo'])) { $labNo = $_REQUEST['labNo']; } //Getting $startrow From Global _GET Variable if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
<?php //Including database.php File From includes/database Directory require_once '../includes/database/dbconfig.php'; if (!$user->is_loggedin()) { $user->redirect('index.php?page=login'); } require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; $pdo = Database::connect(); //Connecting to the database $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $api = new databaseAPI(); $page = null; $valid = true; $uploadVideo = null; $labNo = null; $lab = null; $report = null; //Getting $page From Global _GET Variable if (!empty($_GET['page'])) { $page = $_REQUEST['page']; //Reading the page variable form global GET } //Getting $report if (!empty($_GET['report'])) { $report = $_REQUEST['report']; //Reading the page variable form global GET } //getting $labNo from global $_GET variable if (!empty($_GET['labNo'])) { $labNo = $_REQUEST['labNo'];
<?php //Including database.php File From includes/database Directory require_once '../includes/database/dbconfig.php'; if (!$user->is_loggedin()) { $user->redirect('index.php?page=login'); } require '../includes/database/database.php'; require '../includes/functions/databaseFunctions.php'; $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $api = new databaseAPI(); $page = null; $labNo = null; $valid = true; $message = null; $addNew = null; $successMessage = null; //Getting $page From Global _GET Variable if (!empty($_GET['page'])) { $page = $_REQUEST['page']; //Reading the page variable form global GET } //Getting $addNew From Global _GET Variable if (!empty($_GET['addNew'])) { $addNew = $_REQUEST['addNew']; } //Getting $labNo From Global _GET Variable if (!empty($_GET['labNo'])) { $labNo = $_REQUEST['labNo']; }