We are proud to present annotated and fully searchable books in an online format.
Current Books Available are:
//build list of book titles $sql = "SELECT * FROM books WHERE (books.intPublished=1)"; // get data from database $conn = mysql_connect ("localhost", "roanetnh_spadmin", "aO4XpJv9FK"); // assume mysql is working $has_mysql = 1; if (!$conn) { echo "Unable to connect to DB: " . mysql_error(); // mysql not working, save that fact in variable $has_mysql = 0; } if ($has_mysql==1) { if (!mysql_select_db("roanetnh_coll")) { echo "Unable to select database roanetnh_coll: " . mysql_error(); // mysql not working, save that fact in variable $has_mysql = 0; } } if ($has_mysql==1) { $result = mysql_query($sql,$conn); $num_rows = mysql_num_rows($result); if ($num_rows > 0) { while ($myrow = mysql_fetch_array($result)) { // a row for this pgid was found! get fields.... $book = $myrow["intBookID"]; $title = $myrow["strTitle"]; $author = $myrow["strAuthorName"]; $OrigPub = $myrow["intOriginalPubYr"]; $OnlinePub = $myrow["strOnlinePubYr"]; $htmlLink = $myrow["strMainPg"]; echo "".$title."by: ".$author."
Originally Published:". $OrigPub." | Published Online:".$OnlinePub."
"; } } else { echo "Sorry, database of published books unavailable at this time!"; } mysql_close($conn); } else { // here $has_mysql is not 1, that is, something is wrong with the mysql for some reason, so we must recover gracefully echo "Sorry books database is temporarly unavailable"; } ?>
Editor's notes:
- RoaneTnHistory.org was founded with the desire to help make history readily available wherever possible by placing out-of-copyright material on the web easily searchable and easily readable to anyone with a computer. We have attempted to preserve the original materials where possible.
- Where editorial changes or additions were needed, we have used curly brackets {} to denote our editorial notes.
- If the font used is not readable, you may be able to change the text size using your browser's menu. For example, in Internet Explorer, click on your 'View' menu choice, then click on 'text size' to enlarge.
- Conception, typing, scanning, editing: G. Anne Sloan.
- Database design, programming, web development: Crystal Sloan.
- PHP programming used with permission: Theresa Applegate.
- Web hosting provided by EagleRidge Technologies, Inc..