Skip to content

Instantly share code, notes, and snippets.

View jotapepinheiro's full-sized avatar
🏠
Working from home

João Paulo Pinheiro jotapepinheiro

🏠
Working from home
View GitHub Profile
@jotapepinheiro
jotapepinheiro / JsonView.php
Created February 16, 2014 03:03
Return Json
<?php
// connection to the database
$host = "localhost";
$username = "root";
$password = "159357";
$db_name = "laravel";
try {
$con = new PDO("mysql:host={$host};dbname={$db_name}", $username, $password);
}catch(PDOException $exception){
@jotapepinheiro
jotapepinheiro / email_domain.php
Last active August 29, 2015 13:57
Validar e-mail e domínio.
<?php
function validaEmail($email){
if(filter_var($email, FILTER_VALIDATE_EMAIL))
{
$separa = list($usuario, $provedor) = explode('@', $email);
if(getmxrr($separa[1], $mx_records, $mx_weight))
return $separa[0].'@'.$separa[1];
else
return false;
}
@jotapepinheiro
jotapepinheiro / consoleOff.js
Created March 28, 2014 03:35
Disable Console
// It appears Netflix is following (Facebook's lead)[https://news.ycombinator.com/item?id=7222129].
(function() {
try {
var $_console$$ = console;
Object.defineProperty(window, "console", {
get: function() {
if ($_console$$._commandLineAPI)
throw "Sorry, for security reasons, the script console is deactivated on netflix.com";
return $_console$$

DigitalOcean - Instalação do Apache 2.4.x + PHP 5.5.x no Ubuntu 13.10


Update e LocalTime São Paulo

sudo apt-get update
sudo dpkg-reconfigure tzdata
@jotapepinheiro
jotapepinheiro / gist:08609b0cb745d894bd0f
Last active August 29, 2015 14:04
Generate debug.keystore
keytool -genkey -v -keystore debug.keystore -alias androiddebugkey -keyalg RSA -validity 10000
@jotapepinheiro
jotapepinheiro / contador.sql
Last active August 29, 2015 14:22
Contador PLSQL
DECLARE
V_CONTADOR NUMBER(8) := 0;
V_COMMIT NUMBER(8) := 100;
BEGIN
FOR I IN 1 .. 1000
LOOP
V_CONTADOR := V_CONTADOR + 1;
IF MOD(V_CONTADOR,V_COMMIT) = 0
THEN
DBMS_OUTPUT.PUT_LINE('TESTE CONTADOR: ' || V_CONTADOR);
@jotapepinheiro
jotapepinheiro / verifica.sql
Created June 1, 2015 15:53
Verifica espaço no banco oracle
SELECT DDF.TABLESPACE_NAME "TablespaceName",
DDF.FILE_NAME "DataFile",
DDF.BYTES / (1024 * 1024) "Total(MB)",
ROUND((DDF.BYTES - SUM(NVL(DFS.BYTES, 0))) / (1024 * 1024), 1) "Used(MB)",
ROUND(SUM(NVL(DFS.BYTES, 0)) / (1024 * 1024), 1) "Free(MB)"
FROM SYS.DBA_FREE_SPACE DFS
LEFT JOIN SYS.DBA_DATA_FILES DDF ON DFS.FILE_ID = DDF.FILE_ID
WHERE DDF.TABLESPACE_NAME = 'ETURMALINATAB'
GROUP BY DDF.TABLESPACE_NAME, DDF.FILE_NAME, DDF.BYTES
ORDER BY DDF.TABLESPACE_NAME, DDF.FILE_NAME;
#!/bin/sh
# Script para instalação e configuração do Phalcon | MongoDB
echo "#####################################################################"
echo "#####################################################################"
echo "#####################################################################"
echo ">>>>>>>>>>>>>>>>>>>>>> Instalando MongoDB >>>>>>>>>>>>>>>>>>>>>>>>>>>"
echo "#####################################################################"
echo "#####################################################################"
@jotapepinheiro
jotapepinheiro / maior-menor.sql
Last active August 29, 2015 14:23
RETORNA OS MAIORES E MENORES VALORES DE UMA LINHA (GREATEST-LEAST)
/*
RETORNA OS MAIORES E MENORES VALORES DE UMA LINHA
*/
SELECT
--STRING
GREATEST('MARIA', 'FERNANDA', 'KELLY') AS MAIOR_STRING,
LEAST('MARIA', 'FERNANDA', 'KELLY') AS MENOR_STRING,
--NUMBER
GREATEST(4, 87, 900, 1) AS MAIOR_NUMERO,
LEAST(4, 87, 900, 1) AS MENOR_NUMERO,
@jotapepinheiro
jotapepinheiro / zebra.txt
Last active August 29, 2015 14:24
Zebra CSS Jasper Reports
Styles->Zebra->Condicional
new Boolean(($V{REPORT_COUNT}.intValue() % 2) != 0)
Forecolor [204,204,204]
Backcolor [241,241,241]
Opaque true