怎么将数组传递给php,php – 将数组传递给存储过程

所以我得到了一个解决方法,即连接查询和参数,以便伪代码

CREATE PROCEDURE `related_stories`(IN param1 VARCHAR(255), IN param2 VARCHAR(255), IN param3 VARCHAR(255), IN publishDate INT(11), IN tlimit INT(11))

BEGIN

SET @query =CONCAT( '

select s.* from

(

select * from

(

SELECT something where condition IN (',param1,')

) as table1

UNION ALL

select * from

(

SELECT something where condition IN (',param2,')

) as table2

UNION ALL

select * from

(

SELECT something where condition IN (',param3,')

) as table3

) as s

WHERE (s.publish_date < ',publishDate,')

GROUP BY id limit ',tlimit,';');

PREPARE stmtInsert FROM @query;

EXECUTE stmtInsert;

END

param1,param2,param3是通过php传递的内爆数组,例如(‘1,2,3,4’).希望这有助于某人