$result = mysqli_query($conn, "SELECT * FROM users"); while ($row = mysqli_fetch_assoc($result)) { echo $row["name"] . " is " . $row["age"] . " years old."; }
$result = mysqli_query($conn, "SELECT * FROM products"); $data = array(); while ($row = mysqli_fetch_assoc($result)) { $data[] = $row; } print_r($data);
$product_id = $_GET['id']; $sql = "SELECT * FROM products WHERE id = $product_id"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { $row = mysqli_fetch_assoc($result); echo $row["name"] . " costs $" . $row["price"]; } else { echo "Product not found."; }This example showcases how to use `fetch_assoc` to retrieve a single row of data based on a specific condition, in this case, the product ID. Package Library: MySQLi extension In conclusion, `fetch_assoc` function is commonly used in PHP with the MySQLi extension, which provides a collection of functions that allow PHP developers to interact with MySQL databases.