|
Server IP : 82.112.239.40 / Your IP : 18.217.142.228 Web Server : LiteSpeed System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.35.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 4 05:23:43 EDT 2025 x86_64 User : u641149403 ( 641149403) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u641149403/domains/cabz4you.com/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
date_default_timezone_set("Asia/Kolkata");
require_once 'lib/core.php';
$date = date('Y-m-d h:i:s');
$query=$conn->query("SELECT *,membership_log.status as status FROM membership_log LEFT JOIN vendor_profile ON membership_log.vendor_id=vendor_profile.vendor_id LEFT JOIN vendor_login ON membership_log.vendor_id=vendor_login.id LEFT JOIN membership ON membership_log.membership_id=membership.id WHERE end<'$date' AND membership_log.status=1");
echo mysqli_num_rows($query);
while($res = mysqli_fetch_array($query)) {
$vendor_id=$res['vendor_id'];
$sql=$conn->query("UPDATE membership_log SET status=0 WHERE vendor_id='$vendor_id'");
if ($sql) {
$msg = "Hi, ".$res['full_name'].".
Your membership has been expired.
Start using our services.
For any query contact 24x7
7830530004 7060000113 7830530005
Thanks & Regards
Cabz4you.";
whatsapp($res['contact'],$msg);
echo "update";
}else{
echo 'Not Update';
}
}