Posted By

juanchifc on 10/15/10

Tagged

Versions (?)

Last Edited at 10/15/10 02:28am

Statistics

Viewed 668 times

Favorited by 1 user(s)

Related snippets

Recover fields from a database by filtering per a specific field

/ Published in: PHP

By using this snippet we can recover fields from a database by filtering these ones per a specific field.

Highlighted TextExpand

<?php
$twitter=$_POST['twitter'];

$encontrado=false;
$servidor="localhost";
$usuario="root";
$pass="";
$base_datos="db_amigos";

$conexion=mysql_connect($servidor, $usuario, $pass);
mysql_select_db("db_amigos", $conexion);
$result = mysql_query("SELECT nombre, movil, mail, twitter FROM amigos", $conexion);

if ($row = mysql_fetch_array($result)){
	while($row = mysql_fetch_array($result)){
		if(strcmp($row['twitter'],$twitter)==0){
			$encontrado=true;
			"<h1>Los datos de $twitter son los siguientes:</h1> <br />";
			echo "<table border = '1'> \n";
			echo "<tr> \n";
			echo "<td><b>Nombre</b></td> \n";
			echo "<td><b>MÃƒÂ³vil</b></td> \n";
			echo "<td><b>Mail</b></td> \n";
			echo "</tr> \n";
			
			
			do{
				echo "<tr> \n";
			echo "<td>".$row["nombre"]."</td> \n";
			echo "<td>".$row["movil"]."</td>\n";
			echo "<td>".$row["mail"]."</td> \n";
			echo "</tr> \n";
			}while(($row = mysql_fetch_array($result))&& (strcmp($row['twitter'],$twitter)==0));
		}
		if(!encontrado){
			echo"No tienes ningÃƒÂºn amigo con el usuario".$twitter;
		}
		}//while
}else {
	echo "Ã‚Â¡ La base de datos estÃƒÂ¡ vacia !";
}
		
?>

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.