Tracking Arrivals & Sending Email Notification?

[Grady]

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

[Eric Brongers]

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

[Eric]

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?