web菜鸟始入坑

最新推荐文章于 2022-04-08 16:45:46 发布

weixin_44775372

最新推荐文章于 2022-04-08 16:45:46 发布

阅读量198

点赞数

CC 4.0 BY-SA版权

分类专栏：学习之始文章标签：自制菜鸟

本文链接：https://blog.csdn.net/weixin_44775372/article/details/88598974

学习之始专栏收录该内容

3 篇文章

订阅专栏

关于农场管理系统的编写

Web开发技术课程设计：有机农场生产管理

（1）用户身份
用户打开网页选择身份（农场主、技术员、市场人员或访客）登录系统，农场主用户名为admin，密码为20181225，技术员A用户名为tech，密码为20181225，技术员B用户名为tech2，密码为20181225，市场人员用户名为market，密码为20181225，访客（游客）用户名为guest，密码为空。为了方便老师检查大家的网站，固定使用以上这些用户名和密码，且不提供注册功能。

<!--index.html-->
<html>
<head><link href="all.css" rel="stylesheet" type="text/css"/>
	<title>Home</title>
</head>
<body>
<div align="center" class="1"><h1>农场管理系统登陆</h1>
<br><br><br><br><br>
<form action="welcome.php" method="post">
				
Type:<select name="user">
     <option value="农场主">农场主</option>
     <option value="技术员">技术员</option>
     <option value="游客">游客</option>
     </select><br>
ID: <input type="text" name="id"><br>			
Keywords: <input type="password" name="keyword"><br>
<input type="submit" value="LOGIN">
</form>
</div>
</body>
</html>

对用户及密码的判断

<!--welcome.php-->
<html>
<head><link href="all.css" rel="stylesheet" type="text/css"/></head>
<body>
<?php 
 if (!session_id()) session_start();
  $_SESSION['views']=$_POST["id"];
Switch ($_POST["user"]){
    case "农场主":
       if($_POST["id"]==="admin"and$_POST["keyword"]==="20181225"){
	   header("location:farmer.html");	  
	   }
	   else echo"登陆失败";
	   break;
    case "技术员":
       if($_POST["id"]==="tech1"and$_POST["keyword"]==="20181225"
	   or$_POST["id"]==="tech2"and$_POST["keyword"]==="20181225"){
	   header("location:tech.html");
	   }
	   else echo"登陆失败";
	   break;
    case "游客":
       header("location:visitor.html");	   
	   break;
    default:
       echo"登陆失败";
}
?>
</body>
</html>

（2）土地管理
农场主有自由创建、删除和修改土地的功能，土地分四级管理：地区、地标、地块、地位（以下均以附件“小农夫耕作表.xls”为例），每个地位除了名称外，也有唯一编号、面积（单位为亩），每个地位或闲置或分给某一个技术员管理，每个技术员可以管理多个地位。土地信息不是经常变动的，并且也不多，数据库中只用一张数据表即可记录。
农场主可查看和统计每个地区、地标、地块、地位的总面积。

<!--农场主页面-->
<html>

<head><link href="all.css" rel="stylesheet" type="text/css"/></head>

<body>
<div align="center">
<h1>创建土地</h1>
<form action="insert.php" method="post">
地区: <input type="text" name="diqu" /><br>
地标: <input type="text" name="dibiao" /><br>
地块: <input type="text" name="dikuai" /><br>
地位:<input type="text" name="diwei" /><br>
面积:<input type="text" name="mianji" /><br>
分配：<select name="fenpei">
<option value="tech1">tech1</option>
<option value="tech2">tech2</option>
<option value="闲置">闲置</option>
</select><br>
<input type="submit" />
<input type="reset" value="重 置">
</form>

<h1>修改土地</h1>
<form action="update.php" method="post">
编号：<input type="text" name="bianhao" />例：A棚a1前<br>
菜品: <input type="text" name="caipin" /><br>
分配：<select name="fenpei">
<option value="tech1">tech1</option>
<option value="tech2">tech2</option>
<option value="闲置">闲置</option>
</select><br>
<input type="submit" />
<input type="reset" value="重 置">
</form>

<h1>删除土地</h1>
<form action="delete.php" method="post">
编号：<input type="text" name="bianhao" />例：A棚a1前<br>
<input type="submit" />
<input type="reset" value="重 置">
</form>

<h1>查看所有土地</h1>
<form action="see.php">
<input type="submit" />
<input type="reset" value="重 置">
</form>

<h1>面积统计</h1>
<form action="mianji.php" method="post">
地区: <input type="text" name="diqu" /><br>
地标: <input type="text" name="dibiao" /><br>
地块: <input type="text" name="dikuai" /><br>
地位:<input type="text" name="diwei" /><br>
<input type="submit" />
<input type="reset" value="重 置">
</form>


<h5><a href="index.html">返回登陆界面</a></h5>
</div>
</body>

</html>

当然也需要数据库建库建表操作，详见末尾。
利用PHP在数据库中进行增删改查

<div align="center" size="24">增加的土地</div>
<form method="post">
<table width="400" height="200" border="1" cellpadding="2" cellspacing="2" align="center">
 <tr>
 <td>分配</td>
 <td>地区</td>
 <td>地标</td>
 <td>地块</td>
 <td>地位</td>
 <td>面积</td>
 </tr>
 
<?php
$con = mysql_connect("localhost","root","");

mysql_query("set names 'utf8'");

if (!$con)
  {
	  
  die('Could not connect: ' . mysql_error());
  
  }

mysql_select_db("farmer", $con);

$sql="INSERT INTO tudi (bianhao,diqu,dibiao,dikuai,diwei,fenpei,mianji)
VALUES
('$_POST[diqu]$_POST[dibiao]$_POST[dikuai]$_POST[diwei]','$_POST[diqu]','$_POST[dibiao]','$_POST[dikuai]','$_POST[diwei]','$_POST[fenpei]','$_POST[mianji]')";

if (!mysql_query($sql,$con))
  {
	  
  die('Error: ' . mysql_error());
  
  }
echo "record added";

$result = mysql_query("SELECT * FROM tudi where bianhao='$_POST[diqu]$_POST[dibiao]$_POST[dikuai]$_POST[diwei]'");

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
 echo "<td>";
 echo $row['fenpei'];
 echo "</td>";
 echo "<td>";
 echo $row['diqu'];
 echo "</td>";
 echo "<td>";
 echo $row['dibiao'];
 echo "</td>";
 echo "<td>";
 echo $row['dikuai'];
 echo "</td>";
 echo "<td>";
 echo $row['diwei'];
 echo "</td>";
 echo "<td>";
 echo $row['mianji'];
 echo "</td>";
 echo "</tr>";
  
  }

mysql_close($con);

?>
</table>
</form>

<?php
$con = mysql_connect("localhost","root","");

mysql_query("set names 'utf8'");

if (!$con)
  {
	  
  die('Could not connect: ' . mysql_error());
  
  }

mysql_select_db("farmer", $con);

mysql_query("DELETE FROM tudi WHERE bianhao='$_POST[bianhao]'");

mysql_close($con);

header("location:farmer.html");	
?>

<div align="center" size="24">修改的土地</div>
<form method="post">
<table width="400" height="200" border="1" cellpadding="2" cellspacing="2" align="center">
 <tr>
 <td>分配</td>
 <td>地区</td>
 <td>地标</td>
 <td>地块</td>
 <td>地位</td>
 <td>面积</td>
 </tr>
 
<?php
$con = mysql_connect("localhost","root","");

mysql_query("set names 'utf8'");

if (!$con)
  {
	  
  die('Could not connect: ' . mysql_error());
 
  }

mysql_select_db("farmer", $con);

mysql_query("UPDATE tudi SET caipin = '$_POST[caipin]',fenpei = '$_POST[fenpei]'
WHERE bianhao = '$_POST[bianhao]'");

$result = mysql_query("SELECT * FROM tudi where bianhao='$_POST[bianhao]'");

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
 echo "<td>";
 echo $row['fenpei'];
 echo "</td>";
 echo "<td>";
 echo $row['diqu'];
 echo "</td>";
 echo "<td>";
 echo $row['dibiao'];
 echo "</td>";
 echo "<td>";
 echo $row['dikuai'];
 echo "</td>";
 echo "<td>";
 echo $row['diwei'];
 echo "</td>";
 echo "<td>";
 echo $row['mianji'];
 echo "</td>";
 echo "</tr>";
  
  }

mysql_close($con);


?>
</table>
</form>

<form method="post">
<table width="400" height="200" border="1" cellpadding="2" cellspacing="2" align="center">
 <tr>
 <td>定位</td>
 <td>面积</td>
 </tr>
<?php
    $con = mysql_connect("localhost","root","");
	
     if (!$con)	 
     {
		 
      die('Could not connect: ' . mysql_error());
	  
     }
     mysql_select_db("farmer",$con);
	 
	 if($_POST['diqu']!=="")
	 {
		 
	     $result= mysql_query("select sum(mianji) as zonghe1 from tudi ",$con);
		 
		 $row = mysql_fetch_array($result);
		  echo "<tr>";
          echo "<td>";
          echo $_POST['diqu'];
          echo "</td>";
          echo "<td>";
          echo $row['zonghe1'];
          echo "</td>";
	 echo "</tr>";
	 }
	 
	 if($_POST['dibiao']!=="")
	 {
		 
	   $result= mysql_query("select sum(mianji) as zonghe2 from tudi where dibiao='$_POST[dibiao]' and diqu='$_POST[diqu]'");
	   $row = mysql_fetch_array($result);
 echo "<tr>";
          echo "<td>";
          echo $_POST['diqu']."".$_POST['dibiao'];
          echo "</td>";
          echo "<td>";
          echo $row['zonghe2'];
          echo "</td>";
	echo "</tr>";
	 }
	 
	 if($_POST['dikuai']!=="")
	 {
		 
	    $result= mysql_query("select sum(mianji) as zonghe3 from tudi where dikuai='$_POST[dikuai]' and dibiao='$_POST[dibiao]' and diqu='$_POST[diqu]'");
		$row = mysql_fetch_array($result);
		 echo "<tr>";
          echo "<td>";
          echo $_POST['diqu']."".$_POST['dibiao']."".$_POST['dikuai'];
          echo "</td>";
          echo "<td>";
          echo $row['zonghe3'];
          echo "</td>";
	 echo "</tr>";
	 }
	 
	 if($_POST['diwei']!=="")
	 {
		 
	    $result= mysql_query("select sum(mianji) as zonghe4 from tudi where diwei='$_POST[diwei]' and dikuai='$_POST[dikuai]' and dibiao='$_POST[dibiao]' and diqu='$_POST[diqu]'");
		$row = mysql_fetch_array($result);
		 echo "<tr>";
          echo "<td>";
          echo $_POST['diqu']."".$_POST['dibiao']."".$_POST['dikuai']."".$_POST['diwei'];
          echo "</td>";
          echo "<td>";
          echo $row['zonghe4'];
          echo "</td>";
          echo "</tr>";
	 echo "<br>";
	 }
	 
     mysql_close($con);	 
  
?>
</table>
</form>

<!--表格形式显示-->
<table width="400" height="200" border="1" cellpadding="2" cellspacing="2" align="center">
 <tr>
 <td>分配</td>
 <td>地区</td>
 <td>地标</td>
 <td>地块</td>
 <td>地位</td>
 <td>面积</td>
 <td>菜品</td>
 <td>播种月</td>
 <td>播种日</td>
 <td>上市月</td>
 <td>上市日</td>
 <td>下架月</td>
 <td>下架日</td>
 <td>次供量</td>
 <td>种子来源</td>
 <td>农事操作</td>
 <td>备注</td>
 </tr>

<?php
$con = mysql_connect("localhost","root","");

mysql_query("set names 'utf8'");

if (!$con)
  {
	  
  die('Could not connect: ' . mysql_error());
  
  }

mysql_select_db("farmer", $con);

$result = mysql_query("SELECT * FROM tudi");

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
 echo "<td>";
 echo $row['fenpei'];
 echo "</td>";
 echo "<td>";
 echo $row['diqu'];
 echo "</td>";
 echo "<td>";
 echo $row['dibiao'];
 echo "</td>";
 echo "<td>";
 echo $row['dikuai'];
 echo "</td>";
 echo "<td>";
 echo $row['diwei'];
 echo "</td>";
 echo "<td>";
 echo $row['mianji'];
 echo "</td>";
  echo "<td>";
 echo $row['caipin'];
 echo "</td>";
 echo "<td>";
 echo $row['bozhongyue'];
 echo "</td>";
 echo "<td>";
 echo $row['bozhongri'];
 echo "</td>";
  echo "<td>";
 echo $row['shangshiyue'];
 echo "</td>";
 echo "<td>";
 echo $row['shangshiri'];
 echo "</td>";
  echo "<td>";
 echo $row['xiajiayue'];
 echo "</td>";
 echo "<td>";
 echo $row['xiajiari'];
 echo "</td>";
 echo "<td>";
 echo $row['cigongliang'];
 echo "</td>";
  echo "<td>";
 echo $row['zhongzilaiyuan'];
 echo "</td>";
  echo "<td>";
 echo $row['nongshicaozuo'];
 echo "</td>";
 echo "<td>";
 echo $row['beizhu'];
 echo "</td>";
 echo "</tr>";
  
  }

mysql_close($con);
?>
</table>
</form>

技术员有查看自己所管理的土地的功能。可查看统计所管理的每个地区或地标或地块。

<!--管理员页面-->
<html>

<head><link href="all.css"rel="stylesheet"type="text/css"/></head>

<body>

<h1>查看土地</h1>
<form action="tech.php">
<input type="submit" />
</form>

<h1>查看所有生产材料</h1>
<form action="see2.php">
<input type="submit" />
<input type="reset" value="重 置">
</form>

<h5><a href="index.html">返回登陆界面</a></h5>

</body>

</html>

市场人员和游客没有任何土地管理功能。

<html>
<head><link href="all.css"rel="stylesheet"type="text/css"/></head>
<body>

<h1>查看土地</h1>
<form action="visitor.php">
<input type="submit" />
</form>

<h1>查看所有生产材料</h1>
<form action="see2.php">
<input type="submit" />
<input type="reset" value="重 置">
</form>

<h5><a href="index.html">返回登陆界面</a></h5>

</body>

</html>

（3）生产材料购买
农场主有记录所购买的生产材料的功能，生产材料主要指易耗品，包括种子、配肥配药所需的原料，购买记录包括：“购置记录编号”、购置日期、种子或原料名称（10个汉字以内）、购置数量、购置单价（农业原料价格不稳定，需要每次购买都记录），备注（14个汉字以内）等。一条购买记录里面只包含一种易耗品。

<!--在农场主页面添加即可-->
<h1>生产材料购置</h1>
<form action="zhongzi.php" method="post">
日期: <input type="text" name="riqi" />例：XXXX-XX-XX<br>
种子名字: <input type="text" name="zhongzi" /><br>
数量: <input type="text" name="shuliang1" />单位：克<br>
单价:<input type="text" name="danjia1" />单位：元/克<br>
原料名字: <input type="text" name="yuanliao" /><br>
数量: <input type="text" name="shuliang2" />单位：千克<br>
单价:<input type="text" name="danjia2" />单位：元/千克<br>
备注:<input type="text" name="beizhu" /><br>
<input type="submit" />
<input type="reset" value="重 置">
</form>

<h1>查看所有生产材料</h1>
<form action="see2.php">
<input type="submit" />
<input type="reset" value="重 置">
</form>
<form method="post">

<!--种子购置记录-->
<?php
$_COOKIE["bianhao"]=$_COOKIE["bianhao"]+1;
$a=$_COOKIE["bianhao"];
echo $_COOKIE["bianhao"];

$con = mysql_connect("localhost","root","");

mysql_query("set names 'utf8'");

if (!$con)
  {
  
  die('Could not connect: ' . mysql_error());
  
  }

mysql_select_db("farmer", $con);

$sql="INSERT INTO shengliao (bianhao,riqi,zhongzi,shuliang1,danjia1,yuanliao,shuliang2,danjia2,beizhu)
VALUES
('$a','$_POST[riqi]','$_POST[zhongzi]','$_POST[shuliang1]','$_POST[danjia1]','$_POST[yuanliao]','$_POST[shuliang2]','$_POST[danjia2]','$_POST[beizhu]')";

if (!mysql_query($sql,$con))
  {
	  
  die('Error: ' . mysql_error());
  
  }
echo "record added";

mysql_close($con);

header("location:farmer.html");

<!--材料一览表-->
<table width="400" height="200" border="1" cellpadding="2" cellspacing="2" align="center">
 <tr>
 <td>编号</td>
 <td>日期</td>
 <td>种子</td>
 <td>数量</td>
 <td>种子单价</td>
 <td>原料</td>
 <td>质量</td>
 <td>原料单价</td>
 <td>备注</td>
 </tr>
<?php
$con = mysql_connect("localhost","root","");

mysql_query("set names 'utf8'");

if (!$con)
  {
	  
  die('Could not connect: ' . mysql_error());
  
  }

mysql_select_db("farmer", $con);

$result = mysql_query("SELECT * FROM shengliao");

while($row = mysql_fetch_array($result))
  {
	echo "<tr>";
 echo "<td>";
 echo $row['bianhao'];
 echo "</td>";
 echo "<td>";
 echo $row['riqi'];
 echo "</td>";
 echo "<td>";
 echo $row['zhongzi'];
 echo "</td>";
 echo "<td>";
 echo $row['shuliang1'];
 echo "</td>";
 echo "<td>";
 echo $row['danjia1'];
 echo "</td>";
 echo "<td>";
 echo $row['yuanliao'];
 echo "</td>";
  echo "<td>";
 echo $row['shuliang2'];
 echo "</td>";
 echo "<td>";
 echo $row['danjia2'];
 echo "</td>";
 echo "<td>";
 echo $row['beizhu'];
 echo "</td>";
 echo "</tr>";
  
  }

mysql_close($con);
?>
</table>
</form>

后台数据库创建，以下是利用PHP创建，还有在PHPadmin中用sql语言创建也可以

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
// Create table in farme database
mysql_select_db("farme", $con);
$sql = "CREATE TABLE tudi
(
diqu varchar(15),
dibiao varchar(15),
dikuai varchar(15),
diwei varchar(15),
caipin varchar(15),
bozhongyue varchar(15),
bozhongri varchar(15),
shangshiyue varchar(15),
shangshiri varchar(15),
xiajiayue varchar(15),
xiajiari varchar(15),
cigongliang varchar(15),
zhongzhimianji varchar(15),
zhongzilaiyuan varchar(15),
nongshicaozuo varchar(30),
beizhu varchar(30)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
mysql_query($sql,$con);

mysql_close($con);
 header("location:insert.html");
?>