Design a PHP program for TNEB bill payment process. Write the PHP codes alone.

Assume that we got the following values through $_POST array from HTML form. The values are basic details like user name, password, service number. Using the user name and password create a session.

If the session is set and valid, proceed for getting serice_bill_amount, service number, name from the SERVICE MYSQL database.

Update the current service_bill_amount to 0, since he has paid the bill.

Design a PHP program for TNEB bill payment process. Write the PHP codes alone. Assume that we got the following values through $_POST array from HTML form. The values are basic details like user name, password, service number. Using the user name and password create a session. If the session is set and valid, proceed for getting serice_bill_amount, service number, name from the SERVICE MYSQL database. Update the current service_bill_amount to 0, since he has paid the bill