php - Filling boostrap cards with data from a mySQL database

one text

Solution:

You have a function getData() that has "$this->table". Dont copy paste the codes without understanding what it does.

Clean up your connectDB.php:

<?php
    //Create a database connection
    $dbhost     = "localhost";
    $dbuser     = "root";
    $dbpassword = "";
    $dbname     = "g00398295";

    $connection = mysqli_connect($dbhost, $dbuser, $dbpassword, $dbname);
        
    //Test if connection occoured
    if(mysqli_connect_errno()){
        die("DB connection failed: " .
            mysqli_connect_error() .
            " (" . mysqli_connect_errno() . ")"
        );
    }
?>

In project.php:

<div class = "row text-center py-5">
    //Definite problem here
    <?php
        $sql = "select * from Instruments where itemno = 1; ";
 
        $result = mysqli_query($connection,$sql);
        while ($row = mysqli_fetch_assoc($result)){
            component($row['InstName'], $row['Price'], $row['ProductImg'], $row['description']);
        }
    ?>  
</div>

Source