PHP
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 customer’s bill amount andthe amount paid. Then it will calculate the amount due. If theamount due is greater than 0, an email should be generated and sentto the customer with that amount in the message. If the amount dueis zero or there is a credit, generate a thank-you email thatthanks the customer for his or her payment and expresses Lee’swishes for continued business with this customer. Name the mainpage sendBill.php and be sure to include all the necessaryaccompanying files when you submit your work.
