php - How to Hide Mysql Records in PHP page Every 23 Hours?

Question

can I hide data from mysql every 23 hours a day and display it again after 1 hour?

for example, I want to hide the data on page at 23:00 and display it again at 00:00.

what should I add to this php code?

<?php
$servername = "localhost";
$username = "usrname";
$password = "usrpass";
$database = "dbname";

$mysqli = new mysqli($servername, $username, $password, $database);
$mysqli->select_db($database) or die("Unable to select database");

$sql = "SELECT prize, result FROM qtytable ORDER BY tgl DESC LIMIT 5";
$result = $mysqli->query($sql);

if ($result->num_rows > 0){
while($row = $result->fetch_assoc()){
    echo '<div class="item">';
    echo '<div class="prizes">'. $row["prize"]. '</div>';
    echo '<div class="results">'. $row["result"]. '</div>';
    echo '</div>';
    }
}
else {
    echo '0 results';
}

$mysqli->close();
?>

or is there a reference site for this? I hope someone recommends it to me.

I have been looking for it for a whole day, but I did not find a discussion about this. I found a way to delete records every few hours, but I didn't want to do that.

Please help me, thank you

标签： phpmysql

Answer 1

You can have an if statement before executing the query and compare with the date.

** Updated to make it more effective.

<?php

if(date("G") > 22){
   print "0 Results";
   exit();
   // save cpu time..
}

$servername = "localhost";
$username = "usrname";
$password = "usrpass";
$database = "dbname";

$mysqli = new mysqli($servername, $username, $password, $database);
$mysqli->select_db($database) or die("Unable to select database");

$sql = "SELECT prize, result FROM qtytable ORDER BY tgl DESC LIMIT 5";


$result = $mysqli->query($sql);
  if ($result->num_rows > 0){
    while($row = $result->fetch_assoc()){
       echo '<div class="item">';
       echo '<div class="prizes">'. $row["prize"]. '</div>';
       echo '<div class="results">'. $row["result"]. '</div>';
       echo '</div>';
    }
  }else {
    echo '0 results';
  }


$mysqli->close();


?>