dongshi1914 2014-11-22 18:29
浏览 17

试图创建一个简单的登录系统,非对象错误的属性

Sorry about the probably extremely stupid question but I've been messing with this for hours and still cannot get it to work.

I am trying to create a login system using a mysqli database. For some reason it will not work, i'm currently getting the property of non-object error.

Here is the code

 <?php 

  session_start();

  $db = ("obsidian");
    $mysqli = new mysqli('localhost','admin1', 'password1') or die('Failed to connect to DB' .                          $mysqli->error );

 if(isset($_POST['sub'])){ 

 $username = $_POST['username']; $password = $_POST['password'];

}

$sSQL = "select * from users where password='$password' AND username='$username'";

$rsMain = $mysqli->query( $sSQL );

  if ($rsMain->num_rows == 1)

      {

         $_SESSION['userid'] =$username; 
         header("Location: index.php"); 
      }

  else 

     {

         //ignore
     }  

   ?>

It's the checking for the rows that I'm having the issue with, I cannot figure out how to do it.

Any help would be great.

The error is Notice: Trying to get property of non-object in C:\xampp1\htdocs\ObsidianDream\login2.php on line 20

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度