MySql Forms

nasser

Hello All
I need to collect data from our employees about (1000 ) I have Apache running with PHP4 & Mysql on my PC and its links for others in the LAN , I want to create a form with (Name – Address – Age ….) and each employee can submit his information and updated as he like , but each employee can edit his won record only (shouldn’t see others records )
IS the possible ?
If yes kindly guide me ..
Is there a ready to use database packages works with PHP & Mysql ?
Thanx for your help in advance

Anon

Yes, it is possible but you have a lot more work to do.

You need authentication/session menagement . You can use various packages such as phplib, or the one tim perdue wrote (it is available this site).

Then , you need to key in all the username/password in you database. You can use create a simple pages to let the users to change their password. However, seems that you have 1000 users, thats a a lot of work!!!.

Regards.

[deleted]

A lot of work indeed,
so I'd suggest you also create a form where the users can add their info into the database, and choose a password themselves.
That means you don't have to enter all the user's names.

nasser

I would go with Vincent solution , but what is the first step ? any volunteer can help ?

[deleted]

1) create a form where people can enter their information.

2) create a script that can read the information from the form.
3) create the SQL statement to insert the data into the form.
4) change the script so that it first checks to see if the information that the user entered already exists.
(so people can't enter their data twice)

5) Add a logon feature, so people can choose to logon or enter their data for the first time.

6) Add sessions or cookies so you can remember who logged on, and wether they are stil logged on.

7) make a new form that lets people change their data (that includes pre-filling out the form with the current data)

8) Create a script/sql statement that will update the changed data in the database.

9) treat yourself to a cup of coffee.

nasser

Hay thanx alot for this steps ,I feel bad that I have to do all this alone . I’m new to PHP & Mysql I know how to run php applications on my PC like phpnuke works fine now on my machine .
Kindly more help will be appreciated.

Anon

Nasser,

I think what they are saying is:

You need to need to learn this stuff yourself. I started out with PHP/MySQL about a year ago and went through tons of tutorials and 2 books. This website is great if you are stuck on a particular problem or need some general advice. But you can't come here expecting people to hold your hand and basically write the entire script(s) for you.

Now, since I'm a nice guy, I'll point you to some good php resources that helped me get started:

php.net
http://www.zend.com/zend/art/intro.php
http://www.devshed.com/Server_Side/PHP/
http://www.hotscripts.com/PHP/Scripts_and_Programs/
http://hotwired.lycos.com/webmonkey/99/21/index2a.html

-mt

Anon

here's another one I liked:

http://echodev.com/tutorials/php/basics/

nasser

Hay guys
Don't you think that maybe PHP is not the right tool for this project? What about ASP or Perl , is there a customize package that can help?

Thanx for your support.

Anon

Here's a tip, go to the People section of this site, choose a freelancing person (theyll just need basic experience in php) then give the person a few bucks for coming up with a solution for you.

You obviously dont want to learn anything here or do any work for that matter, so this seems like the obvious answer.

This place is really aimed at those trying to learn and master php, not for "scratch my ass" "code me an app" begging.

Sorry, but it had to be said...