 |
Travis Doering and Lori Collins MESOAMERICAN THREE-DIMENSIONAL IMAGING DATABASE © 2007 Travis Doering and Lori Collins |
 |
'; ##split search words for 'and' and 'or' if($search) { if(strstr($search,' and ') || strstr($search,' or ')) { if(strstr($search,' and ')) { $arr=split(' and ',$search); while(list($key,$value) = each($arr)) { if($where=="") { $where="WHERE (id_number like '%$value%' or artifact_name like '%$value%' or origin_site like '%$value%' or artifact_type like '%$value%' or artifact_medium like '%$value%' or location like '%$value%' or notes like '%$value%' or chron_era like '%$value%' or chron_specific like '%$value%' or collaborators like '%$value%' or site_info like '%$value%')"; } else { $where=$where . " and (id_number like '%$value%' or artifact_name like '%$value%' or origin_site like '%$value%' or artifact_type like '%$value%' or artifact_medium like '%$value%' or location like '%$value%' or notes like '%$value%' or chron_era like '%$value%' or chron_specific like '%$value%' or collaborators like '%$value%' or site_info like '%$value%')"; } //end where=="" }//end while } //end if strstr($search,' and ') if(strstr($search,' or ')) { $arr=split(' or ',$search); while(list($key,$value) = each($arr)) { if($srch_cnt>0) { if($where=="") { $where="WHERE (id_number like '%$value%' or artifact_name like '%$value%' or origin_site like '%$value%' or artifact_type like '%$value%' or artifact_medium like '%$value%' or location like '%$value%' or notes like '%$value%' or chron_era like '%$value%' or chron_specific like '%$value%' or collaborators like '%$value%' or site_info like '%$value%')"; } else { $where=$where . " or (id_number like '%$value%' or artifact_name like '%$value%' or origin_site like '%$value%' or artifact_type like '%$value%' or artifact_medium like '%$value%' or location like '%$value%' or notes like '%$value%' or chron_era like '%$value%' or chron_specific like '%$value%' or collaborators like '%$value%' or site_info like '%$value%')"; } //end where=="" }// end $srch_cnt>0 }//end while } // end strstr($search,' or ') } else { if($where =="") { $where="WHERE (id_number like '%$search%' or artifact_name like '%$search%' or origin_site like '%$search%' or artifact_type like '%$search%' or artifact_medium like '%$search%' or location like '%$search%' or notes like '%$search%' or chron_era like '%$search%' or chron_specific like '%$search%' or collaborators like '%$search%' or site_info like '%$search%')"; } else { $where = $where . " and (id_number like '%$search%' or artifact_name like '%$search%' or origin_site like '%$search%' or artifact_type like '%$search%' or artifact_medium like '%$search%' or location like '%$search%' or notes like '%$search%' or chron_era like '%$search%' or chron_specific like '%$search%' or collaborators like '%$search%' or site_info like '%$search%')"; } //end if($where =="") } //end if(strstr($search,' and ') || strstr($search,' or ')) } else { if($where =="") { $where="WHERE (id_number like '%$search%' or artifact_name like '%$search%' or origin_site like '%$search%' or artifact_type like '%$search%' or artifact_medium like '%$search%' or location like '%$search%' or notes like '%$search%' or chron_era like '%$search%' or chron_specific like '%$search%' or collaborators like '%$search%' or site_info like '%$search%')"; } else { $where = $where . " and (id_number like '%$search%' or artifact_name like '%$search%' or origin_site like '%$search%' or artifact_type like '%$search%' or artifact_medium like '%$search%' or location like '%$search%' or notes like '%$search%' or chron_era like '%$search%' or chron_specific like '%$search%' or collaborators like '%$search%' or site_info like '%$search%')"; } //end if($where =="") } //end if $search //if($icons) { if (@array_count_values($chron) ) { //echo '
' . $icons[0]; $cnt_chron = count($chron); //echo $cnt_chron; if($chron[0]) { for($w=0; $w<$cnt_chron; $w++) { //echo 'inside icons array'; if($chron_elements=="") { $chron_elements = $chron[$w]; } else { $chron_elements = $chron_elements . " and " . $chron[$w]; } if(strstr($chron[$w],' or ')) { $arr=split(' or ',$chron[$w]); while(list($key,$value) = each($arr)) { if($where =="") { $where = "where (chron_specific like '%$value%' or chron_specific like '%$value %' or chron_era like '%$value%' or chron_era like '%$value %')"; } else { $where = $where . " or chron_specific like '%$value%' or chron_specific like '%$value %' or chron_era like '%$value%' or chron_era like '%$value %')"; } //end if($where =="") } //while(list($key,$value) = each($arr)) } else { //echo 'inside else'; if($where =="") { $where = "where (chron_specific like '%$value%' or chron_specific like '%$value %' or chron_era like '%$value%' or chron_era like '%$value %')"; } else { $where = $where . " and (chron_specific like '%$value%' or chron_specific like '%$value %' or chron_era like '%$value%' or chron_era like '%$value %')"; } //end if($where =="") }//end if(strstr($chron[$w],' or ')) }//end for($w=0; $w<$cnt_chron; $w++) } //end if($chron[0]) } else { $chron_elements = ""; if(strstr($chron,' and ')) { if($chron_elements=="") { $chron_elements = $chron; } else { $chronelements = $chron_elements . " and " . $chron; } //end if($chron_elements=="") $arr=split(' and ',$chron); while(list($key,$value) = each($arr)) { if($where =="") { $where = "where (chron_specific like '%$value%' or chron_specific like '%$value %' or chron_era like '%$value%' or chron_era like '%$value %')"; } else { $where = $where . " and (chron_specific like '%$value%' or chron_specific like '%$value %' or chron_era like '%$value%' or chron_era like '%$value %')"; } //end if($where =="") }//while(list($key,$value) = each($arr)) } else if(strstr($chron,' or ')) { if($chron_elements=="") { $chron_elements = $chron; } else { $chron_elements = $chron_elements . " or " . $chron; } //end if($chron_elements=="") $arr=split(' or ',$chron); while(list($key,$value) = each($arr)) { if($where =="") { $where = "where (chron_specific like '%$value%' or chron_specific like '%$value %' or chron_era like '%$value%' or chron_era like '%$value %')"; } else { $where = $where . " and (chron_specific like '%$value%' or chron_specific like '%$value %' or chron_era like '%$value%' or chron_era like '%$value %')"; } //end if($where =="") }//while(list($key,$value) = each($arr)) } else { if($chron) { if($chron_elements=="") { $chron_elements = $chron; } else { $chron_elements = $chron_elements . " or " . $chron; } //end if($chron_elements=="") if($where =="") { $where = "where (chron_specific like '%$chron%' or chron_specific like '%$chron %' or chron_era like '%$chron%' or chron_era like '%$chron %')"; } else { $where = $where . " and (chron_specific like '%$chron%' or chron_specific like '%$chron %' or chron_era like '%$chron%' or chron_era like '%$chron %')"; } //end if($where =="") } //end if($chron) } //end if(strstr($chron,' and ')) } //end if (@array_count_values($chron) ) if($culture) { if($where =="") { $where = "where (culture like '%$culture%' or culture like '%$culture %')"; } else { $where = $where . " and (culture like '%$culture%' or culture like '%$culture %')"; } } if($geographicarea) { if($where =="") { $where = "where (geographicarea like '%$geographicarea%' or geographicarea like '%$geographicarea %')"; } else { $where = $where . " and (geographicarea like '%$geographicarea%' or geographicarea like '%$geographicarea %')"; } } if($site) { if($where =="") { $where = "where (origin_site like '%$site%' or origin_site like '%$site %')"; } else { $where = $where . " and (origin_site like '%$site%' or origin_site like '%$site %')"; } } //only display the published items if($where =="") { $where = "where publish = 1"; } else { $where = $where . " and publish = 1"; } //geographicarea, culture and chron not used at this time //if($search || $site) { #query db with new search term $result = mysql_query("select * from 3dproject $where order by id_number, artifact_type ASC limit $rowstart,$display_number"); $sql = "select * from 3dproject $where order by id_number, artifact_type ASC limit $rowstart,$display_number"; //echo $sql; $result2 = mysql_query("select * from 3dproject $where order by id_number, artifact_type ASC"); if(@mysql_num_rows($result2)==0) { $result_cnt = 0; } else { $result_cnt = mysql_num_rows($result2); } if(@mysql_num_rows($result)==0) { $record_cnt = 0; } else { $record_cnt = mysql_num_rows($result); } ##determine number of pages if (!isset($num_pages)) { if($result_cnt > $display_number) { $num_pages = ceil($result_cnt/$display_number); } elseif($result_cnt > 0) { $num_pages = 1; } } else { $start=0; } $a = $rowstart + ($display_number) ; if ($a > $result_cnt) { $a = $result_cnt ; } $b = $rowstart + 1 ; echo '
| Click on any image to view in high resolution. |
| '; echo "Click the checkboxes and the 'review selections' button to view images with captions in a printable format. |