US Civil War Center Home Reviewers US Civil War Center
Untitled Document {}]/',$field1)) { $Field1Err = "Only letters, numbers and white space allowed"; } } } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?>

* required field.

">
*
*
Clear


real_escape_string($textField1); $textField1= addcslashes($textField1, '%_'); if ($field1 == "Keyword") { $query = "SELECT * FROM cwbr WHERE ISBN LIKE '%$textField1%' OR Price LIKE '%$textField1%' OR Teaser LIKE '%$textField1%' OR Auth_1 LIKE '%$textField1%' OR Auth_2 LIKE '%$textField1%' OR Auth_3 LIKE '%$textField1%' OR Reviewer LIKE '%$textField1%' OR Issue_date LIKE '%$textField1%' OR Issue LIKE '%$textField1%' OR Record_type LIKE '%$textField1%' OR Sub_headline LIKE '%$textField1%' OR Headline LIKE '%$textField1%' OR Publisher LIKE '%$textField1%' OR Pub_date LIKE '%$textField1%' OR SubCategories LIKE '%$textField1%' OR Metadata LIKE '%$textField1%' OR Image LIKE '%$textField1%' OR Field21 LIKE '%$textField1%'";} elseif ($field1 == "Author") { $query = "select * from cwbr where Auth_1 LIKE '%$textField1%' OR Auth_2 LIKE '%$textField1%' OR Auth_3 LIKE '%$textField1%'"; } elseif ($field1 == "Title") { $query = "select * from cwbr where Title LIKE '%$textField1%'"; } elseif ($field1 == "Publisher") { $query = "select * from cwbr where Publisher LIKE '%$textField1%'"; } elseif ($field1 == "Category") { $query = "select * from cwbr where Categories LIKE '%%$textField1%%'"; } elseif ($field1 == "ID") { $query = "select * from cwbr where ID LIKE '%$textField1%'"; } $result = $con->query($query); $numrows=$result->num_rows; echo "
"; if ($numrows == 0) { echo "

Sorry, your search returned zero results

"; } if ($numrows != 0) {echo "

Your search returned $numrows results

";} $n=0; while($row=mysqli_fetch_array($result)){ $n++; echo"Record $n of $numrows"; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; if ($row["Reviewer"] <> '') { echo""; echo""; echo""; echo""; } echo""; echo""; echo""; echo""; echo"
Title:". $row['Title']. "
Author:". $row['Auth_1'] . "
Reviewed by:". $row['Reviewer'] . "
Issue:". $row['Issue_date'] . "
"; echo"


"; } //// FULL RECORD DISPLAY //// $url = 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI']; if (false !== strpos($url,'record=full')) { $record = full; } if ($record == "full"){ $result = $con->query($query); $numrows=$result->num_rows; echo "
"; while ($row= mysqli_fetch_array($result)) { if ($row["Image"] <> '') {echo "

".$row["Image"];} if ($row["Title"] <> '') {echo "

".$row["Title"]."

";} if ($row["Auth_1"] <> '') {echo "by ".$row["Auth_1"]." ";} if ($row["Auth_2"] <> '') {echo "and ".$row["Auth_2"]." ";} if ($row["Auth_3"] <> '') {echo "and ".$row["Auth_3"]."
";} if ($row["Publisher"] <> '') {echo "
Publisher: ".$row["Publisher"]."
";} if ($row["Price"] <> '') {echo "Retail Price: ".$row["Price"]."
";} if ($row["Issue"] <> '') {echo "Issue: ".$row["Issue_date"]."
";} if ($row["ISBN"] <> '') {echo "ISBN: ".$row["ISBN"]."

";} if ($row["Review"] <> '') {echo "

".$row["Review"]."

";} } // close while } // close if mysqli_close($con); ?>

Link To This Site

Button

CivilWarBookReview.com

To use this button on your site, simply copy and paste this code:

<A HREF="http://www.civilwarbookreview.com">
<IMG SRC="http://www.civilwarbookreview.com/images/banners/cwbrbutton.jpg"
BORDER="0" WIDTH="120" HEIGHT="60" ALT="CivilWarBookReview.com"></A>




Text Link

To create a text link that looks like this:

CivilWarBookReview.com

Simply copy and paste this code:
<A HREF="http://www.civilwarbookreview.com">CivilWarBookReview.com</A>

Note: You may also download the graphics and store the images
on your own web server. Simply adjust the pathname in the IMG SRC tag.

[an error occurred while processing this directive]