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
We are in need of Social Network Design from Ground Up - No Framework We are in search of a company that can create a social network site from the ground up using the latest tec

Question: (a) Briefly describe open source technologies, outlining the difference between open source technologies and free technologies. (b) Show advantages of using open

Need to Setup Free PBX Asterisk on Digital Ocean Project Description: Setup Free PBX on Digital Ocean Droplet using Centos 6.5. Skills required are Asterisk PBX, SQL, Linu

sdfsdfsdf

We sell products but now need a program prepared that will take clients serial numbers from products purchased and link it to our website or stand alone software and it alerts clie

Introduction This is an assessed piece of coursework, so the project that you submit must be your own work , and you must understand all the files that you create for this pro

A Web site is a set of linked documents along shared attributes, such as associated topics, a similar design, or a shared reason. Macromedia Dreamweaver is site creation & manageme

In this unit we have study some significant and advanced topics of HTML. Now you have to be able to develop interactive Web pages also. We have discussed ways of connecting to dist


specify a form field where the user can enter large amounts of text. In most respects, works as an field. It can contain a name and