Este é o script de buscas, na primeira querry ele lista todo o banco de dados, mas
a segunda querry não está buscando o item desejado.
<Html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<font face=Verdana,Arial,Helvetica,sans-serif size=-1>
<link href="/menu_assets/
styles.css" rel="stylesheet" type="text/css">
</head>
</html>
<div class='cssmenu'>
<ul>
<li class='active '><a href='
contatos.php'><span>CONTATOS</span></a></li>
<li class='active '><a href='
http://www.jorgeluizsol.wix.com/stmonline'><span>HOME</span></a></li>
</ul>
</div>
<tr>
<td height="0" colspan="0" valign="top"><p align="center"><a
<td align="center"><img src="images/tela1/
tela1encontro.jpg" width="650" height="300" border="2" >
</td>
<table width="645" align="center" border="10" height="94" bgcolor="#FFFF99"
<tr>
<td>
<table width="645" align="center" background="image/
fundo_consulta_rapida.jpg" align="center" border="10" height="94">
<form action="" method="post">
<br>
<input type="text" name="busca" size="100">
<br>
<input type="submit" value="Busca">
</form>
<?php
$host = 'localhost';
$user = 'sol_root';
$pass = 'sol133213';
$db = 'sol_primeirapaginadb';
$conecta = mysqli_connect($host, $user, $pass, $db);
header( 'Content-Type: text/html; charset=utf-8' );
mysqli_query("set names 'utf8'");
mysqli_query('set character_set_connection=utf8');
mysqli_query('set character_set_client=utf8');
mysqli_query('set character_set_results=utf8');
if ( empty($_post['busca']) ) {
$sql = "select * from consulta_rapidastm order by nome";
$res = mysqli_query($conecta,$sql);
$total = mysqli_num_rows($res);
echo "<p>total de resultados: " . $Total . "</P>";
while ($f = mysqli_fetch_array($res)){
$email= $f[email];
$site= $f[site];
echo "<p>" .
Utf8_encode($f[nome]) . " <Br> " . Utf8_encode($f[fone]) .
" <Br> " . Utf8_encode($f[servico]) ."</P>";
echo '<a href="http://'.$Email.'?Site='.$Email.'">'.$Email.'</A>';
echo '<a href="http://'.$Site.'?Site='.$Site.'">'.$Site.'</A>';
}
} else {
$busca = $_post['busca'];
$busca_query = mysqli_query("select * from consulta_rapidastm where nome like '%$busca%' or fone like '%$busca%' or servico like '%$busca%' or servico2 like '%$busca%' or servico3 like '%$busca%' or email like '%$busca%' or site like '%$busca%' order by nome");
if (empty($busca_query)) {
echo "nenhum registro encontrado!";
}
while ($busca = mysqli_fetch_array($busca_query)) {
$email= $f[email];
$site= $f[site];
echo "<p>" . Utf8_encode($f[nome]) . " <Br> " .
Utf8_encode($f[fone]) . " <Br> " . Utf8_encode($f[servico]) ."
<Br> " . Utf8_encode($f[email]) ."</P>";
echo '<a href="http://'.$Site.'?Site='.$Site.'">'.$Site.'</a>';
}
}
mysqli_close($conecta);
?>
Prazo de Entrega: 09 de Julho de 2017