This is an easy project for a programmer who knows what they are doing.
I am looking to create a simple PHP form that will do the following:
1) - install program to create one table in MySQL and pre-populate the records
2) - create a form with that will allow the records to be edited.
-- There are 2 access levels. To keep this as simple as possible, I would like two different forms created. One which shows everything, and one that only shows the records with that correct access level.
3) - when editing is done and the user clicks "save and publish changes" do the following:
a) save changes to the database
b) generate a file from the database
c) create an email
1) Installation Program and Setup
I like things simple and clean. Attached ([url removed, login to view]) is an example program showing how I would like the program to be displayed.
- I would like an install program like this one.
- I would like to use the style sheet options. Separate this out into a [url removed, login to view] file.
- The table will have 4 fields: Tokens, Titles, Values and AccessLevel
-- Tokens. Should be stored as text. Won't be over 255 chars.
-- Titles. Should be stored as text. Won't be over 255 chars.
-- Values. Should be stored as text. Can be over 1000 chars. There will also be HTML stored.
-- AccessLevel. I currently have two values: 0 for admin and 5 for user. I don't care if you use integer or text to store it, or if you wanted to use words (like admin and user) instead of numbers (like 0 and 5). The key is that if it's the admin form, all the records show. If it's the user form, only the user fields are displayed.
2) Forms to edit and update data
There should be two forms. If it's the "admin form" (AccessLevel=0) all the records should be shown. If it's the "user form" (AccessLevel=1), then only the user records should be show.
Display the Titles (bolded) then the Values.
Address 1: 123 Anyplace Avenue
Address 2: Suite 456
City: Your City
For editing there are two options. My preferred way would be to display this all as a form with the form fields pre-populated from the database. Option 2 would be to display all the values and have an "edit" button next to the record and when clicked would allow that record value to be edited.
The fields should allow simple HTML. The following tokes should have text area boxes in the form that translate and display the html tokens correctly:
I'm open to your ideas on the best way to allow editing for all the fields. Let me know your ideas.
3) Saving the information
After the edits are done, there should be a "save and publish" button. When clicked:
a) Save all changes to the database. Depending on the editing option you recommend, each record may be saved as it's edited.
b) Generate a "[url removed, login to view]" file from the database. Attached ([url removed, login to view]) is an example of what this file looks like. When you generate the file, use the "BusinessName-token" value to name it replacing the spaces in the BusinessName-token with dashes.
Example: BusinessName-token=Your Company Name
File name: [url removed, login to view]
The first line of the file should include the date it was updated. (note, the double forward slash indicates a comment)
Example: // Last Update: 06-01-07
Use the "Tokens" and the "Values" fields when creating. When done, it should look exactly like the example file.
c) Create an email: after the data has been saved and the new [url removed, login to view] file is create, kick off an email to a specified email address.
- Email From: I'll define in the script
- Email To: I'll define script
- Email Subject: "Business Name [url removed, login to view] Update - Date"
Use the BusinessName-token value for the Business Name and the current Date for the date.
- Email Body: Business Name [url removed, login to view] has been updated - Date
Post any questions in the PMB.