Database authorization, PHP Web Programming

Use a database table Authorization as shown below with appropriate choice of data typesThis table must be populated by you manually using the PhpMyAdmin interface to MySQL.  The address should be a primary (hence unique) key of appropriate type.   The limit on the number of emails sent to the address should be initialized to some small limit (which can be different per address); the current number sent should be initialized to zero and incremented at each approved request until the limit for the address is reached (based on an SQL update command).  It can be reset manually.

Authorization (for email requests)

address

limit

current

 Mary2@njit.edu

5

4

james.mchugh@njit.edu

3

0

The value of the input address is obtained from the form and the restriction on its number of emails requires using PHP and SQL to compare a pair of columns in the table.  My NJIT address has to be included as above so I can test your work online by sending an email to myself.

Posted Date: 3/29/2013 6:02:43 AM | Location : United States







Related Discussions:- Database authorization, Assignment Help, Ask Question on Database authorization, Get Answer, Expert's Help, Database authorization Discussions

Write discussion on Database authorization
Your posts are moderated
Related Questions
Create a shopping cart I have an incomplete shopping cart. The preceding expert didn't finish the project. He has done 70% of the work as well as then sent it to me. I would lik

Spreecommerce job (RoR) Want a Spree specialist Objectives- 1) To integrate the custom theme (html mark-up need) 2) Slightly change the basic Spree functionality 3)

Need help in Website plateform exchange Here is a brief introduction to the kind of website/plateform I will need. Expert that companies accounts with employees account withi

Web designer / programmer I am seeking a web expert who is able to make changes to templates, flash, html and php scripting for primarily Wordpress, with a bit of OSCommerce, Jo

Opencart (MijoShop) dev -Bespoke Duty/Vat and shipping We have a client who trades wines which are whichever purchased to be shipped to the customer (as standard) OR purchased a

Fix Custom Fields Issue in WordPress Project Description: I am running into a WordPress problem when I import data using the WP All Import plug-in into custom fields created

HTML creation from document besides integration into the website We produce scientific articles besides we wish to create HTML from word documents as well as then integrate it i

I need a Continuing Education Website Please see attached PDF for job specifications. We will be selecting a freelancer within the next week if one meets our needs and budget. T

A function is a deferred script since it does not do anything till a function, an event, a JavaScript link, or an immediate script calls it. You have possibly noticed that you can

Excel calculation on website I acquired one excel sheet which makes a calculation based on four variables. The goal is to have certain sort of online tool which allows people