/** * @param bool|int $id */ public function RefreshIngredients($id = false) { $result = array(); $condition = $id ? "AND tblIngredients.id = " . (int) $id : false; $queryString = "SELECT * FROM tblIngredients WHERE userID = {$this->ID} {$condition}"; $query = $this->DB->Query($queryString); if ($query) { while ($row = $query->Fetch()) { $ingredient = array_key_exists($row['id'], $this->Ingredients) ? $this->Ingredients[$row['id']] : new Ingredient($this, $row); $result[$ingredient->ID] = $ingredient; } } $this->Ingredients = $result; }
<?php require_once "../inc/initialize.php"; //checks if admin user is logged in if (!$session->is_admin_logged_in()) { redirect_to('index.php'); } $role = $_SESSION["role"]; if ($role == 4) { $db = new MySQLDatabase(); $sql = "SELECT `department_name` from `department` WHERE `department_id` = '" . $_SESSION["department_id"] . "'"; $dept = $db->Query($sql); $dept = $db->fetch_array($dept); $dept = array_shift($dept); } function privilege() { global $role; switch ($role) { case 1: $msg = "Main Administrative"; break; case 2: $msg = "Post Graduate Administrative"; break; case 3: $msg = "Non NUC Administrative"; break; case 4: $msg = "Departmental Administrative"; break;
/** @return bool */ public function UpdateDatabase() { $queryString = "\n UPDATE tblBars\n SET\n `type` = " . $this->DB->Quote($this->Type) . "\n , `title` = " . $this->DB->Quote($this->Title) . "\n , `description` = " . $this->DB->Quote($this->Description) . "\n , `modifyStamp` = " . microtime(true) . "\n WHERE id = " . (int) $this->ID . " AND userID = " . (int) $this->Session->ID . "\n "; return (bool) $this->DB->Query($queryString); }
/* * All this crap switches the environment to run from the testing database and session pool. * Pass in /reset, and the database and sessions will be cleared, and a default user will be created. * * Magic! */ $dbCredentials = 'UnitTestDBCredentials'; if (!file_exists(UNITTESTSESSIONPATH)) { mkdir(UNITTESTSESSIONPATH); } session_save_path(UNITTESTSESSIONPATH); if (isset($Path[0]) && $Path[0] == 'reset') { $rm = "rm " . UNITTESTSESSIONPATH . "*"; $rm = `{$rm}`; $db = new MySQLDatabase('UnitTestDBCredentials'); $tables = $db->Query("\n\t\tSELECT table_name AS `table`\n\t\tFROM information_schema.tables\n\t\tWHERE table_schema = " . $db->Quote($UnitTestDBCredentials['name']) . ";\n\t"); singleLog($tables); if ($tables) { $db->Query("SET FOREIGN_KEY_CHECKS = 0;"); while ($table = $tables->Fetch()) { singleLog($db->Query("DROP TABLE IF EXISTS " . $table['table'] . ";")); } $db->Query("SET FOREIGN_KEY_CHECKS = 1;"); } $dump = "mysqldump -u " . $DevDBCredentials['user'] . " -p" . $DevDBCredentials['pass'] . " -d " . $DevDBCredentials['name'] . " | mysql -u " . $UnitTestDBCredentials['user'] . " -p" . $UnitTestDBCredentials['pass'] . " -D" . $UnitTestDBCredentials['name'] . ""; $dump = `{$dump}`; $makeUser = $db->Query("INSERT INTO tblUsers (username, password, accountType, displayName, email) VALUES ('joe', 'nohomohug', 'Standard', 'Joe Testmoore', '*****@*****.**');"); APIResponse(RESPONSE_200, "Cleared the database and sessions."); exit; }
function SelectByWhere($where) { App::LoadDataClass("MySQLDatabase.php"); $mydb = new MySQLDatabase($this->ConnString); $mydb->Open(); $query = "Select * from `{$this->TableName}` {$where}"; //App::Pr($query); $result = $mydb->Query($query); $rows = null; while ($row = mysql_fetch_array($result)) { $rows[] = $row; } $mydb->Close(); if ($mydb->getError()) { $this->setError($mydb->getError()); } return $rows; }