//设定上传目录
//echo $f['type'];
$dest = $dest_dir . '/' . $f['name'];
//设置文件名为日期加上文件名避免重复
$dest1 = iconv('UTF-8', 'utf-8//IGNORE', $dest);
$r = move_uploaded_file($f['tmp_name'], $dest1);
chmod($dest, 0755);
//设定上传的文件的属性
//echo('<script>alert("'.$dest1.'");window.location.href="add_many_stu.php?name="'.$dest1.'";</script>');
sleep(1);
set_include_path(get_include_path() . PATH_SEPARATOR . '../excel_cla/');
include 'PHPExcel/IOFactory.php';
include 'add_user_fun.php';
$inputFileName = $dest1;
//$inputFileName = './excel/stu_add.xls';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
//print_r($sheetData);
foreach ($sheetData as $key => $value) {
if ($key != '1') {
$jud = add_stu_user($value['A'], $value['B'], $value['C'], $value['D'], $value['E'], $value['F'], $value['G'], $value['H'], $value['I'], $value['J'], $value['K'], $value['L'], $value['M'], $value['N'], $value['O'], $value['P']);
}
}
if ($jud) {
echo '增加成功';
echo '<script>window.location.href="add_stu_up.html";alert("增加成功");</script>';
}
}
} else {
echo '<script>window.location.href="add_stu_up.html";alert("请浏览文件");</script>';
}
$stu_clas = $stu_gra . $stu_clas;
$stu_bir = trim($_POST['stu_bir']);
$passport_id = trim($_POST['passport_id']);
$stu_nation = trim($_POST['stu_nation']);
$stu_address1 = trim($_POST['stu_address1']);
$stu_address2 = trim($_POST['stu_address2']);
$contact_way = trim($_POST['contact_way']);
$fri_contact_way = trim($_POST['fri_contact_way']);
$entrydate = trim($_POST['entrydate']);
$gradate = trim($_POST['gradate']);
$nature = trim($_POST['nature']);
$comment = trim($_POST['comment']);
if (is_exist($stu_id) != 0) {
exit('学锟斤拷锟截革拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷');
}
$jud = add_stu_user($stu_id, $stu_pass, $user_name, $en_name, $stu_sex, $stu_sch, $stu_maj, $stu_gra, $stu_clas, $stu_bir, $passport_id, $stu_nation, $stu_address1, $stu_address2, $contact_way, $fri_contact_way, $entrydate, $gradate, $nature, $comment);
if ($jud) {
echo '<script>alert("锟斤拷锟接成癸拷");window.location.href="add_stu.php"</script>';
//echo('<script>alert("'.$stu_clas.'")</script>');
} else {
echo '<script>alert("锟斤拷锟斤拷失锟斤拷");</script>';
}
//$sql="update `user_stu` set ch_name='$user_name', en_name='$en_name', stu_sex='$stu_sex', stu_maj='$stu_maj', stu_gra='$stu_gra', stu_clas='$stu_clas', stu_bir='$stu_bir', passport_id='$passport_id', stu_nation='$stu_nation', stu_address1='$stu_address1', stu_address2='$stu_address2', contact_way='$contact_way', fri_contact_way='$fri_contact_way' where stu_id='201063502140'";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
