Advanced Search
Search Results
95 total results found
Application Development
Documentation
Technical
FAQ
Data
Javascript
PHP
PHP Laravel Framework
PHP Yii2 Framework
Linux
Microsoft Excel
MyIPO SPHI
HTML
CSS
Web Server
Postgresql Database
Tableau
Talend Open Studio for Data Integration
Apache Nifi
KNIME Analytics Platform
Apache Superset
Template
Git
MySQL
Command
Test Mail
Tips & Trick
Database
NGINX
Embed Dashboard
Penpot
Kira beza masa
var date1 = new Date("2021-11-30 09:48:00"); // ni date & time sekarang var date2 = new Date("2021-12-01 00:00:00"); // ni date & time yang dia pilih var masa = ((date2.getTime() - date1.getTime()) / 3600000); console.log(masa); var DateDiff = { inSecon...
Laravel Force Https
use Illuminate\Routing\UrlGenerator; public function boot(UrlGenerator $url) { public function register() { // force https if (config('app.env') !== 'local' && !filter_var(request()->getHost(), FILTER_VALIDATE_IP)) { $thi...
Test Email Relay
Untuk server aplikasi Linux/Windows, berikut adalah summary teknik fully compliant dengan RFC5322 untuk SMTP Relay with IP Authentication, dimana setiap langkah diakhiri dengan menekan butang Enter dan Langkah seterusnya setelah mendapat response selayaknya ...
How to Replace Blank Cells with Zeros in Excel Pivot Tables
For example, suppose I have a data set as shown below: If I use this data set to create a pivot table with Geography in Rows Area, Product in Column Area and Revenue in Values area, the result is something as shown below: As you can see, there are blank ...
List of User
Privilege
PTO_IT Role Privilege SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'PTO_IT'; GRANTEE GRANTED_ROLE ADMIN_OPTION DELEGATE_OPTION DEFAULT_ROLE COMMON INHERITED PTO_IT PTO_IT_ROLE NO NO YES NO NO System Privilege SELECT * FROM ...
Basic HTML Code
<html></html> <!-- Start and end document --> <h1></h1> <!-- Header size 1-6 (large-small) --> <p></p> <!-- Paragraph --> <br> <!-- Break the line --> <!-- Non breaking space --> <strike></strike> <!-- Strike through -->
Input Types in HTML
<input type="text">
What is JavaScript
JavaScript is a dynamic programming language that's used for web development, in web application, for game development, and lots more. It allows you to implement dynamic features on web pages that cannot be done with only HTM and CSS
NGINX Cheat Sheet
Server Block Structure # Define a server block (listens on port 80 by default for HTTP) server { listen [port]; # Optional, default is 80 server_name example.com www.example.com; root /path/to/root; index index.html; } Location Block # Define ...
psql Command
General \copyright show PostgreSQL usage and distribution terms \crosstabview [COLUMNS] execute query and display results in crosstab \errverbose show most recent error message at maximum verbosity \g [FILE] or ; exec...
Embed Dashboard to External Application Using JWT
Install PHP dependency composer require firebase/php-jwt Controller (For Yii2 Framework) use Firebase\JWT\JWT; // Tableau Server configuration $tableauServer = "https://YOUR_TABLEAU_SERVER"; $clientId = "YOUR_CLIENT_ID"; // From the Connected App $s...
Pre Development Template
Requirement Gethering Template Requirement Gathering Template.docx Requirement Gathering Template [SAMPLE].docx User Requirement Specification User Requirement Specification Template.docx User Requirement Specification Template [SAMPLE].docx Sist...
Post Development Template
Mysql Slow Query
vi /etc/my.cnf slow_query_log = 1slow-query-log-file = /var/log/mysql-slow.loglong_query_time = 2 touch /var/log/mysql-slow.log chown mysql:mysql /var/log/mysql-slow.log systemctl restart mysqld
add upstream git channel
git remote add upstream git@gitlab.com:tmukmkd/aaa.git git checkout -b u_master --track upstream/master
Add new user
useradd <username> passwd <username> Enter password
check memory and restart service when less than X gb.
bash#!/bin/bash # Get the available memory in KBfree_mem_kb=$(free -k | grep Mem | awk '{print $4}') # Convert to GB (divide by 1024^2)# without bcfree_mem_gb=$((free_mem_kb / 1024 / 1024))# with bc# free_mem_gb=$(echo "scale=2; $free_mem_kb / (1024 * 1024)"...
check server dah lepas pada postmaster
curl https://postmaster.mygovuc.gov.my/cgi-bin/myip
change ownership
basic chown <user>:<group> <option> <path> chown www-data:wheel -R /var/www/html/project_name -R = recursive change own from one of the user or group only chown -R --from=root nginx /var/www/html/cms chown -R --from=:root :nginx /var/www/html/cms