search
Homephp教程php手册小案例:微型博客,案例:微型博客

小案例:微型博客,案例:微型博客

 

# 初级案例说明

源码下载

一、结构如下

conn.php  为连接数据库文件

index.php 为首页,也是博客列表页   select * from weibo where $id order by  id desc limit 10;

edit.php  为编辑页   UPDATE weibo SET `title`='$title',`contents`='$contents' where `id`='$hid'

del.php   为删除操作页

add.php   为添加页

view.php  为详情页

二、数据库 

  字段说明 id ,hit点击量,title标题,dates日期,contents内容

CREATE TABLE `weibo` (

  `id` int(5) NOT NULL AUTO_INCREMENT,

  `hit` int(11) NOT NULL,

  `title` varchar(50) NOT NULL,

  `dates` date NOT NULL,

  `contents` text NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

三、注意点:

1.编辑时候,在表单中使用了隐藏域进行传递id

2.在搜索的时候巧妙使用了where $w ,

if(!empty($_GET['keys'])){

   // $w = `title` like $_GET['keys'];

   $w = " `title` like '%" . $_GET ['keys'] . "%' ";  //使用模糊搜索

}else{

   $w = 1;  //此句代码转换到sql语句中没有实际意义。

            //sql语句为select * from `weibo` where 1 order by id desc limit 10;

}

 

不懂请留言(微信:moka_2024)

Statement
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools