写一个php,通过php增删改查学生表
要求
1.加入js前端验证和php后台验证
2.验证要求编号,语数英是数字并且不能为空,姓名不能为空
程序设计的分析
数据库和表的设计
mysql> create table student(
-> id int unsigned not null default 0,
-> name varchar(10) not null default '',
-> chinese decimal(5,2) not null default 0.0,
-> english decimal(5,2) not null default 0.0,
-> math decimal(5,2) not null default 0.0
-> )charset=utf8 engine=myisam;
Query OK, 0 rows affected (0.06 sec)
mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from student;
+----+------+---------+---------+-------+
| id | name | chinese | english | math |
+----+------+---------+---------+-------+
| 1 | 张三 | 66.00 | 77.00 | 88.00 |
+----+------+---------+---------+-------+
1 row in set (0.00 sec)
根据设计完成代码
addUser.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<h1>添加用户界面</h1>
<form action="addAction.php" method="post">
<table>
<tr>
<td>学生编号:</td>
<td><input type="text" name="id"></td>
</tr>
<tr>
<td>学生姓名:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>语文成绩:</td>
<td><input type="text" name="chinese"></td>
</tr>
<tr>
<td>英语成绩:</td>