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
Get step-by-step solutions from verified subject matter experts
