Posted by Eric on 10/14/21 11:12

Grady <bezbaq@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?

[Back to original message]