PHP MySQL 增查删改

来源：互联网发布：.us域名查询编辑：程序博客网时间：2024/06/01 09:17

丑的一批，但还能看。

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<form action="#" method="post" name="form1">
   查询关键字：
    <input type="text" name="txt_keyword" id="txt_keyword" />
    <input type="submit" name="Submit" id="Submit" value="搜索" onclick=" return check(form1)" />
</form>

<script language="javascript">
   function check(form1)
   {
       if(form1.txt_keyword.value=="")
       {
           alert("请输入关键字！");
           form1.txt_keyword.focus();
           return false;
       }
       form1.submit();
   }
</script>

<?php
   $link=mysql_connect("localhost","root","a3141592654")or die("数据库服务器连接失败！".mysql_error());
   mysql_select_db("msphp",$link);
   mysql_query("set names utf-8");
   $sql=mysql_query("select * from tb_affiche");
   $info=mysql_fetch_array($sql);
   if($_POST['Submit']=="搜索")
   {
       $keyword=$_POST['txt_keyword'];
       $sql=mysql_query("select * from tb_affiche where title like '%$keyword%' or content like '%$keyword%'");
       $info=mysql_fetch_array($sql);
   }
   if($info==false)
   {
       //echo "检索信息失败";
       echo "<script> alert('检索信息失败！'); window.location.hre='#'; </script>";
   }
   else
   {
       //echo "检索信息成功";
       echo "<script> alert('检索信息成功！'); window.location.href='#'; </script>";
   }
   do{
       echo $info[id]." ";
       echo $info[title]."<br>";
       echo $info[content];
       echo "<a href='update.php?id=".$info[id]."&title=".$info[title]."&content=".$info[content]."'>编辑</a>";
       echo "<a href='delete.php?id=".$info[id]."&title=".$info[title]."&content=".$info[content]."'>删除</a><br/><br/>";

   }while($info=mysql_fetch_array($sql));

?>
</body>
</html>

INSERT

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<form action="#" method="post" name="form1">
       公告主题：
        <input type="text" name="txt_title" id="txt_title" /><br />
        公告内容：
        <textarea name="txt_content" id="txt_content" role="10" cols="100" ></textarea><br />
        <input type="submit" name="Submit" id="Submit" value="保存" onclick="return check(form1)" />
        <input type="reset" name="Reset" id="Reset" value="重置" />
</form>

<script language="javascript">
   function check(form1)
   {
       if(form1.txt_title.value=="")
       {
           alert("请输入公告标题");
           form1.txt_title.focus();
           return false;
       }
       if(form1.txt_content.value=="")
       {
           alert("请输入公告标题");
           form1.txt_content.focus();
           return false;
       }
   form1.submit();
   }
</script>

<?php
   $link=mysql_connect("localhost","root","a3141592654")or die("数据服务器连接失败！".mysql_error());
   mysql_select_db("msphp",$link)or die("数据库连接失败！".mysql_error());
   mysql_query("set names utf-8");
   date_default_timezone_set("RPC");
   if($_POST['Submit']=="保存")
   {
       $title=$_POST['txt_title'];
       $content=$_POST['txt_content'];
       $createtime=date("Y-m-d H:i:s");
       $sql=mysql_query("insert into tb_affiche(title,content,createtime)values('$title','$content','$createtime')");
       if($sql)
       {
           echo "<script> alert('信息添加成功！'); window.location.href='#'; <script/>";
       }
       else
       {
           echo "<script> alert('信息添加失败！'); window.location.href='#';<script/>";
       }
   }
   mysql_close();

?>
</body>
</html>

UPDATE

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<?php
    $id=$_GET['id'];
   $title = $_GET['title'];
   $content = $_GET['content'];
?>

<form action="#" name="form1" method="post">
   公告主题：
    <input type="text" name="txt_title" id="txt_title" value="<?php echo $title;?>" />
    <input type="hidden" name="id" value="<?php echo $id;?>" />
    <br />
    公告内容：
    <textarea name="txt_content" id="txt_content"><?php echo $content;?></textarea><br />
    <input type="submit" name="Submit" id="Submit" value="修改" onclick="return check(form1)" />
    <input type="reset" name="Reset" id="Reset" value="重置" />
</form>

<script language="javascript">
   function check(form1)
   {
       if(form1.txt_title.value=="")
       {
           alert("请输入公告标题");
           form1.txt_title.focus();
           return false;
       }
       if(form1.txt_content.value=="")
       {
           alert("请输入公告内容");
           form1.txt_content.focus();
           return false;
       }
   form1.submit();
   }
</script>

<?php
   $link=mysql_connect("localhost","root","a3141592654")or die("数据库服务器连接失败！".mysql_error());
   mysql_select_db("msphp",$link);
   mysql_query("set names utf-8");
   if($_POST['Submit']=="修改")
   {
       $id=$_POST['id'];
       $title=$_POST['txt_title'];
       $content=$_POST['txt_content'];
       $sql=mysql_query("update tb_affiche set title='".$title."',content='".$content."' where id='".$id."'");
       if($sql==false)
       {
           //echo "检索信息失败";
           echo "<script> alert('修改信息失败！'); history.back(); window.location.href='select2.php'; </script>";
       }
       else
       {
           //echo "检索信息成功";
           echo "<script> alert('修改信息成功！'); history.back(); window.location.href='select2.php'; </script>";
       }
   }
   ?>
</body>
</html>

DELECT

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<?php
   $id=$_GET['id'];
   $title=$_GET['title'];
   $content=$_GET['content'];
?>

<form name="form1" action="#" method="post">
   公告主题：
    <input type="text" name="txt_title" id="txt_title" value="<?php echo $title;?>" />
    <input type="hidden" name="id" value="<?php echo $id;?>" />
    <br />
    公告内容：
    <textarea name="txt_content"><?php echo $content;?></textarea>
    <br />
    <input type="submit" name="Submit" value="删除" />
</form>

<?php
   $link=mysql_connect("localhost","root","a3141592654")or die("数据库服务器连接失败!".mysql_error());
   mysql_select_db("msphp",$link)or die("数据库连接失败！".mysql_error());
   mysql_query("set names utf-8");
   if($_POST['Submit']=="删除")
   {
       $id=$_POST['id'];
       $title=$_POST['txt_title'];
       $content=$_POST['txt_content'];
       $sql=mysql_query("delete from tb_affiche where id='".$id."'");
       if($sql==false)
       {
           echo "<script> alert('信息删除失败！');history.back();window.location.href='select2.php'</script>";
       }
       else
       {
           echo "<script> alert('信息删除成功！');history.back();window.location.href='select2.php'</script>";
       }
   }
   mysql_close();
?>
</body>
</html>

未附加数据库。

阅读全文

0 0