getActiveSheet()->toArray(); // echo "
";
// print_r($data);die;
foreach ($data as $row) {
$name = $row[0];
$email = $row[1];
$age = $row[2];
$sql = "INSERT INTO users (name, email, age) VALUES ('$name', '$email', '$age')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully
";
} else {
echo "Error: " . $sql . "
" . $conn->error . "
";
}
}
} else {
echo 'Only .xls or .xlsx file allowed';
}
} else {
echo 'Please select a file';
}
}
}