Advanced Search

Recover fields from a database by filtering per a specific field

/ Published in: PHP
Save to your folder(s)
By using this snippet we can recover fields from a database by filtering these ones per a specific field.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. <?php
  2. $twitter=$_POST['twitter'];
  3.  
  4. $encontrado=false;
  5. $servidor="localhost";
  6. $usuario="root";
  7. $pass="";
  8. $base_datos="db_amigos";
  9.  
  10. $conexion=mysql_connect($servidor, $usuario, $pass);
  11. mysql_select_db("db_amigos", $conexion);
  12. $result = mysql_query("SELECT nombre, movil, mail, twitter FROM amigos", $conexion);
  13.  
  14. if ($row = mysql_fetch_array($result)){
  15. 	while($row = mysql_fetch_array($result)){
  16. 		if(strcmp($row['twitter'],$twitter)==0){
  17. 			$encontrado=true;
  18. 			"<h1>Los datos de $twitter son los siguientes:</h1> <br />";
  19. 			echo "<table border = '1'> \n";
  20. 			echo "<tr> \n";
  21. 			echo "<td><b>Nombre</b></td> \n";
  22. 			echo "<td><b>Móvil</b></td> \n";
  23. 			echo "<td><b>Mail</b></td> \n";
  24. 			echo "</tr> \n";
  25.  
  26.  
  27. 			do{
  28. 				echo "<tr> \n";
  29. 			echo "<td>".$row["nombre"]."</td> \n";
  30. 			echo "<td>".$row["movil"]."</td>\n";
  31. 			echo "<td>".$row["mail"]."</td> \n";
  32. 			echo "</tr> \n";
  33. 			}while(($row = mysql_fetch_array($result))&& (strcmp($row['twitter'],$twitter)==0));
  34. 		}
  35. 		if(!encontrado){
  36. 			echo"No tienes ningún amigo con el usuario".$twitter;
  37. 		}
  38. 		}//while
  39. }else {
  40. 	echo "¡ La base de datos está vacia !";
  41. }
  42.  
  43. ?>

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.