Skip to content

Instantly share code, notes, and snippets.

View coderdiaz's full-sized avatar
:electron:

Javier Diaz coderdiaz

:electron:
View GitHub Profile
$(document).ready(function(){
$('#getDatos').click(function(){
$.ajax({
url: 'consulta.php',
success: function(data){
$("p").remove();
console.log(data); //<=== Esta puede ser removida;
var datos = $.parseJSON(data);
console.log(datos); //<=== Esta puede ser removida;
$.each(datos, function(i, row) {
@coderdiaz
coderdiaz / index.php
Last active August 29, 2015 14:09
Uso de STR_PAD
<?php
$cadena = "1";
echo str_pad($cadena, 3, "0", STR_PAD_LEFT);
?>
@coderdiaz
coderdiaz / data.js
Created November 27, 2014 07:37
Implementación de DataTables con datos desde Ajax.
var tablaEntradas = $('#tableAjaxEntradas').DataTable();
$.ajax({
url: 'c_repor/obtenerEntradas',
dataType: 'json',
type: 'GET',
success: function(response){
$.each(response, function(i, object){
var datos = [];
var i = 0;
@coderdiaz
coderdiaz / index.php
Created March 3, 2015 22:51
Sumar un intervalo de días en PHP
<?php
$interval = 7;
$fecha = '2015-02-25';
$date = new DateTime(''.$fecha.'');
$date->add(new DateInterval('P'.$interval.'D'));
echo $date->format('Y-m-d') . "\n";
?>
@coderdiaz
coderdiaz / app.js
Last active February 14, 2016 02:52
Manejo de Base de Datos SQLite con $cordovaSQLite en Ionic Framework
var db = null;
var example = angular.module('starter', ['ionic', 'ngCordova'])
.run(function($ionicPlatform, $cordovaSQLite) {
$ionicPlatform.ready(function() {
if(window.cordova && window.cordova.plugins.Keyboard) {
cordova.plugins.Keyboard.hideKeyboardAccessoryBar(false);
}
if(window.StatusBar){
StatusBar.styleDefault();
@coderdiaz
coderdiaz / index.php
Created March 12, 2015 18:15
Agregar datos a un objeto en PHP
<?php
$data1 = new stdClass;
$data1->id = 10;
$data1->url = 11;
$data1->otrodato = 12;
$data2 = new stdClass;
$data2->id = 13;
$data2->url = 14;
@coderdiaz
coderdiaz / delete.sql
Last active August 29, 2015 14:18
How to delete duplicate rows with MySQL
DELETE n1
FROM table1 n1, table1 n2
WHERE n1.id > n2.id
AND n1.id_name = n2.id_name;
/*
* With this query you can
* delete the duplicate rows in one table (table1)
* ´WHERE n1.id > n2.id´ with this line you can keep the first row
* if you want keep the second row you need use ´WHERE n1.id < n2.id´
<VirtualHost *:80>
ServerAdmin webmaster@admin
DocumentRoot /var/www/myproject.dev/public_html
ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>
@coderdiaz
coderdiaz / backup.js
Last active November 9, 2016 13:27
How to backup Database with Ionic Framework
/*
* Implementation with Ionic Framework with $cordovaFile plugin
* ngCordova.
*/
.controller('Ctrl', function($scope, $cordovaFile) {
$scope.backupDatabase = function() {
// Backup Database ;
var URI_DB = cordova.file.applicationStorageDirectory+'databases/';
@coderdiaz
coderdiaz / app.js
Created May 12, 2015 22:39
Obtener el tamaño de un objeto a partir de sus llaves
var var_object = {
'one': 'The first key',
'two': 'The second key',
'three': 'The third key'
};
var size_object = Object.keys(var_object).length;
console.log('The size is: ' + size_object); // The size is: 3 ;