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…
Web Development Tutorials
Practical web-dev,
one tutorial at a time.
NdrieL is a web-development tutorials site — clear, step-by-step guides for WordPress, PHP and Laravel, each one worked through from the first line of code to a result you can run. No fluff — just the steps that work.
WordPress
PHP
Laravel
MySQL
Apache
//
Start here
New to the stack? Work through these in order — from setup to a running app.
-
1
Set up your site
Install WordPress Locally On Windows -
2
Customize safely
Create a WordPress Child Theme -
3
Add your own content
Register A Custom Post Type In WordPress -
4
Make it dynamic
Create A Shortcode In WordPress -
5
Load your own code
Enqueue CSS And JavaScript In WordPress
//
Latest tutorials
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…
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…
//
Most read
//
Browse by topic
</>
Programming
PHP, Laravel, WordPress and jQuery — hands-on coding guides worked through end to end.
61 tutorials →$_
Server Administration
Apache, environments, and running your stack on Windows without the guesswork.
15 tutorials →DB
Database Administration
MySQL queries, PDO, and the everyday tasks of keeping your data in order.
21 tutorials →