What are some common methods for outputting data from a database in PHP?

One common method for outputting data from a database in PHP is to use the MySQLi extension to connect to the database, execute a query, and fetch the results. Another method is to use PDO (PHP Data Objects) which provides a data-access abstraction layer, allowing for more flexibility when working with different types of databases. Additionally, you can use frameworks like Laravel or CodeIgniter which provide built-in functions for database operations. 

// Using MySQLi extension
$connection = mysqli_connect("localhost", "username", "password", "database");
$query = "SELECT * FROM table";
$result = mysqli_query($connection, $query);

while ($row = mysqli_fetch_assoc($result)) {
    echo $row['column_name'] . "<br>";
}

mysqli_close($connection);
```

```php
// Using PDO
$dsn = "mysql:host=localhost;dbname=database";
$username = "username";
$password = "password";

try {
    $pdo = new PDO($dsn, $username, $password);
    $statement = $pdo->query("SELECT * FROM table");

    while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
        echo $row['column_name'] . "<br>";
    }
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

Keywords

SQL MySQL PDO fetch result set

Related Questions