PHP Product::setBrandId Examples

Example #1

File: query.php Project: Nikhil1990/inventory2

<?php

if (!isset($system) || $system != 'yes') {
    die("<H2>You are not allowed to view this resource</H2>");
}
//fetch brand_details
$brand_details = $db->get_results("SELECT * FROM brand ORDER BY b_name");
//fetch category_details
$category_details = $db->get_results("SELECT * FROM category ORDER BY c_name");
require_once './classes/class.product.php';
if (isset($_POST['search_product'])) {
    $p_b_id = $_POST['p_b_id'];
    $p_c_id = $_POST['p_c_id'];
    $product = new Product();
    $product->setBrandId($p_b_id);
    $product->setCategoryId($p_c_id);
    $product_details = $product->productinfo();
}
//fetch product_details
/* $product_details=$db->get_results("SELECT * FROM product ORDER BY p_name");
	
	//fetch product_details_qty */
$product_details_qty = $db->get_results("SELECT * FROM product ORDER BY p_name");
if (isset($_POST['search_product'])) {
    $all_product_details = $db->get_results("SELECT * FROM product_stock_location WHERE psl_s_id='{$a_s_id}'");
}