How do I add an administators approval link in my PHP scripts using mySql on my website?

Question by Dark: How do I add an administators approval link in my PHP scripts using mySql on my website?
I have a database full of adverts of stuff that people want to give away for free, however these ads needs to be vetted by an administrator now before publishing as some people advertise services and for sale stuff on their, I am really quite new to PHP and MySQL, so please give detaied instructions, please? Thanks

Best answer:

Answer by Raja
You have to create the form for post advertises in user page. The user designs ad and when they post to site, they need administrator approval. You have to design the database with status field. 0 means not designed yet, 1 = ad submitted for approval, 2= approved and live 3=disapprove, 4 =expire
When the user submit the ads to administrator approval, send the intimation mail to administrator and once they approve/decline again you send the mail to users

If you need more information I’ll help you with this task. Feel free send the mail to me with your clarifications.

Add your own answer in the comments!

Get the book now