PHP Program to Create Medication DBMS Assignment Solution.

// STEP 1: Create a window (tab) title of the frontend application (web page) ?>

// STEP 2: Create a page header of the frontend application ?>

Medication Module by Shobha Stephen

// Retriving the existing records from the Medication table

$con = new mysqli("localhost","root","");

if(!$con)

echo "-- error in connecting to the database --";

// Connect to the database

// Step 3: Write the name of the database you want to connect to in the double quotes below

mysqli_select_db($con, "week_8_db");

// Retrieve all data from the table in the database

// Step 4: Write the entity/table name in the SQL command line below

$result = mysqli_query($con, "SELECT * FROM MEDICATION");

echo "

// Step 5: Create the column names for the MEDICATION table for output viewing

echo "

echo "

echo "

echo "

echo "

while($row = mysqli_fetch_array($result))

{

//Note: All attribute name appearing in brackets below are case sensitive

//Note: All attribute name must match exactly to what is in the table you created

//Step 6: Write the attribute name in the bracket as it appeared in your table

echo "

}

echo "

// Closing the connection to the database

mysqli_close($con);

?

/BODY