hi I used this code for a search system with multiple filters, the connection is successful but now data or errors are displaying. i can’t understand what’s happening. Please help me. Thanks
Serach Rubrics
Search Rubrics
<div class="input-group flex-nowrap">
<input type="text" class="form-control" name="name" placeholder="Rubric" aria-label="Username" aria-describedby="addon-wrapping">
</div>
</div>
<input class="form-control mt-3" name="chapter" list="datalistOptions" id="chapter" placeholder="Chapter">
<datalist id="datalistOptions">
<option value="Mind">
<option value="Skin">
<option value="Gene">
<option value="Extremities">
<option value="Rectum">
</datalist>
<input class="form-control mt-3" name="category" list="datalistOptions" id="category" placeholder="Category">
<datalist id="datalistOptions">
<option value="Emotions">
<option value="Alternate">
<option value="External">
<option value="Emaciation">
<option value="Itching">
<option value="Anus">
<option value="Constipation">
</datalist>
<div class="d-grid gap-2 col-6 mx-auto mt-3">
<button class="btn btn-primary" name="submit" type="button">Search</button>
</div>
</form>
</div>
</div>
<div id="row">
<table class="table table-striped table-hover">
<thead>
<tr>
<td>Rubric Name</td>
<td>Chapter</td>
<td>Category</td>
<td>Created</td>
</tr>
</thead>
</table>
<tbody>
<?php
include("inc/asses/conn.php");
if(isset($_POST['submit'])){
$name = real_escape_string($POST['name']);
$chapter = real_escape_string($POST['chapter']);
$category = real_escape_string($POST['category']);
if($name != "" || chapter != "" || $category != ""){
echo $query = "SELECT * FROM rubrics WHERE name = '$name' OR chapter = '$chapter' OR category = '$category'";
exit();
$data = mysqli_query($conn, $query) or die('error');
if(mysqli_num_rows($data) > 0){
while($row = mysqli_fetch_assoc($data)){
$name = $row['name'];
$chapter = $row['chapter'];
$category = $row['category'];
?>
<tr>
<td><?php echo $name; ?></td>
<td><?php echo $chapter; ?></td>
<td><?php echo $category; ?></td>
</tr>
<?php
}
}else{
?>
<tr>
<td>Not found!</td>
</tr>
<?php
}
}
}
?>
<script type="text/javascript" src="inc/js/bootstrap.js"></script>
<script type="text/javascript" src="inc/js/jquery-3.6.0.min.js"></script>
<script type="text/javascript" src="inc/js/jquery-ui.js"></script>