Question

I m trying to create a function to return all of the users in a database as an array. When I print_r the users, I m getting a multi-dimensional array returned:

注

Array ( [0] => Array ( [0] => Albers [1] => Abbings [2] => Blaine [3]

Code:

   <?php
        session_start();
        function getActiveUsers() {
            $con = mysql_connect("-","-","-");
            if (!$con)
              {
              die( Could not connect:   . mysql_error());
              }
            else {
                // connected to database successfully
            }
            mysql_select_db("casemanagers", $con);
            $result = mysql_query( select * from users );
            $arr = array();
            while($row= mysql_fetch_assoc($result)){
                $arr[] = $row[ Name ];
            }
            return array ($arr);
        }

        $row = array();
        $row = getActiveUsers();
        print_r($row);

    ?>

谁能告诉我,为什么发生这种情况,或者我可以采取哪些步骤来解决这个问题? 感谢。

Answer 1

该表的回归线是:您应退还而不是-array($arr)。

您为创建新阵列而做的是$arr。它是唯一的内容。

Answer 2

这是因为:

return array ($arr);

只是:

return $arr;

Answer 3

为此:

<?php
    session_start();
    function getActiveUsers() {
        $con = mysql_connect("-","-","-");
        if (!$con)
          {
          die( Could not connect:   . mysql_error());
          }
        else {
            // connected to database successfully
        }
        mysql_select_db("casemanagers", $con);
        $result = mysql_query( select * from users );
        $arr = array();
        while($row= mysql_fetch_array($result)){ //<-- use array instead of assoc
            $arr[] = $row[ Name ];
        }
        return $arr; //<-- just return the array, nothing outside it
    }

    $row = array();
    $row = getActiveUsers();
    print_r($row);

?>

友情链接