Hello to all, I'm as fresh as someone can be with PHP / MySQL but I do my best and have made a little progress in making a php page for my solarsystem.
I got this far that I can get my data from the dbase and can make some query's which can be shown on the page of my home webserver (running Ubuntu LTS 10.04.1 with Apache2 and PHP5 and Mysql)
I also have made som graphic charts with this wonderful PHPgraphlib option which can be found here : http://www.ebrueggeman.com/phpgraphlib
But now I want go a step further and I want my system to send me (postmaster) a mail or message when the solarsystem has produced 1000kWh.
The first question is how to make the query to do this so that it looks for the total produced kWh in the sql dbase and everytime it reaches 1000, 2000, 3000, etc (maybe this should be in another section on this board?
Then the second question is how to make this automatic or should I do this into another package because I can imagine that if the php webpage is not used it will not load anything and it will not send a mail/message.
I also could just make a vissible countdown on this page that would show the remaining to produce count.
I could take the amount of 1000 minus the already produced amount, but what then if this is done? it should restart with 2000 minus the already produced amount.
I have a lot of it all in my head but to get started with this is making my head turning crazy.