从MySQL在PHP中创建数组 [英] Create array in PHP from mysql

问题描述

我认为我可能已经尝试了一些睡眠不足的尝试，但是在从mysql查询创建数组时遇到了问题.我有这样的查询:

I think that I may be over trying things with little sleep but I am having problems creating arrays from mysql queries. I have a query like so:

$result = mysqli_query($con,"SELECT * FROM vehicles ORDER BY id");
while($row = mysqli_fetch_array($result)) {
    $description = $row['description'];
    $description = strtoupper($description);
    $id = $row['id'];
}

我希望它像这样创建一个数组:

I want it to create an array like so:

$v[1] = "Myarray1";

我已经尝试过了，但是没有用:

I have tried this but it does not work:

$v[ $row['id']] = $row;

我必须这样查询吗?

while( $row = mysql_fetch_assoc( $result)){}

如果可以的话，如何根据需要创建数组?

and if I do, how I do create the array as I need it?

非常感谢

推荐答案

您根本不会在此处创建数组.在您的循环中，您只是在修改一些您无法发布的上下文中的变量.

At no point are you creating an array here. In your loop you are simply modifying some variables that in the context you posted I cannot reason on.

如果需要的话，将不会进行任何数据过滤:

If all you need, no data filtering whatsoever this will do:

$list = Array();
while( $row = mysqli_fetch_array($result) ) {
   $list[] = $row;
}

[]基本上在PHP中附加"，这是一个丑陋的机制，但有效.

[] basically 'appends' in PHP, it is an ugly mechanism but it works.

如果要访问每个主键的行(我认为是id)，则只需将[]替换为[$row["id"]]

If you want to access rows per primary key ( id in your case I think ) then simply replace [] with [$row["id"]]

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