MrRoot mrroot5

mrroot5 / youtubeVideoID.js

Created April 22, 2015 17:18

Obtener id video youtube From http://stackoverflow.com/questions/10591547/how-to-get-youtube-video-id-from-url

	var url = "https://www.youtube.com/watch?v=zKx2B8WCQuw";
	var videoid = url.match(/(?:https?:\/{2})?(?:w{3}\.)?youtu(?:be)?\.(?:com\|be)(?:\/watch\?v=\|\/)([^\s&]+)/);
	if(videoid != null) {
	console.log("video id = ",videoid[1]);
	} else {
	console.log("The youtube url is not valid.");
	}

mrroot5 / get_enum_values.php

Created April 28, 2015 10:56

	function get_enum_values( $table, $field )
	{
	$type = $this->db->query( "SHOW COLUMNS FROM {$table} WHERE Field = '{$field}'" )->row( 0 )->Type;
	preg_match("/^enum$\'(.*)\'$$/", $type, $matches);
	$enum = explode("','", $matches[1]);
	return $enum;
	}

mrroot5 / getVimeoId.js

Last active August 29, 2015 14:20

	vimeo_Reg = /(?:https?:\/\/)?(?:www\.)?vimeo.com\/(?:channels\/(?:\w+\/)?\|groups\/([^\/]*)\/videos\/\|album\/(\d+)\/video\/\|)(\d+)(?:$\|\/\|\?)/;

	function vimeoID(url) {
	var match = url.match(vimeo_Reg);

	if (match){
	return "<span>"+match[3]+"</span>";
	}else{
	return "<span class='error'>error</span>";
	}

mrroot5 / capitalize.js

Last active May 3, 2018 07:55

	// Opcion 1: Modificando el objeto String
	String.prototype.capitalize = function(){
	return this.toLowerCase().replace( /\b\w/g, function (m) {
	return m.toUpperCase();
	});
	};

	String.prototype.capitalizeFirstWord = function(){
	return text.charAt(0).toUpperCase() + text.slice(1);
	};

mrroot5 / get_file_extension.php

Last active August 29, 2015 14:20

Snippets subida ficheros. Obtener extensión fichero y cambiar nombre fichero

	<?php
	function get_file_extension($file_name = '') {
	$file_name = (empty($file_name)) ? 'bla.bla..pdf' : $file_name;

	preg_match('/[^\.]+$/i', $file_name, $ext);
	return $ext[0];
	}
	?>

mrroot5 / get_protocol.php

Last active August 29, 2016 08:22

Obtener protocolo http o https From http://stackoverflow.com/questions/4503135/php-get-site-url-protocol-http-vs-https

$protocol = (stripos($_SERVER['SERVER_PROTOCOL'],'https') === true) ? 'https://' : 'http://';

mrroot5 / windows_installation_date.bat

Created May 17, 2015 16:48

Fecha instalación Windows: año/mes/día/hora/minutos/segundos/zonagmt

cmd /k wmic os get installdate

mrroot5 / mysql_update_field_by_date.sql

Last active November 17, 2015 09:19

Actualizar un campo en base a una fecha.

UPDATE `tabla` SET `campo_actualizar` = 0 WHERE `campo_fecha` < NOW() AND `campo_fecha` != '0000-00-00 00:00:00' AND `campo_fecha` IS NOT NULL

mrroot5 / mysql_filter_field_by_words.sql

Last active November 17, 2015 09:19

Obtiene un número de palabras de un campo. Filtra un campo por número de palabras. From: https://www.daniweb.com/web-development/php/threads/131471/displaying-a-limited-number-of-words-from-mysql#post636034

SELECT SUBSTRING_INDEX(description," ",3) FROM table [WHERE condition];

mrroot5 / mysql_check_if_field_exists.sql

Last active November 17, 2015 09:19

Comprobar si un campo existe en una tabla From https://www.ma-no.org/es/content/index_mysql-comprobar-si-existen-campo-y-tabla_1561.php

	function existe_campo ($db_conn, $tabla, $campo) {
	if ($resultado = $db_conn->query('SHOW COLUMNS FROM '.$tabla.' LIKE "'.$campo.'"')) {
	if($resultado->num_rows() === 1) {
	return TRUE;
	} else {
	return FALSE;
	}
	}
	}

	function get_enum_values( $table, $field )
	{
	$type = $this->db->query( "SHOW COLUMNS FROM {$table} WHERE Field = '{$field}'" )->row( 0 )->Type;
	preg_match("/^enum\(\'(.*)\'\)$/", $type, $matches);
	$enum = explode("','", $matches[1]);
	return $enum;
	}