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,…
//
Author: admin
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…
Programming
Log and Display PHP Errors
PHP decides two things separately: whether to print a problem to the browser, and whether to write it to a file. Set display_errors and…