需要示例在PHP中绑定LIKE DB2语句

$sql = \"SELECT * FROM foo WHERE user = ? AND order LIKE ?%\"
$stmt = db2_prepare($conn, $sql);

db2_bind_param($stmt, 1, \"userName\", DB2_PARAM_IN);
db2_bind_param($stmt, 2, \"orderNum\", DB2_PARAM_IN);

db2_execute($stmt);

$sql = \"SELECT * FROM foo WHERE user = ? AND order LIKE ?\"

$orderNum = \'%\' . $your_order_num . \'%\';
db2_bind_param($stmt, 2, \"orderNum\", DB2_PARAM_IN);