function checkout()
{
global $connect;
$ossz_ar = 0;
$termek_szam = 0;
$idopont = date('Y') . '/' . date('m') . '/' . date('d');
foreach ($_SESSION['cart']['items'] as $key => $value) {
$termek_szam++;
$ossz_ar += $value['ar'];
}
$fsql = 'INSERT INTO rendeles(email, idopont, ossz_ar, termek_szam)' . ' VALUES (:email, to_date(:idopont, \'yyyy/mm/dd\'), :ossz_ar, :termek_szam)';
$bQ = oci_parse($connect, $fsql);
oci_bind_by_name($bQ, ':email', $_SESSION['email']);
oci_bind_by_name($bQ, ':ossz_ar', $ossz_ar);
oci_bind_by_name($bQ, ':idopont', $idopont);
oci_bind_by_name($bQ, ':termek_szam', $termek_szam);
$i = 0;
$last = "SELECT * FROM rendeles WHERE rownum <= 1 ORDER BY rendeles_id DESC";
$stid = oci_parse($connect, $last);
if (!$stid) {
$e = oci_error($connect);
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$r = oci_execute($stid);
if (!$r) {
$e = oci_error($stid);
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS);
print_r($row);
foreach ($_SESSION['cart']['items'] as $key => $value) {
$i++;
$rs = 'UPDATE rendeles_reszletei set termek_id = ' . $value['id'] . ', darab_szam = 1, termek_ar = ' . $value['ar'] . ' where rendeles_id = ' . $row['RENDELES_ID'] . ' AND termek_id = ' . $i;
$rq = oci_parse($connect, $rs);
oci_execute($rq);
}
if (oci_execute($bQ)) {
clearcart();
$_SESSION['cart']['items'] = array();
//echo '<script type="text/javascript">window.location.href="../index.php";</script>';
}
}
/**
* Felhasználó bejelentkeztetését és a
* Session lekezelését elvégző metódus
*/
function login_check()
{
error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
session_start();
require_once "php/connection.php";
if (!$_POST["email"] || !$_POST["jelszo"]) {
$errorMessage = "Nem adtad meg az emailt/jelszot!";
header("location:../login.php?Error=" . $errorMessage);
} else {
$email = $_POST["email"];
$jelszo = $_POST["jelszo"];
$tbl_name = "felhasznalo";
$sql = oci_parse($connect, "select * from felhasznalo where email = '" . addslashes($_POST["email"]) . "' and jelszo = '" . addslashes($_POST["jelszo"]) . "'");
oci_execute($sql);
while ($row = oci_fetch_array($sql, OCI_BOTH)) {
$_SESSION['email'] = $row[0];
$_SESSION['nev'] = $row[2];
$_SESSION['szul_ido'] = $row[3];
$_SESSION['telefon'] = $row[5];
$_SESSION['egyenleg'] = $row[6];
$_SESSION['reg_datum'] = $row[7];
$_SESSION['torzsvasarlo'] = $row[8];
}
require_once 'cart.php';
clearcart();
$_SESSION['cart']['items'] = array();
if ($_SESSION['email']) {
$tipus = "felhasznalo";
$_SESSION['tipus'] = $tipus;
header("Location:profile.php");
} else {
echo '<script type="text/javascript">
alert("Hibás email/jelszó ");
window.location.href="/netshop/login.php";</script>';
}
}
}
