LAMP Project- Receipts

Here is the receipt you requested
Query: $query

\n"); include ('em_config.php'); $db_link = new mysqli($db_server, $db_user, $db_password, $db_name); if ($db_link->connect_errno) { print( "Failed to connect to MySQL: (" .$db_link->connect_errno . ") ".$db_link->connect_error); } /* print("

Connection: ".$db_link->host_info . "
\n"); */ /* print( nl2br("Connected successfully\n")); */ $result = mysqli_query($db_link,$query); $result2 = mysqli_query($db_link,$query2); $total = mysqli_fetch_array($result2); print("

\n "); while ($tableRow = mysqli_fetch_array($result)) { print("\t\n"); print("\t\t\n"); print("\t\t\n"); print("\t\t\n"); print("\t\t\n"); print("\t\t\n"); print("\t\t\n"); print("\t\t\n"); print("\t\t\n"); print("\t\n"); } print("
Transaction ID Customer Date Item Item Price Quantity Total Price Image
$tableRow[0]$tableRow[1]$tableRow[2]$tableRow[3]$tableRow[4]$tableRow[5]$tableRow[6]$tableRow[7]
\n"); print("


The total sale price of this transaction was: \$$total[0]

"); /* Free resultset */ mysqli_free_result($result); /* Closing connection */ mysqli_close($db_link); ?>