//pagination setting
$limit = getSettingsValue('npagination_limit');
$page = isset($_GET['page']) ? trim($_GET['page']) : 1;
if (empty($page)) {
    $page = 1;
}
$result = mysql_query($sql) or die(mysql_error());
$totalrows = mysql_num_rows($result);
$limitvalue = ($page - 1) * $limit;
$query_string = " LIMIT {$limitvalue}, {$limit}";
//get results with pagination
$sql = $sql . $query_string;
$rs = mysql_query($sql) or die(mysql_error());
$numofpages = ceil($totalrows / $limit);
//fetch all products to display in search dropdown
$all_products = getAllProducts();
include "../includes/htmltop.php";
?>
<script language="JavaScript" type="text/JavaScript">
    //search feature in listing page
    function clickSearch()
    {
        document.frmProductViewed.submit();
    }
$(document).ready(function() {
var a_href = $('.clsExportLink').attr('href');
var paging =1 ;
$(".clsCheck").change(function() {
    if($('#chkPaging').attr('checked')) {
    var paging =0 ;
} else{
Beispiel #2
0
                                
                                </div>

                                 <div class="form-group">
                                    <label>Address</label>
                                    <input class="form-control" name="cAddress" required="required" type="text" value="<?php 
echo @$_POST['cAddress'];
?>
">
                                </div>

                                 <div class="form-group">
                                    <label>Choose a Category</label>
                                    <select class="form-control" name="pId">
                                    <?php 
$qry = getAllProducts();
while ($row = mysql_fetch_object($qry)) {
    ?>

                                        <option value="<?php 
    echo $row->pId;
    ?>
"> <?php 
    echo $row->pName;
    ?>
 </option>

                                    <?php 
}
?>
                                    </select>
<?php

header('Content-type: application/json');
require_once __DIR__ . '/dbService.php';
session_start();
if (isset($_SESSION["username"])) {
    $result = getAllProducts();
    if ($result['message'] == 'OK') {
        echo json_encode($result);
    } else {
        die(json_encode($result));
    }
} else {
    // return error
    $response = array('error' => 'Favor de iniciar sesion');
    header("HTTP/1.1 417 SESSION NOT SET");
    die(json_encode($response));
}
Beispiel #4
0
    ?>
                </option>
            <?php 
}
?>
            </select>
            <br />
            <input type="submit" value="Submit" />
        </form>    
            
                
        <?php 
if (isset($_POST['category_id'])) {
    ?>
        <?php 
    $products = getAllProducts($category_id);
    ?>
        
            <table class="table">
            <thead>
                <tr>
                    <th>Products</th>
                </tr>
            </thead>
                <?php 
    foreach ($products as $row) {
        ?>
                <tr>
                    <td><?php 
        echo $row['product'];
        ?>
<html>
    <head>
        <meta charset="UTF-8">
        <link rel="stylesheet" href="../../css/bootstrap.css">
        <title></title>
    </head>
    <body>
        <?php 
require_once '../../includes/session-start.php';
require_once '../../includes/access-required.html.php';
include_once '../../functions/dbConn.php';
include_once '../../functions/categoryFunctions.php';
include_once '../../functions/productsFunctions.php';
include_once '../../functions/until.php';
$products = getAllProducts();
$results = '';
if (isPostRequest()) {
    $product_id = filter_input(INPUT_POST, 'product_id');
    deleteProduct($product_id);
    if (deleteProduct($product_id) == true) {
        $results = 'Product deleted';
    } else {
        $results = 'Product was not deleted';
    }
}
?>
    <center>
        <h1>Delete Product</h1>
        
        <?php 
        echo $row['category_id'];
        ?>
"<?php 
        if ($row['category_id'] == filter_input(INPUT_POST, "category_id")) {
            echo "selected";
        }
        ?>
>
                    <?php 
        echo $row['category'];
        ?>
                </option>
            <?php 
    }
    ?>
            </select>
            <br />
            <input type="submit" value="Submit" class="btn btn-default" />
</form>
<hr>
        
      
        
<?php 
    //narrow products to only chosen category by calling different function and filling same array
    if (isset($chosenCategory)) {
        $allProducts = getAllProducts($chosenCategory);
    }
}
?>
   
Beispiel #7
0
     $pic = $_REQUEST['pic'];
     if (!$product->updateProduct($fid, $fname, $fcateg, $fprice, $pic)) {
         echo '{"result":0,"message":"Could not add the product"}';
         return;
     }
     echo '{"result":1,"message":"Succesfully added product"}';
 }
 switch ($cmd) {
     case 1:
         addProduct();
         break;
     case 2:
         updateProduct();
         break;
     case 3:
         getAllProducts();
         break;
     case 4:
         getByCategory();
         break;
     case 5:
         getProductById();
         break;
     case 6:
         deleteProduct();
         break;
     case 7:
         searchProduct();
         break;
     default:
         echo '{"cmd":"none","message":"No command issued"}';
Beispiel #8
0
?>
 />
					<label for="healthyChoice">Healthy Choice</label>
					
					<br />
					<br />

					<input type="submit" value="Search Products" name="searchForm" />
					</fieldset>

				</form>
				<div id="item-list">
				<?php 
//Displays all products by default
if (!isset($_GET['searchForm'])) {
    $records = getAllProducts();
} else {
    $records = filterProducts();
}
foreach ($records as $record) {
    echo "<a target='descriptionFrame' href='getProductInfo.php?productId=" . $record['productId'] . "'>";
    echo $record['productName'];
    echo "</a>";
    echo "- \$" . $record['price'] . "<br>";
}
?>
				</div>
			<div id="description-frame">
            <iframe src="getProductInfo.php" name="descriptionFrame" width="250" height="300" frameborder="0"/>
            </iframe>				
			</div>
    $pagenum = 1;
}
$limit = getSettingsValue('npagination_limit');
$page = isset($_GET['page']) ? trim($_GET['page']) : 1;
if (empty($page)) {
    $page = 1;
}
$result = mysql_query($sql) or die(mysql_error());
$totalrows = mysql_num_rows($result);
$limitvalue = ($page - 1) * $limit;
$query_string = " LIMIT {$limitvalue}, {$limit}";
$sql = $sql . $query_string;
$rs = mysql_query($sql) or die(mysql_error());
$numofpages = ceil($totalrows / $limit);
//fetch all products to display in search dropdown
$all_products = getAllProducts($artistid);
include "../includes/htmltop.php";
?>
<script language="JavaScript" type="text/JavaScript">
    function clickSearch()
    {
        document.frmProductViewed.submit();
    }

</script>

<body>
    <center>

        <div align="left" id="layout">
Beispiel #10
0
    //  echo "id".$ids;
    //print_r($ids);
    $productsB = getProductByIds($ids, $sort);
}
if (!empty($keyWords) && !empty($labels)) {
    foreach ($productsA as $value) {
        foreach ($productsB as $val) {
            if ($value == $val) {
                $products[] = $value;
            }
        }
    }
    $products = multiSort($products, $sort);
} else {
    if (empty($keyWords) && empty($labels)) {
        $products = getAllProducts($sort);
    } else {
        $products = $productsA + $productsB;
        $products = multiSort($products, $sort);
    }
}
//print_r($products);
$page_num = ceil(count($products) / 35);
$productsNum = count($products);
if (empty($products)) {
    $productsNum = 0;
} else {
    $productsNum = count($products);
}
$page_num = ceil($productsNum / 35);
$products = array_slice($products, ($page - 1) * 35, 35);