Hi, I am building a PHP stock control / Inventory system and am in need of some advise on the best way to go about it. Currently, the stock levels are displayed using the below code. I am after a solution to Email me when a certain item fall below a set level. I.e. When a product reaches only 5 left on the shelf, the system will email me the details of this product for re ordering. I hope this makes sense and any advise would be great. <?php include_once('../header.php'); ?> <?php mysql_query("DELETE FROM $database->product_amount WHERE amount='0'"); if(isset($_GET['product_id'])){ $product_id = safety_filter($_GET['product_id']); } ?> <table class="dataTable"> <thead> <tr> <th width="1"></th> <th><?php lang('Product Code'); ?></th> <th><?php lang('Shelf'); ?></th> <th class="text-right"><?php lang('Amount'); ?></th> </tr> </thead> <tbody> <?php $amount_total = 0; if(isset($_GET['product_id'])){ $query_product_amount = mysql_query("SELECT * FROM $database->product_amount WHERE product_id='$product_id' ORDER BY product_id ASC"); } else { $query_product_amount = mysql_query("SELECT * FROM $database->product_amount"); } while($list_product_amount = mysql_fetch_assoc($query_product_amount)) { $product_amount['id'] = $list_product_amount['id']; $product_amount['product_id'] = $list_product_amount['product_id']; $product_amount['shelf'] = $list_product_amount['shelf']; $product_amount['amount'] = $list_product_amount['amount']; echo ' <tr> <td></td> <td><a href="'.get_url('page').'/product/product.php?product_id='.$product_amount['product_id'].'">'.get_product($product_amount['product_id'], 'code').'</a></td> <td>'.$product_amount['shelf'].'</td> <td class="text-right">'.$product_amount['amount'].'</td> </tr> '; $amount_total = $amount_total + $product_amount['amount']; } ?> </tbody> <?php if(isset($_GET['product_id'])) : ?> <tfoot> <tr> <th></th> <th></th> <th></th> <th class="text-right"><?php echo $amount_total; ?></th> </tr> </tfoot> <?php endif; ?> </table> <?php include_once('../../footer.php'); ?>

Email Warning When Certain Amounts Reached.

By roldahayes
November 15, 2012 in PHP Coding Help

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

× Pasted as rich text. Restore formatting

Only 75 emoji are allowed.

× Your link has been automatically embedded. Display as a link instead

× Your previous content has been restored. Clear editor

× You cannot paste images directly. Upload or insert images from URL.