What are common methods for importing Excel data into a MySQL database for display on a website using PHP?

One common method for importing Excel data into a MySQL database for display on a website using PHP is to first convert the Excel file into a CSV file. Then, you can use PHP to read the CSV file and insert the data into the MySQL database using SQL queries. This process allows you to easily transfer the data from Excel to MySQL and display it on a website. 

<?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);
}

// Read CSV file
$csvFile = 'data.csv';
$csv = array_map('str_getcsv', file($csvFile));

// Insert data into MySQL database
foreach ($csv as $row) {
    $sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('" . $row[0] . "', '" . $row[1] . "', '" . $row[2] . "')";
    if ($conn->query($sql) === TRUE) {
        echo "Record inserted successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

// Close MySQL connection
$conn->close();

?>

Keywords

Excel MySQL database import PHP

Related Questions