CSV to MySQL

mail@pastecode.io avatar
unknown
php
25 days ago
1.0 kB
1
Indexable
Never
<?php
// Connect to your MySQL database
$servername = "your_server";
$username = "your_username";
$password = "your_password";
$database = "your_database";

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

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Read the .CSV file
$csvFile = "your_file.csv";
$data = array_map('str_getcsv', file($csvFile));
$columns = $data[0]; // Assuming the first row contains column names

// Create a new table with the same column names
$sql = "CREATE TABLE IF NOT EXISTS your_table (";
foreach ($columns as $column) {
    $sql .= "`$column` VARCHAR(255), ";
}
$sql = rtrim($sql, ", ") . ")";
$conn->query($sql);

// Insert data into the newly created table
for ($i = 1; $i < count($data); $i++) {
    $values = "'" . implode("', '", $data[$i]) . "'";
    $insertQuery = "INSERT INTO your_table (" . implode(", ", $columns) . ") VALUES ($values)";
    $conn->query($insertQuery);
}

// Close the database connection
$conn->close();
?>