public function insert() { if (!is_null($this->id)) { trigger_error("User::insert(): Attempt to insert a user object that already has its ID property set to {$this->id}.", E_USER_ERROR); } $conn = new PDO(DB_DSN, DB_USERNAME, DB_PASSWORD); $sql = "INSERT INTO " . TABLENAME_DATEREQUESTS . " ( type, shopId, sentById, sentToGroupId, sentToUserId, status, date ) VALUES ( :type, :shopId, :sentById, :sentToGroupId, :sentToUserId, :status, :date)"; $st = $conn->prepare($sql); $st->bindValue(":type", $this->type, PDO::PARAM_STR); $st->bindValue(":shopId", $this->shopId, PDO::PARAM_INT); $st->bindValue(":sentById", $this->sentById, PDO::PARAM_INT); $st->bindValue(":sentToGroupId", $this->sentToGroupId, PDO::PARAM_INT); $st->bindValue(":sentToUserId", $this->sentToUserId, PDO::PARAM_INT); $st->bindValue(":status", $this->status, PDO::PARAM_STR); $st->bindValue(":date", $this->date, PDO::PARAM_STR); // print_r( $st ); $result = $st->execute(); $this->id = $conn->lastInsertId(); $conn = null; if (!$result) { self::$errorMessage = "User::insert: Insertion Failed, PDO::errorInfo(): " . $st->errorCode() . ": " . $st->errorInfo()[2]; self::$errorCode = $st->errorCode(); //echo $errorMessage; return false; } else { self::$successMessage = "User::insert: User successfully inserted with id " . $this->id; return true; } }
function acceptDateRequest() { $dateRequest = DateRequest::getById($_GET['id']); $dateRequest->status = "accepted"; $dateRequest->update(); $dateRequests = DateRequest::getOthers($dateRequest->sentById, $dateRequest->type, $dateRequest->sentToGroupId, $dateRequest->sentToUserId); if ($dateRequests[0]['status'] == "accepted" && $dateRequests[1]['status'] == "accepted" && $dateRequest->status == "accepted") { $dateRequest->status = "successful"; $dateRequest->update(); } require TEMPLATE_PATH . "/home.php"; }
function date_req() { if (isset($_SESSION['groupId'])) { echo "date requests for this group:<br>"; // date requests for group which has been selected $dateRequests = DateRequest::getByUserId($_SESSION['userId'], $_SESSION['groupId']); $a = sizeof($dateRequests); for ($i = 0; $i < $a; $i++) { $group = Group::getById($dateRequests[$i]["sentById"]); echo "date request from " . $group->name . "<br>"; echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>"; echo "<a href='/backend/main.php?action=acceptDateRequest&id=" . $dateRequests[$i]["id"] . "'>accept</a>    "; echo "<a href='/backend/main.php?action=declineDateRequest&id=" . $dateRequests[$i]["id"] . "'>decline</a><br>"; } echo "accepted date requests:<br>"; // date requests accepted for group which has been selected $dateRequests = DateRequest::getByGroupId($_SESSION['groupId']); if ($dateRequests['0']['status'] == "successful" or $dateRequests['1']['status'] == "successful" or $dateRequests['2']['status'] == "successful") { $group = Group::getById($dateRequests['0']["sentToGroupId"]); echo "your date request was accepted by" . $group->name . "<br>"; echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>"; } } }
echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>"; echo "<a href='/dating_website/index.php?action=acceptChatRequest&id=" . $chatRequests[$i]["id"] . "'>accept</a>    "; echo "<a href='/dating_website/index.php?action=declineChatRequest&id=" . $chatRequests[$i]["id"] . "'>decline</a><br>"; } echo "date requests for this group:<br>"; $dateRequests = DateRequest::getByUserId($_SESSION['userId'], $_SESSION['groupId']); $a = sizeof($dateRequests); for ($i = 0; $i < $a; $i++) { $group = Group::getById($dateRequests[$i]["sentById"]); echo "date request from " . $group->name . "<br>"; echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>"; echo "<a href='/dating_website/index.php?action=acceptDateRequest&id=" . $dateRequests[$i]["id"] . "'>accept</a>    "; echo "<a href='/dating_website/index.php?action=declineDateRequest&id=" . $dateRequests[$i]["id"] . "'>decline</a><br>"; } echo "accepted date requests:<br>"; $dateRequests = DateRequest::getByGroupId($_SESSION['groupId']); if ($dateRequests['0']['status'] == "successful" or $dateRequests['1']['status'] == "successful" or $dateRequests['2']['status'] == "successful") { $group = Group::getById($dateRequests['0']["sentToGroupId"]); echo "your date request was accepted by" . $group->name . "<br>"; echo "users: <br>" . User::getById($group->adminId)->name . " , " . User::getById($group->per2Id)->name . "and" . User::getById($group->per3Id)->name . "<br>"; } } else { echo "select a group to proceed" . "<br>"; } $groupsPending = Group::getListPendingByAdminId($_SESSION['userId']); $groupsCreatedOnline = Group::getListOnlineByAdminId($_SESSION['userId']); $groupsOnline = Group::getListOnline($_SESSION['userId']); echo "Groups you are admin for <br> "; for ($i = 0; $i < sizeof($groupsCreatedOnline); $i++) { echo "Group Name: " . $groupsCreatedOnline[$i]["name"] . "<br>"; echo "group members: <br>";