public static function validate($uname, $pass) { $query = "select * from users where username='******' and pass = '******'"; $rs = DataAccessHelper::executeQuery($query); if (!$rs) { return false; } return true; }
public static function getComments($imgId) { $query = "select * from imgcomments where imgId=" . $imgId; $result = DataAccessHelper::executeQuery($query); return $result; }
public static function getAllUsers($groupId) { $query = "select * from members join groups on members.gname=groups.gname where groupId= {$groupId}"; $result = DataAccessHelper::executeQuery($query); return $result; }
public static function imageId($imageName) { $query = "select * from photos where name ='" . $imageName . "'"; $rs = DataAccessHelper::executeQuery($query); if ($rs) { return $rs; } return false; }
public static function getotheralbumdata($username) { $query = "select * from photos where username='******' and albumId is NULL "; $result = DataAccessHelper::executeQuery($query); return $result; }