How can data be stored in text files or databases in PHP for future retrieval?

To store data in text files in PHP for future retrieval, you can use file handling functions like fopen, fwrite, and fclose to write data to a text file. For databases, you can use PHP Data Objects (PDO) or MySQLi to connect to a database and execute SQL queries to insert data into tables. 

// Storing data in a text file
$data = "Hello, this is some data to be stored in a text file.";
$file = fopen("data.txt", "w");
fwrite($file, $data);
fclose($file);

// Storing data in a MySQL database
$pdo = new PDO("mysql:host=localhost;dbname=mydatabase", "username", "password");
$stmt = $pdo->prepare("INSERT INTO mytable (data) VALUES (:data)");
$data = "Hello, this is some data to be stored in a database.";
$stmt->bindParam(':data', $data);
$stmt->execute();

Keywords

file handling database management data storage retrieval PHP functions

Related Questions