Bica
Member
Hello guys, i'm doing a school project, and i have this 2 page who search in database, but my code isnt working fine.
Can you guys help me find out what's wrong with it?
search.php
output.php
I rep++ if you guys help me :S
Can you guys help me find out what's wrong with it?
search.php
PHP:
<html>
<head>
<title>Busca</title>
</head>
<body>
<h1 align="center"><font face="comic sans ms" color="darkorange">Pesquisar Pessoas</font></h1>
<form method="POST" action="output.php">
Escolha o Tipo de Pesquisa
<p>
<p>
<select name="categoria">
<option value="BI" >BI</option>
<option value="Nome">Nome</option>
<option value="Morada">Morada</option>
<option value="Telefone">Telefone</option>
<option value="Mail">Mail</option>
<option value="Sexo">Sexo</option>
<option value="Login">Login</option>
<option value="Password">Password</option>
</select>
<p>
Introduza um Termo
<p>
<input type="text" name="Nome" size="20">
<p>
<input type="reset" value="Limpar">
<input type="submit" Value="Submeter">
</form>
</body>
</html>
output.php
PHP:
<?php
$ligacao=mysql_connect("LOCALHOST", "USER", "PASSWORD");
mysql_select_db("DATABASE",$ligacao) or print mysql_error();
$Nome=$_POST['Nome'];
$categoria=$_POST['categoria'];
$sql = mysql_query("SELECT * FROM pessoa WHERE '%$categoria%' LIKE '%$Nome%'");
$count = mysql_num_rows($sql);
if ($count == 0) {
echo "Nenhum resultado!";
} else {
// senão
if ($count == 1) {
echo "1 resultado encontrado!<br>";
}
if ($count > 1) {
echo "$count resultados encontrados!";
}
while ($pessoa = mysql_fetch_array($sql)) {
echo "BI: $pessoa[BI]<br />";
echo "Nome : $pessoa[Nome]<br />";
echo "Morada: $pessoa[Morada] <br />";
echo "Telefone: $pessoa[Telefone]<br />";
echo "Mail: $pessoa[Mail]<br />";
echo "Idade: $pessoa[Idade]<br />";
echo "Sexo: $pessoa[Sexo]<br />";
echo "Login: $pessoa[Login]<br />";
echo "Password: $pessoa[Password]<br />";
echo "<hr>";
}
}
?>
I rep++ if you guys help me :S
Last edited: