php数据修改操作代码,数据库添加、修改、删除基础操作代码(1/4)_PHP教程

人才列表

if($action==’add’){

?>

添加人员

登陆账号

登陆密码

问题

答案

}

elseif($action==’save’){

$login = isset($_post[‘login’]) ? $_post[‘login’] : ”;

$pws = isset($_post[‘pws’]) ? $_post[‘pws’] : ”;

$question = isset($_post[‘question’]) ? $_post[‘question’] : ”;

$answer = isset($_post[‘answer’]) ? $_post[‘answer’] : ”;

$sql = “insert into person (login,pws,question,answer)

values(‘$login’,’$pws’,’$question’,’$answer’)”;

$db->query($sql);

forward(‘发布成功’,’href’,’personlist.php’);

}

elseif($action==’del’){

$person_id=$_get[‘person_id’];

$page=$_get[‘page’];

$sql=”delete from person where person_id=’$person_id'”;

$db->query($sql);

forward(‘删除成功’,’href’,’personlist.php?page=’.$page);

}

elseif($action==’editsave’){

$person_id = isset($_post[‘person_id’]) ? $_post[‘person_id’] : ”;

$page = isset($_post[‘page’]) ? $_post[‘page’] : ”;

$login = isset($_post[‘login’]) ? $_post[‘login’] : ”;

$pws = isset($_post[‘pws’]) ? $_post[‘pws’] : ”;

$question = isset($_post[‘question’]) ? $_post[‘question’] : ”;

$answer = isset($_post[‘answer’]) ? $_post[‘answer’] : ”;

$sql=”update person set login=’$login’,pws=’$pws’,question=’$question’,answer=’$answer’ where person_id=’$person_id'”;

$db->query($sql);

forward(‘修改成功’,’href’,’personlist.php?page=’.$page);

}

elseif($action==’edit’){

$person_id=$_get[‘person_id’];

$page=$_get[‘page’];

$sql=”select * from person where person_id=’$person_id'”;

$query = $db->query($sql);

$row = $db->fetch_array($query);

$login=$row[‘login’];

$pws=$row[‘pws’];

$question=$row[‘question’];

$answer=$row[‘answer’];

?>

删除/