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