get("select * from service order by is_featured desc");
if(isset($_GET["payment_id"]) && !empty($_GET["payment_id"])) {
$order_id = $_GET["payment_id"];
$q_order = $db->get("select * from payment_order where order_id = '".$order_id."'");
$q_order_row = mysqli_fetch_object($q_order);
$q_order_items = $db->get("select * from order_item oi
inner join image i on oi.item_image_id = i.image_id
inner join service s on oi.item_service_id = s.service_id
where item_order_id = '".$order_id."'
group by i.image_id");
$q_all_order_items = $db->get("select * from order_item oi
inner join image i on oi.item_image_id = i.image_id
inner join service s on oi.item_service_id = s.service_id");
}
if(isset($_GET["user_id"]) && !empty($_GET["user_id"])) {
$user_id = $_GET["user_id"];
$q_user = $db->get("select * from user where user_id = '".$user_id."'");
$q_user_row = mysqli_fetch_object($q_user);
}
?>
';
}
unset($_SESSION["error"]);
}
if(isset($_SESSION["success"]))
{
echo '
'; unset($_SESSION["success"]); } ?>
'; } echo ''; ?>
01
Images
02
Contact
03
Payment
' .$e. '
' .$_SESSION["success"]. '
'; unset($_SESSION["success"]); } ?>
'; } echo ''; ?>
Review your order and
Proceed to payment
USER DETAILS
Name: '.$q_user_row->first_name.' '.$q_user_row->last_name.''; ?>
Email: '.$q_user_row->email.''; ?>
Phone: '.$q_user_row->phone_number.''; ?>
image_location).'"/>
SERVICES
';
$services_for_image = $db->get("select * from order_item oi
inner join image i on oi.item_image_id = i.image_id
inner join service s on oi.item_service_id = s.service_id
where i.image_id = '".$q_order_items_row->item_image_id."'");
$description = "";
for($i = 1; $i <= $services_for_image->num_rows; $i++){
$result = $services_for_image->fetch_object();
$description .= $result->service_name.' ($'.$result->item_amount.'), ';
echo ' '.$i.''.$result->service_name.' - $'.$result->item_amount.' per image';
}
echo '
Total price: order_amount; ?>