Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php开发留言板的CRUD(增，删，改，查)操作_php实例

php开发留言板的CRUD(增，删，改，查)操作_php实例

WBOY
Release： 2016-06-07 17:25:33
Original
1478 people have browsed it

项目结构：

添加页面：                                说明：这里只注重操作，对界面的美工没有下工夫，希望大家理解......

列表页面：

修改页面：

项目中所需的sql：

复制代码 代码如下:

create database form;

use form;

CREATE TABLE `message` (
`id` tinyint(1) NOT NULL auto_increment,
`user` varchar(25) NOT NULL,
`title` varchar(50) NOT NULL,
`content` tinytext NOT NULL,
`lastdate` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;


conn.php
复制代码 代码如下:

$conn = @ mysql_connect("localhost", "root", "") or die("数据库链接错误");
mysql_select_db("form", $conn);
mysql_query("set names 'gbk'");
?>

add.php
复制代码 代码如下:

include 'conn.php';
if($_POST['submit']){
$sql="INSERT INTO message(id,user,title,content,lastdate) VALUES (NULL, '$_POST[user]', '$_POST[title]', '$_POST[content]', now())";
mysql_query($sql);

//页面跳转，实现方式为javascript
$url = "list.php";
echo "";
}
?>


用户：

标题：

内容：



list.php
复制代码 代码如下:

include 'conn.php';
?>
echo "";
?>

$sql="select * from message order by id";
$query=mysql_query($sql);
while ($row=mysql_fetch_array($query)){
?>











标题：=$row[title]?> 用户：=$row[user] ?>
编辑  |  删除
内容：=$row[content]?>
发表日期：=$row[lastdate]?>


delete.php
复制代码 代码如下:

include 'conn.php';
$id = $_GET['id'];
$query="delete from message where id=".$id;
mysql_query($query);
?>
//页面跳转，实现方式为javascript
$url = "list.php";
echo "";
?>

preEdit.php
复制代码 代码如下:

include 'conn.php';
$id=$_GET[id];
$query="SELECT * FROM message WHERE id =".$id;
$result=mysql_query($query);
while ($rs=mysql_fetch_array($result)){
?>


用户：

标题：

内容：





postEdit.php
复制代码 代码如下:

include 'conn.php';
$query="update message set user='$_POST[user]',title='$_POST[title]',content='$_POST[content]' where id='$_POST[id]'";
mysql_query($query);
?>
//页面跳转，实现方式为javascript
$url = "list.php";
echo "";
?>
Related labels：
php development message board
source：php.cn
Previous article：php文件操作实例代码_php实例 Next article：php提示Call-time pass-by-reference has been deprecated in的解决方法[已测]_php实例
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Is there a way to force the text in the flexbox to be vertically centered, no matter what other CSS code we have? I have the following CSS code that is part of a larger CSS code used in a website I'm deve...
From 2024-04-06 20:41:51
0
1
518
What are the best practices for displaying version information in web applications? I'm developing a web application. What are the best practices for displaying version infor...
From 2024-04-06 19:13:16
0
2
476
Should we use SSG to deploy dashboards created with Nuxt.js? We will develop a dashboard for internal use using Nuxt.js. Since this will be an internal...
From 2024-04-06 13:17:44
0
1
493
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template