What are the best practices for handling MySQL queries in PHP functions to ensure the results are accessible in the calling page?

When handling MySQL queries in PHP functions, it's important to properly fetch and return the results so that they can be accessed in the calling page. One way to achieve this is by storing the query results in an array or object and returning that data from the function. By doing so, the results can be easily accessed and manipulated outside of the function. 

function fetchDataFromDatabase() {
    $connection = mysqli_connect("localhost", "username", "password", "database");

    $query = "SELECT * FROM table";
    $result = mysqli_query($connection, $query);

    $data = array();
    while ($row = mysqli_fetch_assoc($result)) {
        $data[] = $row;
    }

    mysqli_close($connection);

    return $data;
}

$data = fetchDataFromDatabase();
foreach ($data as $row) {
    echo $row['column_name'] . "<br>";
}

Keywords

MySQL queries PHP functions results accessibility calling page error handling

Related Questions