// Connessione al database
$my_sql_available= true;
$connect = mysql_connect ('mysql.register.it:3306','PB6385_root','r3gp4ss' );
if(!$connect) {
$my_sql_available = false;
}
if(!mysql_select_db( 'directory__online_biz_data', $connect ) ){
$my_sql_available = false;
}
?>
directory-online.biz
directory-online.biz - Directory online
// Numero di risultati per pagina
$num_limit = 30;
if( isset( $_GET['lookfor']) ){
$cerca = trim( $_GET['lookfor'] );
$cerca = preg_replace("/[^\w\d]?/" ,"", $cerca );
if( empty( $cerca )) break;
if( isset( $_GET['start'])){
$start = $_GET['start'];
} else {
$start = 1;
}
$sql = "SELECT * from `dirsites_links_it` WHERE ";
$sql.= " ( LOWER(dsl_description) like LOWER('%$cerca%')) OR ";
$sql.= " ( LOWER(dsl_title) like LOWER('%$cerca%') OR LOWER(dsl_title) like LOWER('$cerca%') OR";
$sql.= " LOWER(dsl_title) like LOWER('$cerca') ) OR ";
$sql.= " ( LOWER(dsl_link) like LOWER('%$cerca%') OR LOWER(dsl_link) like LOWER('$cerca') ) ";
$result = mysql_query ( $sql );
echo "";
if(!$result ){
echo "Nessun risultato trovato!
";
} else {
$total = mysql_num_rows( $result );
$count = 0;
$min = ($start-1) * $num_limit;
$max = ($start ) * $num_limit;
//echo "($min - $max )
";
while ( ($data = mysql_fetch_assoc( $result )) !=false ) {
$count++;
if( $count < $min ) continue;
if( $count > $max) break;
if( !preg_match( '/^http(s|)\:\/\//' , $data['dsl_link'] ) ){
$data['dsl_link'] = 'http://'. $data['dsl_link'];
}
?>
=$data['dsl_description'];?>
=$data['dsl_link']?>
}
mysql_free_result( $result );
?>
$pages = floor( ($total / $num_limit) );
$actual = $_GET['start'];
if( ($actual - 10) > 0 ){
?> << |
}
for ( $i = ($actual -10) ; $i <= ($actual +10); $i++ ){
if( $i > $pages ) break;
if( $i < 1 ) continue;
if( $actual == $i){
echo $i." | ";
} else
echo "$i | ";
}
if( ($actual + 10) < $pages ){
?> >>
}
?>
}
}
?>
mysql_close( $connect);
?>