Franck
|
| Posted: 07/23/2002, 5:47 AM |
|
I want to be explained how to do for this,
i wabt an administration box there I can Update after control forms comleted by visitors like in events. those forms ca'n be on the net without my approbation; how to do please, It's very important for my website.
franck great thanks
|
|
|
 |
Andrew
|
| Posted: 07/23/2002, 6:59 AM |
|
Franck,
So, your visitors are completing a form that creates a record in a table. You then don't want the record to appear on the web without your approval.
You could add a TRUE/FALSE field to the database table called 'OK_to_Show'.
Make your web page show only records where OK_to_Show = TRUE.
When your visitors add records, OK_to_Show should be set to FALSE by default. Then, once you have personally checked what your visitors have written, you can set OK_to_Show to TRUE, and the record will appear.
This site infact uses approval for 'User Submitted Links'. You could download the code to this site and see how the approval is implemented.
|
|
|
|
franck
|
| Posted: 07/23/2002, 7:10 AM |
|
franck, the solution i think can be setting a variable for success aprov.
table can be like this
ID
MESSAGE
USER
STATUS
When user insert status would be "1" so you can make a Admin Page where SQL show only "1" ... so you can read and aprovee... if you are sure to publish, you can set the value to a "2"
So in your Home Page SQL shows only the values for records that contains status = 2
is easy..
|
|
|
|
|
