473,657 Members | 2,932 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2177
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...@y ahoo.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...@y ahoo.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...@y ahoo.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
3709
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
1206
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: ------------------------------------------------ <Limit GET> order deny,allow deny from all allow from mydomain.com </Limit>
2
1489
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 that doesn't give me the ability detect these domains and then redirect users to specific deny pages based on the domains to which they are members. I can include a function on all of my webpages to detect the various domains and redirect users, however this would be a very tedious process...
31
1849
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 hidden. Their reported browser type would be an advantage, regardless of what browser is actually used. Anyone know of anything simple and preferably free that will do this? The site is hosted on a FreeBSD server with access to CGI-Bin but it does not seem to have a server-side stats log. ...
4
12149
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 users="DOMAIN\ACCOUNT,..." /> <deny users="*" /> the authorization is working fine, but the user receives the standard "The page cannot be displayed"
5
16427
by: profdotnet | last post by:
Below is the code of web.config file: <configuration> <system.web> <authentication mode="Forms" /> <authorization> <allow users="Admin"/> <deny users="Jack,Mary" /> <deny users="?"> </authorization>
2
2732
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. Regards Markus <location path="Protected.aspx"> <system.web>
0
4477
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 Access and SiteNaviagation by implementing the following ASP.NET 2.0 features: - Membership - Site Maps
2
1455
by: shapper | last post by:
Hello, After a user has been registered I am sending the following: http://MyDoman.Com/Account/Approve/3620e45b-d899-4990-8ea5-74cbf2af8153?Key=C3EA110078422FF19478A8B45A7C34F4 Basically, the guid after Activate/ is the user ProviderUserKey. The key is a Hashed MD5 string created from: String.Concat(user.UserName, user.Email, user.CreationDate.ToString())
0
8302
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8820
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8718
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8601
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5630
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4300
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1937
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.