Create a PHP program for the following wireframe design.

Name of the database: CRUD

Name of folder: scholars

Tables are ID, Last Name, First Name, Address, Birthdate

Compiler: Notepad will do.

MAIN:

NEW (CREATE)

UPDATE 1: (READ)

UPDATE 2:

DELETE1

DELETE2

Main \begin{tabular}{|l|l|} \cline { 2 - 2 } ID \\ \cline { 2 - 2 } Last Name & \\ \cline { 2 - 2 } First Name & \\ \cline { 2 - 2 } Address & \\ \cline { 2 - 2 } Birthdate & \\ \cline { 2 - 2 } & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline New & Update & Delete \\ \hline \end{tabular} New (Create) \begin{tabular}{|l|l|} \hline ID & \\ \cline { 2 - 3 } Last Name & \\ \hline First Name & \\ \hline Address & \\ \hline Birthdate & \\ \hline & \\ \hline Save & \\ \hline \end{tabular} a Fillup the field b Save if ID exist message Record already exist else insert the record Update 1 (Read) a Enter the ID to search \begin{tabular}{l|l|} \cline { 2 - 2 } ID & \\ \cline { 2 - 2 } Last Name & \\ \cline { 2 - 2 } First Name & \\ \cline { 2 - 2 } Address & \\ \cline { 2 - 2 } Birthdate & \\ & \end{tabular} b Search if ID exist Display the rest of the record else Message record not found c Main Search Update 2 \begin{tabular}{|l|r|} \hline \multicolumn{1}{|c|}{} \\ \cline { 2 - 2 } ID & 12 \\ \cline { 2 - 2 } Last Name & 2 \\ \cline { 2 - 2 } First Name & 12 \\ \cline { 2 - 2 } Address & 12 \\ \cline { 2 - 2 } Birthdate & 12 \\ \cline { 2 - 3 } & \end{tabular} a Make changes to the record b Update Update the record Update Delete 1 \begin{tabular}{|l|l|} \hline ID & \\ \hline Last Name & \\ \hline First Name & \\ \cline { 2 - 3 } Address & \\ \hline Birthdate & \\ \hline & \\ \hline Search & \\ \hline \end{tabular} a Enter the ID to search b Search if ID exist Display the rest of the record else Message record not found Delete 2 \begin{tabular}{|l|l|} \hline ID & \\ \hline Last Name & \\ \hline First Name & \\ \cline { 2 - 3 } Address & \\ \hline Birthday & \\ \hline & \\ \hline Update & \\ \hline \end{tabular} a Make changes to the record b Delete Delete the record c Main