Membuat File JSON dengan PHP
Banyak orang menggunakan file JSON ini karena format datanya mudah dibaca oleh manusia, sangat fleksibel … Read More
Konversi MySQL ke JSON Menggunakan PHP
Json (Javascript Object Notation) merupakan salah satu format pertukaran data yang dikenal ringan, mudah di baca … Read More
jQuery: Reset & Clear Form
Reset Form $(‘:input’,’#myform’) .not(‘:button, :submit, :reset, :hidden’) .val(”) .prop(‘checked’, false) .prop(‘selected’, false); or $(‘#myform’)[0].reset(); to … Read More
Ordering by Specific Field Value First
Question I have a table with 3 columns: id | name | priority ——————– 1 … Read More
How to Find and Replace Data in MySQL
Recently, while migrating my blog, I had to find all the occurrences of my old … Read More
Ordering by Specific Field Values with MySQL
There may be times when a specific order is required in a SQL query which … Read More
jQuery: Submit Form If at Least One Checkbox is Checked
The form will not be submitted until at least one check box is checked or … Read More
Export Data to Excel in PHP
Export data feature is very useful where the data is saved on the local drive … Read More
Membuat Data Dummy di PHP dengan Faker
Membuat Data Dummy di PHP Dengan Faker – Data dummy adalah data palsu yang dibuat … Read More
String Concatenation Done Right – Part 2 – An Effective Technique
Previously I have introduced string concatenation by demonstrating how not to use Transact-SQL to concatenate … Read More
SQL Concatenation Done Right – Part 1 – Dubious Practices
This article is a part of three articles series to explore SQL Concatenation techniques. Having … Read More
INSERT INTO SELECT Statement Overview and Examples
This article covers the SQL INSERT INTO SELECT statement along with its syntax, examples, and … Read More
SQL DELETE duplicate Rows Using GROUP BY and HAVING clause
This article explains the process of performing SQL delete activity for duplicate rows from a … Read More
SQL SELECT INTO statement
This article will cover the SQL SELECT INTO statement including syntax, parameters and use with … Read More