ERROR for DataTables *HELP*
ERROR for DataTables *HELP*
Leon MATATA
Posts: 2Questions: 2Answers: 0
<?php
session_start();
include('database.php');
include('header.php');
include('NavBar.php');
<?php
>
?>
<body>
<div class="modal fade" id="addadminprofile" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Add Product</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<form action="code.php" method="POST" enctype="multipart/form-data">
<div class="modal-body">
<div class="form-group">
<label>Product Name</label>
<input type="text" name="product_name" class="form-control" placeholder="Enter Product Name" required>
</div>
<?php
$category = "SELECT * FROM category";
$cate_run = mysqli_query($connection, $category);
if (mysqli_num_rows($cate_run)) {
?>
<div class="form-group">
<label>Category</label>
<select name="category_id" class="form-control" required>
<option value="">Choose Category</option>
<?php
foreach ($cate_run as $row) {
?>
<option value="<?php echo $row['category_id']; ?>">
<?php echo $row['category_name']; ?>
</option>
<?php
}
?>
</select>
</div>
<?php
} else {
echo "No Data Available";
}
?>
<div class="form-group">
<label>Product Description</label>
<input type="text" name="product_desc" class="form-control" placeholder="Enter Product Description">
</div>
<div class="form-group">
<label for="file">Choose Image:</label>
<input type="file" class="form-control-file" id="file" name="product_image" required>
</div>
<div class="form-group">
<label>Price</label>
<input type="text" name="price" class="form-control" placeholder="Enter Price" required>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" name="productbtn" class="btn btn-primary">Save</button>
</div>
</div>
</form>
</div>
</div>
</div>
<div id="layoutSidenav_content">
<div class="card shadow mb-4">
<div class="card-header py-3">
<div class="button-container">
<button type="button" class="btn btn-primary mt-5" data-toggle="modal" data-target="#addadminprofile">
Add Product
</button>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<?php
$connection = mysqli_connect("localhost", "root", "", "adminpanel");
$sql = "SELECT p.*, c.category_name FROM product p INNER JOIN category c ON p.category_id = c.category_id";
$result = mysqli_query($connection, $sql);
if (mysqli_num_rows($result) > 0) {
?>
<table id="myTable" class="table table-bordered" width="100%" cellspacing="0%">
<thead>
<tr>
<th>ID</th>
<th>Product Name</th>
<th>Category</th>
<th>Product Description</th>
<th>Product Image</th>
<th>Price</th>
<th>Uploaded Date</th>
<th colspan=2 style="text-align:center">Action</th>
</tr>
</thead>
<tbody>
<?php
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td><?php echo $row['product_id']; ?></td>
<td><?php echo $row['product_name']; ?></td>
<td><?php echo $row['category_name']; ?></td>
<td><?php echo $row['product_desc']; ?></td>
<td><?php echo '<center>and this is my header
<!DOCTYPE html>
<html lang="en">
<head>
<title>HappyTalk Administration</title>
<link rel="icon" href="logo/logo.ico" type="image/x-icon">
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Boxicons -->
<link href='https://unpkg.com/boxicons@2.0.9/css/boxicons.min.css' rel='stylesheet'>
<!-- My CSS -->
<link rel="stylesheet" href="style.css">
<link rel="stylesheet" href="styles.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.4/css/dataTables.bootstrap5.min.css" />
<!-- jQuery -->
<script defer src="https://code.jquery.com/jquery-3.7.0.js"></script>
<!-- Bootstrap JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>
</head>
How to solve this error ?
Edited by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide
Answers
That suggests you are loading whatever
util.jsbefore jQuery.If you link to a page showing the issue I can say a bit more clearly what is going on.
Allan