What are the advantages and disadvantages of storing data in a text file versus a database in PHP?

Storing data in a text file in PHP can be simpler and quicker for small amounts of data, but it can become inefficient and difficult to manage as the data grows. On the other hand, using a database in PHP allows for better organization, indexing, and querying of data, but it requires more setup and maintenance. 

// Storing data in a text file
$file = 'data.txt';
$data = "John,Doe,30\n";

file_put_contents($file, $data, FILE_APPEND);

// Retrieving data from a text file
$contents = file_get_contents($file);
echo $contents;

// Storing data in a database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

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

$sql = "INSERT INTO users (firstname, lastname, age) VALUES ('John', 'Doe', 30)";
$conn->query($sql);

// Retrieving data from a database
$sql = "SELECT * FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Name: " . $row["firstname"] . " " . $row["lastname"] . ", Age: " . $row["age"] . "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();

Keywords

text file database PHP file handling SQL

Related Questions