<?php
// php连接数据库
/**
PHP想操作mysql,得先连接上Mysql服务器
1:连接需要哪些要素?
答:服务器的地址,用户名,密码,端口
2:怎么连
答:用mysql_connect()函数来连
*/
/* $server: 服务器的地址[域名/ip],不写一般默认是localhost
$username: 账号
$password: 密码
$new_link: 是否重新连接 */
$conn=mysql_connect('localhost','root','1987',true);
if(!$conn){
die('连接错误'.mysql_error());
}
mysql_select_db('php',$conn);
mysql_set_charset('utf8');
$sql='select * from stu';
$res=mysql_query($sql);
while (!!$row=mysql_fetch_assoc($res)){
$arr[]=$row;
}
//print_r($arr);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="zh-CN">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>学生信息</title>
<pre>
接下来,我们想达到如下 效果:
点击谁,就修改谁.
具体:点击33号用户,则来到一张表单页面,
表单的值 正好是33号用户的信息.
提交后,则修改33号用户
思路:
点击N号时,把N作为参数传过去.
根据参数拼接sql语句,来查询N号用户
查出来的结果,作为表单的默认值.
</pre>
<body>
<form action="add.php" method="post">
<table border='1px'>
<center><caption> 学生成绩表</caption></center>
<tr><td>stu_id</td><td>stu_name</td><td>stu_course</td><td>grade</td><td></td><td></td><td></td></tr>
<?php foreach ($arr as $v){?>
<tr><td><?php echo $v['stu_id']?></td><td><?php echo $v['stu_name']?></td><td><?php echo $v['stu_course']?></td><td><?php echo $v['grade']?></td><td><a href='update.php?id=<?php echo $v['stu_id']?>'>修改</a></td>
<td><a href='del.php?id=<?php echo $v['stu_id']?>'>删除</a></td></tr>
<?php }?>
</table>
<input type="submit" value='添加学生'/>
</form>
</body>
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="zh-CN">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>学生信息</title>
</head>
<body>
<form action="controller.php" method="post"><br/>
stu_name<input type="text" name='stuName'/><br/>
stu_course<input type="text" name='stuCourse'/> <br/>
grade<input type="text" name='grade'/> <br/>
<input type="submit" value='提交'/>
</form>
</body>
</html>
<?php
$conn=mysql_connect('localhost','root','1987');
if (!$conn){
die('连接错误'.mysql_error());
}
mysql_select_db('php',$conn);
mysql_set_charset('utf8');
if (!empty($_POST['stuName'])){
$stu_name=addslashes($_POST['stuName']);
}
if (!empty($_POST['stuCourse'])){
$stu_course=addslashes($_POST['stuCourse']);
}
if (!empty($_POST['grade'])){
$grade=addslashes($_POST['grade']);
}
$sql="insert into stu(stu_name,stu_course,grade)values('$stu_name','$stu_course',$grade)";
//echo $sql;exit;
$b= mysql_query($sql);
if(!$b){
echo '添加失败';
}else{
if(mysql_affected_rows($conn)>0){
echo '添加成功';
}else{
echo '没有行受影响';
}
}
//关闭资源
mysql_free_result($b);
mysql_close($conn);
echo "<a href='stulist.php'>返回列表</a>";
?>
<?php
$conn=mysql_connect('localhost','root','1987');
if (!$conn){
die('连接错误'.mysql_error());
}
mysql_select_db('php',$conn);
mysql_set_charset('utf8');
if (!empty($_POST['stuName'])){
$stu_name=addslashes($_POST['stuName']);
}
if (!empty($_POST['stuCourse'])){
$stu_course=addslashes($_POST['stuCourse']);
}
if (!empty($_POST['grade'])){
$grade=addslashes($_POST['grade']);
}
if (!empty($_POST['id'])){
$id=addslashes($_POST['id']);
}
$sql="update stu set stu_name='".$stu_name."' ,stu_course='".$stu_course."'
,grade=".$grade.' where stu_id='.$id;
// echo $sql;exit;
$b= mysql_query($sql);
if(!$b){
echo '修改失败';
}else{
if(mysql_affected_rows($conn)>0){
echo '修改成功';
}else{
echo '没有行受影响';
}
}
//关闭连接
mysql_close($conn);
echo "<a href='stulist.php'>返回列表</a>";
?>
<?php
$conn=mysql_connect('localhost','root','1987');
if (!$conn){
die('连接错误'.mysql_error());
}
mysql_select_db('php',$conn);
mysql_set_charset('utf8');
$stu_id=isset($_GET['id'])?$_GET['id']+0:0;
$sql='delete from stu where stu_id='.$stu_id;
$b= mysql_query($sql);
if(!$b){
echo '删除失败';
}else{
if(mysql_affected_rows($conn)>0){
echo '删除成功';
}else{
echo '没有行受影响';
}
}
//关闭连接
mysql_close($conn);
echo "<a href='stulist.php'>返回列表</a>";
?>
<?php
$conn=mysql_connect('localhost','root','1987');
if (!$conn){
die('连接错误'.mysql_error());
}
mysql_select_db('php',$conn);
mysql_set_charset('utf8');
$stu_id=isset($_GET['id'])?$_GET['id']+0:0;
//到数据库查询学生信息
$sql='select * from stu where stu_id='.$stu_id;
//echo $sql;exit;
$res=mysql_query($sql);
$row=mysql_fetch_assoc($res); //这里只有一条数据,就不用while循环了
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="zh-CN">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>学生信息</title>
</head>
<body>
<form action="controller1.php" method="post">
stu_id<input type="hidden" name='id' value='<?php echo $row['stu_id'];?>'/><br/>
stu_name<input type="text" name='stuName' value='<?php echo $row['stu_name'];?>'/><br/>
stu_course<input type="text" name='stuCourse' value="<?php echo $row['stu_course'];?>"/> <br/>
grade<input type="text" name='grade' value='<?php echo $row['grade'];?>'/> <br/>
<input type="submit" value='提交'/>
</form>
</body>
</html>
由此可知面向过程使代码量大
转载于:https://my.oschina.net/u/932154/blog/100169