my code stock.com

Los select comunes

Snippet options

Download: Download snippet as datos4.php.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

<?php

$con = mysql_connect('gonzalobenoffi.com.ar','benoffi7_dr','callefalsa123');

if (!$con) {

die('Could not connect: ' . mysql_error());

}



mysql_select_db('benoffi7_sucursales', $con);

if (isset($_GET['nombre'])) 
{
	
	$name = $_GET['nombre'];

	$queryDB = mysql_query("SELECT * FROM sucursales WHERE nombre='$name'");

while ( $res = mysql_fetch_array($queryDB)) 
{

	echo "ID: ".$res['id']." | Nombre: ".$res['nombre']."<br/>";

}

} 
elseif (isset($_GET['id'])) 
{

	$id = $_GET['id'];

	$queryDB = mysql_query("SELECT * FROM sucursales WHERE id=$id");

	$res = mysql_fetch_array($queryDB);

	echo "ID: ".$res['id']." | Nombre: ".$res['nombre']."<br/>";

} else 
{

	$queryDB = mysql_query("SELECT * FROM sucursales");
	
	while ( $res = mysql_fetch_array($queryDB)) 
	{

		echo "ID: ".$res['id']." | Nombre: ".$res['nombre']."<br/>";

	}

}

mysql_close($con);

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.