Skip to content

Instantly share code, notes, and snippets.

mysql> use test;
Database changed
mysql> ---------------------------------
mysql> -- buat table dan sample datanya
mysql> ---------------------------------
mysql> create table tbl_data as
-> select '1' ID ,'001' NOPEL, 'INQUIRY' KATEGORI union all
-> select '2' ID ,'002' NOPEL, 'COMPLAINT' KATEGORI union all
-> select '3' ID ,'003' NOPEL, 'REQUEST' KATEGORI union all
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
D:\xampp\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.16 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Nur Hidayat>d:
D:\>cd xampp\mysql\bin
D:\xampp\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
D:\xampp\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.16 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
@mishbah
mishbah / .vimrc
Created December 28, 2015 01:35 — forked from JeffreyWay/.vimrc
My .vimrc file
set nocompatible " Disable vi-compatibility
set t_Co=256
colorscheme xoria256
set guifont=menlo\ for\ powerline:h16
set guioptions-=T " Removes top toolbar
set guioptions-=r " Removes right hand scroll bar
set go-=L " Removes left hand scroll bar
set linespace=15

#Introduction If you're a php developer on ubuntu, there comes the time where you have to install/reinstall your system. I did it already a few times and i decided to write down the steps for a typical web developer stack with php. This is for a developer machine and not for a live environment!

I hope it helps you too!

fyi @mheiniger and me started with an installer here: https://github.com/mheiniger/webdev-setup

<?php
$I = new TestGuy($scenario);
$I->wantTo('register for a new account');
$I->amOnPage('/register');
$I->see('Register', 'h1');
$I->fillField('email', 'joe@sample.com');
$I->fillField('Password:', 'password');
$I->click('Register');
<?php
// app/start/global.php
/*
|--------------------------------------------------------------------------
| Application Error Logger
|--------------------------------------------------------------------------
|
| Here we will configure the error logger setup for the application which
@mishbah
mishbah / embuh.php
Created August 23, 2016 04:15
Kasus array
$sepatuVarian = [
'KTK001',
'KTK002',
'KTK003',
'KTK004',
'KTK005',
'KTK006'
];
$varians = [
@mishbah
mishbah / php-gettersetter.sublime-snippet
Created September 1, 2016 06:11
Snippet for php getter and setter for sublimetext (tested at sublimetext v3)
<snippet>
<content><![CDATA[/**
* Getter for ${1:$SELECTION}
*
* @return ${2:mixed}
*/
public function get${1/^(\w)|(?:_(\w))|(?:_)/(?1\u$1:)(?2\u$2:)/g}()
{
return \$this->$1;
}