mrroot5

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

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

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

// 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

<?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

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

mrroot5

cmd /k wmic os get installdate

mrroot5

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

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

mrroot5

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;
      }
  }
}