function updateDirector($memberId, $regId) { $sql = "UPDATE directors SET Post={$this->post} WHERE MemberId={$memberId} AND RegId={$regId}"; if ($result = $this->mysqli->query($sql)) { $response = BaseClass::createResponse(1, "Director details updated."); } else { $response = BaseClass::createResponse(0, $this->mysqli->error); } return $response; }
public function getMembers($regId) { $sql = "SELECT Members.MemberId, Members.Name FROM Members LEFT JOIN Spouse ON Spouse.RegId = Members.RegId AND Spouse.MemberId = Members.MemberId WHERE Members.RegId = {$regId};"; if ($result = $this->mysqli->query($sql)) { $response = BaseClass::createResponse(1, "Successful"); $response["list"] = []; while ($row = $result->fetch_assoc()) { $response["list"][] = $row; } } else { $response = BaseClass::createResponse(0, $this->mysqli->error); } return $response; }
$_POST = $children->escapeData($_POST); //set variables $regId = intval($_POST['RegId']); $memberId = intval($_POST['MemberId']); $kidId = intval($_POST['KidId']); $children->name = empty($_POST['Name']) ? 'NULL' : "'" . $_POST['Name'] . "'"; $children->dob = empty($_POST['DOB']) ? 'NULL' : "'" . $_POST['DOB'] . "'"; $children->gender = empty($_POST['Gender']) ? 0 : intval($_POST['Gender']); $children->email = empty($_POST['Email']) ? 'NULL' : "'" . $_POST['Email'] . "'"; $children->email1 = empty($_POST['Email1']) ? 'NULL' : "'" . $_POST['Email1'] . "'"; $children->mobile = empty($_POST['Mobile']) ? 'NULL' : "'" . $_POST['Mobile'] . "'"; $children->mobile1 = empty($_POST['Mobile1']) ? 'NULL' : "'" . $_POST['Mobile1'] . "'"; $children->mobile2 = empty($_POST['Mobile2']) ? 'NULL' : "'" . $_POST['Mobile2'] . "'"; $children->bloodGroup = empty($_POST['BloodGroup']) ? 'NULL' : "'" . $_POST['BloodGroup'] . "'"; $children->hobbies = empty($_POST['Hobbies']) ? 'NULL' : "'" . $_POST['Hobbies'] . "'"; //Perform action $response = $children->updateChildren($regId, $memberId, $kidId); break; case 'GC': //Perform action $regId = intval($_POST['RegId']); $memberId = intval($_POST['MemberId']); $kidId = intval($_POST['KidId']); $response = $children->getChildren($memberId, $regId, $kidId); break; case 'LI': $response = BaseClass::isAdmin(); } } header('Content-Type: application/json'); echo json_encode($response);
function updateHasChildrenToInactive($memberId) { $sql = "UPDATE Members Set hasChildren=2 WHERE MemberId={$memberId}"; if ($result = $this->mysqli->query($sql)) { $response = BaseClass::createResponse(1, "Has Children field updated."); } else { $response = BaseClass::createResponse(0, $this->mysqli->error); } return $response; }
function generateId() { $voucherCode = 1001; $sql = "SELECT MAX(Id) AS 'voucherCode' FROM Members"; if ($result = $this->mysqli->query($sql)) { $voucherCode = intval($result->fetch_assoc()['voucherCode']); $voucherCode = $voucherCode == 0 ? 1001 : $voucherCode + 1; } else { $this->response = BaseClass::createResponse(0, $this->mysqli->error); } return $voucherCode; }
*/ namespace Project\Register; use Project\Base\BaseClass; session_start(); define("ROOT", "../"); require ROOT . "autoload.php"; require ROOT . "authenticate.php"; $response = null; //Do validation if required do { if (isset($_GET)) { $validate = true; } else { $validate = false; $response = BaseClass::createResponse(0, "Invalid Request"); } } while (0); //Create mapping based on request /* * 1 => get all registered users list * 2 => get particular user details * 3 => create csv file and send csv file has response * */ if ($validate) { $reportType = 1; if (!empty($_GET['id'])) { $reportType = 2; } if (!empty($_GET['type'])) {
function addImage($eventId) { //Create folder using BaseClass::createDir($path) function $path = "images/" . $eventId . "/"; //Save image using ImageUpload class //Image name = "cover.jpg" //Update the image path in database. BaseClass::createDir($path); $imageUpload = new ImageUpload($this->image); $imageUpload->dstPath = $path; $imageUpload->dstName = "cover"; if ($imageUpload->save()) { //ImageUpload class by default saves all the image to jpg $imagePath = $path . "cover.jpg"; $sql = "UPDATE Events SET ImagePath = '{$imagePath}' WHERE EventId = {$eventId};"; if ($result = $this->mysqli->query($sql)) { $response = BaseClass::createResponse(1, "Gallery created.."); } else { $response = BaseClass::createResponse(0, $this->mysqli->error); } } else { $response = $imageUpload->response; } //End return $response; }
function __construct() { parent::__construct(); //Initialize variables $this->users = array("User1", "User2", "User3"); }
foreach ($l as $i => $v) { if (!array_key_exists($i, $files)) { $files[$i] = array(); } $files[$i][$k] = $v; } } $index = 0; foreach ($files as $file) { if ($index == 1 && intval($_POST['HasPartner']) == 1) { $index++; } if ($index > 2) { break; } $path = ROOT . "images/newUsers/"; $name = $id . "_" . $fileSuffix[$index++]; $response = uploadImage($file, $name, $path); if ($response["status"] == 1) { $response = BaseClass::createResponse(1, "Form submitted successfully"); } else { $response = BaseClass::createResponse(1, $response["message"]); } } } break; case 'D': $response = $settings->deleteUser(intval($_POST['id'])); } } echo json_encode($response);
function getGalleryDetails($galleryId) { $sql = "SELECT * FROM Gallery where Id={$galleryId}"; if ($result = $this->mysqli->query($sql)) { $response = BaseClass::createResponse(1, "Success"); $response['result'] = array(); while ($row = $result->fetch_assoc()) { $response['result'] = $row; } } else { $response = BaseClass::createResponse(0, $this->mysqli->error); } return $response; }
function ActivateRsvp($eventId, $memberId) { //for this function to work you have to add (name:"Active", type:"tinyint", NOT NULL DEFAULT 2) field into the RSVP table //When this function is called you have to update the active field to value 1 //Don't forget to update the query in updateRsvp().. $this->active = 1; $sql = "UPDATE Rsvp SET Rsvp.Active={$this->active} WHERE Rsvp.EventId={$eventId} AND Rsvp.MemberId={$memberId}"; if ($result = $this->mysqli->query($sql)) { $response = BaseClass::createResponse(1, "Active value updated.."); } else { $response = BaseClass::createResponse(0, "Active value not updated.."); } return $response; }
function deleteMember($memberId) { $sql = "DELETE FROM Members WHERE MemberId={$memberId}"; if ($this->mysqli->query($sql)) { $response = BaseClass::createResponse(1, "Member deleted."); } else { $response = BaseClass::createResponse(0, $this->mysqli->error); } return $response; }