show_classroom.php
<html>
<head>
<title>课室详细信息</title>
<link href="../table_style.css" rel="stylesheet" type="text/css">
</head>
<?php
$con = mysql_connect("localhost","root","");
//通过服务器locahost建立连接,用户名为root,无密码if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("crms", $con);$search1 = "SELECT * FROM classroom2 ";$result1 = mysql_query($search1, $con)or die(mysql_error());
?>
<body><h3>CRMS - 课室详细信息</h3>
<table>
<caption>全部课室情况如下</caption>
<tr>
<th>栋号</th>
<th>课室号</th>
<th>课室容量</th>
<th>话筒情况</th>
<th>空调情况</th>
<th>灯管情况</th>
<th>排插数</th>
<th>操作</th>
</tr><?php
while($row = mysql_fetch_array($result1))
{
?>
<tr>
<td>
<?php
echo $row['building_id'];
?>
</td>
<td>
<?php
echo $row['classroom_id'];
?>
</td>
<td>
<?php
echo $row['size'];
?>
</td>
<td>
<?php
echo $row['microghone'];
?>
</td>
<td>
<?php
echo $row['air_condition'];
?>
</td>
<td>
<?php
echo $row['light'];
?>
</td>
<td>
<?php
echo $row['extention_wire'];
?>
</td>
<td>
<?php
echo '<a href="delete_classroom.php?building_id='.$row['building_id'].'&classroom_id='.$row['classroom_id'].'">删除</a>';
?>
</td>
<?php
echo "<br />";
}
?>
</tr>
</table>
<a href="manage_classroom.php">返回</a>
</body>
</html>显示的时候“课室详细信息”和”全部课室情况如下“之间有很多空格?怎么去掉?
<html>
<head>
<title>课室详细信息</title>
<link href="../table_style.css" rel="stylesheet" type="text/css">
</head>
<?php
$con = mysql_connect("localhost","root","");
//通过服务器locahost建立连接,用户名为root,无密码if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("crms", $con);$search1 = "SELECT * FROM classroom2 ";$result1 = mysql_query($search1, $con)or die(mysql_error());
?>
<body><h3>CRMS - 课室详细信息</h3>
<table>
<caption>全部课室情况如下</caption>
<tr>
<th>栋号</th>
<th>课室号</th>
<th>课室容量</th>
<th>话筒情况</th>
<th>空调情况</th>
<th>灯管情况</th>
<th>排插数</th>
<th>操作</th>
</tr><?php
while($row = mysql_fetch_array($result1))
{
?>
<tr>
<td>
<?php
echo $row['building_id'];
?>
</td>
<td>
<?php
echo $row['classroom_id'];
?>
</td>
<td>
<?php
echo $row['size'];
?>
</td>
<td>
<?php
echo $row['microghone'];
?>
</td>
<td>
<?php
echo $row['air_condition'];
?>
</td>
<td>
<?php
echo $row['light'];
?>
</td>
<td>
<?php
echo $row['extention_wire'];
?>
</td>
<td>
<?php
echo '<a href="delete_classroom.php?building_id='.$row['building_id'].'&classroom_id='.$row['classroom_id'].'">删除</a>';
?>
</td>
<?php
echo "<br />";
}
?>
</tr>
</table>
<a href="manage_classroom.php">返回</a>
</body>
</html>显示的时候“课室详细信息”和”全部课室情况如下“之间有很多空格?怎么去掉?
解决方案 »
- 经济疲软雅虎市值下降 微软考虑减少收购雅虎报价
- 一个很简单的问题,帮帮小弟
- input type=reset 按钮单击后将重置表单控件为其默认值。是只Reset其Value?对它的属性,如Selected或者disabled都不会还原到默认值?
- 问个无限极分类的SQL查询
- Power PC+BOA+PHP+CGI环境 PHP(CGI模式)无法获取表单输入数据
- 关于定时刷票的一个算法问题
- php连接ACCESS数据库怎么就是不成功阿
- 做了一套成绩查询,管理系统,大家PP看
- 用php文件打开html文件的时候,如何解析html文件中的php代码?
- 虽然相似的帖子,但还是不懂。php怎样在下拉菜单动态显示mysql数据库内容
- vbulletin 搜索功能是哪个文件?
- 精通NoSQL的进来看看这种情况有什么好的解决方案??
要不把css帖出来也行 要不你就自己检查下css,看看table tr td th caption的属性都怎么设置的。
<head>
<title>课室详细信息</title>
<link href="../table_style.css" rel="stylesheet" type="text/css">
</head>
<?php
$con = mysql_connect("localhost","root","");
//通过服务器locahost建立连接,用户名为root,无密码if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("crms", $con);$search1 = "SELECT * FROM classroom2 ";$result1 = mysql_query($search1, $con)or die(mysql_error());
?>
<body><h3>CRMS - 课室详细信息</h3>
<table>
<caption>全部课室情况如下</caption>
<tr>
<th>栋号</th>
<th>课室号</th>
<th>课室容量</th>
<th>话筒情况</th>
<th>空调情况</th>
<th>灯管情况</th>
<th>排插数</th>
<th>操作</th>
</tr><?php
while($row = mysql_fetch_array($result1))
{
?>
<tr>
<td>
<?php
echo $row['building_id'];
?>
</td>
<td>
<?php
echo $row['classroom_id'];
?>
</td>
<td>
<?php
echo $row['size'];
?>
</td>
<td>
<?php
echo $row['microghone'];
?>
</td>
<td>
<?php
echo $row['air_condition'];
?>
</td>
<td>
<?php
echo $row['light'];
?>
</td>
<td>
<?php
echo $row['extention_wire'];
?>
</td>
<td>
<?php
echo '<a href="delete_classroom.php?building_id='.$row['building_id'].'&classroom_id='.$row['classroom_id'].'">删除</a>';
?>
</td>
<?php
echo "<br />";
}
?>
</tr>
</table>
<a href="manage_classroom.php">返回</a>
</body>
</html>
帖<link href="../table_style.css" rel="stylesheet" type="text/css">这个CSS。
table
{
font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;
width:100%;
border-collapse:collapse;
}table td, table th
{
font-size:12xp;
border:1px solid #98bf21;
padding:2px 5px 1px 5px;
}table th
{
font-size:12xp;
text-align:left;
padding-top:3px;
padding-bottom:2px;
background-color:#A7C942;
color:#ffffff;
}table tr.alt td
{
color:#000000;
background-color:#EAF2D3;
}
/*padding:2px 5px 1px 5px;*/
按照HTML默认来处理
h1,h2,h3都会按照HTML标准输出时先换行,所以要想按照你的理想输出,自行定义字体、行高、颜色到CSS中。
<?php
$con = mysql_connect("localhost","root","");
//通过服务器locahost建立连接,用户名为root,无密码if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("crms", $con);$search1 = "SELECT * FROM classroom2 ";$result1 = mysql_query($search1, $con)or die(mysql_error());
?>代码越长,空白越多!
在<HEAD> </HEAD>中间加入下面的代码试验下,别放到CSS中去,主要看效果。<style type="text/css">
h1,h3{margin:0px;padding:0px;font-size:12px;}
</style>
<html>
<head>
<title>管理员操作页面</title>
<link href="../table_style.css" rel="stylesheet" type="text/css">
</head><body>
<h3>CRMS - 管理员操作页面</h3> <form action="manage1.php" method="post">
<table border="0">
<tr>
<th>栋号</th>
<td>
<select name="building_id">
<option value ="0">--请选择--</option>
<option value ="A">A</option>
<option value ="B">B</option>
<option value ="C">C</option>
<option value ="D">D</option>
<option value ="E">E</option>
</select>
</td>
</tr> <tr>
<th>课室号</th>
<td><input type="text" name="classroom_id" maxlength="12" size="12"></td>
</tr><?php
$con = mysql_connect("localhost","root","") or die("错误信息:".mysql_error()); //连接
$db = mysql_select_db("crms"); //这个要不写就取不着数据 但不会报错
mysql_query("set names gb2312");
$sql="select * from course2";
$result=mysql_query($sql);
?>
<tr>
<th>课程名</th><td>
<select name="cname">
<option value ="0">--请选择--</option>
<?phpwhile($row=mysql_fetch_array($result)){
?>
<option value="<?php echo $row['cname']; ?>"><?php
echo $row['cname'];
?></option>
<?php
}
?></select>
</td>
</tr>
<tr>
<th>第几节</th>
<td>
<select name="lesson_id">
<option value ="0">--请选择--</option>
<option value ="1">1</option>
<option value ="2">2</option>
<option value ="3">3</option>
<option value ="4">4</option>
<option value ="5">5</option>
<option value ="6">6</option>
<option value ="7">7</option>
<option value ="8">8</option>
<option value ="9">9</option>
<option value ="10">10</option>
<option value ="11">11</option>
<option value ="12">12</option>
<option value ="13">13</option>
<option value ="14">14</option>
<option value ="15">15</option>
</select>
</td>
</tr>
<tr>
<th>时间</th>
<td>
<select name="time">
<option value ="0">--请选择--</option>
<option value ="Monday">Monday</option>
<option value ="Tuesday">Tuesday</option>
<option value ="Wednesday">Wednesday</option>
<option value ="Thursday">Thursday</option>
<option value ="Friday">Friday</option>
<option value ="Saturday">Saturday</option>
<option value ="Sunday">Sunday</option>
</select>
</td>
</tr>
<p>
快速查找您要修改的课室范围(选填)
</p>
<tr>
<td colspan="2"><input type="submit" value="确定"></td>
</tr>
</table>
</form>
</body>
</html>