0){
while ($search = mysqli_fetch_array($search_q, MYSQLI_ASSOC)){
$sel_user = mysqli_query($conn, "select * from shop_user where user_id='$search[userid]'");
$sel_users = mysqli_fetch_array($sel_user, MYSQLI_ASSOC);
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search_id.'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search_id.'';
}else{
$status = 'Unknown';
$link = $search_id;
}
$tr.='| '.$link.' | '.$sel_users['name'].' | '.$sel_users['country'].
' | '.$sel_users['state'].' | '.$sel_users['phone'].' | '.$status.' |
';
}
echo $tr;
}else{
echo 2;
}
}else{
$search_q = mysqli_query($conn, "SELECT * FROM tbl_confirmorder tb INNER JOIN shop_user su ON tb.userid = su.user_id WHERE su.phone like '%$search_id%' and tb.orderstatus!=10
union SELECT * FROM tbl_confirmorder tb INNER JOIN shop_user su ON tb.userid = su.user_id WHERE tb.dif_phone like '%$search_id%' and tb.orderstatus!=10");
$search_rows = mysqli_num_rows($search_q);
if($search_rows > 0){
while ($search = mysqli_fetch_array($search_q, MYSQLI_ASSOC)){
$sel_user = mysqli_query($conn, "select * from shop_user where user_id='$search[userid]'");
$sel_users = mysqli_fetch_array($sel_user, MYSQLI_ASSOC);
if($search['orderstatus']=="")
{
$status="New Order";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="1")
{
$status="Confirmed";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="5")
{
$status="Packing";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="15")
{
$status="Ready to Dispatch";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="2")
{
$status="Dispatched";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="3")
{
$status="Delivered";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="4")
{
$status="Cancelled";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="0")
{
$status="New";
$link = ''.$search['refid'].'';
}elseif($search['orderstatus']=="24")
{
$status="Returned";
$link = ''.$search['refid'].'';
}else{
$status = 'Unknown';
$link = $search['refid'];
}
$tr.='| '.$link.' | '.$sel_users['name'].' | '.$sel_users['country'].
' | '.$sel_users['state'].' | '.$sel_users['phone'].' | '.$status.' |
';
}
echo $tr;
}else{
echo 2;
}
}
?>