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 / 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 / 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 / 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 / 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.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 / tutorial.pdo.bindParam.php
Created March 9, 2014 04:38
<?php
$host = 'localhost';
$dbname = 'tutorial_pdo';
$user = 'root';
$pass = '';
try {
//$dbh , database handler aka db handler
$dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
@hanafiah
hanafiah / tutorial.pdo.bindValue.php
Created March 9, 2014 04:26
<?php
$host = 'localhost';
$dbname = 'tutorial_pdo';
$user = 'root';
$pass = '';
try {
//$dbh , database handler aka db handler
$dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
@hanafiah
hanafiah / tutorial.pdo.8.php
Created March 7, 2014 07:31
<?php
$host = 'localhost';
$dbname = 'tutorial_pdo';
$user = 'root';
$pass = '';
try {
//$dbh , database handler aka db handler
$dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
@hanafiah
hanafiah / tutorial.pdo.7.php
Last active August 29, 2015 13:57
<?php
$host = 'localhost';
$dbname = 'tutorial_pdo';
$user = 'root';
$pass = '';
try {
//$dbh , database handler aka db handler
$dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
@hanafiah
hanafiah / tutorial.pdo.6.php
Created March 7, 2014 07:05
<?php
$host = 'localhost';
$dbname = 'tutorial_pdo';
$user = 'root';
$pass = '';
try {
//$dbh , database handler aka db handler
$dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);