CodePrimer
Search a living directory of web syntax. Pick a problem, copy a working sample, then adapt it.
SQL
Beginner
CREATE DATABASE
How do I create a MySQL database?
SQL
Intermediate
ALTER TABLE add column
How do I add a column to an existing table?
SQL
Intermediate
Foreign key relationship
How do I relate posts to users?
SQL
Intermediate
COUNT with GROUP BY
How do I count rows per category?
SQL
Beginner
LIKE search pattern
How do I search text with a keyword?
SQL
Advanced
Basic transaction
How do I commit or roll back multiple writes?
SQL
Beginner
WHERE with AND / OR
How do I combine filters in SQL?
PHP
Intermediate
PDO connection for Laragon MySQL
How do I connect PHP to Laragon MySQL?
PHP
Intermediate
PDO ERRMODE_EXCEPTION
Why set PDO error mode to exceptions?
PHP
Intermediate
PDO prepared INSERT
How do I insert a row safely?
PHP
Intermediate
PDO prepared UPDATE
How do I update a record with PDO?
PHP
Intermediate
PDO prepared DELETE
How do I delete a row safely?
PHP
Intermediate
PDO fetch all rows
How do I list records from MySQL?
PHP
Beginner
require db.php connection
How do I reuse one DB connection file?