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'); ?>

Jump to content

Existing user? Sign In
Sign In

Remember me Not recommended on shared computers

Forgot your password?
Sign Up

Browse
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
- More
Activity
- All Activity
- Search
- More
Join our Discord!
More
- More

PHP Coding Help

Email Warning When Certain Amounts Reached.

By roldahayes
November 15, 2012 in PHP Coding Help

Start new topic

Recommended Posts

roldahayes

Posted November 19, 2012

Author

- Share

Posted November 19, 2012

Aha, got it working now with:

$query = "SELECT product_amount.id, product.id, product.code, product_amount.amount
FROM product_amount, product
WHERE product_amount.amount<=5.0000 and product.id = product_amount.product_id";

Thanks for the help.

Link to comment

https://forums.phpfreaks.com/topic/270720-email-warning-when-certain-amounts-reached/page/2/#findComment-1393505

Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Browse
- Back
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
Activity
- Back
- All Activity
- Search
Join our Discord!

Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

Sign In