Authorization table and authorized address, PHP Web Programming

The number of emails  to a given email address is updated each time an email is sent.  A request for a given address should be rejected unless the address is in the Authorization table and the number of current number of accesses for that address are below the limit.  Set the limit  at a value that reduces the risk of abuse of your web service if your reporter name and password are compromised.  You can enforce the limit and the authorized email addresses using SQL update command with an appropriate condition in its where clause.

Use the SQL update command in the PHP script to update the current attribute for the unique row with a matching address.  This command  should affect a row only if the address exists and if the limit for the address has not yet been reached.  The addresses and limit attribute values are manually set, and current is manually initialized to zero for each row.  Refer to IT 202 manual for the use of SQL update command (such as p. 239 of manual).  Refer to IT 202 manual or online PHP manual for related use of the mysql_affected_rows() function which returns how many rows were affected by the update (which will be zero if the request was un-authorized but one if the request was granted).

Posted Date: 3/29/2013 6:09:06 AM | Location : United States

Related Discussions:- Authorization table and authorized address, Assignment Help, Ask Question on Authorization table and authorized address, Get Answer, Expert's Help, Authorization table and authorized address Discussions

Write discussion on Authorization table and authorized address
Your posts are moderated
Related Questions
Magazine WordPress Website Developer We are seeking a talented WordPress developer to turn our mockups into a functioning WordPress website. The website will comprise the fol

Shopify Web Developer Project Need changes and expert For Web Developer and Designer - Want header with t4 skinny+ Diet-Free Tea in - Logo redesign - New image for ever

need help with initial programming of the system as displayed in the attachment..its about simple incident response system that , as per my idea, shall be universal and easily depl

3D Printing website as well as software written mainly in Phython and HTML5 We would like to appoint someone who is capable to bring the power of OctoPrint as well as botqueue t

How can we increase the execution time of a php script? By the use of void set_time_limit(int seconds) Set number of seconds a script is allowed to run. If this is reached,

Jr Developer a) I have an Immediate project that needs to be done right now. I have a few PSDs that want to be converted to HTML / CSS for Email (MailChimp) I am looking for a J

Transport layer is the first end-to-end layer. Header of the transport layer has information which helps send the message to the corresponding layer at the destination node. The me

Jaspersoft: Custom Input Control: Tree View For a fresh project we urgently need a custom type of Input Control which is a tree view. we have the subsequent table structure (

We need help to Fix Drupal 5.0 site. not working We have a Drupal 5.0 site that abruptly isn't connecting with Fundamentally, we are having some

Booking Website REQUIRED We are looking for an expert to support us to complete our website on online booking system in this user will register and access the booking page. D