未定义的变量:mysqli&;对null调用成员函数query()


Undefined variable: mysqli & call to a member function query() on null

我对mysqli有点陌生,我正在尝试在表上显示数据。

这是代码:

<tbody>
   <?php
   $query = $mysqli->query("SELECT username,password,FName,LName,userAddress FROM tbl_users");
   $no = 1;
   while($row = $query->fetch_assoc()){
   ?>
   <tr>
  <td><?php echo $no++ ?></td>
  <td><?php echo $row['username'] ?></td>
  <td><?php echo $row['password'] ?></td>
  <td><?php echo $row['FName'] .' '. $row['LName'] ?></td>
  <td><?php echo $row['userAddress'] ?></td>
  <td>
      <a href="update.php?id=<?php echo $row['userid'] ?>" class="btn btn-warning btn-sm"><span class="glyphicon glyphicon-pencil" aria-hidden="true"></span></a>
     <a onclick="return confirm('Are you sure you want to delete data')" href="delete.php?id=<?php echo $row['userid'] ?>" class="btn btn-danger btn-sm"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></a>
  </td>
  </tr>
  <?php
  }
  ?>
</tbody>

这些是错误:

未定义的变量:第205行上C:''examplep''htdocs''company''admin''user_table.php中的mysqli

致命错误:在205 行C:''examplep''htdocs''company''admin''user_table.php中的null处调用成员函数query()

未定义变量:mysqli表示您没有创建对象"mysqli"或无法获取对象mysqli;也就是说,您必须通过创建mysqli的实例来建立与MySQL服务器的连接,然后才能使用此实例向服务器发送查询。

创建对象

$mysqli = new Mysqli("host","db user","db password","db name");

//与数据库连接

对于如何检查连接是否成功建立,看见http://docs.php.net/manual/en/mysqli.construct.php。

感谢@Epodax的提醒。刚把我的配置改成$mysqli。

<?php 
$mysqli = new mysqli('localhost','root','sa','company');
if($mysqli->connect_errno){
echo "Connection Failed".$mysqli->connect_error;
}
?>