PHP databaseAPI 예제들

예제 #1

파일: manageForums.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

        <?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'];
}

예제 #2

파일: exercisesAdmin.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

		<?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
}

예제 #3

파일: discussion.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

        <?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);

예제 #4

파일: index.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

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

예제 #5

파일: admin.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

<?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 = ?';

예제 #6

파일: demoVideos.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

    <?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;

예제 #7

파일: signup.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

<!--
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;
    }

예제 #8

파일: forums.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

<?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'));

예제 #9

파일: students.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

<?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'])) {

예제 #10

파일: instructors.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

    <?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'];

예제 #11

파일: exercise.php 프로젝트: EFRIEM-DESALEW/Interactive-Laboratory-System

<?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'];
}