Bind values in raw queries

PHP

Original CodeSnap example inspired by Laravel News. Source: https://laravel-news.com/eloquent-tips-tricks

PHP

CodeSnap // free canvas

Bind values in raw queries

<?php

$orders = Order::query()
    ->whereRaw(
        'total > CASE WHEN state = ? THEN ? ELSE ? END',
        ['TX', 200, 100],
    )
    ->get();

// Further reading: https://laravel-news.com/eloquent-tips-tricks

50 views Power Surge template