My Final Web Portfolio

Activity 11: MySQL Database Integration

This activity demonstrates a live connection between PHP and MySQL. The records below are being pulled from the database.

Add Student Record

Database Records

View Source

$conn = new mysqli("localhost", "root", "", "vitanzos_db");

$result = $conn->query("SELECT * FROM students");

while ($row = $result->fetch_assoc()) {
    echo $row["fullname"];
}