$conn = mysql_connect($host,$user,$pass); if (!$conn) { die('Could not connect: ' . mysql_error()); } //Connection has succeeded! if(mysql_select_db('bj_poems',$conn)) { if (strcasecmp($searchtype,'title') == 0) //We are hunting for one poem { //Connection is totally successful //retrieve info $SQL = " SELECT * FROM poems "; $SQL = $SQL . " WHERE title LIKE CONVERT( _utf8 '" . $searchstring . "' USING latin1 )"; $retid = mysql_db_query('bj_poems',$SQL, $conn); //echo $SQL; just for testing if (!$retid) { die( mysql_error()); } //If we are here we have succeeded in finding our info if($result = mysql_fetch_assoc($retid)) { echo '
'; //Show tag cloud 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 'Bookmark and Share'; 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

Printer Icon'; echo '

'; echo '
'; } } else if (strcasecmp($searchtype,'year') == 0) //return all poems written in this year { //Search for forms with n number of lines echo '
'; //Show tag cloud 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 '

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 '
'; } else if (strcasecmp($searchtype,'form') == 0) //return all poems written in this form { echo '
'; //Show tag cloud 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 '

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 '
'; } else if (strcasecmp($searchtype,'category') == 0) //return all poems within this category { echo '
'; //Show tag cloud 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 '

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 '
'; } else { 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); ?>
Home - Poetry - Programming