cars.php

<!DOCTYPE html>
<html>

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Cars</title>
    <link rel="stylesheet" href="css/pacific.css">

</head>

<body id="wrapper">
    <header>
        <h1>RentAll </h1>
    </header>

    <div class="row">

        <div class="column-left">

            <nav>
                <ul>
                    <li><a href="index.html">Home</a></li>
                    <li><a href="cars.php">Cars</a></li>
                    <li><a href="owners.php">Owners</a></li>
                    <li><a href="current.php">Current Rentals</a></li>
                    <li><a href="add.php">Add a Car</a></li>
                    <li><a href="reservations.php">Rent out</a></li>
                    <li><a href="myreservations.php">Check Reservations</a></li>
                    <li><a href="update.php">Update Car</a></li>
                    <li><a href="check.php">Check Earnings</a></li>


                </ul>
            </nav>

        </div>

        <div class="column-right">

            <img id="coast" src="images/bug.jpg" height="300px;" width="100%" />
            <section>
                <h2>Cars Available</h2>


                <?php 
                $connection = mysqli_connect('localhost', 'root', ''); //The Blank string is the password
                mysqli_select_db($connection,'rental _company');

                $query = "SELECT * FROM cars"; //You don't need a ; like you do in SQL
                $result = mysqli_query($connection,$query);
                
                
                echo "<table>"; // start a table tag in the HTML
                echo "    <tr>
                            <th>Car ID</th>
                            <th>Model</th>
                            <th>Type</th>
                            <th>D_Rate</th>
                            <th>W_Rate</th>
                            <th>Year</th>
                          </tr>";
                while($row = mysqli_fetch_array($result))
                {   //Creates a loop to loop through results
                echo "<tr><td>" . $row['V_ID'] . "</td><td>" . $row['MODEL'] . "</td><td>" . $row['TYPE'] . "</td><td>" ."$". $row['D_RATE'] . "</td><td>" . "$".$row['W_RATE'] . "</td><td>" . $row['YEAR'] . "</td></tr>";  //$row['index'] the index here is a field name
                }

                echo "</table>"; //Close the table in HTML

                mysqli_close($connection);
                ?>

            </section>
            <br /><br />
            <footer>
                <br />

            </footer>

        </div>

    </div>


    <!--The Footer-->

</body>

</html>