php數(shù)據(jù)訪問之增刪改查操作

更新時間：2016年05月09日 11:36:12 作者：陌上初薰

這篇文章主要為大家詳細介紹了php數(shù)據(jù)訪問之增刪改查操作的相關(guān)資料，感興趣的小伙伴們可以參考一下

增刪改查操作小練習(xí)，大家練練手吧

一、查看新聞頁面-----主頁面

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>查看新聞</title>
</head>
 
<body>
<h1>查看新聞</h1>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
  <td>id</td>
  <td>title</td>
  <td>author</td>
  <td>source</td>
   <td>content</td>
  <td>date</td>
  <td>update</td>
  <td>delete</td>
</tr>
<?php
$db=new MySQLi("localhost","root","","mydb");
!mysqli_connect_error() or die("連接失??！");
$sql="select * from news";
$result=$db->query($sql);
$arr=$result->fetch_all();
foreach ($arr as $v)
{
  echo "<tr>
  <td>{$v[0]}</td>
  <td>{$v[1]}</td>
  <td>{$v[2]}</td>
  <td>{$v[3]}</td>
  <td>{$v[4]}</td>
  <td>{$v[5]}</td>
  <td><a href='Update.php?newsid={$v[0]}'>update</a></td>
  <td><a href='Delete.php?newsid={$v[0]}'>delete</a></td>
   
  </tr>";
  }
 
?>
</table>
<br>
<br />
<div class="xw"><a href="xinwen.php">發(fā)布新聞</a></div>
 
</body>
</html>

二、發(fā)布新聞頁面-----添加內(nèi)容

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>發(fā)布新聞</title>
<style>
.xw
{
   
  margin-top:10px;
  margin-left:400px;
  border:thick; 
  }
.a
{
  float:left;
   
  }
 
</style>
 
</head>
 
<body>
<h1><center>發(fā)布新聞</center></h1>
 
<form action="AddChu.php" method="post">
<div class="xw">標(biāo)題：<input type="text" name="title" style="width:400px"></div>
<div class="xw">作者：<input type="text" name="author"></div>
<div class="xw">來源：<input type="text" name="source"></div>
<div class="xw">內(nèi)容:
<textarea rows="10" cols="80" name="content"></textarea></div>
 
<div class="a"><input type="submit" value="提交" style="margin-left:600px;"></div>
<div class="a"><a href="ChaKan.php"><input type="button" value="查看" style="margin-left:6px;"></a></div>
 
</form>
 
 
</body>
</html>

提交內(nèi)容后的處理：

<?php
$newsid=$_POST["newsid"];
$title=$_POST["title"];
$author=$_POST["author"];
$source=$_POST["source"];
$content=$_POST["content"];
$time=date("Y-m-d",time());
 
$db=new MySQLi("localhost","root","","mydb");
!mysqli_connect_error() or die("聯(lián)系失敗!");
$sql="insert into news values('{$newsid}','{$title}','{$author}','{$source}','{$content}','{$time}')";
$result=$db->query($sql);
if($result)
{
  header ("location:xinwen.php");
  }
else
{
  echo "添加新聞失敗！";
  }

三、刪除內(nèi)容處理

<?php
$newsid=$_GET["newsid"];
$db=new MySQLi("localhost","root","","mydb");
!mysqli_connect_error() or die("連接失敗!");
$sql="delete from news where newsid='{$newsid}'";
$result=$db->query($sql);
if($result)
{
  header ("location:ChaKan.php");
  }
else
{
  echo "刪除數(shù)據(jù)失敗";
  }
?>

四、修改新聞頁面----修改新聞內(nèi)容后提交查看

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>修改新聞</title>
<style>
.xw
{
   
  margin-top:10px;
  margin-left:400px;
  border:thick; 
  }
   
.a
{
  float:left;
   
  }
 
</style>
</head>
 
<body>
<h1><center>修改新聞</center></h1>
<?php
$newsid = $_GET["newsid"];
$db = new MySQLi("localhost","root","","mydb");
$sinfo = "select * from news where newsid='{$newsid}'";
$r = $db->query($sinfo);
$arr = $r->fetch_row(); //這個人的所有信息
?>
 
<form action="UpdateChu.php" method="post">
<div class="xw"><input type="hidden" name="newsid" value="<?php echo $arr[0] ?>"></div>
<div class="xw">標(biāo)題：<input type="text" name="title" style="width:400px" value="<?php echo $arr[1] ?>"></div>
<div class="xw">作者：<input type="text" name="author" value="<?php echo $arr[2] ?>"></div>
<div class="xw">來源：<input type="text" name="source" value="<?php echo $arr[3] ?>"></div>
<div class="xw">內(nèi)容:
<textarea rows="10" cols="80" name="content"><?php echo $arr[4] ?></textarea></div>
 
<div class="a"><input type="submit" value="修改" style="margin-left:600px;"></div>
<div class="a"><a href="ChaKan.php"><input type="button" value="查看" style="margin-left:6px;"></a></div>
 
</form>
 
</body>
</html>

提交修改內(nèi)容后進行處理：

<?php
$newsid=$_POST["newsid"];
$title=$_POST["title"];
$author=$_POST["author"];
$source=$_POST["source"];
$content=$_POST["content"];
$time=date("Y-m-d",time());

$db=new MySQLi("localhost","root","","mydb");
!mysqli_connect_error() or die("聯(lián)系失敗!");
$sql="update news set title='{$title}',author='{$author}',source='{$source}',content='{$content}',time='{$time}' where newsid='{$newsid}'";
$result=$db->query($sql);
if($result)
{
  header ("location:Update.php");
  }
else
{
  echo "修改數(shù)據(jù)失敗!";
  }

以上就是本文的全部內(nèi)容，希望對大家學(xué)習(xí)php程序設(shè)計有所幫助。

您可能感興趣的文章: