All Orders

0) { $i = 0; while ($order_request = mysqli_fetch_array($result_orders_request)) { $sql = "select * from quality where quality_id = " . $order_request['quality_id'] . ""; $match_quality = mysqli_query($link, $sql); $row_quality_data = $match_quality->fetch_assoc(); $sql2 = "select * from buyer where buyer_id = " . $order_request['buyer_id'] . ""; $match_buyer = mysqli_query($link, $sql2); $row_buyer_data = $match_buyer->fetch_assoc(); $sql3 = "select * from seller where seller_id = " . $order_request['seller_id'] . ""; $match_seller = mysqli_query($link, $sql3); $row_seller_data = $match_seller->fetch_assoc(); $i++; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; // echo ""; if ($order_request['order_status'] == 'Processing') { echo ""; } else if ($order_request['order_status'] == 'Delivered') { echo ""; } else if ($order_request['order_status'] == 'Confirmed') { echo ""; } echo ""; } } else { echo ""; echo ""; echo ""; } ?>
No  Order ID  Enquiry ID  Proposal ID  Buyer Name  Seller Name  Quality Name   Quality Image   Quantity  Price  Payment Days  Payment Status  Order Status 
" . $i . "" . $order_request['order_id'] . "" . $order_request['enquiry_id'] . "" . $order_request['proposal_id'] . "" . $row_buyer_data['buyer_name'] . "" . $row_seller_data['seller_name'] . "" . $row_quality_data['quality_name'] . "image" . $order_request['quantity_num'] . "" . $order_request['final_price'] . "" . $order_request['payment_days'] . "" . $order_request['payment_status'] . "" . $order_request['order_status'] . "" . $orders_request['order_status'] . "" . $order_request['order_status'] . "" . $order_request['order_status'] . "" . $order_request['order_status'] . "
Order is Not Found
0) { $i = 0; while ($order_request = mysqli_fetch_array($result_orders_request)) { $sql = "select * from quality where quality_id = " . $order_request['quality_id'] . ""; $match_quality = mysqli_query($link, $sql); $row_quality_data = $match_quality->fetch_assoc(); $sql2 = "select * from buyer where buyer_id = " . $order_request['buyer_id'] . ""; $match_buyer = mysqli_query($link, $sql2); $row_buyer_data = $match_buyer->fetch_assoc(); $sql3 = "select * from seller where seller_id = " . $order_request['seller_id'] . ""; $match_seller = mysqli_query($link, $sql3); $row_seller_data = $match_seller->fetch_assoc(); $i++; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; // echo ""; if ($order_request['order_status'] == 'Processing') { echo ""; } else if ($order_request['order_status'] == 'Delivered') { echo ""; } else if ($order_request['order_status'] == 'Confirmed') { echo ""; } echo ""; } } else { echo ""; echo ""; echo ""; } ?>
No  Order ID  Enquiry ID  Proposal ID  Buyer Name  Seller Name  Quality Name   Quality Image   Quantity  Price  Payment Days  Payment Status  Order Status 
" . $i . "" . $order_request['order_id'] . "" . $order_request['enquiry_id'] . "" . $order_request['proposal_id'] . "" . $row_buyer_data['buyer_name'] . "" . $row_seller_data['seller_name'] . "" . $row_quality_data['quality_name'] . "image" . $order_request['quantity_num'] . "" . $order_request['final_price'] . "" . $order_request['payment_days'] . "" . $order_request['payment_status'] . "" . $order_request['order_status'] . "" . $orders_request['order_status'] . "" . $order_request['order_status'] . "" . $order_request['order_status'] . "" . $order_request['order_status'] . "
Order is Not Found
0) { $i = 0; while ($order_request = mysqli_fetch_array($result_orders_request)) { $sql = "select * from quality where quality_id = " . $order_request['quality_id'] . ""; $match_quality = mysqli_query($link, $sql); $row_quality_data = $match_quality->fetch_assoc(); $sql2 = "select * from buyer where buyer_id = " . $order_request['buyer_id'] . ""; $match_buyer = mysqli_query($link, $sql2); $row_buyer_data = $match_buyer->fetch_assoc(); $sql3 = "select * from seller where seller_id = " . $order_request['seller_id'] . ""; $match_seller = mysqli_query($link, $sql3); $row_seller_data = $match_seller->fetch_assoc(); $i++; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; // echo ""; if ($order_request['order_status'] == 'Processing') { echo ""; } else if ($order_request['order_status'] == 'Delivered') { echo ""; } else if ($order_request['order_status'] == 'Confirmed') { echo ""; } echo ""; } } else { echo ""; echo ""; echo ""; } ?>
No  Order ID  Enquiry ID  Proposal ID  Buyer Name  Seller Name  Quality Name   Quality Image   Quantity  Price  Payment Days  Payment Status  Order Status 
" . $i . "" . $order_request['order_id'] . "" . $order_request['enquiry_id'] . "" . $order_request['proposal_id'] . "" . $row_buyer_data['buyer_name'] . "" . $row_seller_data['seller_name'] . "" . $row_quality_data['quality_name'] . "image" . $order_request['quantity_num'] . "" . $order_request['final_price'] . "" . $order_request['payment_days'] . "" . $order_request['payment_status'] . "" . $order_request['order_status'] . "" . $orders_request['order_status'] . "" . $order_request['order_status'] . "" . $order_request['order_status'] . "" . $order_request['order_status'] . "
Order is Not Found
0) { $i = 0; while ($order_request = mysqli_fetch_array($result_orders_request)) { $sql = "select * from quality where quality_id = " . $order_request['quality_id'] . ""; $match_quality = mysqli_query($link, $sql); $row_quality_data = $match_quality->fetch_assoc(); $sql2 = "select * from buyer where buyer_id = " . $order_request['buyer_id'] . ""; $match_buyer = mysqli_query($link, $sql2); $row_buyer_data = $match_buyer->fetch_assoc(); $sql3 = "select * from seller where seller_id = " . $order_request['seller_id'] . ""; $match_seller = mysqli_query($link, $sql3); $row_seller_data = $match_seller->fetch_assoc(); $i++; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; // echo ""; if ($order_request['order_status'] == 'Processing') { echo ""; } else if ($order_request['order_status'] == 'Delivered') { echo ""; } else if ($order_request['order_status'] == 'Confirmed') { echo ""; } echo ""; } } else { echo ""; echo ""; echo ""; } ?>
No  Order ID  Enquiry ID  Proposal ID  Buyer Name  Seller Name  Quality Name   Quality Image   Quantity  Price  Payment Days  Payment Status  Order Status 
" . $i . "" . $order_request['order_id'] . "" . $order_request['enquiry_id'] . "" . $order_request['proposal_id'] . "" . $row_buyer_data['buyer_name'] . "" . $row_seller_data['seller_name'] . "" . $row_quality_data['quality_name'] . "image" . $order_request['quantity_num'] . "" . $order_request['final_price'] . "" . $order_request['payment_days'] . "" . $order_request['payment_status'] . "" . $order_request['order_status'] . "" . $orders_request['order_status'] . "" . $order_request['order_status'] . "" . $order_request['order_status'] . "" . $order_request['order_status'] . "
Order is Not Found