bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?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";
}