Trying to connect database where you can add/delete/update records for a bookstore, when opening webpage the data base does not load with the webpage this is the code for my view.php
<?php
// connect to the database
include('connect-db.php');
// get results from database
$query = "SELECT * FROM Product;";
$result = mysqli_query($conn, $query); #or die(mysqli_error());
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
echo "<tr>";
echo '<td>' . $row['id'] . '</td>';
echo '<td>' . $row['product_Name'] . '</td>';
echo '<td>' . $row['description'] . '</td>';
echo '<td>' . $row['price'] . '</td>';
echo '<td>' . $row['stock'] . '</td>';
echo '<td><a href="edit.php?id=' . $row['id'] . '">Edit</a></td>';
echo '<td><a href="delete.php?id=' . $row['id'] . '">Delete</a></td>';
echo "</tr>";
}
}
Code for connect-db:
<?php
$servername = "127.0.0.1";
$username = "s4917077";
$password = "0e671ada8c93cd0784960c31e58686f";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>