salve amici del forum ho preparato uno script search.php ma mi da un errore del tipo: Search term too short anche senza le credenziali posso sapere per favore dove sto sbagliando grazie mille.
Codice PHP:
<?php $button = $_GET ['submit'];$search = $_GET ['search']; if(strlen($search)<=1)echo "Search term too short";else{echo "You searched for <b>$search</b> <hr size='1'></br>";mysql_connect("localhost","user","password");mysql_select_db("db"); $search_exploded = explode (" ", $search); $x = "";$construct = ""; foreach($search_exploded as $search_each){$x++;if($x==1)$construct .="Protocollo LIKE '%$search_each%'";else$construct .="AND Protocollo LIKE '%$search_each%'"; } $constructs ="SELECT * FROM protocollo WHERE $construct";$run = mysql_query($constructs); $foundnum = mysql_num_rows($run); if ($foundnum==0)echo "Sorry, there are no matching result for <b>$search</b>.</br></br>1. Try more general words. for example: If you want to search 'how to create a website'then use general keyword like 'create' 'website'</br>2. Try different words with similar meaning</br>3. Please check your spelling";else{ echo "$foundnum results found !<p>"; $per_page = 1;$start = isset($_GET['start']) ? $_GET['start']: '';$max_pages = ceil($foundnum / $per_page);if(!$start)$start=0; $getquery = mysql_query("SELECT * FROM protocollo WHERE $construct LIMIT $start, $per_page"); while($runrows = mysql_fetch_assoc($getquery)){$Protocollo = $runrows ['Protocollo'];$Numero_fattura = $runrows ['Numero_fattura'];$Data_fattura = $runrows ['Data_fattura'];$Venditore = $runrows ['Venditore'];$Importo = $runrows ['Importo'];$Data_pagamento = $runrows ['Data_pagamento'];$Acconto = $runrows ['Acconto'];$Data_acconto = $runrows ['Data_acconto'];$Stato = $runrows ['Stato']; echo "<a href='$url'><b>$title</b></a><br>$desc<br><a href='$url'>$url</a><p>"; } //Pagination Startsecho "<center>"; $prev = $start - $per_page;$next = $start + $per_page; $adjacents = 3;$last = $max_pages - 1; if($max_pages > 1){ //previous buttonif (!($start<=0)) echo " <a href='search.php?search=$search&submit=Search+source+code&start=$Prev'>Indietro</a> "; //pages if ($max_pages < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up{$i = 0; for ($counter = 1; $counter <= $max_pages; $counter++){if ($i == $start){echo " <a href='search.php?search=$search&submit=Search+source+code&start=$i'><b>$counter</b></a> ";}else {echo " <a href='search.php?search=$search&submit=Search+source+code&start=$i'>$counter</a> ";} $i = $i + $per_page; }}elseif($max_pages > 5 + ($adjacents * 2)) //enough pages to hide some{//close to beginning; only hide later pagesif(($start/$per_page) < 1 + ($adjacents * 2)) {$i = 0;for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++){if ($i == $start){echo " <a href='search.php?search=$search&submit=Search+source+code&start=$i'><b>$counter</b></a> ";}else {echo " <a href='search.php?search=$search&submit=Search+source+code&start=$i'>$counter</a> ";} $i = $i + $per_page; } }//in middle; hide some front and some backelseif($max_pages - ($adjacents * 2) > ($start / $per_page) && ($start / $per_page) > ($adjacents * 2)){echo " <a href='search.php?search=$search&submit=Search+source+code&start=0'>1</a> ";echo " <a href='search.php?search=$search&submit=Search+source+code&start=$per_page'>2</a> .... "; $i = $start; for ($counter = ($start/$per_page)+1; $counter < ($start / $per_page) + $adjacents + 2; $counter++){if ($i == $start){echo " <a href='search.php?search=$search&submit=Search+source+code&start=$i'><b>$counter</b></a> ";}else {echo " <a href='search.php?search=$search&submit=Search+source+code&start=$i'>$counter</a> ";} $i = $i + $per_page; } }//close to end; only hide early pageselse{echo " <a href='search.php?search=$search&submit=Search+source+code&start=0'>1</a> ";echo " <a href='search.php?search=$search&submit=Search+source+code&start=$per_page'>2</a> .... "; $i = $start; for ($counter = ($start / $per_page) + 1; $counter <= $max_pages; $counter++){if ($i == $start){echo " <a href='search.php?search=$search&submit=Search+source+code&start=$i'><b>$counter</b></a> ";}else {echo " <a href='search.php?search=$search&submit=Search+source+code&start=$i'>$counter</a> "; } $i = $i + $per_page; }}} //next buttonif (!($start >=$foundnum-$per_page))echo " <a href='search.php?search=$search&submit=Search+source+code&start=$next'>Avanti</a> "; } echo "</center>";} } ?>