Notice: Undefined index: searching in C:\wamp\www\guaoww\otra.php on line 18
Notice: Undefined index: find in C:\wamp\www\oww\otra.php on line 19
Notice: Undefined index: field in C:\wamp\www\oww\otra.php on line 20
Notice: Undefined index: search in C:\wamp\www\oww\otra.php on line 21
Apesar de esto el codigo me funciona!! solo que me arroja solo una consulta!! por decir tengo 2 resultados! y solo arroja una!
este es mi codigo si me pueden ayudar a depurarlo! o a ver en que puedo mejorarlo! es una especie de buscador para encontrar pareja a tu perrito :)
es donde inicia mi php!
Código PHP:
<html>
<body>
<?php
//definimos variables
$searching = htmlspecialchars(trim($_POST['searching']));
$find = htmlspecialchars(trim($_POST['find']));
$field = htmlspecialchars(trim($_POST['field']));
$search = htmlspecialchars(trim($_POST['search']));
//This is only displayed if they have submitted the form
if ($searching =="yes") { echo "<h2>Results</h2><p>";
//If they did not enter a search term we give them an error
if ($find == "") { echo "<p>You forgot to enter a search term"; exit; }
// Otherwise we connect to our Database
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("oww") or die(mysql_error());
// We preform a bit of filtering
$find = strtoupper($find); $find = strip_tags($find); $find = trim ($find);
$field = strtoupper($field); $field = strip_tags($field); $field = trim ($field) ;
//Now we search for our search term, in the field the user specified
$data = mysql_query("SELECT * FROM expediente WHERE sexo LIKE '%$find%' AND raza LIKE '%$field%' ");
//And we display the results
while($result = mysql_fetch_array( $data ))
{
echo $result['dueno'];
echo "<br>";
echo $result['raza'];
echo "<br>";
echo $result['sexo'];
echo "<br>";
echo $result['telefono'];
echo "<br>";
}
//This counts the number or results - and if there wasn't any it gives them a little message explaining that
$anymatches=mysql_num_rows($data); if ($anymatches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; }
//And we remind them what they searched for
echo "<br/>";
echo "<b>Searched For:</b> " .$find .$field; } ?>
<form name="search" method="post" action="otra.php">
Buscar:
Macho<input type="radio" name="find" value="Macho" />
Hembra<input type="radio" name="find" value="Hembra" />
En <select size= 1 name="field">
<option value="Airedale Terrier">Airedale Terrier</option>
<option value="Akita">Akita</option>
<option value="Akita americano">Akita americano</option>
<option value="Alaskan Malamute">Alaskan Malamute</option>
<option value="American pit bull terrier">American pit bull terrier</option>
<option value="American staffordshire terrier">American staffordshire terrier</option>
<option value="Australian terrier">Australian terrier</option>
<option value="Basset Hound">Basset Hound</option>
<option value="Beagle">Beagle</option>
<option value="Bichon maltes">Bichon maltes</option>
<option value="Bloodhound">Bloodhound</option>
<option value="Border Collie">Border Collie</option>
<option value="Boston terrier">Boston terrier</option>
<option value="Bouvier des Flandres">Bouvier des Flandres</option>
<option value="Boxer">Boxer</option>
<option value="Bull terrier">Bull terrier</option>
<option value="Bulldog Ingles">Bulldog Ingles</option>
<option value="Bulldog americano">Bulldog americano</option>
<option value="Bulldog frances">Bulldog frances</option>
<option value="Bullmastiff">Bullmastiff</option>
<option value="Chihuahua">Chihuahua</option>
<option value="Chow Chow">Chow Chow</option>
<option value="Cocker Spaniel Americano">Cocker Spaniel Americano</option>
<option value="Cocker Spaniel Inglés">Cocker Spaniel Inglés</option>
<option value="Dachshund (Salchicha)">Dachshund (Salchicha)</option>
<option value="Dalmata">Dalmata</option>
<option value="Dobermann">Dobermann</option>
<option value="Dogo Argentino">Dogo Argentino</option>
<option value="Dogo de Burdeos">Dogo de Burdeos</option>
<option value="Fila Brasileiro">Fila Brasileiro</option>
<option value="Fox terrier">Fox terrier</option>
<option value="Galgo">Galgo</option>
<option value="Gigate de los Pirineos">Gigante de los Pirineos</option>
<option value="Golden Retriever">Golden Retriever</option>
<option value="Gran Danés">Gran Danés</option>
<option value="Husky Siberiano">Husky Siberiano</option>
<option value="Lhasa apso">Lhasa apso</option>
<option value="Mastiff">Mastiff</option>
<option value="Mastín Español">Mastín Español</option>
<option value="Mastín Napolitano">Mastín Napolitano</option>
<option value="Pastor Aleman">Pastor Aleman</option>
<option value="Pastor Australiano">Pastor Australiano</option>
<option value="Pastor Belga">Pastor Belga</option>
<option value="Pastor Belga Malinois">Pastor Belga Malinois</option>
<option value="Pastor de Shetland">Pastor de Shetland</option>
<option value="Pastor Holandes">Pastor Holandes</option>
<option value="Pekines">Pekines</option>
<option value="Pinscher">Pinscher</option>
<option value="Pinscher Miniatura">Pinscher Miniatura</option>
<option value="Pointer">Pointer</option>
<option value="Pomerania">Pomerania</option>
<option value="Presa Canario">Presa Canario</option>
<option value="Pug">Pug</option>
<option value="Rhodesian Ridgeback">Rhodesian Ridgeback</option>
<option value="Rottweiler">Rottweiler</option>
<option value="Samoyedo">Samoyedo</option>
<option value="San Bernardo">San Bernardo</option>
<option value="Schnauzer estandar">Schnauzer estandar</option>
<option value="Schnauzer gigante">Schnauzer gigante</option>
<option value="Schnauzer miniatura">Schnauzer miniatura</option>
<option value="Scottish terrier">Scottish terrier</option>
<option value="Setter Ingles">Setter Ingles</option>
<option value="Setter Irlandes">Setter Irlandes</option>
<option value="Shar Pei">Shar Pei</option>
<option value="Shih Tzu">Shih Tzu</option>
<option value="Spitz Japones">Spitz Japones</option>
<option value="Terranova">Terranova</option>
<option value="Viejo Pastor Ingles">Viejo Pastor Ingles</option>
<option value="Weimaraner">Weimaraner</option>
<option value="Welsh Corgi Cardigan">Welsh Corgi Cardigan</option>
<option value="West highland white terrier">West highland white terrier</option>
<option value="Xoloitzcuintle">Xoloitzcuintle</option>
<option value="Yorkshire terrie">Yorkshire terrier</option>
</select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
</body>
</html>