最受欢迎

sql server - Php错误信息"未捕获的exception '查询失败:Array"

sql server - Php Error Message " Uncaught exception 'Exception' with message 'Query Failed:Array"

本文关键字：quot exception Array 失败 查询 server Php 错误 sql 信息 | 更新日期: 2023-09-26

我试图渲染一个表从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为resource, null在C:'Users'Adam'Desktop'SimpleUsers MSSQL'Useraccess.php第26行

注意:数组到字符串的转换在C:'Users'Adam'Desktop'SimpleUsers MSSQL'Useraccess.php第29行

致命错误:未捕获异常' exception '伴有消息'Query Failed:Array'在C:'Users'Adam'Desktop'SimpleUsers MSSQL'Useraccess.php:29堆栈跟踪:#0 C:'Users'Adam'Desktop'SimpleUsers MSSQL'Useraccess.php(8): SimpleUsers->getUsers() #1 {main}在C:'Users'Adam'Desktop'SimpleUsers MSSQL'Useraccess.php中抛出

您的conn class属性未设置。

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

尝试添加结构:

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

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 $conn=$GLOBALS["conn"] ;
               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"]);
$GLOBALS["conn"] = sqlsrv_connect($GLOBALS["serverName"], $GLOBALS["connectionInfo"]  );
?> 


I have these two items in my php.ini file enabled:
extension=php_pdo_sqlsrv_53_ts.dll
extension=php_sqlsrv_53_ts.dll
Which is what I had before. Using Wamp Server. PHP 5.3.13 all the same as before. What else am I missing that is not allowing this to connect to the SQL server.
After connection file code.
<?php
$GLOBALS["serverName"] = "localhost";  
$GLOBALS["database"] = "SimpleUsers";  
$GLOBALS["uid"] = "root";
$GLOBALS["pwd"] = "";  
$GLOBALS["connectionInfo"] = array(
                                "Database"=>$GLOBALS["database"],
                                "UID"=>$GLOBALS["uid"],
                                "PWD"=>$GLOBALS["pwd"]);
$conn = sqlsrv_connect($GLOBALS["serverName"], $GLOBALS["connectionInfo"]);
?>
相关文章：
最新更新
www.56WenDa.com 2012-2023 | php问答网 | php学习