I just started a local “directory” site which allows local service-oriented businesses to register and create a profile from a single form (www.needitdone.net/register.php). Currently, I am manually creating (“hand coding”) these profiles from an HTML template using the data emailed to me through a PHP Form Mail script which I configured for this site. I would like to add a backend with login capability which would enable these profiles to be edited by the registered user (businesses) and also have the ability for them to upload additional photos which are to be stored in a pre-existing image folder. The profiles themselves DO NOT necessarily have to be edited “on the fly” (dynamically), I just need to be able to access the records (in whatever format) containing the revised text data after it has been resubmitted. Using this data, I can then go back and manually edit the HTML profile page for that particular business.
At logon, the business would be directed to a page which is identical to the static HTML profile I’ve already created for that business with the possible addition of an SSI link that reads “edit profile”. When they click on this link a form similar to the original registration form should appear with their original data repopulated in the HTML fields, similar to an Ebay or Craigslist listing that is being edited. The PHP script that is run when they re-submit this form should write the new data to a database and POST the additional images to their respective image folder (the one that I created when they first signed up).
For now, the MySQL database can contain a single table and should be configured to be searchable and will include some additional fields that are not derived from the original form such as:
-date
-keywords relating to the category of the business
-path to folder containing images
(etc.)
I am currently set up on JustHost.com with PHP 5.2. MySQL can be configured via phpMyAdmin.
I do not have shell access, but I can get it at additional cost if you need it.
To summarize, I need a PHP script which will:
-retrieve records from a database and re-populate a form (needitdone.net/register.php);
-write records to a database;
-POST images to pre-existing files.
I have very limited knowledge of PHP and MySQL and I’m open to any suggestions.