اضافه کردن مقادیر دیتابیس از فایل اکسل
";
} else {
echo "پایگاه داده قبلا ایجاد شده است : " . mysqli_error($conn) . "
";
}
mysqli_select_db ( $conn , "excel" );
if (!$conn) {
die("خطا در ارتباط: " . mysqli_connect_error());
}
$sql = "CREATE TABLE `users` (
`id` INT NOT NULL AUTO_INCREMENT,
`fullname` VARCHAR(500) NOT NULL,
`student_number` VARCHAR(100) NOT NULL,
`grade` VARCHAR(100) NOT NULL,
`term` VARCHAR(100) NOT NULL,
PRIMARY KEY (`id`));";
if(mysqli_query($conn, $sql)){
echo "جدول با موفقیت ایجاد شد
";
} else {
echo "جدول قبلا ایجاد شده است : " . mysqli_error($conn). "
";
}
if(isset($_POST["import"]))
{
if(!empty($_POST['term_number'])){
$extension = end(explode(".", $_FILES["excel"]["name"]));
$allowed_extension = array("xls", "xlsx", "csv");
if(in_array($extension, $allowed_extension))
{
$file = $_FILES["excel"]["tmp_name"];
include('PHPExcel/IOFactory.php');
$objPHPExcel = PHPExcel_IOFactory::load($file);
echo "
";
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet)
{
$highestRow = $worksheet->getHighestRow();
for($row=2; $row<=$highestRow; $row++)
{
echo "";
$fullname = mysqli_real_escape_string($conn, $worksheet->getCellByColumnAndRow(0, $row)->getValue());
$student_number = mysqli_real_escape_string($conn, $worksheet->getCellByColumnAndRow(1, $row)->getValue());
$grade = mysqli_real_escape_string($conn, $worksheet->getCellByColumnAndRow(2, $row)->getValue());
$term = mysqli_real_escape_string($conn,$_POST['term_number']);
$query = "INSERT INTO users(fullname, student_number , grade , term) VALUES ('".$fullname."', '".$student_number."','".$grade."','".$term."')";
mysqli_query($conn, $query);
echo '| '.$fullname.' | ';
echo ''.$student_number.' | ';
echo ''.$grade.' | ';
echo ''.$term.' | ';
echo '
';
}
}
echo '
';
}
else
{
echo '
';
}
}else{
echo '
';
}
}
?>