DZone Snippets: Sveggiani's Code Snippets

Loop de X elementos por fila

sveggiani (Sebastián) — Wed, 17 Oct 2007 12:46:19 GMT

// Genera una estructura que va colocando un resultset en filas de X elementos.





// Catálogos

$catalogos_query = 'SELECT catalogos.* FROM catalogos WHERE catalogos.estado = 1 ORDER BY catalogos.id_catalogo DESC';

$catalogos_rs = mysql_query( $catalogos_query );

$catalogos_num = mysql_num_rows( $catalogos_rs );



// inicia looper

$elem_count = 0;

$elem_total_count = 0;

$elem_per_row = 6; // Configurar esto!

// bucle entre todas los elementos a mostrar

while( $row = mysql_fetch_assoc( $catalogos_rs ) ) :

	$elem_count++;

	$elem_total_count++;

?>



	



	



		



			$class = "catalogoContainer ultimo";

	else:

		$class = "catalogoContainer";

	endif; ?>



		



			

				" alt="" border="0" />

Devuelve el Referer limpio

sveggiani (Sebastián) — Wed, 03 Oct 2007 16:14:29 GMT

// Limpia y devuelve el REFERER



	function getReferer(){

		// limpia el referer 

		$ref = $_SERVER['HTTP_REFERER'];

		$web = str_replace(array('http://','www.'),'',$ref);

		$web = substr($web,0,strpos ($web, '/'));

		if(!empty($web)):

			// retorna el referer limpio

			return $web;

		else:

			// sin referer

			return 'jane.es';

		endif;

	}

recupera datos del visitante

sveggiani (Sebastián) — Wed, 03 Oct 2007 16:12:20 GMT



	function getLocation( $ip ) {

		

		static $location = array();

		

		if( !isset( $location[$ip] ) ) {

			$url = "http://www.hostip.info/api/get.html?ip=" . $ip . "&position=true&raandom=" . rand(0,500);

			/* cURL */

			$ch = curl_init();

			curl_setopt($ch, CURLOPT_URL, $url);

			curl_setopt($ch, CURLOPT_HEADER, 0);

			curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);

			curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);

			curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

			$data = curl_exec($ch);



			if ( curl_errno( $ch ) ) {

				print "Error: ".curl_error($ch);

			} else {

				curl_close($ch);

				$lines = split ("\n", $data);

				foreach($lines as $l):

					$prop = split(':',$l);

					$location[$ip][trim($prop[0])] = addslashes(trim($prop[1]));

				endforeach;

		   }

			

		}

		return $location[$ip];

	}