Database Administration
Add a Generated Column in MySQL
A generated column holds a value MySQL computes from the rest of the row, so it can never drift out of step. This tutorial…
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
//
Tutorial series
Multi-part arcs — each series builds one topic step by step. Follow the parts in order.
Custom Gutenberg Blocks · 5 parts
-
1
-
2
-
3
-
4
-
5
Maintain a Server · 5 parts
-
1
-
2
Part 2
Deploy a Site With rsync -
3
-
4
-
5
Modern MySQL 8 · 5 parts
-
1
-
2
-
3
-
4
-
5
//
Latest tutorials
Database Administration
Store and Query JSON Data in MySQL
Use the JSON column type to store documents MySQL actually understands. This tutorial inserts JSON, reads keys with JSON_EXTRACT and the ->> shorthand, edits…
Database Administration
Query Hierarchical Data With a Recursive CTE in MySQL
Walk a category tree stored as a flat parent_id column using WITH RECURSIVE. This tutorial builds the anchor and recursive member, adds a depth…
Database Administration
Write a Common Table Expression With WITH in MySQL
Name a query result with WITH so the rest of the statement reads it like a table. This tutorial rewrites a nested subquery as…
Database Administration
Rank Rows With ROW_NUMBER and RANK in MySQL
Number and rank rows in MySQL with the ROW_NUMBER, RANK and DENSE_RANK window functions. Learn how PARTITION BY restarts the count per group, how…
Programming
Add a Block Style Variation in WordPress
register_block_style adds a named look to a block that already exists, without writing a new block at all. WordPress applies an is-style-* class when…
Programming
Register a Block Pattern in WordPress
register_block_pattern stores a ready-made arrangement of blocks, while register_block_pattern_category gives it a home in the inserter. The content is ordinary block markup copied out…
Programming
Create a Dynamic Gutenberg Block With a PHP Render Callback
A dynamic block saves nothing: save returns null and render_callback names the PHP that builds the markup on every request, so the output can…
Programming
Add Settings Controls to a Gutenberg Block
Attributes in block.json declare what a block stores, then InspectorControls moves the fields into the editor sidebar where authors expect them. PanelBody groups the…
Programming
Create a Custom Gutenberg Block Without a Build Step
register_block_type reads a block.json file and wp.blocks.registerBlockType describes the block in plain JavaScript. Because wp.element.createElement replaces JSX, there is no compiler in the loop…
//
Most read
//
Browse by topic
</>
Programming
PHP, Laravel, WordPress and jQuery — hands-on coding guides worked through end to end.
68 tutorials →$_
Server Administration
Apache, environments, and running your stack on Windows without the guesswork.
20 tutorials →DB
Database Administration
MySQL queries, PDO, and the everyday tasks of keeping your data in order.
27 tutorials →