What are the potential risks of manually creating arrays in PHP compared to retrieving data from a database?

When manually creating arrays in PHP, there is a risk of data inconsistency, as the arrays need to be maintained and updated manually. This can lead to errors and inconsistencies in the data. On the other hand, retrieving data from a database ensures data integrity and consistency, as the database handles data storage and retrieval. To mitigate the risks of manually creating arrays, it is recommended to store the data in a database and retrieve it dynamically when needed in PHP. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Retrieve data from the database
$sql = "SELECT * FROM table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"]. "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();

Keywords

SQL injection data validation data sanitization prepared statements database queries

Related Questions