Database Administration
Format Dates in MySQL With DATE_FORMAT
One DATETIME, three presentations: the DATE_FORMAT specifiers that matter (minutes are %i, never %m), DATEDIFF and DATE_ADD arithmetic, a monthly report, and when the…
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
Send Email in WordPress With wp_mail
Send notifications the WordPress way: wp_mail with headers, a From address that exists, an HTML body and attachments - then catch the failure it…
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…
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…
//
Most read
//
Browse by topic
</>
Programming
PHP, Laravel, WordPress and jQuery — hands-on coding guides worked through end to end.
62 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.
22 tutorials →