echo $confirm_headline1;
?>
</div>
<br />
<div id="cartOverview">
<div class="subheader cyan"><?php
echo $confirm_subheader1 . $transaction;
?>
</div>
<?php
$transaction = $_SESSION['transaction'];
//echo $transaction;
include 'db.php';
showCartByTransaction($transaction, "confirm", null);
?>
</div>
<div id="customerForm">
<?php
//print_r($_POST);
if (isset($_POST['fname'])) {
$fn = $_POST['fname'];
}
if (isset($_POST['lname'])) {
$ln = $_POST['lname'];
}
<?php
session_start();
include 'db.php';
$transaction = $_SESSION['transaction'];
$gender = $_GET["gender"];
$brand = $_GET["brand"];
$type = $_GET["type"];
$size = $_GET["size"];
$mysqli = connectDB();
$abfrage = "SELECT c.id, g.Name, b.Name, t.Name, s.Name, c.Brand, c.Size, c.Type, c.Gender, c.Price FROM Clothes c\n JOIN Gender g ON c.Gender=g.id\n JOIN Brand b ON c.Brand =b.id\n JOIN Type t ON c.Type =t.id\n JOIN Size s ON c.Size=s.id\n WHERE LEFT(g.Name,1) = '" . substr($gender, 0, 1) . "'\n AND LEFT(b.Name,4) = '" . substr($brand, 0, 4) . "'\n AND LEFT(t.Name,1) = '" . substr($type, 0, 1) . "'\n AND s.Name='{$size}'\n ";
//echo $abfrage;
$ergebnis = $mysqli->query($abfrage);
while ($row = $ergebnis->fetch_object()) {
$clothId = $row->id;
$brandId = $row->Brand;
$sizeId = $row->Size;
$typeId = $row->Type;
$genderId = $row->Gender;
$price = $row->Price;
break;
}
// TODO: change here to insert prices/clothes along with to new table layout
// INSERT
$insert = "INSERT INTO Transactions_Clothes\n\t\t\t\t(fk_Transactions, fk_Clothes, Brand, Size, Type, Gender, Price)\n\t\t\t\tVALUE ({$transaction}, {$clothId}, {$brandId}, {$sizeId}, {$typeId}, {$genderId}, {$price})";
//echo $insert;
$mysqli->query($insert);
echo showCartByTransaction($transaction, "cart", $mysqli);
$mysqli->close();
</a>
</div>
<div id="cart" class="selcolumnCart">
<div class="subheader cyan">
<?php
echo $sell_subheader1;
?>
<img src="images/sellcart.png" id="cartHeaderImg" />
</div>
<div id="cartList">
<?php
$transaction = $_SESSION['transaction'];
//echo $transaction;
//echo "<br />";
showCartByTransaction($transaction, "sell", null);
?>
</div>
</div>
</div>
</div>
<br />
<div class="background" id="bkg_brandList" style="visibility: hidden;">
echo $cartOverview_subheader1 . $transaction;
?>
</div>
<br />
<br />
<?php
$firstName = "";
$lastName = "";
$email = "";
$transaction = $_SESSION['transaction'];
//print_r($_SESSION);
if (isset($transaction)) {
//echo "Transaction number:" . $transaction;
include 'db.php';
echo "<div id='cartList'>";
showCartByTransaction($transaction, "overview", null);
echo "</div>";
$mysqli = connectDB();
//$abfrage = "INSERT INTO Transactions (id, Status)
// VALUES ($transaction, 'InCart')";
// mysql_query($abfrage);
// Set predefined Values if existing
$abfrage = "SELECT * FROM Transactions\n\t\t\t\t\t\tWHERE id={$transaction}";
$ergebnis = $mysqli->query($abfrage);
while ($row = $ergebnis->fetch_object()) {
$firstName = $row->FirstName;
$lastName = $row->LastName;
$email = $row->Email;
}
$mysqli->close();
} else {
<?php
session_start();
include 'db.php';
$transaction = $_SESSION['transaction'];
$removeId = $_GET["remove"];
$mysqli = connectDB();
$delete = "DELETE FROM Transactions_Clothes\n\t\t\t\tWHERE Id={$removeId}";
$mysqli->query($delete);
$mysqli->close();
echo showCartByTransaction($transaction, "remove", null);
</a>
</div>
<div id="cart" class="selcolumnCart">
<div class="subheader cyan">
<?php
echo $sell_subheader1;
?>
<img src="images/sellcart.png" id="cartHeaderImg" />
</div>
<div id="cartList">
<?php
$transaction = $_SESSION['transaction'];
//echo $transaction;
//echo "<br />";
showCartByTransaction($transaction, "sell");
?>
</div>
</div>
</div>
</div>
<br />
<div class="background" id="bkg_brandList" style="visibility: hidden;">
