File manager - Edit - /home/autoph/public_html/portal/includes/update_birthdays.php
Back
<?php echo "<center><div style='left:350px;padding:15px;position:absolute;top:220px;width:300px;height:100px;border:1px solid gray;border-radius:5px;z-index:999999999999999;padding-top:40px;' class='lightGradient'>"; $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1'"); $num_rows = mysql_num_rows($qq); while($row=mysql_fetch_assoc($qq)){ $i++; $percent = intval($i/$num_rows * 100)."%"; $id = $row['id']; $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); mysql_query("UPDATE `talents_profile` SET `age` ='$newAge' WHERE `id`='$id'"); } if($num_rows = $i){ echo "Refreshing Database.... Process ".$percent." Complete.<br><br>".$i. " Records has been updated...<br><br><a href='main_new.php?view=&sid=db&sview=&tab=0#id-0'> <input type='button' name='close' class='button' value='Close' style='width:50px;'></a>"; }else { echo "Refreshing Database....". $percent; } echo "</div></center>"; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings