Muhamad Hanafiah Yahya hanafiah

🏠

Working from home

Ronin at 402.

hanafiah / tutorial.pdo.5.php

Created March 7, 2014 06:49

	<?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 / tutorial.pdo.4.php

Created March 7, 2014 06:34

	<?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 / tutorial.pdo.3.php

Created March 6, 2014 12:10

	<?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 / tutorial.pdo.2.php

Created March 6, 2014 12:07

	<?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 / tutorial.pdo.connection.php

Last active August 29, 2015 13:57

	<?php
	//mssql
	$dbh = new PDO("mssql:host=$host;dbname=$dbname, $user, $pass");

	//sybase
	$dbh = new PDO("sybase:host=$host;dbname=$dbname, $user, $pass");

	//sqlite
	$dbh = new PDO("sqlite:path/database.db");

hanafiah / tutorial.pdo.sql

Created March 6, 2014 02:01

	CREATE TABLE users (
	id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	username VARCHAR(20) NOT NULL,
	full_name VARCHAR(80) NOT NULL,
	password VARCHAR(40) NOT NULL,
	salt VARCHAR(40) DEFAULT NULL,
	email VARCHAR(80) NOT NULL
	)
	ENGINE InnoDB;

hanafiah / tutorial.pdo.1.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 / contoh2.html

Created March 4, 2014 16:06

	<script type="text/javascript">
	var loc = window.location.hash.substr(1);

	//start position
	context.beginPath();
	context.arc(190, 450, 10, 0, 2 * Math.PI, false);
	context.fillStyle = 'white';
	context.lineWidth = 2;
	context.strokeStyle = 'red';
	context.stroke();

hanafiah / contoh.html

Created March 4, 2014 15:39

	<script type="text/javascript">
	var loc = window.location.hash.substr(1);
	if (loc == 'bke01') {
	context.font = '20px Arial';
	context.strokeText('BKE01', 70, 330);
	context.beginPath();
	context.rect(50, 300, 100, 50);
	context.fillStyle = 'white';
	context.lineWidth = 2;
	context.strokeStyle = 'red';

hanafiah / html5 geolocation.html

Last active August 29, 2015 13:56

	<!DOCTYPE html>
	<html>
	<head>
	<title>Geolocation</title>
	<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
	<meta charset="utf-8">
	<style>
	html, body, #map-canvas {
	height: 100%;
	margin: 0px;