Question: Create a database for the Lee's Landscape business called landscape. The database should have at least two tables with, at minimum, the following fields: Table

Create a database for the Lee's Landscape business called landscape. The database should have at least two tables with, at minimum, the following fields:

Table customers: Fields:

Table billing: Fields:

customer_ID

customer_ID

customer_L_Name

customer_L_Name

customer_F_Name

service

customer_Title (Mr, Ms, Dr. etc,)

customer_bill

street_Address

amt_paid

city_State_Zip

bill_date

customer_Phone

date_paid

customer_Email

Create a PHP page that will extract a customers bill amount and the amount paid. Then it will calculate the amount due. If the amount due is greater than 0, an email should be generated and sent to the customer with that amount in the message. If the amount due is zero or there is a credit, generate a thank-you email that thanks the customer for his or her payment and expresses Lees wishes for continued business with this customer. Name the main page sendBill.php and be sure to include all the necessary accompanying files when you submit your work.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!