|
Server IP : 82.112.239.40 / Your IP : 18.225.98.59 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
require_once 'lib/core.php';
$current_time=date('Y-m-d H:i:s');
$sql="SELECT bookings.*,bookings.id as bk_id,payment_log.txn_amount,payment_log.booking_id,users.* FROM bookings LEFT JOIN payment_log ON payment_log.booking_id=bookings.id LEFT JOIN users ON users.id=bookings.user_id WHERE bookings.status='vendor_pass' AND TIMESTAMP(`pickup_date`, `pickup_time`)<'$current_time' ORDER BY bookings.pickup_date DESC";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
// $sql=$conn->query("update bookings set status='cancelled' where status='vendor_pass' AND TIMESTAMP(`pickup_date`, `pickup_time`)<'$current_time' limit 100");
// $sql=$conn->query("update bookings set status='completed' where id='".$row['bk_id']."'");
}
echo $result->num_rows;
// if ($type=='expired') {
// $sql=$conn->query("update bookings set status='cancelled' where id='".$row['id']."' limit 100");
// }
?>