Не сте регистриран!
Регистрирайте се БЕЗПЛАТНО, за да използвате услугите на сайта!
Програмиране на собствена търсачка с MySQL и PHP
Автор Mutatos (14.04.2005 22:30)
съобщение до автора
Погледнат 5898 пъти
добави към любими
Оценка добави коментар
Гласове 4
изпрати на приятел
Коментари (2)
абонирай се за PHP
Страница 4 / 4
Пример за тестване CODE 1 <? PHP () list ( $usec , $sec ) = explode ( " " , microtime ()) ; return (( float ) $usec + ( float ) $sec ) ; } mysql_pconnect ( " xxx " , " xxx " , " xxx " ) or die ( ' Unable to connect to server. ' ) ; mysql_select_db ( " test " ) or die ( ' Unable to select database. ' ) ; $RESULTS_LIMIT = 10 ; if ( isset ( $search_query )) if ( ! isset ( $first_pos )) $first_pos = " 0 " ; } $start_search = getmicrotime () ; $sql_query = mysql_query ( " SELECT * FROM news WHERE MATCH(title,article) AGAINST(' $search_query ') " ) ; if ( $results = mysql_num_rows ( $sql_query ) != 0 ) $sql_result_query = mysql_query ( " SELECT * FROM news WHERE MATCH(title,article) AGAINST(' $search_query ') LIMIT $first_pos , $RESULTS_LIMIT " ) ; } else { $sql_query = mysql_query ( " SELECT * FROM news WHERE (title LIKE '% " . $search_query . " %' OR article LIKE '% " . $search_query . " %') " ) ; $results = mysql_num_rows ( $sql_query ) ; $sql_result_query = mysql_query ( " SELECT * FROM news WHERE (title LIKE '% " . $search_query . " %' OR article LIKE '% " . $search_query . " %') LIMIT $first_pos , $RESULTS_LIMIT " ) ; } $stop_search = getmicrotime () ; $time_search = ( $stop_search - $start_search ) ; } PHP if ( $results != 0 ) table border = " 0 " cellspacing = " 2 " cellpadding = " 2 " > tr > td width = " 47% " >Резултати за <? PHP echo " <i><b><font color=#000000> " . $search_query . " </font></b></i> " ; ?></ td > td width = " 53% " align = " right " height = " 22 " >Резултати < b ><? PHP echo ( $first_pos + 1 ) . " - " ; if (( $RESULTS_LIMIT + $first_pos ) < $results ) echo ( $RESULTS_LIMIT + $first_pos ) ; else echo $results ; ?></ b > b ><? PHP echo $results ; ?></ b > за ( < b ><? PHP echo sprintf ( " %01.2f " , $time_search ) ; ?></ b > ) td > tr > tr > form action = "" method = " GET " > td colspan = " 2 " align = " center " > < input name = " search_query " type = " text " value = " <?PHP echo $search_query ; ?> " size = " 40 " > input name = " search_button " type = " submit " value = " Search " > </ td > form > tr > PHP while ( $row = mysql_fetch_array ( $sql_result_query )) tr align = " left " > td colspan = " 2 " ><? PHP echo $row [ ' title ' ] ; ?></ td > tr > PHP } table > } else { table border = " 0 " cellspacing = " 2 " cellpadding = " 0 " > tr > td align = " center " >Няма намерени резултати за <? PHP echo " <i><b><font color=#000000> " . $search_query . " </font></b></i> " ; ?></ td > tr > tr > form action = "" method = " GET " > td colspan = " 2 " align = " center " > input name = " search_query " type = " text " value = " <?PHP echo $search_query ; ?> " > input name = " search_button " type = " submit " value = " Search " > td > form > tr > table > PHP } table width = " 300 " border = " 0 " cellspacing = " 0 " cellpadding = " 0 " > tr > td align = " right " > PHP if ( $first_pos > 0 ) $back = $first_pos - $RESULTS_LIMIT ; if ( $back < 0 ) $back = 0 ; } echo " <a href= " search . php ? search_query = " .stripslashes( $search_query ). " & first_pos = $back " ><< </a> " ; } if ( $results > $RESULTS_LIMIT ) $sites = intval ( $results / $RESULTS_LIMIT ) ; if ( $results % $RESULTS_LIMIT ) $sites ++; } for ( $i = 1 ; $i <= $sites ; $i ++ ) $fwd = ( $i - 1 ) * $RESULTS_LIMIT ; if ( $fwd == $first_pos ) echo " <a href= " search . php ? search_query = " .stripslashes( $search_query ). " & first_pos = $fwd " style='color:#000000'><b> $i </b></a> | " ; } else { echo " <a href= " search . php ? search_query = " .stripslashes( $search_query ). " & first_pos = $fwd " > $i </a> | " ; } if ( $first_pos < $results - $RESULTS_LIMIT ) $fwd = $first_pos + $RESULTS_LIMIT ; echo " <a href= " search . php ? search_query = " .stripslashes( $search_query ). " & first_pos = $fwd " > >></a> " ; $fwd = $results - $RESULTS_LIMIT ; } td > tr > table >
Още уроци от тази рубрика
За автора: Mutatos
Николай Николов се занимава с програмиране на PHP/MySQL повече от 6 години. Заедно с разработката на уеб приложения на PHP, се занимава с Java, XML и Webservices.
1 посетител чете този урок (0 потребители и 1 гост)
Активни потребители:
---
