- https://speakerdeck.com/willroth/50-laravel-tricks-in-50-minutes
- https://www.reddit.com/r/laravel/comments/3to60i/50_laravel_tricks/
- 1. Automatic Model Validation
To install the latest Node.js and npm on Ubuntu, follow these steps: | |
Update your package list: | |
sudo apt update | |
Install Node.js using NodeSource: | |
curl -fsSL https://deb.nodesource.com/setup_current.x | sudo -E bash - | |
sudo apt-get install -y nodejs | |
Verify the installation: |
// Source: https://www.typescriptlang.org/play?target=1&ssl=42&ssc=3&pln=21&pc=1&q=316#code/PTAEDEFcDsGMBcCWB7apYAsCGjq4OagCCACgJIDOoWATgKbXrIC2zqoADlvPHTWrgBQIUACksANywBlWDUQd4AGlAB3DIkzosaZlgDWDAJ7JINJgBMGAM2SxIFOheFhVieBlAAbOhSq5eGmYnRFojUCkvSF9qaAtQOiwKRD5QeGRQeixnEQAjOlgsBwZkazSMOkRzaF8kaEIAR0gsL3cUigA6QRdiTMSvL3DYFjY0UjI1DS1VZBp9KglQ9GxcAh7EKgArAEVomiMO0AAJPgYN2ISADyxmDh9QUtAdvaMe-IJQYvi3D3KGeCMHBi1hoLFAABE6NZVrxBgAVQFOABc3UQt1m8FAABJQCCwQAiTZNPhGfEAbm6IhO9AA5FQdFcbncGMUHmUPAxniTiOQUYIsQAKfEAYmgkkQ+G4KGg+IAlB1YH4hbksLB9PhQTALPiVPj6Nr5RUJRh4AKAMwABgt8us2ToZGgAoATFbZRSemQyiZINQLPEsKALMhMewOd5cAwsLlkBI6CpvTSBqBHHQegGvKhCK0KCGytYYAhpZ1QHCNFQuDw+AIqIkKOF0j16BxQRZILAzmhxFJZPJFIdSwxDOFzulQHpDMmzKmRN7qF5VFgjFR6PAzGgwxQbiVcpsCvAuj1qWd6Wg6NdbvdxpNNJ45IlePTljg8PUeuN+xVQEPQCOMthYxcpiBLiBZIOw6g3j0hh0BwVDwDQqr6GyP7QIEYpeMm8DcHGsT+mgyA7nu16YD0Z4cMgjhwZ+V4eNwP70vOi7LnQq78E4B7DNAOa+hYcIzAAcpAzD5DQVAALygAKOa0JiEkAIyyqAYkAHygAA3oIoDeCxoBoBJ0k0PA7paZx3FYBwiBKepmlaaAIhkBedDBKhCSqp4+ZwGBAhoN65jjDZWnZBYAq4LASK6UJIlWQp1m2bZaAA |
1. Go to C:\laragon\bin\mysql\mysql-8.0.30-winx64 | |
2. Execute bin\mysqld.exe --initialize-insecure --console | |
[ | |
initialize-insecure => creates root user without password | |
console => outputs information to current terminal. without it, they may end up in mysqld.log | |
] |
#!/usr/bin/env php | |
<?php | |
function ask(string $question, string $default = ''): string { | |
$answer = readline($question . ($default ? " ({$default})" : null) . ': '); | |
if (! $answer) { | |
return $default; | |
} |
<?php | |
include_once('../../db.php'); | |
// SET 1 | |
$sql = 'SELECT * FROM users'; | |
$stmt = $userConn->query($sql); | |
$users = $stmt->fetch(); // by default, the argument in the bracket is PDO:FETCH_BOTH | |
echo '<pre>',print_r($users),'</pre>'; |
<?php | |
//Create connection | |
$db = new PDO('mysql:host=localhost;dbname=DATABASENAME;charset=utf8mb4', 'USERNAME', 'PASSWORD'); | |
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);//https://www.php.net/manual/en/pdo.setattribute.php | |
//Check connection status | |
echo $db->getAttribute(PDO::ATTR_CONNECTION_STATUS); | |
//SELECT with loop | |
$select = $db->prepare("SELECT `col`, `col2` FROM `table`"); |
<?php | |
$host = 'localhost'; | |
$user = 'root'; | |
$password = '123456'; | |
$dbname = 'pdoposts'; | |
// Set DSN | |
$dsn = 'mysql:host='. $host .';dbname='. $dbname; | |
// Create a PDO instance |