Skip to content

Instantly share code, notes, and snippets.

View demo.sql
CREATE DATABASE `demo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `demo`;
# Dump of table categorias
# ------------------------------------------------------------
DROP TABLE IF EXISTS `categorias`;
CREATE TABLE `categorias` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
View gist:c1d4e8bb2f5244f6cbb7f38fb34a2abe
<!DOCTYPE html
<html>
<head>
<meta charset="utf-8">
</head>
<body>
<?php
// Abrir conexión
$conexion = new mysqli("localhost", "root", "", "tutoriales");
@eamexicano
eamexicano / wget.sh
Created May 14, 2016
Copiar un directorio de manera recursiva con wget
View wget.sh
wget -r --user="user@example.com" --password="password" ftp://domain.tld/
@eamexicano
eamexicano / mysql2xls.php
Last active Mar 2, 2016
Exporta los datos de MySQL a XLS incluyendo el nombre de los campos
View mysql2xls.php
<?php
/**
* The MIT License (MIT)
* Copyright (c) 2016 Emmanuel Ayala Mexicano @eamexicano
* Permission is hereby granted, free of charge, to any person obtaining a copy
* of this software and associated documentation files (the "Software"), to deal
* in the Software without restriction, including without limitation the rights
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
* copies of the Software, and to permit persons to whom the Software is
@eamexicano
eamexicano / data-obj.html
Created Jun 9, 2015
Atributos data - Objetos
View data-obj.html
<!--
Utilizar atributos data para almacenar contenido
-->
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
</head>
<body>
@eamexicano
eamexicano / ejercicios.html
Last active Aug 29, 2015
Cargar scripts de distintas carpetas y ejecutarlos al momento.
View ejercicios.html
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8'>
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Ejercicios</title>
<link rel="stylesheet" href="estilo.css" type="text/css">
</head>
<body>
<h2>Ejercicios disponibles</h2>
@eamexicano
eamexicano / tutoriales.sql
Created Sep 18, 2014
Base de datos para los ejercicios del curso MySQL y PHPMySQL
View tutoriales.sql
-- BD Tutoriales
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
@eamexicano
eamexicano / concatenate.sh
Created Nov 22, 2013
Remove carriage return from windows file and create new file. Exclude some files (from a directory) and concatenate into a one big file.
View concatenate.sh
#!/bin/bash
# Remove carriage return from windows file <CR> and createa a new file
tr -d '\015' < windows_file > another_file
# Exclude some files prior concatenation
ls | sort | grep -v -E "(file1|file2|...|fileN)" | xargs cat > large_file
@eamexicano
eamexicano / template.css
Created Nov 7, 2013
CSS rules for template.html - To be used as a remote repository.
View template.css
body { background: #f2f2f2; margin: 0 auto; font-family: 'helvetica neue', helvetica, sans-serif; font-size: 1em; padding: 1em; color: #151515;}
h1, h2, h3, h4, h5, h6 {font-family: georgia, "times new roman", times, serif;}
header {text-align: left;}
section { }
footer {text-align: right; margin: 1em 0;}
@eamexicano
eamexicano / template.html
Created Nov 7, 2013
HTML5 base template - to be used as a remote repository.
View template.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Template</title>
<link rel="stylesheet" href="template.css" type="text/css" media="screen" title="no title" charset="utf-8">
</head>
<body>
<header>
<h1>Template</h1>