SQL结果中的PHP数组 [英] Php array from sql result
本文介绍了SQL结果中的PHP数组的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何从结果创建数组?我想在mysql IN()查询中使用数组.
How can i create an array from the result? I would like to use the array in a mysql IN() query.
//$array = array();
$get_subscategoria = mysqli_query($kapcs, "SELECT kat_id FROM termek_kategoria WHERE kat_parent = '$id'");
if(mysqli_num_rows($get_subscategoria) > 0 )
{
while($sub_kat = mysqli_fetch_array($get_subscategoria))
{
echo $sub_kat['kat_id'];
//$array[] = $sub_kat;
}
}
//print_r( $array );
现在,此代码将返回4行ID,可以正常工作.我想要一个具有这些ID的数组,例如1,2,3,4.
Now, this code gives back 4 row ID, that works okay. I would like an array with these ID-s, like 1,2,3,4.
推荐答案
while($sub_kat = mysqli_fetch_array($get_subscategoria))
{
$array[] = $sub_kat['kat_id'];
}
echo implode(",",$array);
它给出的结果是1,2,3,4
it give a result like 1,2,3,4
这篇关于SQL结果中的PHP数组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文