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;
}
public function create($_post)
{
$prepare = $this->prepare($_post);
$prepare['idskills'] = parent::search($_post, 'a_skill_list');
// echo "<pre>";
// print_r($prepare);
$this->id = parent::create($prepare, $this->table);
}
public function __construct()
{
parent::__construct();
if (!$_SESSION["currentuser"]) {
echo "<script>window.location.replace('index.php');</script>";
}
//Inicializa las variables
$this->user = new User();
$this->voto = new Voto();
}
public function update($_post)
{
$filter = "`userid` = " . $this->getUser()->id;
$data = $this->prepare($_post);
$success = parent::update($data, $filter, $this->table);
if ($success) {
return $_post;
} else {
throw new Exception("Update failed.", 1);
}
}
<?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";
$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;
function getRoutesFromDB()
{
$relations = array();
$relations = $this->getRelations();
$json_relations = JSONRouteRelation::getJSONRelations();
if (count($json_relations) > 0) {
foreach ($json_relations as $route => $relation) {
if (isset($relations[$route])) {
$relations[$route] = array_merge($relations[$route], $relation);
} else {
$relations[$route] = $relation;
}
}
}
$result = DBController::Query("SHOW TABLES");
if ($result === false) {
exit(ApiResponse::errorResponse(404));
} else {
if (empty($result) === true) {
exit(ApiResponse::errorResponse(204));
} else {
foreach ($result as $k => $v) {
$route = reset($v);
$route = new Route();
$route->routeName = reset($v);
if (isset($relations[$route->routeName])) {
$route->routeFields = $this->getRouteFields($route, $relations[$route->routeName]);
} else {
$route->routeFields = $this->getRouteFields($route);
}
ResterUtils::Log("*** PRIMARY KEY: " . $route->routeName . " => " . $route->primaryKey->fieldName);
$routes[$route->routeName] = $route;
}
}
}
ApiCacheManager::saveValueToCache(ROUTE_CACHE_KEY, $routes);
return $routes;
}
<?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
public function update($_post)
{
$this->prepare($_post);
$filter = "`id` = " . $_post['id'] . " and`userid` = " . self::jsid();
// echo $filter;exit;
$this->id = parent::update($_post, $filter, 'a_language');
}
public function Drop()
{
$builder = DBController::GetBuilder();
$stat = new $builder($builder::T_DROP_TABLE);
$stat->SetTableName($this->table_name);
$result = DBController::DropTable($stat->GetParams());
return $result;
}
public function __construct()
{
parent::__construct();
//Inicializa la variable
$this->user = new User();
//Inicializa la variable
$this->concurso = new Concurso();
}
public function __construct()
{
parent::__construct();
/*if(!$_SESSION["currentuser"]){
echo "<script>window.location.replace('index.php');</script>";
}*/
$this->pincho = new Pincho();
$this->codvoto = new CodVoto();
$this->concurso = new Concurso();
}
public function unlink($_post)
{
// $this->prepare($_post);
for ($i = 0; $i < count($_post); $i++) {
$filter = "`id` = '" . $_post . "'";
// return $filter;
$this->id = parent::unlink($filter, $this->table);
// return $this->id;
}
// return $filter;
// $this->id = parent::unlink($filter, $this->table);
}
public static function parseLogin()
{
$email = $_POST['email'];
$senha = $_POST['senha'];
$temp = DBController::init();
$usuarios = $temp->db_user;
$all = iterator_to_array($usuarios->find(["email" => $email, "senha" => $senha]));
if ($all != array()) {
foreach ($all as $key => $value) {
$obj = array('token' => $key, 'nome' => $value['nome'], 'email' => $value['email'], 'senha' => $value['senha'], 'status' => true, 'message' => "Login feito com sucesso");
}
SessionController::set("user", $obj);
} else {
$obj = array('email' => $email, 'senha' => $senha, 'status' => false, 'message' => "Email ou senha incorretos", 'status' => false);
}
RotaController::res($obj);
}
<?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) {
?>
<!-- 您已登入 -->
<!-- header('refresh:3;url=HasCookie.php'); -->
<h3>You have logged , Welcome to M&M | Shopping Space</h3>
<h4><i><u><?php
echo 'Hello ' . htmlspecialchars($_COOKIE["login"]) . '!';
}
?>
</i></u></h4>
<!-- Get Cookie_End -->
<?php
require_once "dbcontroller.php";
$db_handle = new DBController();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0,maximum-scale=1">
<title>Logged</title>
<!-- Loading third party fonts -->
<link href="http://fonts.googleapis.com/css?family=Roboto:100,300,400,700|" rel="stylesheet" type="text/css">
<link href="fonts/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="fonts/lineo-icon/style.css" rel="stylesheet" type="text/css">
<?php
require_once "dbcontroller.php";
$db_handle = new DBController();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Music</title>
<!-- Bootstrap Core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Custom CSS -->
<link href="css/clean-blog.min.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href="http://maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href='http://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800' rel='stylesheet' type='text/css'>
</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();
// Inspect IPN validation result and act accordingly
// Split response headers and payload, a better way for strcmp
$tokens = explode("\r\n\r\n", trim($res));
$res = trim(end($tokens));
if (strcmp($res, "VERIFIED") == 0) {
// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
include "dbcontroller.php";
$db = new DBController();
// check whether the payment_status is Completed
$isPaymentCompleted = false;
if ($payment_status == "Completed") {
$isPaymentCompleted = true;
}
// check that txn_id has not been previously processed
$isUniqueTxnId = false;
$result = $db->selectQuery("SELECT * FROM payments WHERE txn_id = '{$txn_id}'");
if (empty($result)) {
$isUniqueTxnId = true;
}
// check that receiver_email is your PayPal email
// check that payment_amount/payment_currency are correct
if ($isPaymentCompleted && $isUniqueTxnId && $payment_amount == "0.01" && $payment_currency == "USD") {
$payment_id = $db->insertQuery("INSERT INTO payment(item_number, item_name, payment_status, payment_amount, payment_currency, txn_id) VALUES('{$item_number}', '{$item_name}', {$payment_status}, '{$payment_amount}', '{$payment_currency}', '{$txn_id}')");
<?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;
public function unlink($_post)
{
$filter = "idskill`='{$_post['idskill']}' AND `to_userid`='{$_post['by_userid']}' AND `by_userid`='{$_post['to_userid']}'";
// echo $filter;exit;
$this->id = parent::unlink($_post, $this->table);
}
<?php
session_start();
require_once "dbcontroller.php";
$db_handle = new DBController();
$res_id = $_GET['res_id'];
if (empty($_SESSION['login_user'])) {
include 'header.php';
} else {
include 'user_home.php';
}
?>
<html>
<head>
<title>Review's</title>
<meta name="viewport" content="width=device-width,height=device-height,initial-scale=1.0"/>
<link rel="stylesheet" type="text/css" href="menu_items_info.css">
<link rel="stylesheet" type="text/css" href="css/font-awesome.min.css">
<style>
body{
background-color: #4D2121;
}
.de{
background-color:black;
}
.cat_menu{
background-color: black;
width: 20%;
height: auto;
<?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]);
}
/* Validation to check if gender is selected */
if (!isset($message)) {
if (!isset($_POST["gender"])) {
$message = " Gender field is required";
}
}
/* Validation to check if Terms and Conditions are accepted */
if (!isset($message)) {
if (!isset($_POST["terms"])) {
$message = "Accept Terms and conditions before submit";
}
}
if (!isset($message)) {
require_once "dbcontroller.php";
$db_handle = new DBController();
$query = "INSERT INTO reg(first_name, last_name, DOB, contact, email, gender, nationality, occupation, home_addr) VALUES\n\t\t( '" . $_POST["firstName"] . "', '" . $_POST["lastName"] . "', '" . $_POST["dob"] . "', '" . $_POST["cnumber"] . "', '" . $_POST["userEmail"] . "' , '" . $_POST["gender"] . "', '" . $_POST["nationality"] . "', '" . $_POST["occ"] . "', '" . $_POST["home_add"] . "')";
$result = $db_handle->insertQuery($query);
if (!empty($result)) {
$message = "You have registered successfully!";
unset($_POST);
} else {
$message = "Problem in registration. Try Again!";
}
}
}
?>
<html>
<head>
<title>PHP User Registration Form</title>
<style>
<?php
require_once "dbcontroller.php";
require_once "pagination.class.php";
$db_handle = new DBController();
$name = "";
$code = "";
$perPage = new PerPage();
$queryCondition = "";
if (!empty($_POST["name"])) {
$queryCondition .= " WHERE name LIKE '" . $_POST["name"] . "%'";
}
if (!empty($_POST["code"])) {
if (!empty($queryCondition)) {
$queryCondition .= " AND ";
} else {
$queryCondition .= " WHERE ";
}
$queryCondition .= " code LIKE '" . $_POST["code"] . "%'";
}
$orderby = " ORDER BY id desc";
$sql = "SELECT * FROM toy " . $queryCondition;
$paginationlink = "getresult.php?page=";
$page = 1;
if (!empty($_GET["page"])) {
$page = $_GET["page"];
}
$start = ($page - 1) * $perPage->perpage;
if ($start < 0) {
$start = 0;
}
<?php
include 'util/DBController.php';
$db = new DBController();
if (isset($_POST['eventname']) && isset($_POST['date'])) {
if (isset($_POST['description'])) {
$description = $_POST['description'];
} else {
$description = "";
}
if (isset($_POST['location'])) {
$location = $_POST['location'];
} else {
$location = "";
}
$album_ID = $db->insert_album($_POST['eventname'], $description, $location, $_POST['date']);
header('Location: album.php?id=' . $album_ID);
die;
}
<?php
if (isset($_POST['entry'])) {
include_once '/db/DBController.php';
include_once '/log/Logger.php';
include_once 'plain.php';
$logger = new Logger('Add.php');
$logger->info('Request to add a new entry received.');
try {
$db = new DBController();
echo @$db->addEntry($_POST['entry']);
$logger->info('Added new entry: ' . $_POST['entry']);
} catch (Exception $e) {
echo 0;
}
}
public function unlink($_post)
{
$this->prepare($_post);
$filter = "`id` = " . $_post['id'] . " and`userid` = " . self::jsid();
// echo $filter;exit;
$this->id = parent::unlink($filter, $this->table);
}
