function inserthost($data) { $conn = geteventDB(); $hostname = $data['hostname']; $contactnumber = $data['contactnumber']; $email = $data['email']; $check = "SELECT COUNT(1) as count_ FROM eventhostinfo WHERE hostemail = '{$email}'"; if (!($result = $conn->query($check))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $count = 0; $return_arr = array(); while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); $count = $row['count_']; } if ($count >= 1) { echo "This Information already exists, Press Next to Continue"; } else { $sql = "INSERT INTO eventhostinfo(hostname,hostemail,contactnumber) VALUES('{$hostname}','{$email}','{$contactnumber}')"; //die('There was an error running the query [' .$conn->error . ']\n'); if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } else { echo "New Record Sucessfully inserted, Press Next to Continue"; } } //$stmt->execute(); $conn->close(); }
function insertsavedevent($data) { $conn = geteventDB(); $eventid = $data['EventId']; $username = $data['username']; $check = "SELECT COUNT(1) as number FROM savedevents WHERE eventid = {$eventid} and username='******'"; if (!($result = $conn->query($check))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); $count = 0; while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); $count = $row['number']; } if ($count >= 1) { echo "Already saved"; } else { echo "Inserting new Record"; $sql = "INSERT INTO savedevents(eventid,username) VALUES({$eventid},'{$username}')"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } } //$stmt->execute(); $conn->close(); }
function insertticketscart($data) { $conn = geteventDB(); $eventid = $data['eventid']; $username = $data['username']; $nooftickets = $data['noofticketstaken']; $check = "SELECT COUNT(1) as number FROM ticketscart WHERE eventid = {$eventid} and username='******'"; if (!($result = $conn->query($check))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); $count = 0; while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); $count = $row['number']; } if ($count >= 1) { echo "Updating the exsisting table"; $update_ = "Update ticketscart set nooftickets=nooftickets+{$nooftickets} where eventid = {$eventid} and username='******' "; if (!($_result = $conn->query($update_))) { die('There was an error running the query [' . $conn->error . ']\\n'); } } else { echo "Inserting new Record"; $sql = "INSERT INTO ticketscart(eventid,username,nooftickets) VALUES({$eventid},'{$username}',{$nooftickets})"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } } //$stmt->execute(); $conn->close(); }
function insertlocation($data) { $conn = geteventDB(); $state = $data['state']; $city = $data['city']; $address = $data['address']; $zipcode = $data['zipcode']; $check = "SELECT COUNT(1) as number FROM location WHERE state = '{$state}' and city='{$city}' and address='{$address}' and zipcode='{$zipcode}'"; if (!($result = $conn->query($check))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); $count = 0; while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); $count = $row['number']; } if ($count >= 1) { echo "Location Info is already there"; } else { echo "Inserting new Record"; $sql = "INSERT INTO location(state,city,address,zipcode) VALUES('{$state}','{$city}','{$address}','{$zipcode}')"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } } //$stmt->execute(); $conn->close(); }
function getEventsNextMonth() { $conn = geteventDB(); $sql = "SELECT events.EventId,events.EventName,events.StartDateandTime,events.rating,events.EndDateandTime,events.EventPrice,events.MaxCapacity,events.LogoImageUrl,location.State,location.City,location.Address,location.Zipcode,categories.CategoryName,categories.Categoryid from events \ninner join location inner join categories on events.Categoryid=categories.Categoryid and events.LocationId=location.LocationId \n where YEAR(StartDateandTime) = YEAR(NOW()) AND MONTH(StartDateandTime) = MONTH(NOW())+1"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); } echo json_encode($return_arr); $conn->close(); }
function userSavedEvents($username) { $conn = geteventDB(); $query = "SELECT events.EventId,events.EventName,events.StartDateandTime,events.rating,events.EndDateandTime,events.EventPrice,events.MaxCapacity,events.LogoImageUrl,location.State,location.City,location.Address,location.Zipcode,categories.CategoryName,categories.Categoryid from events inner join location inner join categories inner join savedevents on events.Categoryid=categories.Categoryid and events.LocationId=location.LocationId and events.EventId=savedevents.eventid where savedevents.username='******'"; if (!($result = $conn->query($query))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); } echo json_encode($return_arr); $conn->close(); }
function getNumberOfTicketsSoldForEvent($id) { $conn = geteventDB(); $query = "SELECT sum(nooftickets) as Peoplegoing FROM `ticketscart` WHERE EventId={$id} GROUP by EventId"; if (!($result = $conn->query($query))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); } echo json_encode($return_arr); $conn->close(); }
function getEventsWeekEnd() { $conn = geteventDB(); $sql = "SELECT events.EventId,events.EventName,events.StartDateandTime,events.rating,events.EndDateandTime,events.EventPrice,events.MaxCapacity,events.LogoImageUrl,location.State,location.City,location.Address,location.Zipcode,categories.CategoryName,categories.Categoryid from events inner join location inner join categories on events.Categoryid=categories.Categoryid and events.LocationId=location.LocationId WHERE DAYOFWEEK(StartDateandTime) = 7\nor DAYOFWEEK(StartDateandTime) = 1 or (DATE_FORMAT(StartDateandTime, '%T') > '17:30:00' AND DAYOFWEEK(StartDateandTime) = 6)"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); } echo json_encode($return_arr); $conn->close(); }
function getEventsInfo($id) { $conn = geteventDB(); $sql = "SELECT events.EventId,events.EventName,events.StartDateandTime,events.rating,events.VedioUrl,events.EndDateandTime,events.EventPrice,events.MaxCapacity,events.LogoImageUrl,location.State,location.City,location.Address,location.Zipcode,categories.CategoryName,categories.Categoryid,eventhostinfo.HostName,eventhostinfo.HostEmail,eventhostinfo.ContactNumber from events inner join location inner join categories INNER join eventhostinfo on events.Categoryid=categories.Categoryid and events.LocationId=location.LocationId and events.HostId=eventhostinfo.HostId where events.EventId=" . $id; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); } echo json_encode($return_arr); $conn->close(); }
function getCategories() { $conn = geteventDB(); $sql = "SELECT * FROM categories"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); } echo json_encode($return_arr); $conn->close(); }
function getEventsFromCategories($categoryid) { $conn = geteventDB(); $sql = "SELECT events.EventId,events.EventName,events.StartDateandTime,events.rating,events.EndDateandTime,events.EventPrice,events.MaxCapacity,events.LogoImageUrl,location.State,location.City,location.Address,location.Zipcode,categories.CategoryName,categories.Categoryid from events inner join location inner join categories on events.Categoryid=categories.Categoryid and events.LocationId=location.LocationId where events.Categoryid={$categoryid}"; $query = "SELECT categories.CategoryName,events.EventId,events.Description,events.EventName,events.StartDateandTime,events.EndDateandTime,events.EventPrice,events.MaxCapacity,events.LogoImageUrl FROM `events` inner join categories on events.Categoryid=categories.Categoryid"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); } echo json_encode($return_arr); $conn->close(); }
function insertevent($data) { $conn = geteventDB(); $state = $data['state']; $city = $data['city']; $address = $data['address']; $zipcode = $data['zipcode']; $eventname = $data['eventname']; $eventprice = $data['eventprice']; $maxcapacity = $data['maxcapacity']; $logourl = $data['logourl']; $vediourl = $data['vediourl']; $category = $data['category']; $rating = $data['rating']; $hostname = $data['hostname']; $contactnumber = $data['contactnumber']; $email = $data['email']; $startdateandtime = $data['startdateandtime']; $enddateandtime = $data['enddateandtime']; echo "Getting Categoryid"; $categoryid = "SELECT Categoryid as categoryid FROM categories WHERE CategoryName='{$category}'"; if (!($result = $conn->query($categoryid))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr = array(); $category_id = 0; while ($row = $result->fetch_assoc()) { array_push($return_arr, $row); $category_id = $row['categoryid']; } echo "Getting Locationid"; $locationid = "SELECT LocationId as locid FROM location WHERE State='{$state}' and City='{$city}' and Address='{$address}' and Zipcode='{$zipcode}'"; if (!($result = $conn->query($locationid))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $return_arr_ = array(); $location_id = 0; while ($row = $result->fetch_assoc()) { array_push($return_arr_, $row); $location_id = $row['locid']; } echo "Getting Hostid"; $hostid = "SELECT HostId as hosid FROM eventhostinfo WHERE HostName='{$hostname}' and HostEmail='{$email}' and ContactNumber='{$contactnumber}'"; if (!($result = $conn->query($hostid))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $_return_arr = array(); $host_id = 0; while ($row = $result->fetch_assoc()) { array_push($_return_arr, $row); $host_id = $row['hosid']; } $des = "aaaaaa"; echo "Inserting Record"; $sql = "INSERT INTO events(EventName,Categoryid,LocationId,StartDateandTime,EndDateandTime,LogoImageUrl,EventPrice,IsFree,HostId,MaxCapacity,Rating,IsSelected,VedioUrl,Description) VALUES('{$eventname}',{$category_id},{$location_id},'{$startdateandtime}','{$enddateandtime}','{$logourl}',{$eventprice},0,{$host_id},{$maxcapacity},{$rating},0,'{$vediourl}','{$des}')"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } //$stmt->execute(); $conn->close(); }
if(!$result = $conn->query($sql)){ die('There was an error running the query [' .$conn->error . ']\n'); } $conn->close(); //DeleteSavedEvent($data);*/ }); $app->post('/events/saved/delete/post/', function () use($app) { echo 'This is a POST route'; $json = $app->request->getBody(); $data = json_decode($json, true); echo $data['EventId']; echo $data['username']; $conn = geteventDB(); $eventid = $data['EventId']; $username = $data['username']; $sql = "DELETE FROM savedevents WHERE savedevents.eventid={$eventid} and savedevents.username='******'"; if (!($result = $conn->query($sql))) { die('There was an error running the query [' . $conn->error . ']\\n'); } $conn->close(); //DeleteSavedEvent($data); }); // PUT route $app->put('/put', function () { echo 'This is a PUT route'; }); // PATCH route $app->patch('/patch', function () {