This topic is locked

Expiry Date

12/2/2017 10:57:40 PM
PHPRunner General questions
A
amins author

hi;

Please help,

I have the following fields on RegDate table:

user:username

Dateexpiry (Y-m-d)
I wish after the expiration date, the contents of the index page do not appear, and I entered the below code in (index) Events> List page:Fetch records

global $conn;

$sql = "select Dateexpiry from RegDate where user='".$username."'";

$rs = db_query($sql,$conn);

$data = db_fetch_array($rs);

if ($data["Dateexpiry"]<now())

{

echo "<p align=center>
<font color=red><b>Access denied account expired </b> <font></p>";

return false;

}

else

{

return true;

}



But this code does not display the photos and contents of the index pages before the expiration date.
How do I fix?