micheljp/twitter_display.php

## twitter_display.php
<?php

echo '<head>';

echo '<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />';

echo '</head>';

echo '<body>';

//connect to existing db w/ stored tweets and create variable with MySQL data

mysql_connect("path", "user", "pass") or die(mysql_error());

mysql_select_db("dbname") or die(mysql_error());

$tweet_archive = mysql_query("SELECT * FROM twindicators");

//print out MySQL fields in embedded html

while ($row = mysql_fetch_array($tweet_archive)) {

  $decoded_text = urldecode($row["text"]);
  echo '<p>' . $row[user] . ' | ' . $row[date] . '
  <br /><br />
  <a href="https://twitter.com/#!/' . $row[user]  . '/status/' . $row[twid] . '">' . $decoded_text . ' </a></p>';
  echo '<hr />';

}

echo '</body>';

?>
	<?php

	echo '<head>';

	echo '<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />';

	echo '</head>';

	echo '<body>';

	//connect to existing db w/ stored tweets and create variable with MySQL data

	mysql_connect("path", "user", "pass") or die(mysql_error());

	mysql_select_db("dbname") or die(mysql_error());

	$tweet_archive = mysql_query("SELECT * FROM twindicators");

	//print out MySQL fields in embedded html

	while ($row = mysql_fetch_array($tweet_archive)) {

	$decoded_text = urldecode($row["text"]);
	echo '<p>' . $row[user] . ' \| ' . $row[date] . '
	<br /><br />
	<a href="https://twitter.com/#!/' . $row[user] . '/status/' . $row[twid] . '">' . $decoded_text . ' </a></p>';
	echo '<hr />';

	}

	echo '</body>';

	?>