PHP get_celebrations_by_celebration_id示例

示例#1

文件： celebration.php 项目： Anshul0305/birthdaymanager-api

 public function process_get($celebration_id, $subquery)
 {
     switch ($subquery) {
         case "stub":
             break;
         default:
             $celebrations = get_celebrations_by_celebration_id($celebration_id);
             return $celebrations;
             break;
     }
 }

示例#2

文件： database.php 项目： Anshul0305/birthdaymanager-api

function get_celebrations_by_member_id($member_id)
{
    $connection = connect();
    $sql = "SELECT `celebration_id` FROM `celebration_attendees` WHERE `member_id` = " . $member_id;
    $result = $connection->query($sql);
    disconnect($connection);
    if ($result->num_rows > 0) {
        $celebration = array();
        while ($row = $result->fetch_assoc()) {
            $celebration_team_id = get_celebrations_by_celebration_id($row["celebration_id"])[0]["team_id"];
            if (is_member_part_of_team($member_id, $celebration_team_id)) {
                $celebration[] = get_celebrations_by_celebration_id($row["celebration_id"])[0];
            }
        }
    }
    return $celebration;
}