Something went wrong. Try again.
Open source inventory management system with php and mysql Invoice generation and easy to download invoice in PDF format Lightweight and ea…
Something went wrong. Try again.
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283<?php
require_once 'core.php';
$sql = "SELECT product.product_id, product.product_name, product.product_image, product.brand_id, product.categories_id, product.quantity, product.rate, product.active, product.status, brands.brand_name, categories.categories_name FROM product INNER JOIN brands ON product.brand_id = brands.brand_id INNER JOIN categories ON product.categories_id = categories.categories_id WHERE product.status = 1 AND product.quantity>0";
$result = $connect->query($sql);
$output = array('data' => array());
if($result->num_rows > 0) {
// $row = $result->fetch_array(); $active = "";
while($row = $result->fetch_array()) { $productId = $row[0]; // active if($row[7] == 1) { // activate member $active = "<label class='label label-success'>Available</label>"; } else { // deactivate member $active = "<label class='label label-danger'>Not Available</label>"; } // /else
$button = '<!-- Single button --> <div class="btn-group"> <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> Action <span class="caret"></span> </button> <ul class="dropdown-menu"> <li><a type="button" data-toggle="modal" id="editProductModalBtn" data-target="#editProductModal" onclick="editProduct('.$productId.')"> <i class="glyphicon glyphicon-edit"></i> Edit</a></li> <li><a type="button" data-toggle="modal" data-target="#removeProductModal" id="removeProductModalBtn" onclick="removeProduct('.$productId.')"> <i class="glyphicon glyphicon-trash"></i> Remove</a></li> </ul> </div>';
// $brandId = $row[3]; // $brandSql = "SELECT * FROM brands WHERE brand_id = $brandId"; // $brandData = $connect->query($sql); // $brand = ""; // while($row = $brandData->fetch_assoc()) { // $brand = $row['brand_name']; // }
$brand = $row[9]; $category = $row[10];
$imageUrl = substr($row[2], 3); $productImage = "<img class='img-round' src='".$imageUrl."' style='height:30px; width:50px;' />";
$output['data'][] = array( // image $productImage, // product name $row[1], // rate $row[6], // quantity $row[5], // brand $brand, // category $category, // active $active, // button $button ); } // /while
}// if num_rows
$connect->close();
echo json_encode($output);