public function getProducts()
{
$db_handle = new DBController();
$conn = $db_handle->connectDB();
$results = $db_handle->runQuery($conn, "SELECT * FROM tblproduct ORDER BY id ASC");
return $results;
}
//incrementing cat_id
echo '</a>';
echo '</div>';
}
echo '</div>';
echo '</div>';
?>
</div>
<div class="results_menu_details">
<div class="txt-heading"></div>
<?php
//Change id to dynamic value
//$res_id = $_POST['res_id'];
$product_array = $db_handle->runQuery("SELECT * FROM khanaman.km_restr_menu where res_id={$res_id} order by itm_typ");
$curr_typ = "";
$prev_typ = "";
if (!empty($product_array)) {
foreach ($product_array as $key => $value) {
?>
<?php
$curr_typ = $product_array[$key]["itm_typ"];
if ($curr_typ != $prev_typ) {
?>
<div class="for_item_heading"><a name="<?php
echo $product_array[$key]["itm_typ"];
?>
">
<div class="container">
<!-- Page Header -->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">The Music
<small>I LOVE</small>
</h1>
</div>
</div>
<!-- /.row -->
<!-- Projects Row -->
<!-- <div class="row"> -->
<?php
$music_array = $db_handle->runQuery("SELECT * FROM music ORDER BY music_id ASC");
if (!empty($music_array)) {
foreach ($music_array as $key => $value) {
?>
<!-- <div class="row"> -->
<div class="col-md-4 portfolio-item">
<a href="#">
<!-- <img class="img-responsive" src="http://placehold.it/700x400" alt=""> -->
<!-- <iframe width="350" height="200" src="https://www.youtube.com/embed/fzxag7U3Snk?rel=0&controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe> -->
<?php
echo $music_array[$key]["youtube"];
?>
</a>
<h3>
<!-- <a href="https://itunes.apple.com/album/crazy-single/id794455910" target="_blank">Gnarls Barkley - Crazy (Cover) by Daniela Andrade</a> -->
<a href="<?php
<?php
session_start();
if (isset($_SESSION["username"])) {
header("location:home.php");
exit;
}
require_once "dbcontroller.php";
$db_handle = new DBController();
$conn = $db_handle->connectDB();
$error = "";
if (isset($_POST['username']) && isset($_POST['password'])) {
$username = mysqli_real_escape_string($conn, $_POST['username']);
$password = mysqli_real_escape_string($conn, $_POST['password']);
$query = $db_handle->runQuery("SELECT id,username,password FROM doctor where username='******' and password='******'");
if (!empty($query)) {
$_SESSION["id"] = $query[0]['id'];
$_SESSION["username"] = $query[0]['username'];
header("location:home.php");
exit;
} else {
$error = "Invalud username or password";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>login</title>
<style media="screen">
<?php
require_once 'dbcontroller.php';
session_start();
$dbcontroller = new DBController();
$cedula = $_POST['cedula'];
$password = $_POST['password'];
//$cedula = "3cdbLK2vl7mP";
//$password = "******";
$query = "CALL login_usuario('" . $cedula . "', '" . $password . "');";
$resultArray = $dbcontroller->runQuery($query);
if (!empty($resultArray)) {
# code...
$_SESSION['username'] = $cedula;
echo true;
} else {
echo false;
}
<?php
require_once 'dbcontroller.php';
$dbcontroller = new DBController();
$cedula = $_POST['cedula'];
$nombre = $_POST['nombre'];
$edad = $_POST['edad'];
$sexo = $_POST['sexo'];
$correo = $_POST['correo'];
$password = $_POST['password'];
$carnet = $_POST['carnet'];
$anoCursante = $_POST['anoCursante'];
$activo = $_POST['activo'];
$existe1 = $dbcontroller->runQuery("Select Buscar_Cedula_Coordinador('" . $cedula . "') as resultado");
$existe2 = $dbcontroller->runQuery("Select Buscar_Cedula_Usuario('" . $cedula . "') as resultado");
$existeCarnet = $dbcontroller->runQuery("Select Buscar_Carnet_Estudiante('" . $carnet . "') as resultado");
// Si la cedula existe en el sistema o el carnet
if (($existe1['resultado'] == "1" || $existe2['resultado']) == "1" || $existeCarnet['resultado'] == "1") {
# code...
// No se va a poder registrar
echo false;
} else {
// Si esta disponible
# code...
$query = "CALL Insert_Estudiante('" . $cedula . "', '" . $nombre . "', " . $edad . ", '" . $sexo . "', '" . $correo . "', '" . $password . "', '" . $carnet . "', '" . $anoCursante . "', '" . $activo . "');";
$operation = $dbcontroller->runInsertQuery($query);
echo $operation;
}
<?php
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_POST["keyword"])) {
$query = "SELECT * FROM lokasi WHERE alamat like '" . $_POST["keyword"] . "%' ORDER BY alamat";
$result = $db_handle->runQuery($query);
if (!empty($result)) {
?>
<ul id="country-list">
<?php
foreach ($result as $lokasi) {
?>
<li onClick="selectAlamat('<?php
echo $lokasi["alamat"];
?>
');"><?php
echo $lokasi["alamat"];
?>
</li> <?php
}
?>
</ul> <?php
} else {
?>
<ul id="country-list">
<li onClick="selectAlamat('<?php
echo $lokasi["alamat"];
?>
');">rusak</li> <?php
<?php
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_POST["submit"])) {
$result = mysql_query("UPDATE contacts set name = '" . $_POST["name"] . "', phone1 = '" . $_POST["phone1"] . "', phone2 = '" . $_POST["phone2"] . "', email = '" . $_POST["email"] . "', notes = '" . $_POST["notes"] . "' WHERE id=" . $_GET["id"]);
if (!$result) {
$message = "Problem in Editing! Please Retry!";
} else {
echo "<script>alert('Contact Saved!');</script>";
echo "<script>window.location='index.php'</script>";
}
}
$result = $db_handle->runQuery("SELECT * FROM contacts WHERE id='" . $_GET["id"] . "'");
?>
<html>
<body>
<p><a href="index.php">Back</a></p>
</body>
</html>
<script>
function validate() {
var valid = true;
$(".demoInputBox").css('background-color','');
$(".info").html('');
if(!$("#name").val()) {
$("#name-info").html("(required)");
$("#name").css('background-color','#FFFFDF');
valid = false;
<?php
require_once "dbcontroller.php";
$db_handle = new DBController();
mysql_query("UPDATE usuarios set nome = '" . $_POST["nome"] . "', sobrenome = '" . $_POST["sobrenome"] . "', email = '" . $_POST["email"] . "', telefone = '" . $_POST["telefone"] . "', senha = '" . $_POST["senha"] . "' WHERE id=" . $_GET["id"]);
$result = $db_handle->runQuery("SELECT * FROM usuarios WHERE id='" . $_GET["id"] . "'");
?>
<td class="nome"><?php
echo $result[0]["nome"];
?>
</td>
<td class="sobrenome"><?php
echo $result[0]["sobrenome"];
?>
</td>
<td class="email"><?php
echo $result[0]["email"];
?>
</td>
<td class="telefone"><?php
echo $result[0]["telefone"];
?>
</td>
<td class="senha"><?php
echo $result[0]["senha"];
?>
</td>
<td class="action">
<a class="btnEditAction" onClick="showEdit(<?php
echo $_GET["id"];
?>
}
</style>
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_POST["action"])) {
switch ($_POST["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productByCode = $db_handle->runQuery("SELECT itm_name,itm_id,quantity,itm_price FROM khanaman.km_restr_menu WHERE itm_id='" . $_POST["itm_id"] . "'");
$itemArray = array($productByCode[0]["itm_id"] => array('itm_name' => $productByCode[0]["itm_name"], 'itm_id' => $productByCode[0]["itm_id"], 'quantity' => $_POST["quantity"], 'itm_price' => $productByCode[0]["itm_price"]));
if (!empty($_SESSION["cart_item"])) {
$code_value = $productByCode[0]["itm_id"];
$code_array = array('itm_id' => "");
foreach ($_SESSION["cart_item"] as $k => $v) {
array_push($code_array, $_SESSION["cart_item"][$k]["itm_id"]);
}
if (in_array($productByCode[0]["itm_id"], $code_array)) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productByCode[0]["itm_id"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] += $_POST["quantity"];
}
if ($_SESSION["cart_item"][$k]["quantity"] <= 0) {
if ($_POST["itm_id"] == $k) {
unset($_SESSION["cart_item"][$k]);
</strong>
</div>
<!--here for the change-->
<div class="col-sm-12">
<div class="tab-content" id="h4">
<div id="stud" class="tab-pane in active">
<div class="row">
<?php
ini_set('error_reporting', 0);
require_once "dbcontroller.php";
$db_handle = new DBController();
$query = "SELECT id,username FROM cc_users where username='******'";
$results = $db_handle->runQuery($query);
foreach ($results as $user_details) {
$user_id = $user_details['id'];
$user_name = $user_details['username'];
}
$query = "SELECT course_id, title FROM cc_courses INNER JOIN (select * from cc_course_registrations where user_id = '" . $user_id . "') AS cc ON cc_courses.id = cc.course_id";
$results = $db_handle->runQuery($query);
?>
<div><!--form start-->
<form action="" method="post" class="form-horizontal" role="form">
<div class="form-group">
<label class="col-sm-3 control-label no-padding-right" for="form-field-1">Select course</label>
<div class="col-sm-9">
<?php
require_once "__Globals.php";
require_once "admin/__dbcontroller.php";
$db_handle = new DBController();
$types = $db_handle->runQuery($GET_ALL_TB_TYPES);
$products = $db_handle->runQuery($GET_ALL_TB_PRODUCTS);
?>
<style>
div:empty:before {
content:attr(data-placeholder);
color:gray
}
</style>
<script type="text/javascript" charset="utf-8">
$(document).ready( function () {
</button>
</div>
<!-- <div class="col-md-offset-0 col-md-1">
<button class="btn" type="reset">
<i class="ace-icon fa fa-undo bigger-110"></i>
Reset
</button>
</div>-->
</form> </div>
<!--here only-->
<!--here--->
<?php
$db_handle = new DBController();
$query = "SELECT id,username FROM cc_users";
$results = $db_handle->runQuery($query);
if (isset($_POST['submit'])) {
//include('connect-db.php');
//$username = $_POST['username'];
//$user_id = $_POST['id'];
$course_name = $_POST['course_name'];
$problem_id = $_POST['problem_name'];
//$sql = " select id from cc_courses WHERE title= '$course_name'";
$sql = " SELECT course_id, title FROM cc_courses INNER JOIN (select * from cc_course_registrations ) AS cc ON cc_courses.id = cc.course_id where title='{$course_name}'";
$results = $db_handle->runQuery($sql);
//$result=mysql_query($sql) or die(mysql_error());
//while($row=mysql_fetch_array($result))
foreach ($results as $row) {
$course_id = $row['course_id'];
}
}
$id = $_GET['id'];
$sql = "SELECT * FROM wednesday WHERE productID = {$id}";
$rev = "SELECT * FROM reviews WHERE productID = {$id}";
$myData = mysql_query($sql, $con);
$myRev = mysql_query($rev, $con);
?>
<!--for cart-->
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_GET["action"])) {
switch ($_GET["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productBycode = $db_handle->runQuery("SELECT * FROM wednesday WHERE code='" . $_GET["code"] . "'");
$itemArray = array($productBycode[0]["code"] => array('productName' => $productBycode[0]["productName"], 'code' => $productBycode[0]["code"], 'quantity' => $_POST["quantity"], 'price' => $productBycode[0]["price"], 'productImage' => $productBycode[0]["productImage"]));
if (!empty($_SESSION["cart_item"])) {
if (in_array($productBycode[0]["code"], $_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productBycode[0]["code"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] = $_POST["quantity"];
}
}
} else {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
}
} else {
$_SESSION["cart_item"] = $itemArray;
}
}
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_GET["action"])) {
switch ($_GET["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productByCode = $db_handle->runQuery("SELECT * FROM khanaman.tblproduct WHERE code='" . $_GET["code"] . "'");
$itemArray = array($productByCode[0]["code"] => array('name' => $productByCode[0]["name"], 'code' => $productByCode[0]["code"], 'quantity' => $_POST["quantity"], 'price' => $productByCode[0]["price"]));
if (!empty($_SESSION["cart_item"])) {
if (in_array($productByCode[0]["code"], $_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productByCode[0]["code"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] = $_POST["quantity"];
}
}
} else {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
}
} else {
$_SESSION["cart_item"] = $itemArray;
}
}
break;
/*starts*/
/*starts*/
case "increase":
//if(empty($_SESSION["cart_item"])) {
// $_SESSION["cart_item"] = $itemArray;
<?php
include 'include/config.php';
?>
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_GET["action"])) {
switch ($_GET["action"]) {
case "add":
echo "adding";
if (!empty($_POST["quantity"])) {
$productByCode = $db_handle->runQuery("SELECT * FROM km_restr_menu WHERE item_id='" . $_POST["code"] . "'");
echo "{$productByCode}";
$itemArray = array($productByCode[0]["itm_id"] => array('itm_name' => $productByCode[0]["itm_name"], 'itm_id' => $productByCode[0]["itm_id"], 'quantity' => $_POST["quantity"], 'itm_price' => $productByCode[0]["itm_price"]));
if (!empty($_SESSION["cart_item"])) {
if (in_array($productByCode[0]["itm_id"], $_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productByCode[0]["itm_id"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] = $_POST["quantity"];
}
}
} else {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
}
} else {
$_SESSION["cart_item"] = $itemArray;
}
$nombre = $_POST['nombre'];
$edad = $_POST['edad'];
$password = $_POST['password'];
$sexo = $_POST['sexo'];
$correo = $_POST['correo'];
$posicionJerarquica = $_POST['posicionJerarquica'];
$nombreDepartamento = $_POST['nombreDepartamento'];
//$cedula = "2074s346";
//$nombre = "Miguel";
//$edad = 20;
//$password = "******";
//$sexo = 'h';
//$correo = "*****@*****.**";
//$posicionJerarquica = "Jefe";
//$nombreDepartamento = "Jefatura";
$existe1 = $dbcontroller->runQuery("Select Buscar_Cedula_Coordinador('" . $cedula . "') as resultado");
$existe2 = $dbcontroller->runQuery("Select Buscar_Cedula_Usuario('" . $cedula . "') as resultado");
$existe3 = $dbcontroller->runQuery("Select Buscar_Nombre_Departamento('" . $nombreDepartamento . "') as resultado");
// Si la cedula existe en el sistema
if (($existe1['resultado'] == "1" || $existe2['resultado']) == "1") {
# code...
// No se va a poder registrar
echo false;
} else {
// Si esta disponible
if ($existe3['resultado'] == "1") {
# code...
$query = "CALL Insert_Administrativo_Departamento_Existe('" . $cedula . "', '" . $nombre . "', " . $edad . ", '" . $sexo . "', '" . $correo . "', '" . $password . "', '" . $nombreDepartamento . "', '" . $posicionJerarquica . "');";
$operation = $dbcontroller->runInsertQuery($query);
echo $operation;
} else {
public $id = "";
public $username = "";
public $dob = "";
public $purchase = "";
}
class Purchase
{
public $id = "";
public $product_name = "";
public $purchase_date = "";
public $Cost = "";
}
$user = new User();
$purchase = new Purchase();
if (!empty($_GET["uid"]) && !empty($_GET["auth"])) {
$result = $db_handle->runQuery("SELECT * FROM user WHERE uid='" . $_GET["uid"] . "'");
$hash = $result[0]['auth_key'];
if ($_GET["auth"] == $hash) {
$user->id = $result[0]['uid'];
$user->username = $result[0]['username'];
$user->dob = $result[0]['dob'];
}
$uname = $result[0]['username'];
$purchase_result = $db_handle->runQuery("SELECT * FROM purchase WHERE uname='" . $uname . "'");
if (empty($purchase_result)) {
$user->purchase = $purchase;
$json_output = json_encode($user);
echo $json_output;
} else {
foreach ($purchase_result as $k => $v) {
$purchase->id = $purchase_result[$k]['pur_id'];
<?php
session_start();
$current_page_uri = $_SERVER['REQUEST_URI'];
$part_url = explode("/", $current_page_uri);
require_once "controller/dbcontroller.php";
$db_handle = new DBController();
$conn = $db_handle->connectDB();
if (!empty($_POST["action"])) {
switch ($_POST["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productByCode = $db_handle->runQuery($conn, "SELECT * FROM tblproduct WHERE code='" . $_POST["code"] . "'");
$itemArray = array($productByCode[0]["code"] => array('name' => $productByCode[0]["name"], 'code' => $productByCode[0]["code"], 'quantity' => $_POST["quantity"], 'price' => $productByCode[0]["price"]));
if (!empty($_SESSION["cart_item"])) {
if (in_array($productByCode[0]["code"], $_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productByCode[0]["code"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] = $_POST["quantity"];
}
}
} else {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
}
} else {
$_SESSION["cart_item"] = $itemArray;
}
}
break;
case "remove":
if (!empty($_SESSION["cart_item"])) {
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_GET["action"])) {
switch ($_GET["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productByid = $db_handle->runQuery("SELECT * FROM bakeryproducts WHERE id='" . $_GET["id"] . "'");
$itemArray = array($productByid[0]["id"] => array('name' => $productByid[0]["name"], 'id' => $productByid[0]["id"], 'quantity' => $_POST["quantity"], 'price' => $productByid[0]["price"]));
if (!empty($_SESSION["cart_item"])) {
if (in_array($productByid[0]["id"], $_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productByid[0]["id"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] = $_POST["quantity"];
}
}
} else {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
}
} else {
$_SESSION["cart_item"] = $itemArray;
}
}
break;
case "remove":
if (!empty($_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($_GET["id"] == $k) {
unset($_SESSION["cart_item"][$k]);
<?php
session_start();
require_once 'dbcontroller.php';
require_once 'controladorConsultas.php';
$dbcontroller = new DBController();
// Obtengo la información del usuario
$cedula = $_SESSION['username'];
// Obtengo las publicaciones que puede ver el usuario
$result = $dbcontroller->runQuery("call Ver_Publicaciones('{$cedula}')");
?>
<!-- Empiezo la lista de publicaciones -->
<ul>
<?php
if (is_iterable($result)) {
foreach ($result as $publicacion) {
# code...
?>
<li>
<article>
<center>
<header id="titulo"> <h4> <?php
echo $publicacion['TITULO_PUBLICACION'];
?>
</h4> </header> <br>
<section id="emisor"> <?php
echo $publicacion['EMISOR'];
?>
</section> <br>
<section id="destinatario"> <?php
</style>
<!-- js -->
<script type="text/javascript" src="../media_datatables/complete.js"></script>
<script type="text/javascript" src="../media_datatables/jquery.min.js"></script>
<script type="text/javascript" src="../media_datatables/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="../media_datatables/jquery.dataTables.editable.js"></script>
<script type="text/javascript" src="../media_datatables/jquery.jeditable.js"></script>
<script type="text/javascript" src="../media_datatables/jquery-ui.js"></script>
<script type="text/javascript" src="../media_datatables/jquery.validate.js"></script>
<!-- php general var -->
<?php
// to do merge with __css_js_crud.php
$db_handle = new DBController();
$types = $db_handle->runQuery($GET_ALL_TB_TYPES);
$n_types = count($types);
$products = $db_handle->runQuery($GET_ALL_TB_PRODUCTS);
// to do merge with __css_js_crud.php
if (explode("_", $this_filename)[1] == "products") {
$GET_ALL_TB_ELEMENTS = $GET_ALL_TB_PRODUCTS;
$sql_table = $TB_PRODUCTS;
}
if (explode("_", $this_filename)[1] == "types") {
$GET_ALL_TB_ELEMENTS = $GET_ALL_TB_TYPES;
$sql_table = $TB_TYPES;
}
$elements = $db_handle->runQuery($GET_ALL_TB_ELEMENTS);
//////////////////////////////////////////////// GET or create colum name ///////////////////////////////////////////
$arrayNameCols = array();
$result = mysql_query("SHOW COLUMNS FROM {$sql_table}");
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
?>
<!-- Add , Remove , Empty function -->
<?php
if (!empty($_POST["action"])) {
switch ($_POST["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productByCode = $db_handle->runQuery("SELECT * FROM products WHERE code='" . $_POST["code"] . "'");
// $productByCode = $db_handle->runQuery("SELECT * FROM products WHERE product_id='" . $_POST["product_id"] . "'");
// $itemArray = array($productByCode[0]["code"]=>array('name'=>$productByCode[0]["name"], 'code'=>$productByCode[0]["code"], 'quantity'=>$_POST["quantity"], 'price'=>$productByCode[0]["price"]));
// $itemArray = array($productByCode[0]["code"]=>array('name'=>$productByCode[0]["product_name"], 'code'=>$productByCode[0]["code"], 'quantity'=>$_POST["quantity"], 'price'=>$productByCode[0]["product_price"]));
$itemArray = array($productByCode[0]["code"] => array('desc' => $productByCode[0]["product_desc"], 'pic' => $productByCode[0]["product_pic"], 'name' => $productByCode[0]["product_name"], 'code' => $productByCode[0]["code"], 'quantity' => $_POST["quantity"], 'price' => $productByCode[0]["product_price"]));
if (!empty($_SESSION["cart_item"])) {
if (in_array($productByCode[0]["code"], $_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productByCode[0]["code"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] = $_POST["quantity"];
}
}
} else {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
}
} else {
$_SESSION["cart_item"] = $itemArray;
}
<?php
require_once "../__Globals.php";
require_once "__dbcontroller.php";
$db_handle = new DBController();
/* $get_db_products = $db_handle->runQuery($GET_ALL_TB_PRODUCTS);
$get_db_types = $db_handle->runQuery($GET_ALL_TB_TYPES);*/
$this_filename = explode(".", __FILE__)[0];
$this_container = "container_" . explode("_", $this_filename)[1] . ".php";
$ch = explode("_", $this_filename)[1];
include '__css_js_crud.php';
// don't touch emplacement
if (explode("_", $this_filename)[1] == "products") {
$GET_ALL_TB_ELEMENTS = $GET_ALL_TB_PRODUCTS;
$sql_table = $TB_PRODUCTS;
}
if (explode("_", $this_filename)[1] == "types") {
$GET_ALL_TB_ELEMENTS = $GET_ALL_TB_TYPES;
$sql_table = $TB_TYPES;
}
$elements = $db_handle->runQuery($GET_ALL_TB_ELEMENTS);
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_GET["action"])) {
switch ($_GET["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productByCode = $db_handle->runQuery("SELECT * FROM products WHERE id='" . $_GET["code"] . "'");
$itemArray = array($productByCode[0]["id"] => array('name' => $productByCode[0]["name"], 'id' => $productByCode[0]["id"], 'quantity' => $_POST["quantity"], 'price' => $productByCode[0]["price"]));
if (!empty($_SESSION["cart_item"])) {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
} else {
$_SESSION["cart_item"] = $itemArray;
}
}
break;
case "remove":
if (!empty($_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($_GET["code"] == $k) {
unset($_SESSION["cart_item"][$k]);
}
if (empty($_SESSION["cart_item"])) {
unset($_SESSION["cart_item"]);
}
}
}
break;
case "empty":
<?php
include 'css.php';
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_GET["action"])) {
switch ($_GET["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productByCode = $db_handle->runQuery("SELECT * FROM tblproduct WHERE code='" . $_GET["code"] . "'");
$itemArray = array($productByCode[0]["code"] => array('name' => $productByCode[0]["name"], 'code' => $productByCode[0]["code"], 'quantity' => $_POST["quantity"], 'price' => $productByCode[0]["price"]));
if (!empty($_SESSION["cart_item"])) {
if (in_array($productByCode[0]["code"], $_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productByCode[0]["code"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] = $_POST["quantity"];
}
}
} else {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
}
} else {
$_SESSION["cart_item"] = $itemArray;
}
}
break;
case "remove":
if (!empty($_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($_GET["code"] == $k) {
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
if (!empty($_GET["action"])) {
switch ($_GET["action"]) {
case "add":
if (!empty($_POST["quantity"])) {
$productBycode = $db_handle->runQuery("SELECT * FROM wednesday WHERE code='" . $_GET["code"] . "'");
$itemArray = array($productBycode[0]["code"] => array('productName' => $productBycode[0]["productName"], 'code' => $productBycode[0]["code"], 'quantity' => $_POST["quantity"], 'price' => $productBycode[0]["price"], 'productThumb' => $productBycode[0]["productThumb"], 'productImage' => $productBycode[0]["productImage"]));
if (!empty($_SESSION["cart_item"])) {
if (in_array($productBycode[0]["code"], $_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($productBycode[0]["code"] == $k) {
$_SESSION["cart_item"][$k]["quantity"] = $_POST["quantity"];
}
}
} else {
$_SESSION["cart_item"] = array_merge($_SESSION["cart_item"], $itemArray);
}
} else {
$_SESSION["cart_item"] = $itemArray;
}
}
break;
case "remove":
if (!empty($_SESSION["cart_item"])) {
foreach ($_SESSION["cart_item"] as $k => $v) {
if ($_GET["code"] == $k) {
unset($_SESSION["cart_item"][$k]);
<main class="main-content">
<div class="container">
<div class="page">
<section>
<header id="newProduct">
<h2 class="section-title">New Products</h2>
<!-- <a href="#" class="all">Show All</a> -->
</header>
<div class="product-list">
<!--Ajax test(Show Product)(Link to dbcontroller.php) -->
<!--Paypal test -->
<form id="frmCart">
<?php
$product_array = $db_handle->runQuery("SELECT * FROM products ORDER BY product_id ASC");
if (!empty($product_array)) {
foreach ($product_array as $key => $value) {
?>
<!--[Ajax] Show Products -->
<div class="product">
<div class="inner-product">
<div class="figure-image">
<a href="single.html"><img src="<?php
echo $product_array[$key]["product_pic"];
?>
"></a>
</div>
<!-- <h3 class="product-title"><a href="#">test</a></h3> -->
<?php
include 'connect.inc.php';
require_once "dbcontroller.php";
$db_handle = new DBController();
$result = $db_handle->runQuery("SELECT * FROM toy");
$header = $db_handle->runQuery("SELECT `COLUMN_NAME` \nFROM `INFORMATION_SCHEMA`.`COLUMNS` \nWHERE `TABLE_SCHEMA`='blog_samples' \n AND `TABLE_NAME`='toy'");
require 'fpdf/fpdf.php';
$pdf = new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial', 'B', 12);
foreach ($header as $heading) {
foreach ($heading as $column_heading) {
$pdf->Cell(90, 12, $column_heading, 1);
}
}
foreach ($result as $row) {
$pdf->SetFont('Arial', '', 12);
$pdf->Ln();
foreach ($row as $column) {
$pdf->Cell(90, 12, $column, 1);
}
}
$pdf->Output();
<?php
require_once "dbcontroller.php";
$db_handle = new DBController();
$perPage = 25;
$sql = "SELECT topic_id,category FROM topic ORDER BY views DESC ";
$page = 1;
if (!empty($_GET["page"])) {
$page = $_GET["page"];
}
$start = ($page - 1) * $perPage;
if ($start < 0) {
$start = 0;
}
$query = $sql . " limit " . $start . "," . $perPage;
$faq = $db_handle->runQuery($query);
if (empty($_GET["rowcount"])) {
$_GET["rowcount"] = $db_handle->numRows($sql);
}
$pages = ceil($_GET["rowcount"] / $perPage);
$output = '';
if (!empty($faq)) {
$output .= '<input type="hidden" class="pagenum" value="' . $page . '" /><input type="hidden" class="total-page" value="' . $pages . '" />';
foreach ($faq as $k => $v) {
$output .= '<div class="question">' . $faq[$k]["question"] . '</div>';
$output .= '<div class="answer">' . $faq[$k]["answer"] . '</div>';
}
}
print $output;
