Expire base on time

[depojones]

Hi folks,

I am working on a real estate web portal that will require users to either sign up and list and manage their properties or search for available houses based on the different criteria,using php and mysql.

 

Based upon request of the client i am suppose to develop the property listing application with a  date & time based expiration function or class.That will automatically expire and deactivate a users property after a specified period of time for example 7 days or 30 days.

 

From my own understanding of php coding i've attempted to solve the problem by creating 3 extra fields in the property listing table in my mysql database.

 

the first field will be a ENUM field for listing status that will have default value (Yes,No )or (1,0) while the 2nd extra field is a timestamp field that automatically stores the time property was listed while the 3rd field is also timestamp that calculates and stores the specified expire date of the listing.(I guess or presume that should be expected too)

 

Now i actually need anyone who's worked on a similar app before to please guide me through the steps to write the function or script so that i can actually use the script to calculate and arrive at the date and time due and automatically run via a CRON or whatever and automatically deactivate the listing by updating the active field from 1 to 0 or Yes to No

[samshel]

1) Write cron

2) Select all active records from table

3) check 3rd field if the time has already passed. if yes deactivate the listing by updating record.

[depojones]

Can you give me a head start to that. In terms of the actual code???

[samshel]

mysql_connect("localhost", "user" ,"***");
mysql_select_db("dbname");

$strSql = "UPDATE  propertylisting set propertylisting_status = 'NO' WHERE propertylisting_status = 'YES' AND propertylisting_expiry < '".time()."'"; 

mysql_query($strSql);

//Assumptions 
//- u will be showing records with status = 'YES'
//- u r storing unix time stamp in your third field whcih is _expiry,
//- u will run this script periodically,