<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; carset=utf-8" />
<meta name="description" content="A research collaboration on the country Russia and its totalitarian roots for a jYork group project stemming from George Orwell's 1984." />
<meta name="keywords" content="russia, totalitarian, research, george orwell, 1984, regime, soviet union, USSR, project" />
<title>The Russia Project- A YorkBrit 1984 Research Collaboration</title>
<link rel="stylesheet" type="text/css" href="trp.css" />
</head>
<body>
<img class="bgimg" src="ussr and russia flag.png" alt="" />
<div class="wrap">
<div class="header">
<img class="headerimg" src="trpheader.png" alt="The Russia Project: A YorkBrit 1984 Research Collaboration" />
</div>
<div class="menubar">
<table class="menubar" cellpadding="0px" cellspacing="0px">
<tr>
<td id="leftendcap"> </td>
<td>
<a href="index.html" id="home"><span>Home</span></a>
</td>
<td>
<a href="ussr.html" id="ussr"><span>U.S.S.R.</span></a>
</td>
<td>
<a href="russia.html" id="russia"><span>Russia</span></a>
</td>
<td>
<a href="workscited.html" id="workscited"><span>Works Cited</span></a>
</td>
<td id="rightendcap"> </td>
</tr>
</table>
</div>
<center>
<div class="content">
<h1 class="page-title">COMMENT TEST PAGE</h1>
<br />
<hr id="article_comment_break" noshade />
<?php
require_once($_SERVER['DOCUMENT_ROOT']. '/database_connect.php');
//querying comments for this article
$inf = "SELECT * FROM `comments` WHERE page = '".stripslashes($_SERVER['REQUEST_URI'])."' ORDER BY time";
$info = mysql_query($inf) or die ( mysql_error() );
if( mysql_num_rows( $info ) != 0 ) {
echo '<h3 class="comments">Comments:</h3>';
echo '<table class="comments">';
while ( $info2 = mysql_fetch_object( $info ) ) {
echo '<tr>';
echo '<td>'.htmlspecialchars(stripslashes($info2->subject)).'" by: <a href="'.$info2->contact.'">'.htmlspecialchars(stripslashes($info2->username)).'</a></td><td><div> @ '.date('h:is a', $info2->time).' on '.$info21->date.'</div></td>';
echo '</tr><tr>';
echo '<td colspan="2"> '.htmlspecialchars(stripslashes(n12br($info2->comment))).' </td>';
echo '</tr>';
} // end while
echo '</table>';
echo '<hr noshade width="500px" align="center" />';
}
else echo 'No comments for this page. Feel free to be the first. <br />';
if (isset($_POST['submit'])) {
if(!addslashes($_POST['username'])) {
die('<u>ERROR:</u> You must enter an alias to comment.');
}
if(!addslashes($_POST['contact'])) {
die('<u>ERROR:</u> Please enter an email or URL to comment.');
}
if(!addslashes($_POST['subject'])) {
die('<u>ERROR:</u> Please give your comment a subject.');
}
if(!addslashes($_POST['comment'])) {
die('You <u>must</u> enter a comment in order to comment (DUH!).');
}
// this is for a valid contact
if(substr($_POST['contact'],0,7) != 'mailto:' && !strstr($_POST['contact'],'//')) {
$_POST['contact'] = "mailto:".$_POST['contact']."";
}
else {
$_POST['contact'] = "http://".$_POST['contact']."";
}
// end valid contact
//add comment
$q = "INSERT INTO `comments` VALUES ('".$_GET['id']."', '".$_POST['page']."', '".$_POST['date']."', '".$_POST['time']."', '".addslashes(htmlspecialchars($_POST['username']))."', '".$_SERVER['REMOTE_ADDR']."', '".addslashes(htmlspecialcharacters($_POST['contact']))."', '".addslashes(htmlspecialchars($_POST['subject']))."', '".addslashes(nl2br(htmlspecialchars($_POST['comment'])))."')";
$q2 = mysql_query($q);
if(!$q2) die(mysql_error());
//refresh page so they can see new comment
header('Location: http://' . $_SERVER['HTTP_HOST'] . $_POST['page'] . "#comments");
}
else { //display form
?>
<form name="comments" action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<input type="hidden" name="page" value="<?php echo($_SERVER['REQUEST_URI']); ?>">
<input type="hidden" name="date" value="<?php echo(date()); ?>">
<input type="hidden" name="date" value="<?php echo (time()); ?>">
<div class="form_fields" >
<label>Alias:</label><input type="text" name="username" size="30"><br />
<label>Subject:</label><input type="text" name="subject" size="30"><br />
<label>Email or URL:</label><input type="text" name="contact" size="30"><br />
<label>Message:</label><textarea name="comment" rows="5" cols="24"></textarea><br />
<input type="submit" value="Post Comment" />
</div>
<?php
} //end else
?>
</div>
</div>
</center>
<div class="footer">
<p class="footer"> Design ©2010 Scriptech Designs • Content ©2010 YorkBrit English 11-4</p>
</div>
</div>
</body>
</html>
