Rodrigo rodurma

rodurma / tree_menu.php

Created December 14, 2011 10:59

nested category

	<?
	$con = mysql_connect('localhost', 'root', '') or die('Erro ao conectar no banco de dados.');
	$base = mysql_select_db('test');

	// listando as categorias
	$sql_tree = "SELECT node.category_id, CONCAT( REPEAT( '_', (COUNT(parent.name) - 1) ), node.name) AS name
	FROM nested_category AS node,
	nested_category AS parent
	WHERE node.lft BETWEEN parent.lft AND parent.rgt
	GROUP BY node.name

rodurma / gist:1892219

Created February 23, 2012 10:46

CREATE INDEX no MySQL

CREATE INDEX idx_letra ON alfabeto (letra(1));

rodurma / gist:1892244

Created February 23, 2012 10:52

Consulta com índice (MySQL)

SELECT * FROM alfabeto USE INDEX (idx_letra) WHERE letra = 'A';

rodurma / gist:1957926

Created March 2, 2012 11:38

Removendo registros duplicados no MySQL

	CREATE TABLE tabela_temporaria as SELECT * FROM tabela_atual WHERE 1 GROUP BY [coluna com registros duplicados];

	DROP TABLE tabela_atual;

	RENAME TABLE tabela_temporaria TO tabela_atual;

rodurma / gist:2045346

Created March 15, 2012 17:11

API Mercado Libre - Reply

rodurma / gist:2162667

Created March 22, 2012 19:37

Hello World

rodurma / gist:2162693

Created March 22, 2012 19:38

rodurma / .htaccess

Created April 11, 2012 11:53

.htaccess

	Options +FollowSymlinks

	Options -Indexes

	RewriteEngine On

	RewriteBase /
	RewriteCond %{REQUEST_FILENAME} !-f
	RewriteCond %{REQUEST_FILENAME} !-d
	RewriteCond %{REQUEST_URI} !.*\.(ico\|gif\|jpg\|jpeg\|png\|js\|css)

rodurma / gist:3227677

Created August 1, 2012 15:12

Slider simples Jquery

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<title></title>
	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js" type="text/javascript"></script>
	</head>
	<body>
	<script type="text/javascript">
	$(document).ready(function(){

rodurma / gist:4061446

Created November 12, 2012 19:41