You work for The Worlds Greatest Bank and you have been asked to design and program a web page using PHP/MySQL. Your program should support a bank client database. Your database should maintain fields for client information, where each client record must contain the account number, client name, client email address, client telephone number, account type (Packaged, Savings, Checking, Fixed Deposit, Recurrent Deposit, or Minor Account), and amount available. 

 All your pages should contain a header with links to different pages. These pages should be:

 

  Home  which is the main page. The main page lists all the clients stored in the database with buttons to Delete, Deposit an Amount, or Withdraw an Amount for each client.

 

  Add a Client which adds a new client with a unique account number to the database. This page will allow the user to choose the type of account from a dropdown list, enter the client name, email address, telephone number, and starting amount to deposit. Validate all the data entered then generate a nine-digit account number. The account number contains a fixed number for the first digit depending on the account type (Packaged Account = 1, Savings Account = 2, and so on), followed by 7 random digits, followed by a check digit in the rightmost digit. The check digit is calculated using the Luhn Mod-10 Method:

 

 The second, fourth, sixth, and eighth numbers are each doubled. If the value after doubling is greater than 9, then subtract 9 from the resulting value. Take the sum of all the individual resulting digits along with the skipped digits. The check digit is determined by subtracting the remainder of the total divided by ten from ten. Place this value in the rightmost digit of the account number.

 

 If the account number exists in the database then generate another account number. Print the new client information, including the bank account number, on the screen for the user and ask for confirmation before storing in the database.

 

  Withdraw from a Clients account which allows the user to enter an account number and amount to be withdrawn. Validate the inputs given. Make sure the account number is valid by using the method above before searching the database for the account record. A proper message should be displayed if the account number was not found in the database. The account is not allowed to be overdrawn; therefore, you must make sure to provide a proper message if this is to occur and the user should be able to enter another amount to withdraw. If the amount entered is permissible, print the account details before withdrawing and after withdrawing and ask for confirmation from the user. If the user confirms the transaction, update the database with the new amount to the account. If the user decides to cancel the transaction, then they should be directed to the main page.

 

  Deposit into a Clients account which allows the user to enter an account number and amount to be deposited. Validate the inputs given. Make sure the account number is valid by using the method above before searching the database for the account record. A proper message should be displayed if the account number was not found in the database. Print the account details before depositing the amount and after depositing the amount. Ask for confirmation from the user. If the user confirms the transaction, update the database with the new amount to the account. If the user decides to cancel the transaction, then they should be directed to the main page.

 

  Delete a Client which allows the user to enter an account number. Validate the account number by using the method above before searching the database for the account record. A proper message should be displayed if the account number was not found in the database. Print the account details and ask for confirmation from the user. If the user confirms the operation, then delete the clients record from the database. If the user decides to cancel the operation, then they should be directed to the main page.

 

 **Note**: Any invalid input data should be identified with a message and the user should be allowed to enter the data again.

 

 The header should also contain a search box and button to click to perform the search. The user may enter any sequence of characters to search for in the search input field. The characters entered in the search box may appear in any field of the record. After clicking the search button, all records containing the sequence of characters, appearing in any of the record fields, should be displayed for the user with the choice to Delete, Deposit an Amount, or Withdraw an Amount for each client record. The number of records found should also be displayed along with the sequence of characters searched for.