How can PHP scripts be used to import data from MySQL to MongoDB?

To import data from MySQL to MongoDB using PHP scripts, you can connect to both databases, query the data from MySQL, and then insert it into MongoDB using the appropriate methods provided by the MongoDB PHP driver. This process involves fetching the data from MySQL, transforming it into a format suitable for MongoDB, and inserting it into the MongoDB collection. 

```php
<?php
// Connect to MySQL
$mysqlConnection = new mysqli('localhost', 'username', 'password', 'database_name');

// Connect to MongoDB
$mongoClient = new MongoDB\Client('mongodb://localhost:27017');
$mongoDB = $mongoClient->selectDatabase('mongodb_database_name');
$mongoCollection = $mongoDB->selectCollection('mongodb_collection_name');

// Query data from MySQL
$result = $mysqlConnection->query("SELECT * FROM table_name");

// Insert data into MongoDB
foreach ($result as $row) {
    $data = [
        'field1' => $row['field1'],
        'field2' => $row['field2'],
        // Add more fields as needed
    ];
    $mongoCollection->insertOne($data);
}

// Close connections
$mysqlConnection->close();
```
This code snippet demonstrates how to import data from a MySQL table into a MongoDB collection using PHP. Make sure to replace the placeholder values with your actual database connection details and field names.

Keywords

PHP MySQL MongoDB data import scripts

Related Questions