|
Posted by up2trouble on 07/03/07 13:13
<!-- FORM TO POST -->
<FORM ACTION="blog_addentry.php" METHOD="post">
<TABLE ALIGN="left" CELLSPACING="2" CELLPADDING="2" BORDER="1"
WIDTH="95%">
<TR>
<TD CLASS="title">Record Number:</TD>
<TD><INPUT TYPE="text" NAME="record" SIZE="15" MAXLENGTH="15"
DISABLED></TD>
</TR>
<TR>
<TD CLASS="title">Date/Time:</TD>
<TD><INPUT TYPE="text" NAME="time" SIZE="15" MAXLENGTH="15" DISABLED></
TD>
</TR>
<TR>
<TD CLASS="title">Poster:</TD>
<TD><INPUT TYPE="text" NAME="user" SIZE="25" MAXLENGTH="25" ></TD>
</TR>
<TR>
<TD CLASS="title">Entry:</TD>
<TD><TEXTAREA COLS="45" ROWS="7" NAME="entry"></TEXTAREA></TD>
</TR>
<TR>
<TD COLSPAN="2"><INPUT TYPE="submit" NAME="addblogentry"
VALUE="Add"><INPUT TYPE="reset" NAME="Clear"></TD>
</TR>
</TABLE>
</FORM>
<!-- PHP TO ADD POST -->
<?PHP
if(isset($_POST['addblogentry']))
{
$user = $_POST['user'];
$entry = $_POST['entry'];
$sql = "INSERT INTO $db_table1 (user, entry) VALUES
('$user','$entry')";
mysql_query ($sql) or die(mysql_error());
}
?>
<!-- PHP TO LIST POSTS -->
<?PHP
$sql = "SELECT * FROM $db_table1 ORDER BY time DESC";
$result = mysql_query($sql)OR die ('I crashed because: ' .
mysql_error());
while ($row = mysql_fetch_array($result))
{
$user = $row['user'];
$time = $row['time'];
$entry = $row['entry'];
echo "<FIELDSET><LEGEND>Comments</LEGEND>";
echo "<P CLASS='latest'> $entry <FONT SIZE='-2'>[<STRONG>Posted On:</
STRONG> $time][<STRONG>Posted By:</STRONG> $user]</FONT></P>";
echo "<BR>";
echo "</FIELDSET>";
}
?>
don't fotget to add connection stuff and make mysql table
Navigation:
[Reply to this message]
|