我从数据库中取出数据,写入数组中,怎么做? $sql = "SELECT buys, sells, volume, date from amount where commodities = $comm_code AND broker = 1 \
order by date desc limit 10"; $res = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli)); $row_num = mysqli_num_rows($res);
if(!$row_num)
{
}
else
{
$array_1 = array();
$array_2 = array();
while($res_row = mysqli_fetch_array($res))
{
}
}
order by date desc limit 10"; $res = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli)); $row_num = mysqli_num_rows($res);
if(!$row_num)
{
}
else
{
$array_1 = array();
$array_2 = array();
while($res_row = mysqli_fetch_array($res))
{
}
}
if(!$res) return "";
if(mysql_num_rows($res)==0) return "";
while($row=mysql_fetch_assoc($res))
{
$data[]=$row;
}
return($data);
$sql = "SELECT buys, sells, volume, date from amount where commodities = $comm_code AND broker = 1 \
order by date desc limit 10"; $res = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli)); $row_num = mysqli_num_rows($res);
if(!$row_num)
{
}
else
{
while($res_row = mysqli_fetch_array($res))
{
$new_array[]=$res_row;
}
}
然后你打印一下数组,查看一下.
echo '<pre>';
print_r($new_array);
echo '</pre>';
$res = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli)); $row_num = mysqli_num_rows($res);
if(!$row_num)
{
}
else
{
while($res_row = mysqli_fetch_array($res))
{
$new_array[]=$res_row;
}
} // free mysql results
mysqli_free_result($res);
// close the cnnection to mysql
mysqli_close($mysqli);