How can PHP be used to read and write data to a TXT file or a MySQL database for user registration purposes?

To read and write data to a TXT file for user registration, you can use file handling functions like fopen, fwrite, and fclose in PHP. For MySQL database, you can use PHP's MySQLi or PDO extension to connect to the database, execute queries, and fetch results. For reading and writing data to a TXT file: 

// Write data to a TXT file
$file = 'users.txt';
$data = "Username: example, Password: password\n";
file_put_contents($file, $data, FILE_APPEND);

// Read data from a TXT file
$file = 'users.txt';
$data = file_get_contents($file);
echo $data;
```

For reading and writing data to a MySQL database:

```php
// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

// Insert data into MySQL database
$username = "example";
$password = "password";

$sql = "INSERT INTO users (username, password) VALUES ('$username', '$password')";
$conn->query($sql);

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

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Username: " . $row["username"] . ", Password: " . $row["password"] . "<br>";
    }
}

$conn->close();

Keywords

PHP file handling MySQL user registration data manipulation

Related Questions