Expired clients

[techker]

Hey guys i have a script that runs with a CRON job every day

while ($row2 = $result->fetch_assoc()){
	
$todays_date = date("Y-m-d");
	
$Dates=$row2['DateServices'];
	
if ($todays_date < $Dates) {
        echo 'Subscription is ok';
	echo "<br />\n";
	echo $row2['name'];
	echo "<br />\n";
	echo $todays_date ;
	
    }else{
	
	echo 'Subscription is expired';
	echo "<br />\n";
	echo $row2['name'];
	echo "<br />\n";
	echo $Dates ;
	
	
}
	
    }

So im having a hard time taking all the data (clients expired and inserting it in a Exired database (inserts email and date expired.

 

 

one im ok ,but if there is 3 clients how can i take the info and insert one by one in the database?

[requinix]

If you can do it with one then you can put the code into a loop, like the one you already have, and do it with many.

 

I'm confused about what the problem is.

[techker]

its to insert in database all the clients expired.

[Barand]

You already have expired clients in your database and you know which ones they are. Why would you need to duplicate that information. It's a waste of time and space.

[techker]

true..how can i liste all the clients?

 

i would like to send and email to the expired clients?i can't use mail function cause my server has bloqued it..smtp only?

[techker]

i can list with

 

foreach ($row2 as &$value) {
    echo $value ;
}

im thinking i can send the information from there?but value gives me all the clients info

[Barand]

SELECT ...

FROM ...

WHERE DateServices < CURDATE()

[techker]

the selection of the clients is done like in my first post,

 

i setled the insert in new database not doing since they are alreay there..

 

i would like to update the databse mark all expired clients with a flag.

 

so i need to loop tru all the clients expired and update there profile with an expired flag

 

that part im confused

[Barand]

The date field is already your expiry flag. If it's less than today, it's expired.

 

You do insist on creating unnecessary work, don't you!

[techker]

true..

 

but how can i take that data and send it to an admin email saying all these clients are expirerd?i want to automate it..

[Barand]

SELECT ...

FROM ...

WHERE DateServices < CURDATE()