Skip to content

Instantly share code, notes, and snippets.

View wallacesilva's full-sized avatar
🌎
Working Remotely

Wallace Silva wallacesilva

🌎
Working Remotely
84 followers · 265 following
View GitHub Profile
@wallacesilva
wallacesilva / bindParam - PDO PHP
Created May 12, 2016 14:33
Example using PDO PHP - bindParam - Reference to variables
<?php
$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (?, ?)");
$stmt->bindParam(1, $name);
$stmt->bindParam(2, $value);
// insert one row
$name = 'one';
$value = 1;
$stmt->execute();
@wallacesilva
wallacesilva / gist:9a517fced8ad81654049f79d3605f336
Created September 19, 2016 18:17
<html>
<head><title>Hi</title></head>
<body>My Sexy body</body>
</html
@wallacesilva
wallacesilva / utf8fix.php
Created December 7, 2016 21:46
funcao gambiarra em php pra resolver problemas de dados não utf8 e converter corretamente.
<?php
// funcao gambiarra em php pra resolver problemas de dados não utf8 e converter corretamente.
// Fonte: https://berseck.wordpress.com/2010/09/28/transformar-utf-8-para-acentos-iso-com-php/comment-page-1/
function utf8Fix($msg){
$accents = array("á", "à", "â", "ã", "ä", "é", "è", "ê", "ë", "í", "ì", "î", "ï", "ó", "ò", "ô", "õ", "ö", "ú", "ù", "û", "ü", "ç", "Á", "À", "Â", "Ã", "Ä", "É", "È", "Ê", "Ë", "Í", "Ì", "Î", "Ï", "Ó", "Ò", "Ô", "Õ", "Ö", "Ú", "Ù", "Û", "Ü", "Ç");
$utf8 = array("á","à ","â","ã","ä","é","è","ê","ë","í","ì","î","ï","ó","ò","ô","õ","ö","ú","ù","û","ü","ç","Á","À","Â","Ã","Ä","É","È","Ê","Ë","Í","Ì","Î","Ï","Ó","Ò","Ô","Õ","Ö","Ú","Ù","Û","Ü","Ç");
$fix = str_replace($utf8, $accents, $msg);
return $fix;
}
@wallacesilva
wallacesilva / replace_mysql.sql
Created December 7, 2016 22:07
gambiarra de iso pra utf8 em banco ja convertido incorretamente
-- Mysql
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'á','á');
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'ä','ä');
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'é','é');
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'í©','é');
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'ó','ó');
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'íº','ú');
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'ú','ú');
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'ñ','ñ');
UPDATE `produtos` SET `titulo` = REPLACE(`titulo` ,'í‘','Ñ');
@wallacesilva
wallacesilva / keybase.md
Created February 21, 2017 16:03
keybase.md

Keybase proof

I hereby claim:

  • I am wallacesilva on github.
  • I am wallacesilva09 (https://keybase.io/wallacesilva09) on keybase.
  • I have a public key ASDkQkpCYJ4nFD4B9T2ExMT0Tmnze2nRB-ZAznRUhO_0Xwo

To claim this, I am signing this object:

@wallacesilva
wallacesilva / play-plause.sh
Created January 25, 2018 18:04
Shell Script to play/pause multiple media players
#!/bin/bash
is_started()
{
qtd=$(ps aux | grep $1 | wc -l)
if test "$qtd" = 1
then
return 0
else
@wallacesilva
wallacesilva / panel-alpha.sh
Created March 10, 2018 17:32 — forked from bharadwaj-raju/panel-alpha.sh
changes panel transparency depending on whether any window is maximized or not
#!/usr/bin/env bash
#-- CONFIGURATION
transparent_alpha=0
maximized_alpha=100
interval=0
#--
alpha_prop_list=()
for prop in $(xfconf-query -c xfce4-panel -p /panels -l); do
@wallacesilva
wallacesilva / MySQLPDO_Lumine
Created March 13, 2018 17:28
Driver to Lumine PHP connect mysql with PDO
<?php
/**
* Conexao com MySQL via PDO
* @author Wallace Silva
* @link http://www.hufersil.com.br
* @package Lumine_Connection
*/
Lumine::load('Connection_AbstractConnection');
@wallacesilva
wallacesilva / Prefectures REST API.md
Created May 14, 2018 15:07 — forked from gblmarquez/Prefectures REST API.md

/Providers

POST /Providers

  {
    id: "paulistana", // ID
    name: "Paulistana",
    standard: "ABRASF",
    version: "1.00",
    actions: [
@wallacesilva
wallacesilva / cnaes-servico.json
Created May 14, 2018 15:07 — forked from gblmarquez/cnaes-servico.json
CNAEs de Serviço
[
"0161001",
"0161002",
"0161003",
"0161099",
"0162801",
"0162802",
"0162803",
"0162899",
"0163600",