DELIMITER $$
CREATE PROCEDURE sp_gs( IN stuNo CHAR(10), OUT total tinyint)
BEGIN
__________ No CHAR(6);
IF (EXISTS(SELECT * FROM tb_gs WHERE sno = stuNo AND role = '社长')) THEN
SELECT gno INTO No FROM tb_gs
WHERE sno = stuNo AND role = '社长';
SELECT count(*) INTO ________
FROM tb_gs WHERE gno = ______;
______ SET total=0;
END IF;
END $$
DELIMITER ;
DELIMITER %%
CREATE TRIGGER tr_gs_insert _________ INSERT
ON tb_gs FOR EACH ROW
BEGIN
DECLARE num INT;
SELECT count(*) INTO ______ FROM tb_gs WHERE gno = __________;
IF (num =0) THEN
SET NEW.role = '社长';
_________;
END %%
DELIMITER ;
<?php
$host="localhost"; $user="root"; $pwd="";
$db_name="db_club";
$conn=mysql_connect($host,$user,$pwd )
or die("连接数据库服务器失败。".mysql_error());
//**********found**********
_____________________($db_name,$conn)
or die("连接数据库失败。".mysql_error());
mysql_query("set names 'gb2312'");
?>
<html >
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<head><title>社团情况查询</title>
<style type="text/css">
<!--
.STYLE1 {font-size: 18px; font-family: "黑体";}
-->
</style>
</head>
<body >
<div align="center"><font face="黑体" size="5" color="#008000">
<b>社团情况查询</b></font></div><br><br>
<form name="frm1" method="post">
<table width="400" align="center">
<tr><td><span class="STYLE1">社团名称：</span></td>
<td><input type="text" name="Name" size="30"></td>
<td><input type="submit" name="select" value="查询"></td></tr>
</table>
</form>
<?php
if(isset($_POST['select']))
{
$Name=$_POST['Name'];
if(!$Name)
echo "<script> alert('输入不正确！')</script>;";
//**********found**********
_________
{
echo "<br>";
echo "<table width=550 border=1 align=center>";
echo "<tr><td>社团总人数</td><td>剩余名额</td></tr>";
//**********found**********
$sql="select _____________, remainder from tb_gs,tb_group where tb_gs.gno=tb_group.gno AND gname='___________'";
$result=mysql_query($sql);
//**********found**********
while($row=mysql_fetch_row(____________))
{list($SUM,$FREE)=$row;
echo "<tr><td>$SUM</td><td>$FREE</td></tr>";
}
echo "</table>";
}
}
?>
</body>
</html>
发表回复