Source code for:
challenge4.php
<HTML>
<HEAD>
<TITLE>Q7310 Challenge 4</TITLE>
</HEAD>
<BODY bgcolor="000000" link="#FFFF00" vlink="#FFFF00" alink="#00FF00" text="#ececec">
<A name="print_sub"></A>
<?php
/*
=========================================
prtBR = Function to print a line of text and move to a NEW line
prtBR ("the arguement is in double quotes for variable \$text");
==========================================
*/
FUNCTION prtBR($text){
PRINT ("$text <br> \n");
}
// prtBR("This is printing routine.");
?>
<H1 align="center"> Program #4<BR>
MySQL & DATABASE PROCESSING </H1>
<DIV align="center"> <FONT face="arial, helvetica, sans-serif" size=2 color="ececec">
<TABLE width="90%" border=1 cellpadding=10 cellspacing=0>
<TR width="20%">
<TD width="11%"> <FONT color="yellow"> <B><FONT face="Arial, Helvetica, sans-serif" size="2">Item
No.</FONT></B> </FONT> </TD>
<TD width="89%">
<CENTER>
<FONT color="yellow"> <B>Challenge #4 Requirements</B></FONT>
</CENTER>
</TD>
</TR>
<TR width="20%">
<TD width="11%"> </TD>
<TD width="89%"><FONT face="Arial, Helvetica, sans-serif" size="2">Create
a web application that accepts data from the user and stores
it in a database table. Write a web application that retrieves
the data from the database table and provides a report of that
data. </FONT></TD>
</TR>
<TR>
<TD width="11%"> #1 </TD>
<TD width="89%"> - HTML <A href="challenge4/iacsurvey.php">form</A>
to accept user inputs    [<A href="challenge4/src_iacsurvey.php" target="_blank">source</A>]</TD>
</TR>
<TR>
<TD width="11%"> #2 </TD>
<TD width="89%"> - Provide <A href="challenge4/dvalidate.php">data
integrity checking </A>before submitting data to database [<A href="challenge4/src_dvalidate.php" target="_blank">source</A>]</TD>
</TR>
<TR>
<TD width="11%"> #3 </TD>
<TD width="89%">- Save <A href="challenge4/addrecord.php">form
submissions</A> to the database   [<A href="challenge4/src_addrecord.php" target="_blank">source</A>]<BR>
-- Save form submissions to a <A href="challenge4/savedata.php">LOG
</A> with browser information [<A href="challenge4/src_savedata.php" target="_blank">source</A>]
<BR>
-- link to the <A href="challenge4/iac_rawdata.txt" target="_blank">"raw
text file"</A> log; review log as a <A href="formatfile.php" target="_blank">
Report </A> [<A href="challenge4/src_formatfile.php" target="_blank">source</A>]
</TD>
</TR>
<TR>
<TD width="11%"> #4 </TD>
<TD width="89%">- Program-generated HTML page that <A href="challenge4/select_record.php">
displays data in MySQL </A> tables [<A href="challenge4/select_record.php" target="_blank">source</A>]
</TD>
</TR>
<TR>
<TD width="11%"> #5 </TD>
<TD width="89%">- Use at least 2 subroutines (PHP=FUNCTIONS)
in the Program<BR>
-- prtBR [<A href="src_printbreak.php">source snippet</A>]<BR>
-- prtTiger [<A href="challenge4/src_print_mutiger.php" target="_blank">source
snippet</A>]</TD>
</TR>
<TR>
<TD width="11%">#6</TD>
<TD width="89%">- Use at least 1 <A href="challenge4/backmsg.php">external
module </A> [<A href="challenge4/src_backmsg.php" target="_blank">source</A>]
</TD>
</TR>
<TR>
<TD width="11%"> </TD>
<TD width="89%">
<CENTER>
<IMG src="academic_computer.gif" width="65" height="67" alt="Completed Program">
<A href="challenge4/sqlformdp1.php" target="_blank"><FONT face="Arial, Helvetica, sans-serif" size="+2">Completed
</FONT></A><FONT face="Arial, Helvetica, sans-serif" size="+2">
Challenge 4 Program [<A href="challenge4/src_sqlformdp1.php" target="_blank">source</A>]
</FONT>
</CENTER>
</TD>
</TR>
<TR>
<TD width="11%"> </TD>
<TD width="89%"> SOURCE CODE: Click <A href="source4.php" target="_blank">
HERE </A> </TD>
</TR>
</TABLE>
</FONT> </DIV>
[<A href="top" target="_self">Top</A>] <BR>
Last Updated <I>:
<!-- #BeginDate format:fcAm1m -->Tuesday, November 23, 2004 18:45<!-- #EndDate -->
</I>
<P>
<FONT face="Arial, Helvetica, sans-serif" size="1">
(c) 2004 Robin Y. Mabry Hubbard <A href="mailto:4ascii@marz.com">4ascii@marz.com</A>
</FONT>
</P>
</BODY>
</HTML>
|