久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

<small id='TQDi2'></small><noframes id='TQDi2'>

    <i id='TQDi2'><tr id='TQDi2'><dt id='TQDi2'><q id='TQDi2'><span id='TQDi2'><b id='TQDi2'><form id='TQDi2'><ins id='TQDi2'></ins><ul id='TQDi2'></ul><sub id='TQDi2'></sub></form><legend id='TQDi2'></legend><bdo id='TQDi2'><pre id='TQDi2'><center id='TQDi2'></center></pre></bdo></b><th id='TQDi2'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='TQDi2'><tfoot id='TQDi2'></tfoot><dl id='TQDi2'><fieldset id='TQDi2'></fieldset></dl></div>
  1. <tfoot id='TQDi2'></tfoot>
    <legend id='TQDi2'><style id='TQDi2'><dir id='TQDi2'><q id='TQDi2'></q></dir></style></legend>

    • <bdo id='TQDi2'></bdo><ul id='TQDi2'></ul>

    1. PHP 準(zhǔn)備好的語(yǔ)句問(wèn)題

      PHP Prepared Statement Problems(PHP 準(zhǔn)備好的語(yǔ)句問(wèn)題)

            <tbody id='UpJGD'></tbody>
          • <legend id='UpJGD'><style id='UpJGD'><dir id='UpJGD'><q id='UpJGD'></q></dir></style></legend>
              <bdo id='UpJGD'></bdo><ul id='UpJGD'></ul>
              1. <tfoot id='UpJGD'></tfoot>
              2. <i id='UpJGD'><tr id='UpJGD'><dt id='UpJGD'><q id='UpJGD'><span id='UpJGD'><b id='UpJGD'><form id='UpJGD'><ins id='UpJGD'></ins><ul id='UpJGD'></ul><sub id='UpJGD'></sub></form><legend id='UpJGD'></legend><bdo id='UpJGD'><pre id='UpJGD'><center id='UpJGD'></center></pre></bdo></b><th id='UpJGD'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='UpJGD'><tfoot id='UpJGD'></tfoot><dl id='UpJGD'><fieldset id='UpJGD'></fieldset></dl></div>

                <small id='UpJGD'></small><noframes id='UpJGD'>

                本文介紹了PHP 準(zhǔn)備好的語(yǔ)句問(wèn)題的處理方法,對(duì)大家解決問(wèn)題具有一定的參考價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)吧!

                問(wèn)題描述

                慢慢習(xí)慣了 PHP 準(zhǔn)備好的語(yǔ)句,但仍然出現(xiàn)這個(gè)錯(cuò)誤

                slowly getting used to PHP prepared statements, however still get this error

                警告:mysqli_stmt::bind_result():綁定變量的數(shù)量與第 20 行 C:UsersPCDocumentsXAMPPhtdocslogin.php 中準(zhǔn)備好的語(yǔ)句中的字段數(shù)不匹配".

                "Warning: mysqli_stmt::bind_result(): Number of bind variables doesn't match number of fields in prepared statement in C:UsersPCDocumentsXAMPPhtdocslogin.php on line 20".

                 <?php
                
                 $mysqli = new mysqli('localhost', 'c3337015', 'c3337015', 'members');
                
                if (mysqli_connect_errno()) {
                    printf("Connect failed: %s
                ", mysqli_connect_error());
                    exit();
                    }
                
                 if(isset($_GET['loginEmail'])){
                
                 session_start();
                
                    $stmt = $mysqli->prepare("SELECT Email FROM members WHERE Email=? AND  Password=? LIMIT 1");
                    $email = $_GET['loginEmail'];
                    $password = $_GET['loginPassword'];
                    $password = sha1($password);
                    $stmt->bind_param('ss', $email, $password);
                    $stmt->execute();
                    $stmt->bind_result($email, $password);
                    $stmt->store_result();
                    if($stmt->num_rows == 1)  //To check if the row exists
                        {
                            while($stmt->fetch()) //fetching the contents of the row
                
                              {$_SESSION['Logged'] = 1;
                               $_SESSION['Email'] = $email;
                               header('Location: index.php');
                               exit();
                               }
                        }
                        else {
                            echo "Wrong Username or Password!";
                        }
                        $stmt->close();
                    }
                    else 
                    {   
                    echo "Something went Wrong";
                    }
                $mysqli->close();
                ?>
                

                推薦答案

                $stmt->bind_result($email, $password);
                

                您正在綁定 2 個(gè)變量,但只要求一個(gè):SELECT Email FROM members.

                You are binding 2 variables, but only asking for one: SELECT Email FROM members.

                我還建議對(duì) bind_result 使用不同的變量,因?yàn)樗?bind_param 都適用于引用.

                I'd also suggest using different variables for bind_result, as it and bind_param both work on references.

                $stmt->bind_result($userEmail);
                

                這篇關(guān)于PHP 準(zhǔn)備好的語(yǔ)句問(wèn)題的文章就介紹到這了,希望我們推薦的答案對(duì)大家有所幫助,也希望大家多多支持html5模板網(wǎng)!

                【網(wǎng)站聲明】本站部分內(nèi)容來(lái)源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問(wèn)題,如果有圖片或者內(nèi)容侵犯了您的權(quán)益,請(qǐng)聯(lián)系我們刪除處理,感謝您的支持!

                相關(guān)文檔推薦

                store_result() and get_result() in mysql returns false(mysql 中的 store_result() 和 get_result() 返回 false)
                Call to undefined function mysqli_result::num_rows()(調(diào)用未定義的函數(shù) mysqli_result::num_rows())
                mysqli_fetch_array returning only one result(mysqli_fetch_array 只返回一個(gè)結(jié)果)
                PHP MySQLi Multiple Inserts(PHP MySQLi 多次插入)
                How do I make sure that values from MySQL keep their type in PHP?(如何確保 MySQL 中的值在 PHP 中保持其類(lèi)型?)
                Fatal error: Call to undefined method mysqli::error()(致命錯(cuò)誤:調(diào)用未定義的方法 mysqli::error())
                  <legend id='c2pbI'><style id='c2pbI'><dir id='c2pbI'><q id='c2pbI'></q></dir></style></legend>

                  • <small id='c2pbI'></small><noframes id='c2pbI'>

                      • <bdo id='c2pbI'></bdo><ul id='c2pbI'></ul>

                        <i id='c2pbI'><tr id='c2pbI'><dt id='c2pbI'><q id='c2pbI'><span id='c2pbI'><b id='c2pbI'><form id='c2pbI'><ins id='c2pbI'></ins><ul id='c2pbI'></ul><sub id='c2pbI'></sub></form><legend id='c2pbI'></legend><bdo id='c2pbI'><pre id='c2pbI'><center id='c2pbI'></center></pre></bdo></b><th id='c2pbI'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='c2pbI'><tfoot id='c2pbI'></tfoot><dl id='c2pbI'><fieldset id='c2pbI'></fieldset></dl></div>
                        <tfoot id='c2pbI'></tfoot>

                            <tbody id='c2pbI'></tbody>
                          主站蜘蛛池模板: 国产成人精品一区二区 | 精品免费视频 | 黄色影视大全 | 国产91在线播放 | 日本黄色三级视频 | 在线色网站 | 亚洲av毛片| 黄色免费大片 | 亚洲成人精品 | 一区二区视频在线播放 | 天天操天天干天天 | 夜夜欢天天干 | 国产在线欧美 | 欧美日韩免费在线 | av少妇 | 日韩欧美小视频 | 老司机精品福利视频 | 乱色av | 免费国产网站 | 免费高清av| 三级av网站 | 欧美精品99久久久 | 日本国产一区 | 久久久久亚洲精品 | 亚洲激情五月 | 22精品一区二区三区 | 国产成人综合在线 | 亚洲综合在线视频 | 一区二区三区久久久 | 亚洲国产成人精品女人 | 国产一区二区在线看 | a在线免费观看 | 三级久久久 | 日韩成人综合 | 红桃视频成人 | 日韩网站免费观看 | 久久精品久久久 | 黄色毛毛片 | 在线观看免费毛片 | 午夜av在线播放 | 日本在线不卡视频 |