//include "stu_list.php";
include "../lw_inc/lw_conn.php";
include "../lw_inc/obj_name.php";
/*$cla=$_GET['clas'];
if($cla==''){
exit('操作失败');
}
$class=obj_name($cla);
$class='班级：'.$class;
$cla='1010101';*/
$num = $_GET['iidd2'];
//$num='201392503039';
$sql = "select stu_gra,user_name,stu_sex,entrydate,gradate from user_stu where stu_id='{$num}'";
$query = mysql_query($sql);
$re = mysql_fetch_assoc($query);
$class = obj_name($re['stu_gra']);
$filenm = $re['user_name'] . '成绩单.xls';
$year = date('Y');
$term = array();
$sql = "select distinct cou_term from cou_choose where cou_choose_stu='{$num}'";
$query = mysql_query($sql);
while ($ret = mysql_fetch_row($query)) {
array_push($term, $ret[0]);
//echo('<p>'.$ret[0]);
}
$workbook = new Spreadsheet_Excel_Writer();
$format_title =& $workbook->addFormat();
$format_title->setBold();
$format_title->setSize('16');
$format_title->setAlign('merge');
$format_text =& $workbook->addFormat();
exit('操作失败');
}
$class=obj_name($cla);
$class='班级：'.$class;
$cla='1010101';*/
$num = $_GET['iidd2'];
//$num='201392503039';
//echo $num;
$sql = "select stu_clas,user_name,stu_sex,entrydate,gradate from user_stu where stu_id='{$num}'";
$query = mysql_query($sql);
$re = mysql_fetch_assoc($query);
$re['user_name'] = encoding($re['user_name']);
$re['stu_sex'] = encoding($re['stu_sex']);
$re['entrydate'] = encoding($re['entrydate']);
$re['gradate'] = encoding($re['gradate']);
$class = obj_name($re['stu_clas']);
$class = encoding($class);
$filenm = $re['user_name'];
//$filenm=encoding($filenm);
$filenm = $filenm . '成绩单.xls';
date_default_timezone_set('PRC');
$year = date('Y');
$term = array();
$sql = "select distinct cou_term from cou_choose where cou_choose_stu='{$num}'";
$query = mysql_query($sql);
while ($ret = mysql_fetch_row($query)) {
array_push($term, $ret[0]);
//echo('<p>'.$ret[0]);
}
$workbook = new Spreadsheet_Excel_Writer();
//$workbook->setVersion(8);
<?php
require_once 'Spreadsheet/Excel/Writer.php';
//include "stu_list.php";
session_start();
include "../lw_inc/lw_conn.php";
include "../lw_inc/obj_name.php";
$cla = $_GET['clas'];
if ($cla == '') {
exit('操作失败');
}
date_default_timezone_set('PRC');
$class = obj_name($cla);
$class = encoding($class);
//$class='班级：'.$class;
//$cla='1010101';
$sql = "select stu_id,user_name,stu_sex,nature,stu_nation,en_name,stu_bir,passport_id,stu_address1,stu_address2,contact_way from user_stu where stu_clas='{$cla}'";
$query = mysql_query($sql);
//$re=mysql_fetch_assoc($query);
$workbook = new Spreadsheet_Excel_Writer();
$format_bold =& $workbook->addFormat();
$format_bold->setBold();
$format_bold->setBorder(2);
$format_bold_1 =& $workbook->addFormat();
$format_bold_1->setBold();
$format_bold_1->setBorder(1);
$format_merge_b_1 =& $workbook->addFormat();
$format_merge_b_1->setBold();
$format_merge_b_1->setBorder(1);
$format_merge_b_1->setAlign('merge');
$format_title =& $workbook->addFormat();
