alifhaikal88

How to create an HTTPS certificate for localhost domains

This focuses on generating the certificates for loading local virtual hosts hosted on your computer, for development only.

Do not use self-signed certificates in production ! For online certificates, use Let's Encrypt instead (tutorial).

alifhaikal88

-- to use sqlCmd ( command line sql tool)

-- open command prompt and execute the "sqlcmd.exe" probably located at
-- "C:\Program Files\Microsoft SQL Server\100\Tools\Binn"

> sqlcmd.exe -U username -P password -S .\sqlServer

This will open sql server in cmd

1> select DB_Name()

alifhaikal88

Making chained API Calls using @ngrx/Effects

Purpose

This recipe is useful for cooking up chained API calls as a result of a single action.

Description

In the below example, a single action called POST_REPO is dispatched and it's intention is to create a new repostiory on GitHub then update the README with new data after it is created.
For this to happen there are 4 API calls necessary to the GitHub API:

1. POST a new repostiry
2. GET the master branch of the new repository
3. GET the files on the master branch

alifhaikal88

/*
It builds a hierarchical query. 
There are 2 components to it:
"start with" -- this identifies all LEVEL=1 nodes in the tree
"connect by" -- describes how to walk from the parent nodes above to their children and their childrens children.
*/
select ename, empno, mgr from emp;
select lpad(' ',level*2,' ')||ename ename, 
sys_connect_by_path(business_code, '/') path,
connect_by_isleaf is_leaf,

alifhaikal88

WhatsApp On Web Monitor

What It does

It gives notifications when someone goes online or offline or typing. Open chat of the contact you want to monitor and start script.

Simple Way

• Create a bookmark and Add the content of bookermarklet as url. (or goto http://parthpower.github.io/serviceworkers/whatsappmonitor.html)
• Goto whatsapp on web and click on the bookmark.
• Open chat of the contact you want to monitor.

alifhaikal88

Vanilla JavaScript Quick Reference / Cheatsheet

Just migrated it from Codepen.io to markdown. Credit goes to David Conner.

Working with DOM	Working with JS	Working With Functions
Accessing Dom Elements	Add/Remove Array Item	Add Default Arguments to Function
Grab Children/Parent Node(s)	Add/Remove Object Properties	Throttle/Debounce Functions
Create DOM Elements	Conditionals

alifhaikal88

Basic CRUD operations with PDO

CRUD = Create, Read, Update, Delete

Open a database connection

$host = '127.0.0.1';
$dbname = 'test';
$username = 'root';

alifhaikal88

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

alifhaikal88

#!/usr/bin/env bash
 
# Formatting constants
export BOLD=`tput bold`
export UNDERLINE_ON=`tput smul`
export UNDERLINE_OFF=`tput rmul`
export TEXT_BLACK=`tput setaf 0`
export TEXT_RED=`tput setaf 1`
export TEXT_GREEN=`tput setaf 2`
export TEXT_YELLOW=`tput setaf 3`

alifhaikal88

#!/usr/bin/env bash
# tputdemo.sh

echo -e "\n$(tput bold) reg  dim  bld  und   tput-command$(tput sgr0)"
for i in $(seq 0 15); do
  for k in sgr0 dim bold smul; do
    echo -n " $(tput $k)$(tput setaf $i)Text$(tput sgr0)"
  done
  echo    "  \$(tput setaf $i)"
done