Authorizing submitted forms

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
morris_osu
Forum Newbie
Posts: 2
Joined: Mon Jun 06, 2005 12:59 am

Authorizing submitted forms

Post by morris_osu »

Okay, I'm not sure if this question has been asked yet, so I'll just ask it on here.

What I want to do is have a form in which users can submit data. Then, I want that data to be stored in a database (an un-authorized database). Then, on an admin-only page, I want the un-authorized data listed and the ability to authorize them by a mere click of a button, thereby adding them to an authorized database. This information will then be posted online.

Sound easy? I'm having trouble with the authorization part of the entire thing. Would it be easiest to just have another form, have the un-authorized data listed, and when a certain one is selected (from a drop-down menu, probably), to just have the submit button put it in the authorized database? Or would there be an easier way, maybe? Thanks!
thegreatone2176
Forum Contributor
Posts: 102
Joined: Sun Jul 11, 2004 1:27 pm

Post by thegreatone2176 »

i think it would be easier to just use one table and then have a column for 'authorized' and when its first submitted set it to 0 then after you do your admin function have it update that column to 1

using two would be a big waste of time/space/code
morris_osu
Forum Newbie
Posts: 2
Joined: Mon Jun 06, 2005 12:59 am

Post by morris_osu »

Ah, good call. It's late, LOL.
Post Reply