<? $title = "البحث في السجلات"; ?>
<?php include ('header.php'); ?>
<div class="grid_6">
<form action='search.php' method="GET">
<input type="text" name="search" class="searchbox" value="محرك بحث الآثاري" onblur="if(this.value == '') { this.value='محرك بحث الآثاري'}" onfocus="if (this.value == 'محرك بحث الآثاري') {this.value=''}"/>
<input type="submit" value="بحث" class="searchbtn" />
<input type='hidden' name='do' value='s'/>
</form>
</div>
<div class="grid_6"></div>
<div class="clear"></div>
<div class="grid_12">
<?php 
include('includes/config.php');

$s = trim(strip_tags(mysql_real_escape_string($_GET['search'])));
$data = mysql_query("SELECT * FROM archive WHERE BINARY  name_artifact LIKE '%$s%' 
|| museum LIKE '%$s%'
|| special_No LIKE '%$s%'
|| general_No LIKE '%$s%'
|| registration_No LIKE '%$s%'
|| branch_archaeology LIKE '%$s%'
|| source_get_artifact LIKE '%$s%'
|| fossil_No LIKE '%$s%'
|| location LIKE '%$s%'
|| scan_archaeology LIKE '%$s%'
|| admin_fossil LIKE '%$s%'
|| artist LIKE '%$s%'
|| reference LIKE '%$s%'
|| year LIKE '%$s%'
|| era LIKE '%$s%'
|| show_exhibition LIKE '%$s%'
|| date_show LIKE '%$s%'
|| location_show LIKE '%$s%'
|| writing LIKE '%$s%'
|| type_writing LIKE '%$s%'
|| draw LIKE '%$s%'
|| pic LIKE '%$s%'
|| description LIKE '%$s%'       
|| length LIKE '%$s%'
|| width LIKE '%$s%'    
|| height LIKE '%$s%'    
|| diameter LIKE '%$s%'        
|| weight LIKE '%$s%'      
|| thickness LIKE '%$s%'
|| other LIKE '%$s%'
|| status LIKE '%$s%'
|| type_material LIKE '%$s%'
|| place LIKE '%$s%'
|| exploration_season LIKE '%$s%'") or die (mysql_error());
if(isset($_GET['do']) and $_GET['do'] =='s'){
if(empty($s)){
echo "<div class='warning'><p> اكتب الكلمة المراد البحث عنها </p></div>";
}else if(strlen($s)<1  or strlen($s)>20){
echo "<div class='warning'><p> ..كلمة البحث شرط تكون اكثر من 2 حرفين واقل من 20  حرف </p></div>";
}else {
$num = mysql_num_rows($data);
if($num <1){
echo"<div class='warning'><p>لا يوجد ما تبحث عنه حاول مرة أخرى</p></div>";
}else{
echo " 
<table class='bor' width='100%'>
<tr class='tbl'>
<td colspan='6'> نتيجة البحث عن : <b style='color: red;'>$s</b> </td>
</tr>
<tr class='tbl1'>
<td style='width:5%;'>#</td>
<td style='width:22%;'>القطعة الأثرية</td>
<td style='width:22%;'>المتحف</td>
<td style='width:22%;'>فرع الآثار</td>
<td style='width:22%;'>العصر أو العام</td>
<td style='width:5%;'>عرض السجل</td>
</tr>";      
while($row = mysql_fetch_array($data)){
echo "<tr class='tbl2'>
<td style='width:5%;  text-align:center;'>".$row['id']."</td>
<td style='width:22%; text-align:center;'>".$row['name_artifact']."</td>
<td style='width:22%; text-align:center;'>".$row['museum']."</td>
<td style='width:22%; text-align:center;'>".$row['branch_archaeology']."</td>
<td style='width:22%; text-align:center;'>".$row['year']."</td>
<td style='width:5%;  text-align:center;'><a href='archive.php?id=".$row['id']."'><img border='0' src='images/open.png' alt='logo' title='عرض السجل'></a></td>";
}echo "</table><br />";
}
}
}
@mysql_free_result($data);
@mysql_close($connection);
?>
</div>
<div class="clear"></div>
<?php include "footer.php"; ?>