Skip to content

Instantly share code, notes, and snippets.

View rodurma's full-sized avatar

Rodrigo rodurma

23 followers · 53 following
View GitHub Profile
@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
rodurma / gist:1892219
Created February 23, 2012 10:46
CREATE INDEX no MySQL
CREATE INDEX idx_letra ON alfabeto (letra(1));
@rodurma
rodurma / gist:1892244
Created February 23, 2012 10:52
Consulta com índice (MySQL)
SELECT * FROM alfabeto USE INDEX (idx_letra) WHERE letra = 'A';
@rodurma
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
rodurma / gist:2045346
Created March 15, 2012 17:11
API Mercado Libre - Reply
<?php
session_start();
require 'meli-php/src/meli.php';
$meli = new Meli(array(
'appId' => 'appId',
'secret' => 'secret'
));
@rodurma
rodurma / gist:2162667
Created March 22, 2012 19:37
Hello World
<?php
function hello_world(){
echo "Olá Mundo";
}
?>
@rodurma
rodurma / gist:2162693
Created March 22, 2012 19:38
#!/usr/bin/php -q
<?php
function hello_world(){
echo "Olá Mundo";
}
?>
@rodurma
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
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
rodurma / gist:4061446
Created November 12, 2012 19:41
<div class="container">
<div class="row">
<div class="span12">TOPO</div>
</div>
<div class="row">
<div class="span2">MENU</div>
<div class="span10"></div>
</div>
<div class="row">
<div class="span12">RODAPE</div>