Showing posts with label programming. Show all posts
Showing posts with label programming. Show all posts
Thursday, October 7, 2021

PHP: Exporting data table array to Excel xlsx file with PhpSpreadsheet library

›
In many occasions when a data table is queried from database and/or displayed on the screen of web application, there is a need to enable th...
Monday, July 12, 2021

MySQL - How to insert record if not exists to avoid data duplication

›
While coding an application with MySQL as database, you might come into this situation: You want to insert a new record into a table, if and...
Monday, June 29, 2020

Generating PHP codes for mobile-friendly web database applications with AppGini rapid development tool

›
AppGini by Bigprof Software is a rapid web application development tool for the PHP and MySQL web service stack. It is very easy to use, ...
Thursday, May 30, 2019

How to implement select all function for multiple sets of checkbox items on the same webpage using simple JavaScript

›
When designing a webpage with list of checkbox items, it is common and useful to implement a Select All/None function so that the user can e...
Friday, May 3, 2019

DSN-less access to Microsoft SQL Server from Raspberry Pi Raspbian Stretch

›
Accessing Microsoft SQL Server (including SQL Server Express and Azure SQL Database) from Linux isn't that straightforward. Microsoft ...
Monday, April 29, 2019

dnGrep - Free GUI "grep" and "sed" tool for Windows

›
If you are familiar with UNIX/Linux operating system, you must be using a lot of "grep" command to search for string inside text f...
Thursday, April 18, 2019

Free database clients able to access multiple DBMS - DBeaver CE & DBSL Database Browser

›
Nowadays it is not unusual for IT personnel to deal with multiple databases at the same time. There is also a high chance of the need to dea...
Wednesday, March 27, 2019

EmEditor - lightweight text editor able to open large file and also manipulate CSV

›
Recently, I was looking for a text editor that is capable to open and edit an SQL dump as large as 2.7 GB, and I only found EmEditor to be ...
Monday, February 11, 2019

Automate Flow: Let your phone / tablet inform you when its battery is 100% fully charged

›
This is an example of Automate flow. To learn more about Automate for Android phones, click here . It is advisable to unplug your phone / ...

Automate Flow: Auto disable WiFi when you are travelling in a vehicle unless you are connected to a hotspot

›
This is an example of Automate flow. To learn more about Automate for Android phones, click here . Normally when we are travelling in a ve...
Thursday, January 17, 2019

Fixed MySQL Workbench installation problem with missing Visual C++ Redistributable package (2015)

›
MySQL Workbench is a very useful unified visual tool for database architects, developers, and DBAs working on MySQL and/or MariaDB. It provi...
Thursday, January 10, 2019

Laragon the free WAMP platform better than XAMPP, WampServer, etc.

›
The Windows-Apache-MySQL-PHP or Windows-Apache-MariaDB-PHP (WAMP) is a web application server platform running on Microsoft Windows operatin...
1 comment:
Tuesday, January 23, 2018

Book: Algorithms Notes for Professionals

›
An algorithm is a procedure or formula for solving a problem, based on conducting a sequence of specified actions. Algorithm plays an impo...
Friday, December 8, 2017

Automate Flow: Auto enable Bluetooth to connect to car hands-free when you are driving, else disable Bluetooth

›
This is an example of Automate flow. To learn more about Automate for Android phones, click here . It is always a good idea to disable the...
Thursday, December 7, 2017

Automate Flow: Auto enable WiFi when you arrive home and disable WiFi when you leave home

›
This is an example of Automate flow. To learn more about Automate for Android phones, click here . It is always a good idea to disable the...
Wednesday, December 6, 2017

Automate Flow: Always go back to Home screen whenever phone is unlocked at launcher screen

›
This is an example of Automate flow. To learn more about Automate for Android phones, click here . This is a very simple Automate flow wit...
Monday, December 4, 2017

Automate Flow: Switch your phone between Vibrate and Normal profile with customized mute

›
This is an example of Automate flow. To learn more about Automate for Android phones, click here . Your Android phone is likely to have 3 ...

Making your Android phone smarter by programming task automation using Automate

›
Automate is a freemium Android app developed by LlamaLab that enables you to perform task automation in your smartphone. With it, you can...
Saturday, October 7, 2017

Book: Cracking the Coding Interview (6th Edition) by Gayle Laakmann McDowell

›
Whether you are a fresh graduate or an experienced software developer, if you are thinking about landing your dream job in the software engi...