我无法编辑我的用户数据

Question

我尝试编辑/更新我的数据表单，但是当我点击“编辑”按钮时它不会改变任何内容，我不知道发生了什么，输出说

Fatal error: Uncaught Error: Call to a member function query() on null in C:\xampp\htdocs\Admin\requestform5.php:24 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Admin\requestform5.php on line 24

编码

<?php 
include "errorReporting.php"; 
include "conn.php"; 
$conn = connect(); 
$db = connectdb(); 

$wardID = $_REQUEST["wardID"]; 
$RequestName = $_REQUEST["RequestName"]; 
$Department =$_REQUEST["Department"]; 
$Position =$_REQUEST["Position"]; 
$Date=$_REQUEST["Date"]; 

$TypeOfRequest=$_REQUEST["TypeOfRequest"]; 
$PleaseSpecify=$_REQUEST["PleaseSpecify"]; 
$DateRequire= $_REQUEST["DateRequire"]; 
$DateReturn= $_REQUEST["DateReturn"]; 

mysqli_select_db ($conn,"admin") or die ($conn->error ."\n"); 
$query = "select*from requestform"; 
$result= $conn->query($query) or die ($conn->error."\n"); 
$row_result =mysqli_fetch_assoc($result); 

mysqli_select_db ($conn,"admin") or die ($conn->error."\n"); 
$mysqli->query("UPDATE requestform SET RequestName='$RequestName',Department='$Department',Position='$Position',Date='$Date',TypeOfRequest='$TypeOfRequest',PleaseSpecify='$PleaseSpecify',DateRequire='$DateRequire',DateReturn='$DateReturn' where wardID='$wardID'"); 
$mysqli->affected_rows or die ($conn->error()."\n"); 


header("Location:requestform3.php");?> 

Answer 1

查询的主要问题是

$query = "select*from requestform"; 

改变这个

mysqli_select_db ($conn,"admin") or die ($conn->error ."\n"); 
$query = "select * from requestform"; 
$result= $conn->query($query) or die ($conn->error."\n"); 
$row_result =mysqli_fetch_assoc($result); 

$conn->query("UPDATE requestform SET RequestName='$RequestName',Department='$Department',Position='$Position',Date='$Date',TypeOfRequest='$TypeOfRequest',PleaseSpecify='$PleaseSpecify',DateRequire='$DateRequire',DateReturn='$DateReturn' where wardID='$wardID'"); 
$conn->affected_rows or die ($conn->error()."\n"); 

Answer 2

问题是在这里排队的

$ mysqli->查询（“UPDATE requestform SET RequestName = '$ RequestName'，系= '$系'，位置= '$位置' 第24号，Date ='$ Date'，TypeOfRequest ='$ TypeOfRequest'，PleaseSpecify ='$ PleaseSpecify'，DateRequire ='$ DateRequire'，DateReturn ='$ DateReturn'where wardID ='$ wardID'“）; $ mysqli-> affected_rows或die（$ conn-> error（）。“\ n”）;

这个$ mysqli从哪里来的？这是一个对象吗？我无法在任何地方看到这个对象。你确实有$ conn对象。

只是改变$ mysqli->查询到$ conn->查询