0) { // $challan_request = mysqli_fetch_array($result_challan_request); $product_request = $result_product_request->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 '
Invoice # INV/2023 Demo Copy

Nexriseworld for you Bill Online

Order Date: ' . $product_request['order_date'] . '
Account:Nexriseworld for you Nexriseworld for you
bar code
Description Amount
Product Name:'.$row_product_data['product_name'].'
Size:'.$row_size_data['size_value'].'
Color:'.$row_color_data['color_value'].'		 Rs.' . $attribute_request['sale_price'] . '
No of Quantity
 *' . $product_request['qty'] . '
Total Payable Amount
Fix Charges		 Rs.' . $product_request['order_subtotal'] . '.00
Signature and Stamp NEXRISEWORLD HEAD


'; } else { echo 'Not Found'; } ?>