Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

php查询条件为一维数组

WBOY
Release： 2016-06-23 13:47:19
Original
1299 people have browsed it

PHP查询条件where id = array(1,2,3)怎么做


回复讨论(解决方案)

where id in (1,2,3)

$id = implode(',', array(1,2,3));
$sql = "....where id in ($id) ";

使用in可以 

$id = array(1,2,3);$sqlstr = "select * from table where id in(".implode(',',$id).")";
Copy after login

Related labels：
php查询条件为一维数组
source：php.cn
Previous article：linux convert命令把gif转jpg的问题 Next article：apache开启htaccess后域名访问不生效（ip访问可以）
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Using PHP, can I put a foreach statement into a transient? I'm working in WP using PHP and trying to reduce the load time of a function that fetches ...
From 2024-04-03 17:12:43
0
2
330
Eliminate rows with duplicate values ​​in column a from a table Is there a way to check if lead_id appears multiple times in the table and if so, exclude ...
From 2024-03-31 10:42:26
0
1
268
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template