public function getUserTypeById($usertypeid) { $query = "SELECT * FROM " . USER_TYPE . " WHERE utp_usertype_id = " . "'{$usertypeid}'"; $dbHelper = new DBHelper(); $result = $dbHelper->executeSelect($query); $user = $this->getUserType($result); return $user->getuserTypeName(); }
public function Login($uname, $upwd) { $uname = $uname; $upwd = sha1($upwd); // returns all users with the names passed //$query = "SELECT * FROM ".USER. " WHERE upper(usr_first_name) like " ."%JOHN%"; $query = "SELECT * FROM " . USER . " WHERE usr_login = '******' and usr_password='******'"; $dbHelper = new DBHelper(); $result = $dbHelper->executeSelect($query); $Users = $this->getLogin($result); return $Users; }
public function getEntryDislikeNumByEntry($entryId) { $query = "SELECT count(rating.rat_dislike_user_id) AS dislikeNum\n FROM " . ENTRY . " AS entry INNER JOIN " . RATING . " AS rating\n ON rating.rat_entity_id = CONCAT('ent', '" . $entryId . "') \n AND rating.rat_dislike_user_id IS NOT NULL AND rating.rat_dislike_user_id >0\n GROUP BY entry.ent_entry_id \n HAVING entry.ent_entry_id='" . $entryId . "'"; //echo "<br/>EAD getEntryDislikeNum query: ".$query; $dbHelper = new DBHelper(); $resultOfSelect = $dbHelper->executeSelect($query); $dislike_num = ""; $count = 0; while ($list = mysqli_fetch_assoc($resultOfSelect)) { $dislike_num = $list['dislikeNum']; $count++; } return $dislike_num; }
data="views/entry/search_phrase_examples.html"> </object> </div><!--LeftCol--> <div id="MidCol"> <div> <div class="container" style="border-collapse: inherit; width: 99%; font-size: 20px;"> <div class="heading"> <div class="col_33"> <h3 class="t_title">Top 10 Translations</h3> <div class="mid_scoll"> <ol type="circle" style="padding: 0px 5px; margin: 0px"> <!-Display top 10 translations--> <?php $query = "SELECT *, count(rating.rat_like_user_id) AS num_like\n FROM \n (SELECT orig.ent_entry_id AS orig_entry_id, orig.ent_entry_text AS orig_phrase, \n trans.ent_entry_id AS trans_entry_id, trans.ent_entry_text AS trans_phrase,\n trans.ent_entry_creation_date AS trans_date\n FROM \n (SELECT ent_entry_id, ent_entry_text, ent_entry_verbatim, ent_entry_translit, ent_entry_authen_status_id, \n ent_entry_translation_of, ent_entry_creation_date\n FROM tbl_entry where ent_entry_authen_status_id = 1) AS orig\n INNER JOIN \n (SELECT ent_entry_id, ent_entry_text, ent_entry_verbatim, ent_entry_translit, ent_entry_authen_status_id, \n ent_entry_translation_of, ent_entry_creation_date\n FROM tbl_entry where ent_entry_authen_status_id = 2) AS trans\n ON orig.ent_entry_id = trans.ent_entry_translation_of\n ) AS sub_entry\n LEFT JOIN tbl_rating AS rating\n ON rating.rat_entity_id = CONCAT('ent', sub_entry.trans_entry_id) \n AND rating.rat_like_user_id IS NOT NULL AND rating.rat_like_user_id >0\n GROUP BY sub_entry.trans_entry_id\n ORDER BY num_like DESC, sub_entry.trans_date DESC, sub_entry.trans_entry_id ASC"; $dbHelper = new DBHelper(); $result = $dbHelper->executeSelect($query); $count = 0; while ($list = mysqli_fetch_assoc($result)) { $trans_phrase = $list['trans_phrase']; $orig_phrase = $list['orig_phrase']; $trans_entry_id = $list['trans_entry_id']; $num_like = $list['num_like']; if ($count < 10) { ?> <li> <!-- <div>--> <div class="text_shortcut"><a href="entryview.php?id=<?php echo $trans_entry_id; ?> "><?php echo $trans_phrase;
public function getLocationBylocationId($locationId) { $query = "select * from " . LOCATION . " where loc_location_id = " . $locationId; $dbHelper = new DBHelper(); $result = $dbHelper->executeSelect($query); $loc = $this->getAddressList($result); return $loc; }
public function LoginReset($resetcode) { if (isset($resetcode)) { //object that holds the password and user id for the resetter //Retrieving the data from the table, based on the data sent $Reset = new ResetPassword(); $query = "SELECT * FROM " . PASSWORD_RESET . " WHERE reset_code = '{$resetcode}' "; $dbHelper = new DBHelper(); $result = $dbHelper->executeSelect($query); // 30 //getting the object of PasswordReset $Reset = $this->getReset($result); } return $Reset; }
public function getUserByUserId($userId) { // returns returns all users with the names passed $query = "SELECT * FROM " . USER . " WHERE usr_user_id = '{$userId}' "; $dbHelper = new DBHelper(); $result = $dbHelper->executeSelect($query); $Users = $this->getUser($result); return $Users; }