0) { while ($product_request = mysqli_fetch_array($result_product_request)) { // $sql = "select * from category where category_id = " . $product_request['category_id'] . " "; // $match_category = mysqli_query($link, $sql); // $row_category_data = $match_category->fetch_assoc(); // $sql2 = "select * from sub_category where sub_category_id = " . $product_request['sub_category_id'] . " "; // $match_sub_category = mysqli_query($link, $sql2); // $row_sub_category_data = $match_sub_category->fetch_assoc(); $sql3 = "select * from products where product_id = " . $product_request['product_id'] . " "; $match_product = mysqli_query($link, $sql3); $row_product_data = $match_product->fetch_assoc(); $sql6 = "select * from product_attributes where attribute_id = " . $product_request['attribute_id'] . " "; $match_p = mysqli_query($link, $sql6); $attribute_request = $match_p->fetch_assoc(); $sql4 = "select * from color where color_id = " . $attribute_request['color_id'] . " "; $match_product_attribute = mysqli_query($link, $sql4); $row_color_data = $match_product_attribute->fetch_assoc(); $sql5 = "select * from size where size_id = " . $attribute_request['size_id'] . " "; $match_product_attribute = mysqli_query($link, $sql5); $row_size_data = $match_product_attribute->fetch_assoc(); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ($row_product_data['product_image_1'] != null) { echo ""; } else { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // echo ""; if ($product_request['order_status'] == 'Processing') { echo ""; } else if ($product_request['order_status'] == 'Delivered') { echo ""; } else if ($product_request['order_status'] == 'Confirmed') { echo ""; } echo ""; echo ""; // echo ''; echo ""; } } else { echo ""; echo ""; echo ""; } ?>

No	Order ID	User ID	Attribute ID	Product ID	Product Type	Product Name	Product Image	Size	Color	Order Date	Quantity	Total Billing Amount	First Name	Last Name	Address	City	State	Pincode	Contact No	Email ID	Order Status	Change Status	Action
" . $i++; "	" . $product_request['order_id'] . "	" . $product_request['user_id'] . "	" . $product_request['attribute_id'] . "	" . $product_request['product_id'] . "	" . $row_product_data['product_type'] . "	" . $row_product_data['product_name'] . "			" . $row_size_data['size_value'] . "	" . $row_color_data['color_value'] . "	" . $product_request['order_date'] . "	" . $product_request['qty'] . "	₹" . $product_request['order_subtotal'] . "	" . $product_request['first_name'] . "	" . $product_request['last_name'] . "	" . $product_request['street_address'] . "	" . $product_request['city'] . "	" . $product_request['state'] . "	" . $product_request['pincode'] . "	" . $product_request['contactno'] . "	" . $product_request['email_id'] . "	" . $product_request['order_status'] . "	" . $product_request['order_status'] . "	" . $product_request['order_status'] . "	" . $product_request['order_status'] . "	"; if ($product_request['order_status'] == 'Processing') { ?> Processing Processing Delivered Delivered Confirmed Confirmed  Edit	View Bill	// // // // // // //
order is Not Found