<?php
$array = array('new','used');
$placeholder = implode( ',', array_fill( 0, count( $array ), '?' ) );
$sql = 'select p.name,p.image from product p where p.condition in (' . $placeholder . ')';
echo $sql;
- Output for 5.6.38 - 5.6.40, 7.0.33, 7.1.25 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.26, 8.4.1 - 8.4.13
- select p.name,p.image from product p where p.condition in (?,?)
preferences:
146.1 ms | 408 KiB | 5 Q