$db = mysqli_connect('localhost', 'username', 'password', 'dbname'); $query = "SELECT * FROM users"; $result = mysqli_query($db, $query); while ($row = mysqli_fetch_assoc($result)) { echo "Name: " . $row["name"]. " Email: " . $row["email"]. "
"; }
$db = new PDO("pgsql:host=localhost;dbname=mydb", "username", "password"); $query = "SELECT * FROM products"; $result = $db->query($query); foreach ($result as $row) { echo "Product: " . $row["name"]. " Price: $" . $row["price"]. "This code connects to a PostgreSQL database using the PDO library, executes a SELECT query to retrieve all the products, and then uses a foreach loop to extract each row of data one at a time and print it to the screen. Package library: PHP PDO extension
"; }