Code snippets
Code snippets
Copy-ready answers to everyday coding questions, each with a short explanation. Laravel, PHP, JavaScript, SQL, Bash and more.
2 snippets tagged #rest · Show all
SQL
October 20, 2026
MySQL backup and restore a database with mysqldump
Dumps a database to a file and restores it later. --single-transaction gives a consistent backup of InnoDB tables without locking them.
# Backup
mysqldump -u root -p --single-transaction mydb > mydb.sql
# Backup compressed
PHP
October 19, 2026
Laravel API Resource transform model to JSON response
Controls exactly which fields your API returns, so you never leak columns by accident. whenLoaded includes a relation only if it was eager loaded, which avoids...
<?php
// php artisan make:resource PostResource
namespace App\Http\Resources;