PHP? ??? ?? ?? ???? ?? ?? ??(2?)
??? ????? ?????? ?? ? ?? ??? ?? ??????. ?? ???? ?? ??? ???????. ?? ?? ??? ?? ?? ??? ?????.
<?php header("Content-type: text/html; charset=utf-8");//設(shè)置編碼 $con =@mysql_connect("localhost","root","root") or die("數(shù)據(jù)庫連接失敗"); mysql_select_db('news') or die("指定的數(shù)據(jù)庫不能打開"); mysql_query("set names utf8");//設(shè)置數(shù)據(jù)庫的字符集 $id=$_GET['id']; $sql="select * from new where id=$id"; $res = mysql_query($sql); $row = mysql_fetch_array($res); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title></title> <style type="text/css"> *{margin:0px;padding:0px;} body{background:#ccc;} .add{width:450px;height:280px;background:#eee;float:left;} .cont{width:500px;height:350px;margin-top:5px;margin-left:5px;} form{margin-left:10px;padding-top:30px;} .sub{width:100px;height:40px;border:1px solid #ccc;} .sub:hover{background:#f90} </style> </head> <body> <div class="add"> <div class="cont"> <form method="post" action="modify.php?id=<?php echo $id;?>"> 標(biāo)題:<input type="text" name="title" value="<?php echo $row['title']?>"></br></br> 內(nèi)容:<textarea cols="50" rows="5" name="content"><?php echo $row['content']?></textarea></br></br> <input type="submit" value="修改" class="sub"> </form> </div> </div> </body> </html>
? ??? ????? ??? ??? ????. ??.php? ??? ? ??? ???????.
?? ??????? ???? ???
<?php header("Content-type: text/html; charset=utf-8");//設(shè)置編碼 $con =@mysql_connect("localhost","root","root") or die("數(shù)據(jù)庫連接失敗"); mysql_select_db('news') or die("指定的數(shù)據(jù)庫不能打開"); mysql_query("set names utf8");//設(shè)置數(shù)據(jù)庫的字符集
?? ?? ?? ??? ?????
<?php $id = $_GET['id']; $title = $_POST['title']; $content = $_POST['content']; $messtime = time();
??: ???? ID? ???? ???. ?? ????? ??? ??? ?? ?? ??? ???? ? ?? ???? ??? ?????. ??? ID? ???? ?? ?????.
???? ?????. ???
$sql = "? ?? ?? ????=' $title',content='$content',messtime='$messtime' where id='$id'";
$res = mysql_query($sql );
??? ?? ? ??
if($res){
???????????????????????????????????????????????????????????????????????~????????????????????????????????? Echo "<script>alert('?? ??');location.href='newlist.php';</script>" ; ('?? ??');history.go(-1);</script>";
}
??? ??? ??? ????.
<?php header("Content-type: text/html; charset=utf-8");//設(shè)置編碼 $con =@mysql_connect("localhost","root","root") or die("數(shù)據(jù)庫連接失敗"); mysql_select_db('news') or die("指定的數(shù)據(jù)庫不能打開"); mysql_query("set names utf8");//設(shè)置數(shù)據(jù)庫的字符集 $id = $_GET['id']; $title = $_POST['title']; $content = $_POST['content']; $messtime = time(); $sql = "update new set title='$title',content='$content',messtime='$messtime' where id='$id'"; $res = mysql_query($sql); if($res){ echo "<script>alert('修改成功');location.href='newlist.php';</script>"; }else{ echo "<script>alert('修改失敗');history.go(-1);</script>"; } ?>
??? ?? ??? ??? ??? ???????.