Page 255 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes (@$rowReference)
{
print qq!<TR>!;
foreach $column

(@$columnReference)
{
print qq!<TD>
$column

</TD>\n!;
}
print qq!</TR>!;
}

}
print qq!
</TABLE>
</CENTER>

</BODY>
</HTML>!;
exit;
}

else
{
print qq~Your SQL Query has been
processed, please hit the

back button and submit a
SELECT to see the changes!~;
}
}

Well, however simple that application is, it should be enough to get you started. You will have
to design your own application logic for a more useful database tool, but all the components for
a full featured application are demonstrated here.
As it so happens, I wrote a more complex application that you can use if you’d like. This
application handles inserts, selects, updates and deletes in a much more user-friendly way.
If you want to see the code, click here. Otherwise check out the screen shot of the interface.

248 LOVELY PROFESSIONAL UNIVERSITY