实现从数据库中的数组 [英] making an array from database

问题描述

我要疯了这个问题，我想用逗号（串），如例如分离的数组：从数据库（1,2,4,6），并插入此像一个查询中的变量（从表中选择其中id IN（$变量字符串）。谁能帮助我？

I'm going crazy with this issue, I want to get an array separated by commas(string) like example:(1,2,4,6) from a database and insert this as a variable inside a query like(select from table where id IN($variable string). Can anyone help me with this?

例如：

<?php
//connect
$sql = "select id from users where id=1";
//get the results as an array

插入此查询里面的那个变量

insert that variable inside this query

select from table where id IN($variable);
//
?>

我试过多种方式，总是有不同的问题。请需要一个答案！

i tried multiple ways and always have different issues. Please need an answer!

推荐答案

破灭（）变换数组到由您选择的字符分隔值的字符串：

implode()transforms an array into a string of values separated by the char you choose:

$arr = array(1,2,3,4,5,6,7,8,9); // make an array
$list = implode(',',$arr);
$sql = "SELECT * FROM table WHERE id IN($list)";

这篇关于实现从数据库中的数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！