Database Administration
Insert or Update a Row With ON DUPLICATE KEY UPDATE in MySQL
One statement that inserts a new sku or updates the one already stocked: the row alias that reads your own values, a whole feed…
//
Author: admin
Programming
Read a Large File Line by Line With PHP Generators
A generator hands back one line at a time instead of building the whole array, which cut peak memory from 35.3 MB to 2.0…
Server Administration
Check Disk, Memory and CPU Usage From the Terminal
Diagnose a struggling Linux server in under a minute with df, du, free and top - which resource is short, and which directory or…
Programming
List Files in a Directory With PHP
Inventory a folder with PHP: match a pattern with glob(), read every entry with scandir(), walk sub-folders with RecursiveDirectoryIterator, then sort by size or…
Database Administration
Search Text With a MySQL FULLTEXT Index
Replace a slow LIKE '%word%' with a FULLTEXT index: rank matches by relevance in natural-language mode, require or exclude terms in boolean mode, and…
Programming
Create a WordPress Settings Page With the Settings API
Build an admin settings screen the way WordPress intends: add_options_page for the menu, register_setting with a sanitize callback, and a form that options.php saves…