Skip to content

Instantly share code, notes, and snippets.

View hanafiah's full-sized avatar
🏠
Working from home

Muhamad Hanafiah Yahya hanafiah

🏠
Working from home
46 followers · 20 following
View GitHub Profile
@hanafiah
hanafiah / group.by.normal.sql
Created March 14, 2014 11:47
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE MONTH(datalog) = '3' AND YEAR(datalog) = '2012' GROUP BY link_id;
/* 0 rows affected, 233 rows found. Duration for 1 query: 173.062 sec. */
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE datalog BETWEEN '2012-03-01 00:00:00' AND '2012-04-01 00:00:00' GROUP BY link_id;
/* 0 rows affected, 233 rows found. Duration for 1 query: 174.328 sec. */
@hanafiah
hanafiah / group.by.optimized.sql
Created March 14, 2014 11:48
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE MONTH(datalog) = '3' AND YEAR(datalog) = '2012' GROUP BY crc32(link_id);
/* 0 rows affected, 233 rows found. Duration for 1 query: 4.859 sec. */
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE datalog BETWEEN '2012-03-01 00:00:00' AND '2012-04-01 00:00:00' GROUP BY crc32(link_id);
/* 0 rows affected, 233 rows found. Duration for 1 query: 4.829 sec. */
@hanafiah
hanafiah / group.by.all.sql
Last active August 29, 2015 13:57
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE MONTH(datalog) = '3' AND YEAR(datalog) = '2012' GROUP BY link_id;
/* 0 rows affected, 233 rows found. Duration for 1 query: 174.312 sec. */
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE datalog BETWEEN '2012-03-01 00:00:00' AND '2012-04-01 00:00:00' GROUP BY link_id;
/* 0 rows affected, 233 rows found. Duration for 1 query: 173.172 sec. */
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE MONTH(datalog) = '3' AND YEAR(datalog) = '2012' GROUP BY crc32(link_id);
/* 0 rows affected, 233 rows found. Duration for 1 query: 4.765 sec. */
SELECT link_id,COUNT(*) FROM ltlinks_log WHERE datalog BETWEEN '2012-03-01 00:00:00' AND '2012-04-01 00:00:00' GROUP BY crc32(link_id);
@hanafiah
hanafiah / php.xampp.mac.sh
Last active July 29, 2025 01:39
ubah default php path dalam mac osx
#1. buka terminal, dan taip arahan di bawah
which php
#2. secara default, lokasi php adalah seperti berikut
/usr/bin/php
#3. edit bash_profile
sudo vim ~/.bash_profile
#3a. if use zsh
@hanafiah
hanafiah / iframe_test.html
Last active August 29, 2015 14:01
<!DOCTYPE html>
<html>
<head>
<title>iframe test</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<div>change url to test</div>
<iframe src="http://www.amazon.com/" style='width:100%;height:300px' ></iframe>
@hanafiah
hanafiah / gist:a8628b0be5e9e2dcfb61
Created October 9, 2014 01:54
contoh 1
<?php
$arr = [
'a' => [
0=>[
'file_name'=>'abc',
'file_type'=>'image/jpeg',
],
1=>[
'file_name'=>'def',
@hanafiah
hanafiah / verify_domain_ownership.php
Created November 28, 2014 03:38
<?php
//contoh hash yang hendak di semak
$lookup_txt = 'sample1-123';
var_dump(is_txt_exist('ibnuyahya.com',$lookup_txt));
function is_txt_exist($tld,$lookup_txt){
$txts = dns_get_record($tld,DNS_TXT);
foreach ($txts as $txt) {
if($lookup_txt ==$txt['txt'] )
@hanafiah
hanafiah / aws-php-sdk-describe-elb.php
Last active November 21, 2024 03:34
<?php
/**
* 1st. make sure you've created your access key in IAM. then configure credential file in the following path
*
* ~/.aws/credentials
* enter credentials info as below..
[default]
aws_access_key_id = YOUR_ACCESS_KEY_ID
aws_secret_access_key = YOUR_SECRET_ACCESS_KEY
@hanafiah
hanafiah / check java version
Created December 10, 2014 05:52
~ java -version
java version "1.8.0_25"
Java(TM) SE Runtime Environment (build 1.8.0_25-b17)
Java HotSpot(TM) 64-Bit Server VM (build 25.25-b02, mixed mode)
@hanafiah
hanafiah / composer.ssl.issue
Created January 16, 2015 10:43
[Composer\Downloader\TransportException]
The "https://getcomposer.org/version" file could not be downloaded: SSL operation failed with code 1. OpenSSL Error messages:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
Failed to enable crypto
failed to open stream: operation failed