PHP MYSQL
(quick guide & example)
DUMMY USER TABLE id | BIGINT(20) | PRIMARY KEY email | VARCHAR(255) name | VARCHAR(255)
DUMMY CSV USERS job@doe.com | Job Doe jon@doe.com | Jon Doe joy@doe.com | Joy Doe
<form action="import.php" method="post" enctype="multipart/form-data"> <input type="file" name="up" accept=".csv" required> <input type="submit" value="Upload"> </form>
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8", USER, PASSWORD);
OPEN UPLOADED CSV $fh = fopen($_FILES["up"]["tmp_name"], "r"); if ($fh === false) { exit("ERROR"); }
IMPORT ROW-BY-ROW while (($r = fgetcsv($fh)) !== false) { $stmt = $pdo->prepare("INSERT INTO `users` (`email`, `name`) VALUES (?,?)"); $stmt->execute([$r[0], $r[1]]); } fclose($fh);