VestaCP Guide: How to Install PHP Selector on CentOS 7
Are you one of VestaCP fans? Then you should know this trick. By default, VestaCP … Read More
Query MySQL di dalam PHP Loop – Bad Practice!
Bagi yang baru belajar bahasa pemrograman, entah apapun bahasanya maka bisa dipastikan akan melakukan hal … Read More
Sending POST Requests Without Waiting for Response
https://jagowebdev.com/query-mysql-dalam-php-loop/
Cara Setup Website 2 Region Menggunakan Load Balancer di Cloud VPS
Mengenal Load Balancing Load balancing adalah sebuah teknis untuk membagi beban suatu server ke server … Read More
Tutorial Cara Download dan Install Composer di Windows & Linux
Bagi Anda yang berencana untuk menginstall dan menggunakan framework PHP Laravel, pastinya Anda tahu bahwa … Read More
Script PHP Updating Data Secara Simultan (Studi Kasus Update Nilai Kuliah Mahasiswa)
Setelah beberapa waktu yang lalu saya memposting artikel tentang cara hapus data secara simultan dengan … Read More
How to Optimize MySQL Performance Using MySQLTuner
Running MySQL at optimal settings for specific resources helps handle larger server loads and prevents … Read More
Install and Configure Redis on CentOS 7
Redis is an open-source, in-memory, data structure store with optional disk writes for persistence. It … Read More
How To Install and Secure Redis on CentOS 7
Introduction Redis is an open-source, in-memory data structure store which excels at caching. A non-relational … Read More
How to Sort an Alphanumeric Column in MYSQL?
I have a column with values like below after ordering by it’s column name (equipment_no) … Read More
How to Select Only Non-numeric Values from varchar Column in MySQL?
You need to use REGEXP for this. The syntax is as follows SELECT *FROM yourTableName … Read More
MySQL Query To Get max id From varchar Type And The Values In Numeric?
Use CAST() in MAX() to get max id from varchar type and values in numeric. … Read More
How To Select Only Non-numeric Values From varchar Column in MySQL?
You need to use REGEXP for this. The syntax is as follows SELECT *FROM yourTableName … Read More
How To Sort varchar Numeric Columns by DESC or ASC in MySQL?
Let us first create a table − mysql> create table DemoTable726 (Value varchar(100)); Query OK, … Read More