LoginSignup
1
1

More than 5 years have passed since last update.

配列をカンマ区切りにしてSQLのIN() に入れたい時に便利なquoteInto()

Posted at

こんなときは、 ZendFramework の quoteInto()が便利です。


$id = array(5, 7, 12, 18);

上記IDのIDの情報を取得したいときは、


$include = $db->quoteInto('AND id IN (?)', $id));
$old = 10;
$query = "
         SELECT
            *
         FROM user 
         WHERE old >= ?
               {$include}
         ";

$user = $db->fetchAll($query, array($old));
1
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
1