Php阻止用户查看过期页面

Question

Consider the following url based on a sporting event happening in the future:
http://www.example.com/file.php?1615=Submit

The 1615 in the url is the eventid. Now after the event has finishedthe page should not be viewable anymore.

Thus my question is how do I stop user from viewing the page if event has expired? Would something like this be my most efficient option using the following logic:

1. Get event id from url assign to var $check
2. Select event_date from events where event_id = $check
3. If(date('Ymd') > event_date) then redirect user

Is there a more efficient way I can tackle this problem?

Answer 1

Here is a water down version of what I believe you would like to do, change as needed

 $id =  $_SERVER["REQUEST_URI"]; 
    $id = substr($id,0,4); //here is your event_id
    //query your database
$data = $conn->query('SELECT event_date from events WHERE event_id ="$id"')
    //get date
     foreach($data as $row) {
        $event_date =($row);
        }
$cur_date = date("Ymd");
if($cur_date>$date){
//do what you need to do
}