PHP导出效果图:现数据库设计:
现在这样的数据库设计,怎样全部导出像效果图那样的效果???
导出效果必须一模一样!求教!
跪求代码!!!跪求思路!!!
高分!急!!!!!!!注意事项:
1.数据库Q_id第一题到第十题 等于 效果图的point1到point10
2.数据库A_id数值 等于 效果图point1到point10的数值PHP数据库导出
现在这样的数据库设计,怎样全部导出像效果图那样的效果???
导出效果必须一模一样!求教!
跪求代码!!!跪求思路!!!
高分!急!!!!!!!注意事项:
1.数据库Q_id第一题到第十题 等于 效果图的point1到point10
2.数据库A_id数值 等于 效果图point1到point10的数值PHP数据库导出
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=$filename");
header("Pragma: no-cache");
header("Expires: 0");
看不出 excel 各列与表的对应关系
select * from table group by tusername
$res 为查出的数组
$array = array();
foreach($res as $rows)
{
if($rows['tusername ']!=$tusername )
{
$i=0;
}
$array[$rows['tusername ']][$rows['q_id']] = $rows['A_id'];
$i++;
$tusername =$rows['tusername '];
}
思路是这样的
新的数组打印出来就是你要的结果
就是对你查出来的结果 数组重新排
具体你在调试一下吧
要求按用户导出!!!
先把文件头显示,然后在用SQL代码分别查询Q_id每一个Q_id的分值,但这样的话只能导出一个,不能全部导出
先把文件头显示,然后在用SQL代码分别查询Q_id每一个Q_id的分值,但这样的话只能导出一个,不能全部导出你要循环你的数据啊
你不循环输出,肯定就只有一条啊
先把文件头显示,然后在用SQL代码分别查询Q_id每一个Q_id的分值,但这样的话只能导出一个,不能全部导出你要循环你的数据啊
你不循环输出,肯定就只有一条啊版主,我那数据库设计的话,循环不了,请你看那效果图和那数据库设计!
<?php
$filename="info.xls";//先定义一个excel文件header("Content-Type: application/vnd.ms-execl");
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=$filename");
header("Pragma: no-cache");
header("Expires: 0");//我们先在excel输出表头,当然这不是必须的echo iconv("utf-8", "gb2312", "教师姓名")."\t";
echo iconv("utf-8", "gb2312", "学生姓名")."\t";
echo iconv("utf-8", "gb2312", "卷号")."\t";
echo iconv("utf-8", "gb2312", "point1")."\t";
echo iconv("utf-8", "gb2312", "point2")."\t";
echo iconv("utf-8", "gb2312", "point3")."\t";
echo iconv("utf-8", "gb2312", "point4")."\t";
echo iconv("utf-8", "gb2312", "point5")."\t";
echo iconv("utf-8", "gb2312", "point6")."\t";
echo iconv("utf-8", "gb2312", "point7")."\t";
echo iconv("utf-8", "gb2312", "point8")."\t";
echo iconv("utf-8", "gb2312", "point9")."\t";
echo iconv("utf-8", "gb2312", "point10")."\n";
//注意这个要换行//这里我们定义一个数据库为localhost 数据库用户名:root 密码为:123
$conn = mysql_connect("localhost","root","123");
mysql_select_db("komet");
//在这里我们定义一个名叫komet的表
$tt='teacher0001';
$ss='S20130001';
$pp='BBBBB';
echo iconv("utf-8", "gb2312", $tt)."\t";
echo iconv("utf-8", "gb2312", $ss)."\t";
echo iconv("utf-8", "gb2312", $pp)."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='1'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='2'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='3'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='4'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='5'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='6'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='7'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='8'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='9'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";$sql1="SELECT `A_id` FROM `kfs` WHERE `TUserName` = '$tt' and `SUserName` = '$ss' and `PaperCode` = '$pp' and`Q_id`='10'";
$R1 = mysql_query($sql1, $conn) or die(mysql_error());
$row_R1 = mysql_fetch_assoc($R1);
echo iconv("utf-8", "gb2312", $row_R1['A_id'])."\t";
?>
以上是单条记录输出的代码,以上代码能实现选择教师名,选择学生名,选择试卷,输出单条记录
但是如果我想把所有教师名,所有学生名,所有试卷的每一条记录
像效果图那样子导出的话,应该怎样实现???