Example #1
0
    } else {
        $output .= "\"Cancel Offer\">";
    }
    $output .= "</form>";
    echo $output;
}
?>
	<h1 class="h1_spacing">Purchased Books:</h1>
	<br />
	<?php 
$query = "SELECT * ";
$query .= "FROM buy ";
$query .= "WHERE buyer_id = {$user_id}";
$buy_set = mysqli_query($connection, $query);
while ($buy_order = mysqli_fetch_assoc($buy_set)) {
    $sell_id = $buy_order["sell_id"];
    $query = "SELECT * ";
    $query .= "FROM sell ";
    $query .= "WHERE id = {$sell_id}";
    $sell_set = mysqli_query($connection, $query);
    while ($sell_order = mysqli_fetch_assoc($sell_set)) {
        echo print_book_details_for_sales($sell_order);
    }
    //print some book details
}
?>
</div>
</body>
</html>
<?php 
ob_end_flush();
Example #2
0
 $user_set = mysqli_query($connection, $query);
 while ($user = mysqli_fetch_assoc($user_set)) {
     $convo_partner = $user["username"];
     //pull out the name
     $header_output .= $convo_partner;
 }
 $header_output .= "</h1>";
 $header_output .= $output2;
 $sell_id = $messages["sell_id"];
 //use the id from the "sell" database to know which selling order is being discussed
 $query = "SELECT * ";
 $query .= "FROM sell ";
 $query .= "WHERE id = {$sell_id}";
 $sell_set = mysqli_query($connection, $query);
 while ($sell_order = mysqli_fetch_assoc($sell_set)) {
     $header_output .= print_book_details_for_sales($sell_order);
 }
 $buyer_name = "";
 $buyer_id = $messages["buyer_id"];
 $seller_name = "";
 $seller_id = $messages["seller_id"];
 $query = "SELECT * ";
 $query .= "FROM users ";
 $query .= "WHERE id = {$buyer_id} ";
 $query .= "LIMIT 1";
 $buyer_set = mysqli_query($connection, $query);
 while ($buyer = mysqli_fetch_assoc($buyer_set)) {
     //extract the name of the buyer
     $buyer_name = $buyer["username"];
 }
 $query = "SELECT * ";