Forum Moderators: bakedjake
I have a potential client who has a number of pizza franchises-7 or 8. He wants his store managers to be able to log in to the company's website and enter the daily "numbers" in a db. He wants that information to be compiled automatically and outputted to a results page on the site so that everyone can view the current numbers, cash flow, etc of all of the stores.
From everything I have read so far, I can accomplish this using my servers' pre-installed MySQL database (it's a unix server running appache) and, using PHP, configure the web page to output the data from the database.
Is my assumption correct? I have not done databases so far, but I am pretty savvy at figuring things out and should be able to configure it properly. (I HOPE)
Thanks for any feedback. It's always a pleasure to lurk around here.
Pat
You bet. You'll probably get into a bit of secure login, session management and other fun stuff along the way. You could take this as far as you'd like, even display graphs from the collected data, fancying it up a bit ;)
they could simply email the numbers to a mailbox , with the top and bottom of the email being something like
****branch 15 start****
figures
****branch 15 end****
so that you can easily parse the results for each branch.
add a user called "mailreports" (useradd mailreports)
- this will create a mailbox - usually in /var/spool/mail
when mail starts coming in, you'll see the mail file as
/var/spool/mail/mailreports
You can then use php to parse the contents and input them into a backend dbase.
this'll save you all the hassle of session logins , forgotten passwords and numerous other nightmares.
you might need to install php-cli in order to run php from the command line - in debian this is usually installed by doing a
apt-get php-cli
with a
php -v to confirm the install.
