<link rel="stylesheet" type="text/css" href="style.css" />
<script language="php">
<!--
// include the database configuration and
// open connection to database
include 'index/config.php';
include 'index/opendb.php';

// check if the form is submitted
if(isset($_POST['btnSign']))
{
	include 'index/config.php';
	include 'index/opendb.php';



	// get the input from $_POST variable
	// trim all input to remove extra spaces
	$name	 = trim($_POST['txtName']);
	$country = trim($_POST['txtCountry']);
	$message = trim($_POST['mtxMessage']);

	// escape the message ( if it's not already escaped )
	if(!get_magic_quotes_gpc())
	{
		$name	 = addslashes($name);
		$message = addslashes($message);
	}

	// prepare the query string
	$query = "INSERT INTO guestbook	(name, country, message, entry_date) " .
		VALUES ('$name', '$country', '$message', current_date)";

	// execute the query to insert the input to database
	// if query fail the script will terminate
	mysql_query($query) or die('Error, query failed. ' . mysql_error());

	// redirect to current page so if we click the refresh button
	// the form won't be resubmitted ( as that would make duplicate entries )
	header('Location: ' . $_SERVER['REQUEST_URI']);
	
	// force to quite the script. if we don't call exit the script may
	// continue before the page is redirected
	exit;
}
-->
</script>
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<title>Guest Book</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script language="JavaScript">
<!--
/*
	This function is called when
	the 'sign Guestbook' button is pressed
	Output : true if all input are correct, false otherwise
*/
function checkForm()
{
	// the variables below are assigned to each
	// form input
	var gname, gcountry, gmessage;
	with(window.document.guestform)
	{
		gname		= txtName;
		gcountry	= txtCountry;
		gmessage	= mtxMessage;
	}

	// if name is empty alert the visitor
	if(trim(gname.value) == '')
	{
		alert('Please type your name');
		gname.focus();
		return false;
	}
	// alert the visitor if country is empty
	else if(trim(gcountry.value) == '')
	(
		alert('Please type in your country');
		gcountry.focus();
		return false;
	}

	}
	// alert the visitor if message is empty
	else if(trim(gmessage.value) == '')
	(
		alert('Please enter your message');
		gmessage.focus();
		return false;
	}
	else
	{
		// when all input are correct
		// return true so the form will submit
		return true;
	}
}

/*
Strip whitespace from the beginning and end of a string
Input	: a string
Output	: the trimmed string
*/
function trim(str)
{
	return str.replace(/^\s+|\s+$/g,'');
}
-->
</script>
</head>
<body>

<table width="23%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
  <td height="52"><p align="center"><img src="images/SASFNAITitle.jpg" width="304" height="72"></p>
</td>
</tr>
</table>

<table width="20%" height="80" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td height="20"><div align="left"><a href="index.html">Home</a></div></td>
</tr>
<td height="20"><div align="left"><a href="Movies.html">Entertainment Media</a></div></td>
</tr>
<tr>
<td height="20"><div align="left"><a href="quotes.html">Quotes</a></div></td>
</tr>

<tr>
<td height="20"><div align="left"><a href="Seasonscalendar.html">Outdoor Photography</a></div>
</td>
</tr>
</table>

<form method="post" name="guestform">
<table border="1" cellpadding="0" cellspacing="0" bgcolor="#dddddd">
<tr>
<td colspan="2" align="center">
<strong><p>Guest Book</p></strong>
</td>
</tr>

<tr>
<td width="40"><p>Name</p></td> 
<td><input name="txtName" type="text" id="txtName" size="20" maxlength="20" tabindex="1"></td>
</tr>

<tr>
<td width="40"><p>Country</p></td>
<td><input name="txtCountry" type="text" id="txtCountry" size="20" maxlength=20 size=20 tabindex="1">
</td>
</tr>

<tr>
<td width="40"><p>Favorite Movie or TV</p></td>
<td><input name="txtFavorite" type="text" id="txtFavorite" maxlength=20 size=20 tabindex="1" />
</td>

<tr>
<td width="20"><p>Message</p></td> <td>
<textarea name="mtxMessage" id="mtxMessage" cols="40" rows="2" wrap="physical" tabindex="1">
</textarea>
</td>
</tr>

<tr>
<td colspan="2" valign="right">
<input type="Reset" size=5 value="Reset" tabindex="1" />

<input name="btnSign" type="submit" tabindex="1" value="Post Entry"
onClick="return checkForm();"></td>
</tr>
</table>
</form>
<script language="php">
<!--

// =======================
// Show guestbook entries
// =======================

// how many guestbook entries to show per page
$rowsPerPage = 10;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use the value as page number
if(isset($_GET['page']))
{
	$pageNum = $_GET['page'];
}

// counting the offset ( where to start fetching the entries )
$query = (pageNum - 1) * $rowsPerPage;

// prepare the query string
$query = "SELECT id, name, country, message, DATE_FORMAT(entry_date, '%d.%m.%Y') ".
	 "FROM guestbook ".
		 "ORDER BY id DESC ".		 // using ORDER BY to show the most current entry first
		 "LIMIT $offset, $rowsPerPage";  // LIMIT is the core of paging

// execute the query
$result = mysql_query($query) or die('Error, query failed. ' . mysql_error());

// if the guestbook is empty show a message
if(mysql_num_rows($result) == 0)
{
-->
</script>
<p align="center">Guestbook is temporarily inoperative<br>I apologize for any inconvenience</p>
<script language="php">
<!--
}
else
{
	// get all guestbook entries
	while($row = mysql_fetch_array($result))
	{
		// list() is a conventient way of assign a list of variables
		// from an array values
		list(($id, $name, $country, $message, $date) =$row;

		// change all HTML special characters,
		// to prevent some nasty code injection
		$name	 = htmlspecialchars($name);
		$message = htmlspecialchars($message);

		// convert newline characters ( \n OR \r OR both ) to HTML break tag ( <br> )
		$message = n12br($message);
-->
</script>
<table width="400" border="1" cellpadding="0" cellspacing="0">
<tr>
<td align="right">
<p><?="date;?><?=$name;?></p></td>
</tr>
<tr>
<td colspan="2"><?=$message;?>
</td>
</tr>
</table>
<br>
<script language="php">
<!--
	} // end while

// below is the code needed to show page numbers

// count how many rows we have in database
$query	 = "SELECT COUNT(id) AS numrows FROM guestbook";
$result	 = mysql_query($query) or die('Error, query failed. ' . mysql_error());
$row	 = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
$maxPage  = ceil($numrows/$rowsPerPage);
$nextLink = '';

// show the link to more pages ONLY IF there are
// more than one page
if($maxPage > 1)
{
	// this page's path
	$self	= $_SERVER['PHP_SELF'];

	// we save each link in this array
	$nextLink = array();

	// create the link to browse from page 1 to page $maxPage
	for($page = 1; $page <= $maxPage; $page++)
	{
		$nextLink[] =  "<a href=\"$self?page=$page\">$page</a>";
	}

	// join all the link using implode()
	$nextLink = "Go to page : " . implode(' &raquo; ', $nextLink);
}

// close the database connection since
// we no longer need it
include 'index/closedb.php';
-->
</script>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="right" class="text">
<?=$nextLink;?>
</td>
</tr>
</table>
<script language="php">
<!--
}
-->
</script>
<br>
<br>
<br>
<br>
<table width="75%" height="65" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="10%"><div align="center"><a href="affiliates.html">Affiliates</a>
</div>
</td>

<td width="10%">
<div align="center"><a href="site_updates.html">Updates</a>
</div>
</td>

<td width="10%">
<div align="center"><a href="purpose_of_this_site.html">Mission Statement</a>
</div>
</td>
<td width="10%">
<div align="center"><a href="mailto:MStrasko08@gmail.com">Contact Me</a>
</div>
</td>
</tr>

<tr>
<td height="20" colspan="4"><p align="center">Established in May 2006. All original content and layout is the intellectual ownership &copy; of Michael C Strasko 2008.<br>
All content related and/or referring to media, technology, and Science are the ownership of their individual
companies and organizations.</p></td>
</tr>
</table>

<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3824687-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</body>
</html>