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…
//
Author: admin
Database Administration
Export MySQL Query Results to a CSV File
SELECT ... INTO OUTFILE turns any query into a spreadsheet file, written by the server itself. Handle the quoting that keeps embedded commas safe,…
Programming
Submit a Form With jQuery AJAX POST
Send a form's fields in the background and show the answer without reloading the page. preventDefault() stops the normal submission, serialize() packs every field…
Server Administration
Rotate Logs With logrotate
A log file that grows forever will eventually fill the disk. Write a logrotate config that renames, compresses and expires old copies, test it…
Programming
Modify the Main Query With pre_get_posts
WordPress builds a query for every page before it runs, and pre_get_posts hands you that query while it is still being built. Change how…
Database Administration
Combine Query Results With UNION in MySQL
A join widens a row by adding columns; UNION instead stacks one result on top of another. Build a single contact list from a…