Page 253 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes <TABLE BORDER = “1”>
<TR>
<TH>Enter SQL Query</TH>
<TD>

<INPUT TYPE = “TEXT”
SIZE = “40”
NAME = “sql”>
</TD>

<TD>
<INPUT TYPE = “SUBMIT”
NAME = “requestType”
VALUE = “Submit SQL”>

</TD>
</TR>
</TABLE>
</FORM>

</BGODY>
</HTML>!;
exit; }
# If there was a value for $sql, we know

# that the user has already seen the
# HTML form and has submitted some
# SQL for us to process. In that case,
# we will open a connection to the

# database, execute the SQL, gather
# the result set and display it
# to the user. In the case of a
# simple SELECT, we will display

# the results in an HTML table.
# If, on the other hand, the SQL
# was a DELETE, MODIFY or INSERT,
# we will let them know that the

# operation was successful.
#
# Notice that you need to do a lot

246 LOVELY PROFESSIONAL UNIVERSITY