Code Explainers

Code explainers tagged #prepared-statements

php
<?php
 
namespace App\Database;
 

Building a fluent SQL query builder in PHP

fluent-interface method-chaining sql
Intermediate 10 steps
php
<?php
 
final class OrderRepository
{

Atomic order placement with PDO transactions

transactions prepared-statements atomicity
Intermediate 8 steps
php
<?php
 
final class UserRepository
{

A safe PDO user repository in PHP

prepared-statements repository-pattern sql-injection
Intermediate 7 steps
php
public function importUsers(array $users): int
{
    $inserted = 0;
 

Bulk-inserting users with batched PDO upserts

batching bulk-insert prepared-statements
Intermediate 6 steps
php
<?php
 
final class ProductRepository
{

Safe SQL pagination with PDO in PHP

pagination input-validation prepared-statements
Intermediate 7 steps