1) ) { ?>

Search

You can perform a full record search by entering keywords.

Special keywords AND, OR and NOT can be used in between words to refine your search.

Search Options

Wildcard character * and the use of quotes are also supported.

Register

Create your own FREE account with surfacequery.com and we will contact you with more details about a subscription or a one-off search.

More details…

Search

Here you can perform a record search by entering keywords.

You can use the special keywords AND, OR and NOT in between words to refine your search.

This search also supports the wildcard character * and the use of quotes.

Subscription or one-off search

With a subscription or a one-off seach, the "author", "journal", "source", "date", "volume" and "page" details are presented along with the "abstract titles" and "anstracts".

More details…

0) $keywords = $res[0]; else $keywords = array(); //for($i = 0; $i < count($res[0]); $i++) echo $res[0][$i] . '
'; $match_phrase = array(); $score_and = array(); $score_or = array(); for($i = 0; $i < count($keywords); $i++){ $kw = $keywords[$i]; $lkw = strtolower($kw); $phrase++; $mode = 'or'; while($lkw == 'and' || $lkw == 'not' || $lkw == 'or'){ if($lkw == 'not' && $mode == 'and') $mode = 'and not'; else $mode = $lkw; $kw = $keywords[++$i]; $lkw = strtolower($kw); } $kw = preg_replace('/([\+\-\>\<\(\)\~])/i', '\\\\$1', $kw); $mpc = count($match_phrase); $match_phrase[$mpc] = array(); switch($mode){ case 'and': $mpcz = ($phrase > 1) ? '+' : '(' ; $match_phrase[$mpc] = array($mpcz, $kw); if($match_phrase[$mpc - 1][0] != '(-' && strpos($match_phrase[$mpc - 1][0], '(') !== false){ $match_phrase[$mpc - 1][0] .= '+'; if(!$not)array_push($score_and, $match_phrase[$mpc - 1][1]); } if(!$not)array_push($score_and, $kw); break; case 'and not': $mpcz = ($phrase > 1) ? '-' : '(-' ; $match_phrase[$mpc] = array($mpcz, $kw); break; case 'not': $mpcz = ($phrase > 1) ? ') -(' : '-(' ; $match_phrase[$mpc] = array($mpcz, $kw); $not = true; break; case 'or': $mpcz = ($phrase > 1) ? ') (' : '(' ; $match_phrase[$mpc] = array($mpcz, $kw); $not = false; array_push($score_or, $kw); } } for($i = 0; $i < count($match_phrase); $i++) $match_phrase[$i] = implode('', $match_phrase[$i]); $match_phrase = implode(' ', $match_phrase) . ')'; $score_phrase = array_merge($score_and, $score_or); for($i = 0; $i < count($score_phrase); $i++) $score_phrase[$i] = str_replace('*', '', $score_phrase[$i]); $score_phrase = array_unique($score_phrase); $score_phrase_string = implode(' ', $score_phrase); $query = "select source, authors, year, volume, part, page, title, abstract, match (source, authors, year, volume, part, page, title, keywords, abstract) against ('$score_phrase_string') as relevancy from surface_finishing_abstracts where match (source, authors, year, volume, part, page, title, keywords, abstract) against ('$match_phrase' in boolean mode) order by relevancy desc"; } //CALCULATE PAGINATION $query_a = "select count(*) as results from ($query) qa"; $result = mysql_query($query_a) or die('can\'t query'); $rs = mysql_fetch_assoc($result); $total_count = $rs['results']; //Changed by MP //if(!$page = (int)$_GET['page'])$page = 1; if(isset($_GET['page'])) { $page = (int)$_GET['page']; } else { $page = 1; } //end $page_b = $page - 1; $page_f = $page + 1; if(isset($_GET['rpp'])) { $rpp = $_GET['rpp']; } else { $rpp = NULL; } if(!isset($user_rpp)) { $user_rpp=15; } if($rpp !== NULL && $rpp != $user_rpp){ $rpp = (int)$rpp; $rppq = "update user set rpp = $rpp where id = $user_id"; mysql_query($rppq) or die(sqlDeath(__LINE__, __FILE__)); }else $rpp = $user_rpp; if($rpp != 0){ $pages = ceil($total_count / $rpp); $plimit = $rpp * ($page - 1); $query = "$query limit $plimit, $rpp"; } //echo $query; $result = mysql_query($query) or die(sqlDeath(__LINE__, __FILE__)); $results = false; if($total_count == 0) { ?>

No matches found for

results. per page $pages){ $max_page = $pages; $min_page = $pages - 11; if($min_page < 1) $min_page = 1; } if($pages > 1){ if($page > 1) echo "« "; for($i = $min_page; $i <= $max_page; $i++){ if($i == $page) echo "$i "; else echo "$i "; } if($page < $pages) echo "» "; ?>

' . $lw_rs['word'] . ''; } // GET HIGHLIGHT WORDS $score_phrase_hl = array(); if ($score_phrase != '0') { for($i = 0; $i < count($score_phrase); $i++){ $score_phrase_hl[$i] = '/(' . str_replace('"', '', $score_phrase[$i]) . ')/i'; } } function highlight($what){ global $score_phrase_hl; return preg_replace($score_phrase_hl, '$1', $what); } $line = 0; while($rs = mysql_fetch_assoc($result)){ $results = true; $rs_source = highlight(nbsp(htmlentities($rs['source']))); $rs_authors = highlight(nbsp(htmlentities($rs['authors']))); $rs_year = highlight(nbsp(htmlentities($rs['year']))); $rs_volume = highlight(nbsp(htmlentities($rs['volume']))); $rs_part = highlight(nbsp(htmlentities($rs['part']))); $rs_page = highlight(nbsp(htmlentities($rs['page']))); $rs_title = highlight(nbsp(htmlentities($rs['title']))); // INSERT LINK WORDS $rs_abstract = highlight(nbsp(str_replace($lw_word, $lw_link, htmlentities($rs['abstract'])))); $rs_relevancy = nbsp(round($rs['relevancy'], 2)); if($user_access_level > 1) { ?>

Source:

Authors:

Year:

Volume:

Part:

Page:

Relevancy:

Relevancy: