Database Administration
Create an Index and Read EXPLAIN in MySQL
Create an index in MySQL and use EXPLAIN to prove it worked, turning a 5,000-row full table scan into a targeted lookup of just…
Web Development Tutorials
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.
New to the stack? Work through these in order — from setup to a running app.
Set up your site
Install WordPress Locally On WindowsCustomize safely
Create a WordPress Child ThemeAdd your own content
Register A Custom Post Type In WordPressMake it dynamic
Create A Shortcode In WordPressLoad your own code
Enqueue CSS And JavaScript In WordPressDatabase Administration
Create an index in MySQL and use EXPLAIN to prove it worked, turning a 5,000-row full table scan into a targeted lookup of just…
Database Administration
Add a foreign key in MySQL to link two tables and have the database enforce it, rejecting orphan rows while an ON DELETE CASCADE…
Database Administration
Create a MySQL table from the terminal with a single CREATE TABLE statement: typed columns, an AUTO_INCREMENT primary key, and sensible defaults, confirmed with…
Programming
Format, parse, and compare dates with PHP's built-in DateTime class. format() prints any layout, createFromFormat() reads non-standard strings, and diff() measures the gap between…
Programming
Group your WordPress content your own way, beyond the built-in categories and tags. register_taxonomy() on the init hook creates a hierarchical Topic taxonomy —…
Server Administration
Create an Apache virtual host to serve multiple sites from one Apache install. Define a block with ServerName and DocumentRoot, add a hosts-file entry,…
Programming
Give the WordPress post editor an extra field of your own — a short "key takeaway" saved with each post. A small plugin adds…
Programming
Keep a user logged in across page loads with PHP's built-in session functions. session_start() opens the session, the $_SESSION array holds the data, and…
Database Administration
Join tables in MySQL to combine related rows in a single query. Learn INNER JOIN for matches, LEFT JOIN to keep unmatched rows, table…
Programming
Hash and verify passwords in PHP with password_hash() and password_verify(). Store a secure bcrypt hash, check logins against it, and upgrade old hashes automatically…
PHP, Laravel, WordPress and jQuery — hands-on coding guides worked through end to end.
40 tutorials →Apache, environments, and running your stack on Windows without the guesswork.
6 tutorials →MySQL queries, PDO, and the everyday tasks of keeping your data in order.
11 tutorials →