function __construct()
{
$this->Conn = new mysqli('127.0.0.1', 'root', '', "tpsshop");
if (mysqli_connect_errno()) {
die("<p>Unable to connect to database.</p>" . "<p>Error code " . Mysqli_connect_errno() . ": " . mysqli_connect_errno()) . "</p>";
}
}
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="http://fonts.googleapis.com/css?family=Source+Sans+Pro:200,300,400,600,700,900" rel="stylesheet" />
<link href="default.php" rel="stylesheet" type="text/css" media="all" />
<link href="fonts.php" rel="stylesheet" type="text/css" media="all" />
<!--[if IE 6]>
<link href="default_ie6.css" rel="stylesheet" type="text/css" />
<![endif]-->
</head>
<?php
session_start();
$Conn = new mysqli('127.0.0.1', 'root', '', "tpsshop");
if (mysqli_connect_errno()) {
die("<p>Unable to connect to database.</p>" . "<p>Error code " . Mysqli_connect_errno() . ": " . mysqli_connect_errno()) . "</p>";
}
$UpdQtySQL = "UPDATE orders SET status=1 WHERE id=" . $_SESSION['SESS_ORDERNUM'] . ";";
// update TOTAL in Oreder Table
@mysqli_query($Conn, $UpdQtySQL) or die(mysql_error());
$sql = "DELETE FROM orderitems WHERE order_id = " . $_SESSION['SESS_ORDERNUM'];
$del = mysqli_query($Conn, $sql) or die(mysql_error());
?>
<body>
<?php
require 'header.php';
?>
//'User has orders create orderitems for him';
$itemsql = "INSERT INTO orderitems(order_id,product_id, quantity) VALUES(" . $_SESSION['SESS_ORDERNUM'] . ", " . $_GET['id'] . ", " . $_POST['amountBox'] . ")";
@mysqli_query($Conn, $itemsql) or die(mysql_error());
//echo "<p>ITEM ALREADY EXIST</p>"; // update the current quantity
$totalprice = $prodrow['price'] * $_POST['amountBox'];
// multiply quantity
$UpdQtySQL = "UPDATE orders SET total = total + " . $totalprice . " WHERE id = " . $_SESSION['SESS_ORDERNUM'] . ";";
// update TOTAL in Oreder Table
@mysqli_query($Conn, $UpdQtySQL) or die(mysql_error());
}
header("Location: " . $config_basedir . "showcart.php");
} else {
if (isset($_SESSION['SESS_LOGGEDIN'])) {
//'User dont have orders create an order for him';
$OrderSQL = "INSERT INTO orders(customer_id,status, date) VALUES(" . $_SESSION['SESS_USERID'] . ", 0, NOW())";
$QueryResult = @mysqli_query($Conn, $OrderSQL) or die("<p>Unable to create order.</p>" . "<p>Error code " . Mysqli_connect_errno() . ": " . mysqli_connect_errno()) . "</p>";
// select the order id and then create oder itemsql
// one process as i did for the login
$PrderSQL = "SELECT id FROM orders WHERE customer_id = " . $_SESSION['SESS_USERID'] . " AND status = 0";
// create an order if necessary
$OrderQueryResult = @mysqli_query($Conn, $PrderSQL);
$numrows = mysqli_num_rows($OrderQueryResult);
if ($numrows != 0) {
$orderrow = mysqli_fetch_assoc($OrderQueryResult);
$_SESSION['SESS_ORDERNUM'] = $orderrow['id'];
$itemsql = "INSERT INTO orderitems(order_id,product_id, quantity) VALUES(" . $_SESSION['SESS_ORDERNUM'] . ", " . $_GET['id'] . ", " . $_POST['amountBox'] . ")";
@mysqli_query($Conn, $itemsql) or die(mysql_error());
$totalprice = $prodrow['price'] * $_POST['amountBox'];
// multiply quantity
$UpdSQL = "UPDATE orders SET total = total + " . $totalprice . " WHERE id = " . $_SESSION['SESS_ORDERNUM'] . ";";
@mysqli_query($Conn, $UpdSQL) or die(mysql_error());