I tried to figure out why after submitting form, I cannot update the database. So, I excluded the sql query and test the $_POST[‘submit’] and it turns out that $_POST[‘submit’] is the problem because when i try to submit, it gives a white blank screen.
Here’s the code
<?php
$db_host = "localhost";
$db_username = "root";
$db_pass = "";
$db_name = "umsdb";
$conn = mysqli_connect($db_host,$db_username,$db_pass,$db_name)
or die("Error, cannot connect to MySQL");
session_start();
if(isset($_GET['id']))
{
$id = $_GET['id'];
if(isset($_GET['uid']))
{
$uid = $_GET['uid'];
if(isset($_GET['room']))
{
$room = $_GET['room'];
if(isset($_GET['device']))
{
$device = $_GET['device'];
?>
<!DOCTYPE html>
<html>
<head>
<title>Add Report</title>
<link rel="stylesheet" href="webstyle.css">
</head>
<body>
<main>
<div class="container2">
<form method="post" action="<?php ob_start(); echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
<div class = "form-attribute">
<label>Room: <?php echo $room; ?></label><br>
</div>
<div class = "form-attribute">
<label>Device: <?php echo $device; ?></label><br>
</div>
<div class="form-attribute">
<label for="status">Status:</label>
<select id="status" name="status">
<option>Select the status</option>
<option value="Good">Good</option>
<option value="Broken">Broken</option>
</select>
</div>
<div class="form-attribute">
<label for="cause">Cause (If status is broken):</label>
<input type="text" class="form-control" name="cause">
</div>
<input type="submit" name="submit" class="btn btn-primary">
</form>
</div>
</main>
<?php
include "errorreportall.php";
if(isset($_POST['submit']))
{
echo "Room: " . $room . "<br>
Device: " . $device . "<br>
ID: " . $id . "<br>
User ID: " . $uid;
/*$status = mysqli_real_escape_string($conn, $_POST['status']);
$cause = mysqli_real_escape_string($conn, $_POST['cause']);
$select = "SELECT * FROM report WHERE did = '$id";
$date = date("Y/m/d");
$sql= "INSERT INTO report (uid,did,R_STATUS,CAUSE,R_DATE)
VALUES ('$uid','$id','$status','$cause','$date');";
$result = mysqli_multi_query($conn, $sql);
if(!$result)
{
if(mysqli_errno($conn) == 1062)
{
echo "Please enter a different value";
}
}
else
{
header("Location:report.php");
echo "Adding successfully";
}*/
}
?>
</body>
</html>
<?php
}
}
}
}
?>
And yes, i already try ‘error_reporting()’, it is still not working.