How can PHP scripts be used to streamline the process of importing CSV files into MySQL databases?

Importing CSV files into MySQL databases can be streamlined using PHP scripts by reading the CSV file line by line, parsing the data, and inserting it into the MySQL database using SQL queries. This process can be automated using PHP functions to handle the file upload, data parsing, and database insertion, making it more efficient and less error-prone. 

<?php
// Connect to MySQL 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);
}

// Open and read CSV file
$csvFile = fopen('data.csv', 'r');
while (($data = fgetcsv($csvFile)) !== FALSE) {
    $sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('" . $data[0] . "', '" . $data[1] . "', '" . $data[2] . "')";
    if ($conn->query($sql) === TRUE) {
        echo "Record inserted successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

// Close CSV file and MySQL connection
fclose($csvFile);
$conn->close();
?>

Keywords

PHP CSV files MySQL databases import streamline

Related Questions