More than 5 years have passed since last update.

CakePHP2: queryでプレースホルダ

Posted at 2016-12-14

LIKEを使う場合にプレースホルダが効かずに悩んでいました：

ダメな例1：

ng1.php

$sql = "SELECT * FROM shops WHERE name LIKE '%?%'";
$results = $this->query($sql, array('原宿') );

ダメな例2：

ng2.php

$sql = "SELECT * FROM shops WHERE name LIKE %?%";
$results = $this->query($sql, array('原宿') );

正しい書き方：

ok.php

$sql = "SELECT * FROM shops WHERE name LIKE ?";
$results = $this->query($sql, array('原宿') );