By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,537 Members | 1,471 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,537 IT Pros & Developers. It's quick & easy.

Tracking Arrivals & Sending Email Notification?

P: n/a
Help.

I need to create a simple database that tracks equipment arrivals (and
departures) at my facility. What I want is to create a simple form,
which the receptionist could fill out, every time someone delivers
something at the front door. The form would simply have a place to put
the time/date, delivery method, addressee, and a brief description.
Once the receptionist filled it out and hit enter it would create a
new record and then send a summary notification email to a group of
people on site who would then process the equipment as needed.

Is there relatively simple way to do this in PHP & MYSQL? Basically
all I need to create a data entry form that also sends a notification
email. I was thinking I could just create a simple form on our
intranet site. I would also like a way to track items as they leave
the building as well.

Thanks,
BEZ
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes this is quite simple with PHP / MySQL and if you like witch Pear.

Regards,
Eric Brongers
Freelance PHP progammer.

"Grady" <be****@yahoo.com> schreef in bericht
news:26**************************@posting.google.c om...
Help.

I need to create a simple database that tracks equipment arrivals (and
departures) at my facility. What I want is to create a simple form,
which the receptionist could fill out, every time someone delivers
something at the front door. The form would simply have a place to put
the time/date, delivery method, addressee, and a brief description.
Once the receptionist filled it out and hit enter it would create a
new record and then send a summary notification email to a group of
people on site who would then process the equipment as needed.

Is there relatively simple way to do this in PHP & MYSQL? Basically
all I need to create a data entry form that also sends a notification
email. I was thinking I could just create a simple form on our
intranet site. I would also like a way to track items as they leave
the building as well.

Thanks,
BEZ

Jul 17 '05 #2

P: n/a
Grady <be****@yahoo.com> wrote:
Help.

I need to create a simple database that tracks equipment arrivals (and
departures) at my facility. What I want is to create a simple form,
which the receptionist could fill out, every time someone delivers
something at the front door. The form would simply have a place to put
the time/date, delivery method, addressee, and a brief description.
Once the receptionist filled it out and hit enter it would create a
new record and then send a summary notification email to a group of
people on site who would then process the equipment as needed.

Is there relatively simple way to do this in PHP & MYSQL? Basically
all I need to create a data entry form that also sends a notification
email. I was thinking I could just create a simple form on our
intranet site. I would also like a way to track items as they leave
the building as well.


Yep, it is a very easy thing to do.

But....

The first step is to again write down _everything_ you want this system
to do. After you have written it down, hand it to everyone you can
(including the receptionist who will be forced to use it a lot) for
review in case you missed something important (and you most certainly
did). After a few rounds of this, you _may_ finally have a specification
that would be worth implementing.

For example, what kind of security do you want this system to have?
Should anyone walking up to a computer with access be allowed to make
changes?


Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.