333858 php form that adds to database

Đã hoàn thành Đã đăng vào Jul 9, 2009 Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

I am looking to get a simple project going. I have a website that is not live yet. It is a penpal site for inmates.

I need the following:

I need to get a link added to my Inmate Profile Listings (thats not the part I really need help with).. When they click on it I want it to check a table (mysql) to see if they have writes to "send message".

If they have don't have that right or not logged in, I want it to show something about you need to purchase that membership package...etc..

If they do have that right, I need it needs to go to a form. Simple form that would grab the the inmate name, facility address, city, state, zip from a table (from the profile that they just were just viewing) and post it to the form (unchangeable). On that form would also be a spot for their name, address, city, state, zip, and a message box. We would need to put some type of limit to that message field. Then a submit button and it would be entered to the mysql database, emailed to their email address, and copy to me.

One other thing, I want to limit each user to be limited to one letter per day. If they have already sent one letter, it will tell them they are limited to one per day. They would get that before they type the whole letter out. During the first verification maybe.

I would need a screen where I can go to where I can view the information, in the table, from the form. And one extra table field "printed" that I can change so that I can verify that I printed and sent the letter.

In otherwords, I want people that purchased a special right (site already does this part) to be able to send snail mail letters to the inmate (limit one per day). I'll print out the email and mail it to the inmate. The form that goes to the database would be a backup incase the email doesn't go through or something.

I am open to ideas on other ways of doing this.

I am not in a rush for this. Not needed till around July 15th.

I can PM other info as needed.

MySQL Odd Jobs PHP

ID dự án: #2079668

Về dự án

1 đề xuất Dự án từ xa Jul 11, 2012 đang mở

Được trao cho:

weso

Hi, Please view more details in PMB. Thanks, Antony

$25 USD trong 1 ngày
(19 Đánh Giá)
5.8