douyue3800 2011-06-27 15:02
浏览 200
已采纳

从mysql表创建一个数组

I am trying to create an automated log in system with cakePHP and need a bit of help working out how to get an array of possible log ins. At the moment I have this code, which means I have to manually add in the log in details each time a new user is needed:

$this->Security->loginUsers = array(
    'user1' => 'password1',
    'user2' => 'password2'
);

I have a mysql table called 'operators' which looks like this:

**Username     Password**
 user1      password1
 user2      password2
 user3      password3

etc. and this is automatically populated from a registration form. Could someone please tell me how I would turn the table into an array like the one above so that I can use it in the cakePHP code?

Thanks for any help

Edit: This is the code I have now but it doesn't work

    $test = mysql_query("SELECT * FROM operators");

    while($row = mysql_fetch_array($test))

    {

    $array = "'".$row['username']."' => '".$row['password']."'";


    }

$this->Security->loginUsers = $array;
  • 写回答

4条回答 默认 最新

  • dtlygweb2017 2011-06-27 19:08
    关注

    Try this:

       $test = mysql_query("SELECT * FROM operators");
    
        $users = array();
        while($row = mysql_fetch_array($test))
        {
            $users[ $row['username'] ] = $row['password'];
        }
    
        $this->Security->loginUsers = $users;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?

悬赏问题

  • ¥15 MATLAB卫星二体模型仿真
  • ¥15 怎么让数码管亮的同时让led执行流水灯代码
  • ¥20 SAP HANA SQL Script 。如何判断字段值包含某个字符串
  • ¥85 cmd批处理参数如果含有双引号,该如何传入?
  • ¥15 fx2n系列plc的自控成型机模拟
  • ¥15 时间序列LSTM模型归回预测代码问题
  • ¥50 使用CUDA如何高效的做并行化处理,是否可以多个分段同时进行匹配计算处理?目前数据传输速度有些慢,如何提高速度,使用gdrcopy是否可行?请给出具体意见。
  • ¥15 基于STM32,电机驱动模块为L298N,四路运放电磁传感器,三轮智能小车电磁组电磁循迹(两个电机,一个万向轮),如何通过环岛的原理及完整代码
  • ¥20 机器学习或深度学习问题?困扰了我一个世纪,晚来天欲雪,能饮一杯无?
  • ¥15 c语言数据结构高铁订票系统