PHPtutorial/refreshlist.php at master · StrayCargo/PHPtutorial · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<?php //Runs the expiration Method for determining if a user is still Active

require_once('mysqli_connect.php');

  $dbc = @mysqli_connect(db_host,db_user,db_password,db_database) OR die('Could not Connect to mySQL' . mysqli_connect_error());
    $query="select date_entered , student_id from users ";
    $response = @mysqli_query($dbc,$query);
    if($response)
    {
      while($row=mysqli_fetch_array($response))
      {
        $expiredtime ="1451649569";
          if($row["Expire_Time"] >= $expiredtime)
          {
            $query="update users set status = 0 where student_id ='".$row["student_id"]."'";
              @mysqli_query($dbc,$query);
          }else{
            $query="update users set status = 1 where student_id ='".$row["student_id"]."'";
              @mysqli_query($dbc,$query);
          }
      }
    }
  mysqli_close($dbc);
?>
<html>
  <meta http-equiv="refresh" content="0; url=AdminManagement.php" />
</html>