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