Talan Portfolio | Web Systems Final Project

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

ID	Full Name	Course	Year Level	Email	Action
3	Colby Davis Venoya	BSIT	3rd Year	colby@example.com	Edit Delete
2	Herald John Cubero	BSIT	3rd Year	herald@example.com	Edit Delete
1	Mark Ian Galinato	BSIT	3rd Year	mark@example.com	Edit Delete

View Source

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

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

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