PHP错误消息“未捕获的异常'Exception'和消息'Query Failed：Array'

debugcn 发表于 Dev

用户名

我试图将表格从MS-SQL数据库呈现到网页，但出现此错误。我对PHP还是很陌生。请帮忙

Useraccess.php

 <?php


        $path = dirname(__FILE__);
        require_once(dirname(__FILE__)."/simpleusers/config.inc.php");

        $SimpleUsers = new SimpleUsers();
        $users = $SimpleUsers->getUsers();

        class SimpleUsers
        {

            private $mysqli , $stmt;
            private $conn;
            private $sessionName = "SimpleUsers";
            public $logged_in = false;
            public $userdata;
            public $uPassword;
            public $salt;


           public function getUsers()
            {
                $sql = "SELECT DISTINCT userId, uUsername, uActivity, uCreated FROM users ORDER BY uUsername ASC";

                $stmt = sqlsrv_query($this->conn, $sql);

                if( $stmt == false){
                    throw new Exception("Query Failed:".sqlsrv_errors());
                }
                $stmt->execute();
                $stmt->store_result();

                if( $stmt->num_rows == 0){
                    return array();
                }


                $users = array();
                $i = 0;

                while( $stmt->fetch() )
                {       
                    $users[$i]["userId"] = $userId;
                    $users[$i]["uUsername"] = $username;
                    $users[$i]["uActivity"] = $activity;
                    $users[$i]["uCreated"] = $created;

                    $i++;
                }
            }               
        }   
    ?>


    <html>
        <head>
            <title></title>
          <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
          <style type="text/css">

                * { margin: 0px; padding: 0px; }
                body
                {
                    padding: 30px;
                    font-family: Calibri, Verdana, "Sans Serif";
                    font-size: 12px;
                }
                table
                {
                    width: 800px;
                    margin: 0px auto;
                }

                th, td
                {
                    padding: 3px;
                }

                .right
                {
                    text-align: right;
                }

            h1
            {
                color: #FF0000;
                border-bottom: 2px solid #000000;
                margin-bottom: 15px;
            }

            p { margin: 10px 0px; }
            p.faded { color: #A0A0A0; }

          </style>

        </head>
        <body>

            <h1>User administration</h1>
            <table cellpadding="0" cellspacing="0" border="1">
                <thead>
                    <tr>
                        <th>Username</th>
                        <th>Last activity</th>
                        <th>Created</th>
                        <th></th>
                    </tr>
                </thead>
                <tfoot>
                    <tr>
                        <td colspan="4" class="right">
                            <a href="newuser.php">Create new user</a> | <a href="logout.php">Logout</a>
                        </td>
                    </tr>
                </tfoot>
                <tbody>
                    <?php foreach
                    ( $users as $user ): ?>
                    <tr>
                        <td><?php echo $user["uUsername"]; ?></td>
                        <td class="right"><?php echo $user["uActivity"]; ?></td>
                        <td class="right"><?php echo $user["uCreated"]; ?></td>
                        <td class="right"><a href="deleteuser.php?userId=<?php echo $user["userId"]; ?>">Delete</a> | <a href="userinfo.php?userId=<?php echo $user["userId"]; ?>">User info</a> | <a href="changepassword.php?userId=<?php echo $user["userId"]; ?>">Change password</a></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>

        </body>
    </html>

config.inc.php

<?php

$GLOBALS["serverName"] = "DESKTOP-KRF6KT7\SQLEXPRESS";  
$GLOBALS["database"] = "SimpleUsers";  
$GLOBALS["uid"] = "sa";  
$GLOBALS["pwd"] = "twinz0000";  
$GLOBALS["connectionInfo"] = array(
                                "Database"=>$GLOBALS["database"],
                                "UID"=>$GLOBALS["uid"],
                                "PWD"=>$GLOBALS["pwd"])

?>

显示错误

警告：sqlsrv_query（）期望参数1为资源，在第26行的C：\ Users \ Adam \ Desktop \ SimpleUsers MSSQL \ Useraccess.php中给出null

注意：第29行的C：\ Users \ Adam \ Desktop \ SimpleUsers MSSQL \ Useraccess.php中的数组到字符串的转换

致命错误：C：\ Users \ Adam \ Desktop \ SimpleUsers MSSQL \ Useraccess.php：29中未捕获消息'Query Failed：Array'的未捕获异常'Exception'堆栈跟踪：＃0 C：\ Users \ Adam \ Desktop \ SimpleUsers MSSQL \ Useraccess.php（8）：在第29行的C：\ Users \ Adam \ Desktop \ SimpleUsers MSSQL \ Useraccess.php中，抛出了SimpleUsers-> getUsers（）＃1 {main}

扬·里希特（Jan Richter）

您的conn课程属性未设置。

调用之前，$stmt = sqlsrv_query($this->conn, $sql);必须在sqlsrv_connect中进行设置。

尝试添加构造：

public function __construct()
{
    $this->conn = sqlsrv_connect($GLOBALS["serverName"], $GLOBALS["connectionInfo"]);
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。

编辑于2021-06-23

我来说两句

0条评论

登录后参与评论

来自分类Dev

Related 相关文章

文章