PHP User::wrap Examples

Example #1

File: User.php Project: rockerest/capstone

		public static function getByTable($id)
		{
			global $db;
			$sql = "SELECT * FROM users WHERE LOWER(fname)='table' AND lname=?";
			$values = array($id);
			$res = $db->qwv($sql, $values);
			
			return User::wrap($res);
		}

Example #2

File: User.php Project: nickparker88/capstone

		public static function getByID($id)
		{
			global $db;
			$userSQL = "SELECT * FROM users WHERE userid=?";
			$values = array($id);
			$user = $db->qwv($userSQL, $values);
			
			return User::wrap($user);
		}

Example #3

File: User.php Project: rockerest/Afterthought

		public static function search($term = null){
			$base = new Base();
			
			if( !$term ){
				$sql = "SELECT * FROM users ORDER BY lname ASC, fname ASC";
				$res = $base->db->q($sql);
			}
			else{
				$sql = "SELECT * FROM users WHERE lname LIKE ? OR fname LIKE ? OR CONCAT(fname, ' ', lname) LIKE ? ORDER BY lname ASC, fname ASC";
				$values = array('%' . $term . '%', '%' . $term . '%', '%' . $term . '%');
				$res = $base->db->qwv($sql, $values);
			}
			
			return User::wrap($res);
		}