Skip to content

Instantly share code, notes, and snippets.

@sbarrat
sbarrat / Preferences.sublime-settings
Created February 16, 2014 18:56
Sublime Text 3 User Preferences Settings
{
"auto_complete": true,
"auto_complete_commit_on_tab": true,
"auto_complete_with_fields": true,
"bold_folder_labels": true,
"caret_style": "phase",
"color_scheme": "Packages/User/base16-ocean.light (SL).tmTheme",
"detect_indentation": true,
"fade_fold_buttons": false,
"folder_exclude_patterns":
@sbarrat
sbarrat / quitaEspacios.php
Last active August 29, 2015 13:58
Función para quitar espacios en blanco extras dentro de los textos
<?php
function quitaEspacios($texto)
{
$partes = explode(' ', $texto);
$textoLimpio = "";
foreach ($partes as $parte) {
if (strlen($parte) > 0 || $parte != "") {
$nombreLimpio .= $parte." ";
}
}
@sbarrat
sbarrat / ExtractURLVarValues.sql
Last active August 29, 2015 14:24
Extract the values of the vars in a url
/**
Si le pasamos una cadena como:
'index.php?var=17&otravar=12&masvar=33&muchovar=21'
nos devuelve una tabla con los valores de las variables
*/
DROP PROCEDURE IF EXISTS extractVars;
CREATE PROCEDURE extractVars(url VARCHAR(255))
BEGIN
DECLARE posicion INT;
DECLARE fin INT;
@sbarrat
sbarrat / generoPersona.php
Last active September 12, 2022 17:04
Detección de genero de Persona España
function generoPersona($nombre, $provider = 'genderAPI')
{
$providers = array(
'genderAPI' => array(
'url' => 'https://gender-api.com/get?name=',
'pais' => '&country=ES'
),
'genderize' => array(
'url' => 'https://api.genderize.io/?name=',
'pais' => '&country_id=es'