FM / cal

/home/desid573/public_html/magicride.ng/cal/

/home/desid573/public_html/magicride.ng/cal

Name	Size	Mode	Actions
components/	-	0755	rm
css/	-	0755	rm
fonts/	-	0755	rm
img/	-	0755	rm
js/	-	0755	rm
less/	-	0755	rm
tmpls/	-	0755	rm
bower.json	315	0644	edit dl rm
check.php	463	0644	edit dl rm
composer.json	839	0644	edit dl rm
config.php	342	0644	edit dl rm
CONTRIBUTING.md	372	0644	edit dl rm
error_log	1379	0644	edit dl rm
events.json.php	1742	0644	edit dl rm
event_report.php	5315	0644	edit dl rm
get-event-list.php	1803	0644	edit dl rm
getEvents.php	716	0644	edit dl rm
Gruntfile.js	1076	0644	edit dl rm
index-bs3.html	7991	0644	edit dl rm
index.html	8237	0644	edit dl rm
LICENSE	1080	0644	edit dl rm
min.html	4309	0644	edit dl rm
min.php	5924	0644	edit dl rm
package.json	832	0644	edit dl rm
README.md	9183	0644	edit dl rm
register-driver.php	3277	0644	edit dl rm
web.config	188	0644	edit dl rm

Edit: /home/desid573/public_html/magicride.ng/cal/get-event-list.php (1803B)

<?php 
            require("config.php");
            
            $sql = "SELECT * FROM onboard_events WHERE id=".$_POST["event"];
            
            $success = $conn->query($sql);
            
            if($success->num_rows > 0) {
                
                $response["status"] = "OK";
                $response["message"] = "found";
                $response["event_data"] = $success->fetch_assoc();
                
                $sql = "SELECT * FROM onboard_register WHERE event_id=".$_POST["event"];
            
                $success = $conn->query($sql);
                
                if($success->num_rows > 0) {
                    
                    $attendees = [];
                    
                    while($row = $success->fetch_assoc()) {
                        
                        $driver_id = $row["driver_id"];
                        
                        $sql = "SELECT * FROM driver_onboard WHERE id=".$driver_id;
                        
                        error_log($sql);
                        
                        $result = $conn->query($sql);
                        
                        array_push($attendees, $result->fetch_assoc());
                        
                    }
                    
                    $response["attendees"] = $attendees;
                    
                } else {
                    
                    $response["attendees"] = "[]";
                }
                
                
                
            } else {
                
                $response["status"] = "error";
                $response["message"] = "Event Not Found";
                
            }
            
            echo json_encode($response, true);
            
            
            ?>

query($sql); if($success->num_rows > 0) { $response["status"] = "OK"; $response["message"] = "found"; $response["event_data"] = $success->fetch_assoc(); $sql = "SELECT * FROM onboard_register WHERE event_id=".$_POST["event"]; $success = $conn->query($sql); if($success->num_rows > 0) { $attendees = []; while($row = $success->fetch_assoc()) { $driver_id = $row["driver_id"]; $sql = "SELECT * FROM driver_onboard WHERE id=".$driver_id; error_log($sql); $result = $conn->query($sql); array_push($attendees, $result->fetch_assoc()); } $response["attendees"] = $attendees; } else { $response["attendees"] = "[]"; } } else { $response["status"] = "error"; $response["message"] = "Event Not Found"; } echo json_encode($response, true); ?>