目前我正在为一个网站创建一个新闻部分。
我创建了它,以便新闻类型由字符串分隔。例如,category=,2,4,6,
我通常不会经常使用字符串,我最初的想法是这样做:
$query_listelements = "SELECT * FROM newsitems WHERE released = 1 AND (category = 2 OR category = 4 OR category = 6) ORDER BY date_rel DESC";
很明显,这不起作用,因为我需要隔离/扩展字符串。所以它需要类似于:
$query_listelements = "SELECT * FROM newsitems WHERE released = 1 AND (category = strval(",2,") OR category = strval(",4,") OR category = strval(",6,")) ORDER BY date_rel DESC";
我也不认为以上是解决问题的正确方法。
任何想法都会受到重视!
你可以像下面这样使用它,听起来更好。
$category= array ( 2, 4, 6);
$category = implode(',', $category); //Now it is a string like '2,4,6'
$query_listelements = "SELECT * FROM newsitems WHERE released = 1 AND (category IN ($category)) ORDER BY date_rel DESC";