Venue Database

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
Sarahlmorrow
Forum Newbie
Posts: 2
Joined: Thu Jul 21, 2011 6:31 pm

Venue Database

Post 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?
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Venue Database

Post 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.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Venue Database

Post 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.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Venue Database

Post 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.
(#10850)
Post Reply