...
| Excerpt |
|---|
Heredoc is one of the useful solution to secure better readability when we code SQL Query in PHP |
Below is an example using Heredoc for SQL Query in PHP
| Code Block |
|---|
$sql = <<<SQL
select *
from class
where grade>5
SQL; |
Below is another example using Heredoc with variables for SQL Query in PHP
| Code Block |
|---|
$sql = <<<SQL insert into celebrity( id, name, gender, year, month, day, hour, lunar, img, thumbnail, created_at, updated_at, active) values('{$id}', '{$name}', '{$gender}', {$yy}, {$mm}, {$dd}, {$hh}, '{$lunar}', '{$new_img_filename}', '{$new_thumbnail_filename}', '{$now}', '{$now}', true) SQL; |
...