public function ForgotPassword($email) { $reset = false; //some random text to be shuffled and generated by the user $random_text = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789@.()"; //TO SHUFFLE THE ABOVE TEXT AND PIC 10 CHARS. $substr = substr(str_shuffle($random_text), 0, 10); $user = new User(); $query = "SELECT * FROM " . USER . " WHERE usr_email = '{$email}' "; $dbHelper = new DBHelper(); $result = $dbHelper->executeSelect($query); // 30 $user = $this->getUser($result); $userid = $user->getLogin(); $username = $user->getFirstName(); $date = date("Y/m/d"); if ($user) { //PASSWORD_RESET Email to be sent to the user, a function called email, if email is sent then do the things below if ($this->email($email, $username, $substr, null)) { //PASSWORD_RESET, a table that carries the user password forgot request $query_insert = "INSERT INTO " . PASSWORD_RESET . " VALUES('','{$substr}','{$userid}', '{$date}',0)"; //connection to the database $dbHelper = new DBHelper(); //returning the connection result $result = $dbHelper->executeQuery($query_insert); if ($result) { $reset = true; } } //$last_inserted_id = mysql_insert_id(); } return $reset; }
public function getLanguages() { $dbHelper = new DBHelper(); $query = "SELECT * FROM " . LANGUAGE . " order by lan_lang_name asc "; $result = $dbHelper->executeQuery($query); $Languages = $this->getListOfLang($result); return $Languages; }
public function getAllUserTypes() { $dbHelper = new DBHelper(); $query = "SELECT * FROM " . USER_TYPE . " ORDER BY utp_usertype_id ASC"; $result = $dbHelper->executeQuery($query); $Users = $this->getUserTypeList($result); return $Users; }
public function getTreqBriefById($id) { $query = "SELECT\n r.treq_entry_id,\n l.lan_lang_name\n FROM \n " . TRANS_REQUEST . " AS r \n STRAIGHT_JOIN \n " . LANGUAGE . " AS l \n WHERE\n r.treq_target_lang_id = l.lan_language_id\n AND\n r.treq_id={$id}"; $dbHelper = new DBHelper(); $result = $dbHelper->executeQuery($query); $treqGottenByEntryId = $this->getTreqBrief($result); return $treqGottenByEntryId; }
public function getReportByReason($reason) { $query = "SELECT * FROM " . REPORT . " WHERE rep_reason LIKE '%" . $reason . "%' ORDER BY rep_reported_on DESC"; $dbHelper = new DBHelper(); $result = $dbHelper->executeQuery($query); $reports_by_reason = $this->getReportList($result); return $reports_reason; }
public function getBadWordList() { $query = "SELECT * FROM " . BADWORD; $dbHelper = new DBHelper(); $result = $dbHelper->executeQuery($query); $badword_all = $this->getBadwordPatterns($result); return $badword_all; }
public function getUsersByLanguageProf($Prof, $LanguageId) { $dbHelper = new DBHelper(); $query = "SELECT * FROM " . LANGUAGE_PROF . " where language_id = " . "'" . $LanguageId . "' \n and upper(prof) = " . "'" . strtoupper($Prof) . "'"; $result = $dbHelper->executeQuery($query); $Users = $this->getListOfLangProf($result); return $Users; }
public function getAuthenByName($authenName) { $dbHelper = new DBHelper(); //to escape the strings for inserting $authen_name = $dbHelper->EscapeString($authenName); $authen_name = strtoupper($authen_name); $query = "SELECT * FROM " . AUTHEN . " WHERE UPPER(athn_stat_name) = " . "'" . $authen_name . "'"; $result = $dbHelper->executeQuery($query); $authen = $this->getAuthen($result); return $authen->getAuthenId(); }
public function getAllFathers() { // a 'father' is the entry from which all translations are made $dbHelper = new DBHelper(); $query = "SELECT * " . "FROM " . ENTRY . "WHERE ent_entry_authen_status_id = 'o'" . " AND e.ent_entry_deleted = 0" . " ORDER BY ent_entry_id DESC"; $resultOfSelect = $dbHelper->executeQuery($query); $Users = $this->getListOfFathers($resultOfSelect); return $Users; }
public function getSubscriptionByLocation($subscriber_location) { $query = "SELECT * FROM SUBSCRIPTION WHERE sub_location_name = {$subscriber_location}"; $dbHelper = new DBHelper(); $subscriptions_by_location = $dbHelper->executeQuery($query); $this->getSuscriber($subscriptions_by_location); //$subscriber = $this->getCommentList($result); return $subscriber; }
public function getCommentByEntry($comment_entry_id) { //echo "<br/>CommentDataAccessor entry id: ".$comment_entry_id."<br/><br/>"; $query = "SELECT * FROM " . COMMENT . " WHERE com_entry_id = '" . $comment_entry_id . "' AND com_is_visible='Y' ORDER BY com_created_on"; $dbHelper = new DBHelper(); $result = $dbHelper->executeQuery($query); $comments_by_entry = $this->getCommentList($result); return $comments_by_entry; }
public function getRatingByEntityDislikeUser($entity_id, $dislike_user_id) { $query = "SELECT * FROM " . RATING . " WHERE rat_entity_id = '" . $entity_id . "' AND rat_dislike_user_id = '" . $dislike_user_id . "'"; $dbHelper = new DBHelper(); $result = $dbHelper->executeQuery($query); $ratings_by_entity_dislike_user = $this->getRating($result); return $ratings_by_entity_dislike_user; }
<?php include "DBHelper.php"; $dbConfig = json_decode(file_get_contents("dbConfig.json"), true); $dsn = $dbConfig["dsn"]; $user = $dbConfig["user"]; $pass = $dbConfig["pass"]; $dbh = DBHelper::connect($dsn, $user, $pass); if (is_array($dbh)) { $result = $dbh; } else { $result = DBHelper::executeQuery($dbh, "SHOW DATABASES"); DBHelper::disconnect($dbh); } echo json_encode($result);
public function getUserByHashData($email) { $dbHelper = new DBHelper(); $query = "SELECT * FROM " . USER . " ORDER BY usr_user_id DESC"; $result = $dbHelper->executeQuery($query); $userid = $this->compareHash($result, $email); return $userid; }
<?php /** * Created by PhpStorm. * User: admin * Date: 14.02.2016 * Time: 23:32 */ include "DBHelper.php"; $result = array(); $data = json_decode($_POST["data"]); $dbConfig = json_decode(file_get_contents("dbConfig.json"), true); $dsn = $dbConfig["dsn"]; $user = $dbConfig["user"]; $pass = $dbConfig["pass"]; $dbh = DBHelper::connect($dsn, $user, $pass); foreach ($data->db as $dbName) { DBHelper::executeQuery($dbh, "USE " + $dbName); if (is_array($dbh)) { $result[$dbName] = $dbh; continue; } $result[$dbName] = DBHelper::executeQuery($dbh, $data->query); } DBHelper::disconnect($dbh); echo json_encode($result);