473,320 Members | 2,189 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Tracking Arrivals & Sending Email Notification?

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
2 2489
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: mcstock | last post by:
before i begin to roll my own, can anybody recommend a web-based application design & tracking tool that provides: functional hierarchy/network definition work break-down structures module...
2
by: Grady | last post by:
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...
1
by: Sori Schwimmer | last post by:
Hi, I am working on an application which involves interprocess communication. More to the point, processes should be able to notify other processes about certain situations, so the "notifyees"...
4
by: Reidar | last post by:
I am trying to send web email in vs2005, but haven't succeeded so far. I found an example in C# to make a Console application. The top of the code is using System; using System.Web.Mail; I have...
12
by: InvalidLastName | last post by:
We have been used XslTransform. .NET 1.1, for transform XML document, Dataset with xsl to HTML. Some of these html contents contain javascript and links. For example: // javascript if (a &gt; b)...
6
by: rahul sinha | last post by:
Please help me to find a email class which contains the functions for sending email as well as email tracking. Thanks Rahul S
0
by: LiveTecs | last post by:
http://www.livetecs.com TimeLive Web Collaboration Suite is an integrated suite that allows you to manage project life cycle including tasks, issues, bugs, timesheet, expense, attendance. ...
4
by: =?Utf-8?B?R3V5IENvaGVu?= | last post by:
Hi all I use: Dim message As New MailMessage(txtTo.Text, txtFrom.Text, txtSubject.Text, txtBody.Text) Dim emailClient As New SmtpClient(txtSMTPServer.Text) emailClient.Send(message) And its...
2
by: Keith G Hicks | last post by:
I'm using the following code to send out email messages to a list of people in a database. My problem is that if I'm sending to 100 people and the 40th address is bad, it crashes on that one and...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.