public function testGetProducts()
{
$params = array('title' => 'My test post is here', 'content_type' => 'post', 'subtype' => 'product', 'is_active' => 1);
//saving
$new_page_id = save_content($params);
$get_pages = get_products($params);
$page_found = false;
if (is_array($get_pages)) {
foreach ($get_pages as $page) {
if ($page['id'] == $new_page_id) {
$page_found = true;
$this->assertEquals('post', $page['content_type']);
$this->assertEquals('product', $page['subtype']);
}
//PHPUnit
$this->assertEquals(true, intval($page['id']) > 0);
}
}
//clean
$delete_sub_page = delete_content($new_page_id);
//PHPUnit
$this->assertEquals(true, $page_found);
$this->assertEquals(true, intval($new_page_id) > 0);
$this->assertEquals(true, is_array($get_pages));
$this->assertEquals(true, is_array($delete_sub_page));
}
function get_table()
{
////////////////////////////////////////////////////////////////////////////////////////////////////
$conn = mysqli_connect("localhost", "root", "", "consimentweb_sql");
if (!$conn) {
echo "Error: ";
}
//create table
$table_str = '<table id="product_table">';
$table_str .= "<tr>";
$table_str .= '<th>Image</th><th>Name</th><th>Price</th><th>Date</th><th>Detail</th>';
$table_str .= "</tr>";
$products = get_products();
$pic = "";
$class = "article current";
$all = count($products);
$pad = ceil($all / 4);
foreach ($products as $product) {
$query = "select * from con_photo where {$product->P_ID}=con_photo.p_id limit 1";
$data = mysqli_query($conn, $query);
$pic = mysqli_fetch_array($data, MYSQLI_ASSOC);
$table_str .= "<tr>";
$table_str .= '<td width="20%" height="100px"><center><img src="images/' . $pic["PHOTO"] . '"></center></td>
<td><center>' . $product->P_NAME . '</center></td>
<td><center>' . $product->PRICE . '<center></td>
<td><center>' . $product->START_DATE . '<center></td>
<td><div style="cursor: pointer;" class="' . $class . '"><center>View detail</center></div>
<div class="pop">
<div style="position:absolute; width:50%; height:100%; left:0px; top:0px;";>
<div style="position:relative; top:25%; left:10%; border-style: solid; border-width: 1px; width:80%; height:50%;">
<img src="#" style="width:100%; height:100%;">
</div>
</div>
<div style="position:absolute; width:50%; height:100%; right:0px; top:0px;">
<div style="height:15%; width:200%; border-style:solid; border-width:1px; margin-left:-100%;">' . $product->P_ID . '
</div>
<div style="height:30%; width:100%; border-style: solid; border-width: 1px;">
<div style="margin:5%; border-style: solid; border-width:1px; word-wrap:break-word;">' . $product->P_NAME . $product->PRICE . $product->START_DATE . $pic["PHOTO"] . '</div>
</div>
<div style="height:55%; width:100%; border-style: solid; border-width: 1px;">
<div style="margin:5%; border-style: solid; border-width:1px; word-wrap:break-word;">' . $product->DETAIL . '</div>
<div style="position:absolute; bottom: 2vh;right: 2vw;"><a href="create_transaction.php?P_ID=' . $product->P_ID . '">BUY</a></div>
</div>
</div>
</div>
</td>';
$table_str .= '</tr>';
$class = "article";
}
$table_str .= '</table><div class="padding">';
for ($b = 1; $b <= $pad; $b++) {
$table_str .= '<a href="show_list_product_sql.php?page=' . $b . '" style="text-decoration:none ">' . $b . ' </a>';
}
$table_str .= '</div><div id="pop_close">X</div>';
////////////////////////////////////////////////////////////////////////////////////////////////////////
mysqli_close($conn);
///////////////////////////////////////////////////////////////////////////////////////////////////////////
return $table_str;
}
function get_table()
{
$table_str = '';
$Product = get_products();
foreach ($Product as $product) {
$table_str .= '' . $product->product_name;
}
return $table_str;
}
function save_page_data($page, $sort, $per_page)
{
$cache_key = build_cache_key($page, $sort);
$result = get_cache($cache_key);
if (!$result) {
$data = get_products($page, $per_page, true);
$ids = '';
foreach ($data as $product) {
$ids .= $product[0] . ',';
}
set_cache($cache_key, substr($ids, 0, -1));
}
}
function get_page_data()
{
if (isset($_GET['page'])) {
$page = $_GET['page'] - 1;
} else {
$page = 0;
}
$data['products'] = get_products($page, PER_PAGE);
$data['pagination']['total'] = ceil(get_count_product() / PER_PAGE);
$data['pagination']['page'] = $page + 1;
prepare_response($data);
return $data;
}
function normalView()
{
echo '<p>Click on some of the filters to alter your query.</p>';
echo '<table width="100%">
<tr>
<td style="width:20%;vertical-align:top;">';
get_questions();
echo '</td>
<td style="vertical-align:top;">';
get_products();
echo '</td>
</tr>
</table>';
}
function get_table()
{
//create table
$products = get_products();
$table_str = '<table id="t1">';
$table_str .= '<thead>';
$table_str .= '<tr>';
$table_str .= '<th>Nombre del Evento</th>';
$table_str .= '<th>Descripción</th>';
$table_str .= '<th>Lugar</th>';
$table_str .= '<th>Fecha de Inicio</th>';
$table_str .= '<th>Fecha de Final</th>';
$table_str .= '<th id="thButtons">Crear Evento</th>';
$table_str .= '<th id="thButtons"><a href="CrearEvento.php"><button class="addButton"></button></a></td>';
$table_str .= '</tr>';
$table_str .= '</thead>';
$table_str .= '<tbody>';
foreach ($products as $product) {
$table_str .= '<tr>';
$table_str .= '<td>' . $product->Nombre . '</td>';
$table_str .= '<td>' . $product->Descripcion . '</td>';
$table_str .= '<td>' . $product->Lugar . '</td>';
$table_str .= '<td>' . $product->FechaInicio . '</td>';
$table_str .= '<td>' . $product->FechaFinal . '</td>';
$table_str .= '<td id="tdButtons"><button class="editButton"></button></td>';
$table_str .= '<td id="tdButtons"><button class="deleteButton onclick="deleteFromDB()"></button></td>';
$table_str .= '</tr>';
}
$table_str .= '</tbody>';
$table_str .= '<tfoot>';
$table_str .= '<tr>';
$table_str .= '</tr>';
$table_str .= '</tfoot>';
$table_str .= '</table>';
return $table_str;
}
function get_table()
{
//create table in HTML
$table_str = '<table id=product_table>';
$products = get_products();
$i = 1;
$table_str .= '<tr class="head_table">';
$table_str .= '<th>DeviceId</th><th>TimeStamp</th><th>Action</th><th>Value</th>';
$table_str .= '</tr>';
foreach ($products as $product) {
$class = '';
if ($i % 2 == 0) {
$class = 'row_even';
} else {
$class = 'row_odd';
}
$table_str .= '<tr class="' . $class . '">';
$table_str .= '<td width=30>' . $product['My_DeviceId'] . '</td><td>' . $product['My_TimeStamp'] . '</td><td>' . $product['My_Action'] . '</td><td>' . $product['My_Value'] . '</td>';
$table_str .= '</tr>';
$i++;
}
$table_str .= '</table>';
return $table_str;
}
/**
* Looks for products using a keyword
*/
function find_products($keyword)
{
return get_products();
}
<?php
//type of request
//1: get description of product
//2: delete product
//3: edit price
$cmd = $_REQUEST['cmd'];
switch ($cmd) {
case 1:
get_products($_REQUEST['id']);
break;
case 2:
delete_product($_REQUEST['id']);
break;
default:
}
function get_products($id)
{
include "products.php";
$obj = new products();
$row = $obj->get_product($id);
//return a JSON string to browser when request comes to get description
echo '{"result":1,"desc":"' . $row['description'] . '"}';
}
function delete_product($id)
{
include "products.php";
$obj = new products();
if ($obj->delete($id)) {
echo '{"result":1,"message": "deleted"}';
} else {
if (preg_match('#\\d{7}#', $match[1], $matches)) {
if (array_key_exists('0', $matches)) {
$skus[] = $matches[0];
}
}
}
}
return $skus;
}
// Include the library.
require 'scraperwiki/simple_html_dom.php';
// The base URL.
$base_url = "http://techmanual.yakima.com/";
$allowed_tags = "<br>,<strong>,<b>";
$active_skus = get_products("active");
$discontinued_skus = get_products("discontinued");
process_data($active_skus, 1);
process_data($discontinued_skus, 0);
// To process the data.
function process_data($skus, $avail = 1)
{
global $allowed_tags;
if (!empty($skus) && is_array($skus)) {
foreach ($skus as $sku) {
// Get the description.
$description = strip_tags(get_description($sku), $allowed_tags);
// Add it to an array.
$record = array('sku' => $sku, 'avail' => $avail, 'desc' => $description);
// Add it to the table.
scraperwiki::save_sqlite(array('sku'), array($record), "techmanual", 2);
}
<?php
include_once 'db.php';
if (isset($_GET['id']) && count($_POST) > 0) {
$changes = $_POST;
foreach ($changes as $key => $value) {
$changes[$key] = htmlspecialchars($value);
}
$changes['id'] = $_GET['id'];
change_product($db, $changes);
}
$items = get_products($db);
include_once 'table.php';
if (isset($_GET['id'])) {
$item = get_product($db, $_GET['id']);
include_once 'form.php';
}
<?php
$products = get_products($db);
include_once 'views/head.php';
include_once 'views/header.php';
?>
<main>
<div class="container">
<div class="banner"></div>
<div class="row clearfix">
<!-- боковое меню -->
<?php
include_once 'views/category_menu.php';
?>
<div class="column column9">
<div class="catalog">
<div class="row clearfix">
<!-- элементы каталога -->
<?php
foreach ($products as $product) {
include 'views/_product.php';
}
?>
</div>
</div>
</div>
</div>
</div>
</main>
<?php
include_once 'views/footer.php';
$result['gebinde_dreiviertel'] = $gebinde_dreiviertel;
$result['gebinde_liter'] = $gebinde_liter;
$results[] = $result;
$result = array();
}
if (count($results) == 0) {
$results = False;
}
$stmt->free_result();
$db->close();
return $results;
}
$results = get_products();
if ($results == False) {
$_GET['kategorie'] = "rotwein";
$results = get_products();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/default.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta name="description" content="Das Weinhaus Michel ist eine gemütliche Weinstube mit Gewölbekeller und Straßenterrasse mitten in der Altstadt von Mainz." />
<meta name="keywords" content="Weinhaus, Weinstube, Michel, Stefan, Weingut in Weinolsheim, Mainz, Altstadt, Weinanbau, Weinverkauf, Essen und Trinken, Warme Küche, Rheinhessische Spezialitäten, Gewölbekeller, Veranstaltungen, Gesellschaften, Straßenlokal, Terrasse, Raummiete, Weihnachtsfeier, Reservierungen, Weinbestellung, Fastnacht" />
<meta name="robots" content="index,follow" />
<meta name="language" content="de" />
<meta name="city" content="Mainz" />
<meta name="country" content="DE, Deutschland, Germany" />
<title>Weinhaus Michel – Seitentitel</title>
<link href="../style/default.css" rel="stylesheet" type="text/css" />
<link href="../favicon.ico" rel="shortcut icon" />
<?php
require_once 'Slim/Slim.php';
require_once 'Lite/Lite.php';
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app->get('/api/products', function () {
echo json_encode(get_products());
});
$app->get('/api/products/:pids', function ($pids) {
echo json_encode(get_products($pids));
});
$app->post('/api/sync', function () {
echo json_encode(sync_products());
});
$app->post('/api/sync/vendor/:vid', function ($vid) {
echo json_encode(sync_products($vid, NULL));
});
$app->post('/api/sync/channel/:cid', function ($cid) {
echo json_encode(sync_products(NULL, $cid));
});
$app->post('/api/sync/vendor/:vid/channel/:cid', function ($vid, $cid) {
echo json_encode(sync_products($vid, $cid));
});
$app->run();
$function = $_GET['function'];
$values = $_GET;
} else {
$values = file_get_contents('php://input');
$values = (array) json_decode($values);
$function = $values['function'];
}
switch ($function) {
case 'add_product':
include_once __DIR__ . '/products/add_product.php';
$responseArray['response'] = add_product($values);
$responseArray['message'] = 'Successfully added product';
break;
case 'get_products':
include_once __DIR__ . '/products/get_products.php';
$responseArray['response'] = get_products($values);
$responseArray['message'] = 'Products successfully read';
break;
case 'update_product':
include_once __DIR__ . '/products/update_product.php';
update_product($values);
$responseArray['message'] = 'Product successfully updated';
break;
case 'add_product_class':
include_once __DIR__ . '/products/add_product_class.php';
add_product_class($values);
$responseArray['message'] = 'Class successfully added';
break;
case 'get_product_classes':
include_once __DIR__ . '/products/get_product_classes.php';
$responseArray['response'] = get_product_classes($values);
function get_term_children_num($tax, $term)
{
$products = get_products($tax, $term, -1);
return $products->post_count;
}
<?php
include 'view_block/header.php';
include 'data/data.php';
//var_dump(get_products());
$catalogue = get_products();
?>
<div class="container">
<div class="col-md-12">
<div class="center-block text-center">
<h1>AFRICANSTYLE</h1>
<p class="lead">VENTE DE VETEMENTS</p>
</div>
<div class="container">
<div class="menu row">
<div class="product col-sm-12">
<div class="product col-lg-12"></div>
<div class="product col-lg-12 text-center">
<hr>
<h2>AFRICAN STYLE</h2>
<p></p>
<hr>
<h2 class="text-right"></h2>
</div>
<div class="product col-lg-12">
<?php
foreach ($catalogue as $k => $list) {
$ids = !$ids ? $id : $ids . $id;
/*=========Пагинация==========*/
// кол-во товаров на страницу
$perpage = isset($_COOKIE['per_page']) && (int) $_COOKIE['per_page'] ? $_COOKIE['per_page'] : PERPAGE;
// общее кол-во товаров
$count_goods = count_goods($ids);
// необходимое кол-во страниц
$count_pages = ceil($count_goods / $perpage);
// минимум 1 страница
if (!$count_pages) {
$count_pages = 1;
}
// получение текущей страницы
if (isset($_GET['page'])) {
$page = (int) $_GET['page'];
if ($page < 1) {
$page = 1;
}
} else {
$page = 1;
}
// если запрошенная страница больше максимума
if ($page > $count_pages) {
$page = $count_pages;
}
// начальная позиция для запроса
$start_pos = ($page - 1) * $perpage;
$pagination = pagination($page, $count_pages);
/*=========Пагинация==========*/
$products = get_products($ids, $start_pos, $perpage);
include VIEW . "{$view}.php";
<?php
if (!isset($_GET['cmd'])) {
exit;
}
switch ($_GET['cmd']) {
case 0:
get_products();
break;
case 1:
transaction();
break;
default:
break;
}
function get_products()
{
include_once 'product.php';
$obj = new product();
if (!$obj->connect()) {
$json = '{"status":2, "products":{}}';
echo $json;
exit;
}
if ($obj->get_products()) {
$row = $obj->fetch();
$length = $obj->get_num_rows();
// Products as a set
$json = '{"status":0, "products":{';
for ($i = 0; $i < $length; $i++) {
$bcode = $row['PRODUCT_BARCODE'];
<?php
session_start();
if (!isset($_SESSION['imonggo_api_token'])) {
header('Location:login.php');
}
include 'post_get.php';
//Gets products available on-hand
$inventories = array_filter(get_inventories());
//Gets tags for checkbox creation
$get_output = get_products();
$response = $get_output[0];
$tags = $get_output[1];
if (isset($_GET['post_products'])) {
if (!empty($inventories)) {
$post_tags = $_GET['checkbox_name'];
post_products($response, $post_tags, $inventories);
} else {
$error_msg = "Error: No product available";
echo $error_msg;
}
if (isset($_GET['post_all_products'])) {
if (!empty($inventories)) {
get_all_products($inventories);
} else {
$error_msg = "Error: No product available";
echo $error_msg;
}
}
} elseif (isset($_GET['pull_customers'])) {
get_customers();
dol_syslog("products.inc.php::get_new_products rien � faire", LOG_DEBUG);
$last = 0;
}
}
else
{
dol_syslog("products.inc.php::get_new_products erreur ".$sql, LOG_DEBUG);
return -1;
}
// 1. recherche des nouveaux porduits
if ($res = get_new_products($siteid,$db, $user, $limit) < 0) print "Erreur traitement des produits �tape 1"."\n";
else print "fin �tape 1 d�but �tape 2"."\n";
// on fait les deux traitements syst�matiquement
if ($res = get_products($siteid, $db, $user, $limit, $last)) print "traitement produit r�ussi $last $limit"." \n";
else print "Erreur traitement des produits $last $limit"."\n";
break;
case 'prospect':
print "traitement des prospects\n";
// traitement de la limite
if (! isset($argv[3])) $limit = 0;
elseif ($argv[3] > 0 ) $limit = $argv[3];
else $limit = 100; // on limite
// pour ne pas re-traiter les prospects
$sql = "SELECT max(ecom_customer) last FROM ".MAIN_DB_PREFIX."ecom_customer ec ";
$sql .= "WHERE ec.siteid = '".$siteid."' AND ec.site_cust_status = 'P'";
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$product_list = array();
$sql = "SELECT name, price, description, category FROM products";
$result = $conn->query($sql);
echo $conn->error;
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$product = array("Name" => $row["name"], "Price" => $row["price"], "Desc" => $row["description"], "Category" => $row["category"]);
array_push($product_list, $product);
}
}
return $product_list;
}
$products = get_products();
?>
<html lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<title>cs3140 Final Project</title>
</head>
<body>
<div id="header">
<h1>ROASTED</h1>
</div>
<?php
include 'navbar.php';
?>
<div id="main">
require '../model/registration_db.php';
require '../model/product_db.php';
$action = filter_input(INPUT_POST, 'action');
if ($action == 'login') {
$email = filter_input(INPUT_POST, 'email');
if ($email == NULL || $email == FALSE) {
include '../product_register/customer_login.php';
} else {
$login = get_customer_by_email($email);
if ($login['customerID'] == NULL || $login['customerID'] == FALSE) {
$message = 'Invalid Username';
include '../product_register/product_register.php';
} else {
$first = $login['firstName'];
$last = $login['lastName'];
$list = get_products();
include '../product_register/product_register.php';
}
}
} else {
if ($action == 'add_registration') {
$product_code = filter_input(INPUT_POST, 'product_code');
}
}
/*
* What you will need
* 1. The product_register application should default to the customer_login view
* 2. If the email address is not provided, make them enter one
* 3. Check if the email entered is valid, if so get the user information from
* the database
* 4. Send the logged-in user to the product registration page
<?php
include 'model.php';
include 'functions.php';
echo embed('tpl/home.tpl.php', array('header' => embed('tpl/header.tpl.php', array()), 'sidebar_first' => embed('tpl/category.tpl.php', array('result' => get_category())), 'body' => embed('tpl/allproduct.tpl.php', array('result' => get_products())), 'sidebar_second' => embed('tpl/top_last_added.tpl.php', array('result' => last_added()))));
<?php
require '../model/database.php';
require '../model/product_db.php';
if (isset($_POST['action'])) {
$action = $_POST['action'];
} else {
if (isset($_GET['action'])) {
$action = $_GET['action'];
} else {
$action = 'display_all';
}
}
if ($action == 'display_all') {
$all_products = get_products();
include 'product_list.php';
} else {
if ($action == 'delete_record') {
$product_item = $_POST['product_item'];
delete_product($product_item);
header('Location: .');
} else {
if ($action == 'add_record') {
$product_item = $_POST['product_item'];
$name = $_POST['name'];
$version = $_POST['version'];
$release_date = $_POST['release_date'];
if (empty($product_item) || empty($name) || empty($version) || empty($release_date)) {
$error = "Invalid product data. Check all fields and try again.";
header("Location: .?error={$error}");
} else {
<form id="addproduct-form" onsubmit="return submitCreateProduct()" method="post">
code: <input type="text" name="code" id="code"><br>
description: <input type="text" name="description" id="description">
price: <input type="number" name="price" id="price">
type: <input type="text" name="type" id="type">
<input type="submit" id="login-btn">
</form>
</div>
<div id="login-info">
<p>Products:</p>
</div>
<div>
<?php
include "../controllers/get_products.php";
$products = array();
$products = (array) get_products();
echo "<table border=\"1\">";
echo "<tr>";
echo "<th>Code</th>";
echo "<th>Description</th>";
echo "<th>Price</th>";
echo "<th>Unit desc</th>";
echo "<th>Unit abbrev</th>";
echo "<th>Class</th>";
echo "<th>Class desc</th>";
echo "</tr>";
foreach ($products as $p) {
echo "<script>console.log(" . json_encode($p) . ")</script>";
echo "<tr>";
echo "<td>" . $p['prod_code'] . "</td>";
echo "<td>" . $p['prod_desc'] . "</td>";
$result = mysql_fetch_array($query);
return $result;
}
function get_filtered($post_product_id, $post_filter_id)
{
$conn = connDB();
$sql = "SELECT COUNT(*) AS rows FROM tbl_filter_item WHERE `filter_param` = '{$post_filter_id}' AND `product_param` = '{$post_product_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
// DEFINED VARIABLE
$ajx_alias = $_POST['alias'];
// CALL FUNCTIONS
$filter = get_filter();
$data_product = get_products($ajx_alias);
?>
<span id="id_filter_container">
<div class="box row">
<div class="desc col-xs-3">
<h3>Filter</h3>
<p>Manage filter.</p>
</div>
<div class="content col-xs-9">
<ul class="form-set">
<li class="form-group row">
<?php
foreach ($filter as $filter) {
echo get_company_review($_GET);
} else {
if (strpos($uri, '/add_review_company') !== false) {
echo add_company_review($_POST);
} else {
if (strpos($uri, '/get_account') !== false) {
echo get_account($_GET);
} else {
if (strpos($uri, '/components') !== false) {
echo get_components($_GET);
} else {
if (strpos($uri, '/documents') !== false) {
echo get_documents($_GET);
} else {
if (strpos($uri, '/products') !== false) {
echo get_products($_GET);
} else {
if (strpos($uri, '/add_to_project') !== false) {
echo add_to_project($_POST);
} else {
if (strpos($uri, '/remove_from_project') !== false) {
echo remove_from_project($_POST);
} else {
if (strpos($uri, '/uploadServiceImage') !== false) {
echo upload_service_image($_POST, $_FILES);
} else {
if (strpos($uri, '/upload') !== false) {
echo upload_document($_POST, $_FILES);
} else {
if (strpos($uri, '/create_discussion') !== false) {
echo create_discussion($_POST);
function add_item($key, $quantity)
{
global $db;
$products = get_products();
if ($quantity < 1) {
return;
}
// If item already exists in cart, update quantity
if (isset($_SESSION['cart'][$key])) {
$quantity += $_SESSION['cart'][$key]['qty'];
update_item($key, $quantity);
return;
}
$cost = $products[$key]['Price'];
$total = $cost * $quantity;
$item = array('Plant_Name' => $products[$key]['Plant_Name'], 'Price' => $cost, 'qty' => $quantity, 'total' => $total);
$_SESSION['cart'][$key] = $item;
}
