';
//Show tag cloud
echo '
';
}
}
else if (strcasecmp($searchtype,'year') == 0) //return all poems written in this year
{
//Search for forms with n number of lines
echo '';
$dateCloud = new wordCloud();
$categoryCloud = new wordCloud();
$formCloud = new wordCloud();
$SQL = "SELECT date, form, category FROM poems";
$retid = mysql_db_query('bj_poems',$SQL, $conn);
if (!$retid)
{
die( mysql_error());
}
else
{
/* fetch rows */
$NumberOfRows = mysql_num_rows($retid);
for ($i = 0; $i < $NumberOfRows; $i++)
{
if (!mysql_data_seek($retid, $i))
{
echo "Cannot seek to row $i: " . mysql_error() . "\n";
continue;
}
if (!($row = mysql_fetch_assoc($retid)))
{
continue;
}
$dateCloud->addWord($row['date']);
$categoryCloud->addWord($row['category']);
$formCloud->addWord($row['form']);
}
$myDateCloud = $dateCloud->showCloud('array');
$myFormCloud = $formCloud->showCloud('array');
$myCategoryCloud = $categoryCloud->showCloud('array');
echo 'Search by Year
'; if(is_array($myDateCloud)); { foreach($myDateCloud as $key => $value) { echo''.$value['word'].' '; } } echo '
Search by Forms
'; if(is_array($myFormCloud)); { foreach($myFormCloud as $key => $value) { echo''.$value['word'].' '; } } echo '
Search by Categories
'; if(is_array($myCategoryCloud)); { foreach($myCategoryCloud as $key => $value) { echo''.$value['word'].' '; } } } echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
';
echo ''; if(is_array($myDateCloud)); { foreach($myDateCloud as $key => $value) { echo''.$value['word'].' '; } } echo '
Search by Forms
'; if(is_array($myFormCloud)); { foreach($myFormCloud as $key => $value) { echo''.$value['word'].' '; } } echo '
Search by Categories
'; if(is_array($myCategoryCloud)); { foreach($myCategoryCloud as $key => $value) { echo''.$value['word'].' '; } } } echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
'; echo $result["title"]; echo '
'; echo ''; echo parse_bbcode($result["poem"]); echo '
Copyright Ben Johnson '; echo $result["date"]; echo '
Notes
'; echo parse_bbcode($result["notes"]); echo '
Print This Information
'; echo '';
//Show tag cloud
echo '
'; //retrieve info $SQL = "SELECT title FROM poems "; $SQL = $SQL . "WHERE date = "; $SQL = $SQL . $searchstring; $SQL = $SQL . " ORDER BY title"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } echo '
';
}
else if (strcasecmp($searchtype,'form') == 0) //return all poems written in this form
{
echo '';
echo 'Search by other years
'; $cloud = new wordCloud(); $SQL = "SELECT date FROM poems ORDER BY date"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } $cloud->addWord($row['date']); } $myCloud = $cloud->showCloud('array'); if(is_array($myCloud)); { foreach($myCloud as $key => $value) { echo''.$value['word'].' '; } } } echo '
';
echo ''; $cloud = new wordCloud(); $SQL = "SELECT date FROM poems ORDER BY date"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } $cloud->addWord($row['date']); } $myCloud = $cloud->showCloud('array'); if(is_array($myCloud)); { foreach($myCloud as $key => $value) { echo''.$value['word'].' '; } } } echo '
Search Results For Poems Written In '; echo strtoupper($searchstring); echo '
'; //retrieve info $SQL = "SELECT title FROM poems "; $SQL = $SQL . "WHERE date = "; $SQL = $SQL . $searchstring; $SQL = $SQL . " ORDER BY title"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } echo '
'; echo $row['title']; echo '
'; } } echo '';
//Show tag cloud
echo '
'; //retrieve info $SQL = "SELECT title FROM poems "; $SQL = $SQL . "WHERE form LIKE CONVERT( _utf8 '"; $SQL = $SQL . $searchstring . "' USING latin1 ) ORDER BY title COLLATE latin1_swedish_ci"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } echo '
';
}
else if (strcasecmp($searchtype,'category') == 0) //return all poems within this category
{
echo '';
echo 'Search by other forms
'; $cloud = new wordCloud(); $SQL = "SELECT form FROM poems ORDER BY form"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } $cloud->addWord($row['form']); } $myCloud = $cloud->showCloud('array'); if(is_array($myCloud)); { foreach($myCloud as $key => $value) { echo''.$value['word'].' '; } } } echo '
';
echo ''; $cloud = new wordCloud(); $SQL = "SELECT form FROM poems ORDER BY form"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } $cloud->addWord($row['form']); } $myCloud = $cloud->showCloud('array'); if(is_array($myCloud)); { foreach($myCloud as $key => $value) { echo''.$value['word'].' '; } } } echo '
Search Results For Poems Written In '; echo ucfirst(strtolower($searchstring)); echo ' Form Type
'; //retrieve info $SQL = "SELECT title FROM poems "; $SQL = $SQL . "WHERE form LIKE CONVERT( _utf8 '"; $SQL = $SQL . $searchstring . "' USING latin1 ) ORDER BY title COLLATE latin1_swedish_ci"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } echo '
'; echo $row['title']; echo '
'; } } echo '';
//Show tag cloud
echo '
'; //retrieve info $SQL = "SELECT title FROM poems "; $SQL = $SQL . "WHERE category LIKE CONVERT( _utf8 '"; $SQL = $SQL . $searchstring . "' USING latin1 ) ORDER BY title COLLATE latin1_swedish_ci"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } echo '
';
}
else
{
echo '';
echo 'Search other categories
'; $cloud = new wordCloud(); $SQL = "SELECT category FROM poems ORDER BY category"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } $cloud->addWord($row['category']); } $myCloud = $cloud->showCloud('array'); if(is_array($myCloud)); { foreach($myCloud as $key => $value) { echo''.$value['word'].' '; } } } echo '
';
echo ''; $cloud = new wordCloud(); $SQL = "SELECT category FROM poems ORDER BY category"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } $cloud->addWord($row['category']); } $myCloud = $cloud->showCloud('array'); if(is_array($myCloud)); { foreach($myCloud as $key => $value) { echo''.$value['word'].' '; } } } echo '
Search Results For All '; echo strtoupper($searchstring); echo ' Poems
'; //retrieve info $SQL = "SELECT title FROM poems "; $SQL = $SQL . "WHERE category LIKE CONVERT( _utf8 '"; $SQL = $SQL . $searchstring . "' USING latin1 ) ORDER BY title COLLATE latin1_swedish_ci"; $retid = mysql_db_query('bj_poems',$SQL, $conn); if (!$retid) { die( mysql_error()); } else { /* fetch rows */ $NumberOfRows = mysql_num_rows($retid); for ($i = 0; $i < $NumberOfRows; $i++) { if (!mysql_data_seek($retid, $i)) { echo "Cannot seek to row $i: " . mysql_error() . "\n"; continue; } if (!($row = mysql_fetch_assoc($retid))) { continue; } echo '
'; echo $row['title']; echo '
'; } } echo '';
echo 'Sorry your search did not yield any results, please press the back button on your Browser and try a different search term.';
echo '
Searchtype = '; echo $searchtype; echo '
Searchvalue = '; echo $searchstring; echo '
';
}
}
mysql_close($conn);
?>
Searchtype = '; echo $searchtype; echo '
Searchvalue = '; echo $searchstring; echo '