blob: e3571054ab5d83775de8108d38622e40927c45ca [file] [log] [blame]
<?php
require '../credentials.php';
require '../php/utils.php';
$csvname = $_FILES['csvname']['tmp_name'];
$dbname = $_POST['dbname'];
// Read from CSV
$inscrits = array_map('str_getcsv', file($csvname));
array_shift($inscrits); // remove header
$start = 1;
$i = $start;
foreach ($inscrits as $user) {
$i = ($i + 1) % ($start + count($inscrits));
if ($i == 0) $i = $i + 1;
$template = "INSERT INTO `".$dbname."` (`id`, `nom`, `curs`, `grau`, `quimata`, `requested`, `mort`, `password`)" .
" VALUES (NULL, '".$user[0]."', '".$user[1]."', '".$user[2]."', ".$i.", '0', '0', '')";
if (!query($template)) die("An error ocurred.");
}
die("<script>window.location.href = './index.php'</script>");
?>