Nome
Numero
city
"; echo "
"; echo "
ID
"; echo "
Nome
"; echo "
"; echo "
"; echo "
"; define('DB_NAME', 'forms1'); define('DB_USER', 'root'); define('DB_PASSWORD', ''); define('DB_HOST', 'localhost'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db(DB_NAME, $link); if (!$db_selected) { die('Can\'t use ' . DB_NAME . ': ' . mysql_error()); } $Nome = str_replace(' ', '%', $_POST['Nome']); $Numero = str_replace(' ', '%', $_POST['Numero']); $city = str_replace(' ', '%', $_POST['city']); $arNome = str_split($Nome); $arNumero = str_split($Numero); $arcity = str_split($city); $Nome=''; foreach ($arNome as $value) { if ($value=='%') continue; $Nome.=$value.'%'; } $Numero=''; foreach ($arNumero as $value) { if ($value=='%') continue; $Numero.=$value.'%'; } $city=''; foreach ($arcity as $value) { if ($value=='%') continue; $city.=$value.'%'; } $sql = mysql_query("SELECT * FROM demo WHERE Autore LIKE '%$Nome%' AND Titolo LIKE '%$Numero%' AND cit LIKE '%$city%' ORDER BY Autore") or die(mysql_error()); $i = 0; while($row=mysql_fetch_array($sql)){ $i++; echo "
"; echo "
" . " ". "
" . $i . " ". "
". "
"; echo "
" . " " . $row[1] . " " . "
"; echo "
". "
"; echo "
" . " ". "
" . $row[2] . "
". " " . "
"; echo "
" . " ". "
" . $row[3] . "
". " " . "
"; echo "
"; } mysql_close(); ?>