472,328 Members | 2,077 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

Simple PHP approve/deny

Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.

I hope this all makes sense.

Thanks in advance,
Bryan
Sep 20 '08 #1
4 2087
On 20 Sep, 21:20, Igoogler <Galat...@gmail.comwrote:
Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.

I hope this all makes sense.

Thanks in advance,
Bryan
Why not just have one table with an "approved" column. When the word
gets written to the table, the approved column is blank, when you
approve it, put a 1 in.

The query to display words will only display those with a 1 in the
approved column.
Sep 20 '08 #2
On Sep 20, 1:24*pm, Captain Paralytic <paul_laut...@yahoo.comwrote:
On 20 Sep, 21:20, Igoogler <Galat...@gmail.comwrote:
Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.
I hope this all makes sense.
Thanks in advance,
Bryan

Why not just have one table with an "approved" column. When the word
gets written to the table, the approved column is blank, when you
approve it, put a 1 in.

The query to display words will only display those with a 1 in the
approved column.
You know, that really isn't a bad idea. I think I might try that
instead. Thanks!
Sep 20 '08 #3
Igoogler wrote:
On Sep 20, 1:24 pm, Captain Paralytic <paul_laut...@yahoo.comwrote:
>On 20 Sep, 21:20, Igoogler <Galat...@gmail.comwrote:
>>Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.
I hope this all makes sense.
Thanks in advance,
Bryan
Why not just have one table with an "approved" column. When the word
gets written to the table, the approved column is blank, when you
approve it, put a 1 in.

The query to display words will only display those with a 1 in the
approved column.

You know, that really isn't a bad idea. I think I might try that
instead. Thanks!
Also, make the words column unique. That way no duplicate can be added.
Sep 20 '08 #4
On 20 Sep, 21:26, Igoogler <Galat...@gmail.comwrote:
On Sep 20, 1:24*pm, Captain Paralytic <paul_laut...@yahoo.comwrote:


On 20 Sep, 21:20, Igoogler <Galat...@gmail.comwrote:
Here's what I want to do
I have a form on my site that lets people add a word and then submit
it. It gets submitted to a secondary database. I would then go to the
script and it would show all the words that were added and I could
approve or deny. By approving it would copy that specific row in the
secondary db to the primary which shows on the site live and by
denying it would keep it in the secondary (to prevent duplicates) and
remove it from the script approve/deny page.
I hope this all makes sense.
Thanks in advance,
Bryan
Why not just have one table with an "approved" column. When the word
gets written to the table, the approved column is blank, when you
approve it, put a 1 in.
The query to display words will only display those with a 1 in the
approved column.

You know, that really isn't a bad idea.
I'm glad I've learnt something useful in all my years as an analyst/
programmer!
Sep 22 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Carlos Marangon | last post by:
hello! Can anyone please tell me where can I find a script that deny access if password is wrong 3 times CM
2
by: spike | last post by:
I tried to upload a .htaccess-file to the directory that i wanted to protect. This is what I wrote in it:...
2
by: Galahad | last post by:
I have a current requirement to deny access to a particular website from a list of domains. I can add these domains to a deny list in IIS, however...
31
by: Mike | last post by:
I'm after a *simple* script to log each visitor to a website. All I actually need is the visitor's reported IP address whether genuine, proxied or...
4
by: Dan | last post by:
hi ng. i have a strange behaviour when i want to control who can access a web application by setting web.config like: <authorization> <allow...
5
by: profdotnet | last post by:
Below is the code of web.config file: <configuration> <system.web> <authentication mode="Forms" /> <authorization> <allow users="Admin"/>...
2
by: Markus Palme | last post by:
Hi NG! Is it possible to deny access to a (logged in) user that is not in any role? Placeholders like <deny roles="?"/don't seem to be possible....
0
by: Douglas J. Badin | last post by:
Hi, The problem with Authorization is it stops at the first match and doesn't permit Grouping. On the Web Site, I am trying to Secure Page...
2
by: shapper | last post by:
Hello, After a user has been registered I am sending the following: ...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.