Page 1 of 1
Venue Database
Posted: Thu Jul 21, 2011 6:38 pm
by Sarahlmorrow
I am just trying to come up with a few ways to make this happen,
basically what I need is a way for a user to visit a web page and enter their venue information into a form. Then that information needs to be sent to a database to be added upon approval from an administrator.
This database would also be made searchable..
any suggestions of where I should get started?
Re: Venue Database
Posted: Thu Jul 21, 2011 7:54 pm
by califdon
You are describing a fairly sizable project. Are you thinking of designing the logic and writing the code yourself? Unless you have some experience with PHP, databases, and web design, I think you will not find it practical to do it yourself. If you want to hire someone to do it, I suggest that you post this in the Job Hunt forum.
Re: Venue Database
Posted: Wed Jul 27, 2011 12:45 pm
by califdon
jaydeee wrote:interesting.
guess this is fairly easy.
Easy for an experienced web developer. Not so easy for someone who has to ask this question in the first place.
Re: Venue Database
Posted: Wed Jul 27, 2011 7:36 pm
by Christopher
Sarahlmorrow wrote:any suggestions of where I should get started?
It is a little bit of work to create something like this. Since there is an approval process you will need a 'approved' field in your database in addition to the fields to hold the entered information. There are three main parts:
- The form where users enter their information. Important that you validate and filter the input for security, and escape it before inserting into the database. At this point 'approved' will be set to NO.
- An admin page where you can view a list of records where approved is NO and approve a record by updating approved to YES. This area of the site needs to be password protected, which can be complicated to implement. You could also use HTTP authentication to protect this area of the site.
- A search page that allows people to search records where approved is YES that match the search criteria. Again, it is mportant that you validate and filter the input for security, and escape it before inserting into the database.