douzhanbai9526 2017-07-30 07:44
浏览 62
已采纳

如何从MySQL表创建PHP数组

I have a MySQL table:

-------------------
|type_id|type_name| 
-------------------
|  22   | Toyota  |
|  22   | Mazda   |
|  23   | Volvo   |
|  23   |  Man    |
|  25   | Scania  |
|  25   | Iveco   |
|  25   | Fiat    |
-------------------

which is created dynamically from user input. I want to create an array from the table using PHP like this:

array(
    '22' => array('Toyota', 'Mazda'),
    '23' => array('Volvo', 'Man'),
    '25' => array('Scania', 'Iveco','Fiat'),
);

where array id will be type_id and elements will be type_name's of the type_id.I tried this:

$results = array();
    while($line = mysqli_fetch_array($result, MYSQL_ASSOC))
    {
    $results[] = $line;
    }   
    print_r($results);

But I am getting:

Array ( 
    [0] => Array ( 
            [type_id] => 22 
            [type_name] => Toyota
        ) 
    [1] => Array ( 
            [type_name] => 22 
            [type_name] => Mazda
        )
    ...so on

Please help!

  • 写回答

3条回答 默认 最新

  • doudong0425 2017-07-30 08:05
    关注

    You need to change your code a bit and it will work fine:-

    $results = array(); 
    while($line = mysqli_fetch_array($result, MYSQL_ASSOC)) { 
      $results[$line['type_id']][] = $line['Type_name'];  //check change here
    } 
    print_r($results);
    

    Note:- check your column-names and correct them if any mistake is there.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 java 的protected权限 ,问题在注释里
  • ¥15 这个是哪里有问题啊?
  • ¥15 关于#vue.js#的问题:修改用户信息功能图片无法回显,数据库中只存了一张图片(相关搜索:字符串)
  • ¥15 texstudio的问题,
  • ¥15 spaceclaim模型变灰色
  • ¥15 求一份华为esight平台V300R009C00SPC200这个型号的api接口文档
  • ¥15 就很莫名其妙,本来正常的Excel,突然变成了这种一格一页
  • ¥15 字符串比较代码的漏洞
  • ¥15 欧拉系统opt目录空间使用100%
  • ¥15 ul做导航栏格式不对怎么改?