PHP增刪改查項(xiàng)目的實(shí)戰(zhàn)詳解

第PHP增刪改查項(xiàng)目的實(shí)戰(zhàn)詳解sql:

--phpMyAdminSQLDump

--version4.5.1

--

--Host:

--GenerationTime:2025-03-1517:51:32

--服務(wù)器版本：10.1.13-MariaDB

--PHPVersion:5.6.21

SETSQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SETtime_zone="+00:00";

/*!40101SET@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT*/;

/*!40101SET@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS*/;

/*!40101SET@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION*/;

/*!40101SETNAMESutf8mb4*/;

--Database:`a`

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

--表的結(jié)構(gòu)`search`

CREATETABLE`search`(

`id`int(11)NOTNULL,

`content`textCOLLATEutf8_vietnamese_ciNOTNULLCOMMENT'內(nèi)容'

)ENGINE=InnoDBDEFAULTCHARSET=utf8COLLATE=utf8_vietnamese_ci;

--轉(zhuǎn)存表中的數(shù)據(jù)`search`

INSERTINTO`search`(`id`,`content`)VALUES

(21,'陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴'),

(22,'陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴'),

(23,'陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴'),

(24,'陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴陳作業(yè)貴'),

(25,'陳作業(yè)貴'),

(26,'陳作業(yè)貴'),

(27,'陳作業(yè)貴'),

(28,'陳作業(yè)貴'),

(29,'000000'),

(30,'');

--Indexesfordumpedtables

--Indexesfortable`search`

ALTERTABLE`search`

ADDPRIMARYKEY(`id`);

--在導(dǎo)出的表使用AUTO_INCREMENT

--使用表AUTO_INCREMENT`search`

ALTERTABLE`search`

MODIFY`id`int(11)NOTNULLAUTO_INCREMENT,AUTO_INCREMENT=67;

/*!40101SETCHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT*/;

/*!40101SETCHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS*/;

/*!40101SETCOLLATION_CONNECTION=@OLD_COLLATION_CONNECTION*/;

cyg.php

php

$link=mysqli_connect('localhost','root','','a');

//然后是指定php鏈接數(shù)據(jù)庫(kù)的字符集

mysqli_set_charset($link,'utf8');

$sql="select*fromsearch";

//模糊查詢(xún)出像數(shù)據(jù)庫(kù)中的title或者content里面的值或者說(shuō)像數(shù)據(jù)庫(kù)中的title或者content里面的某一段值相對(duì)應(yīng)的就行了,就可以輸出啦

$result=mysqli_query($link,$sql);//運(yùn)行sql

!--顯示的效果--

!DOCTYPEhtml

htmllang="en"

head

metacharset="UTF-8"

titleDocument/title

/head

body

tableborder="1"cellpadding="5"

tdid/td

td標(biāo)題/td

td內(nèi)容/td

php

while($row=mysqli_fetch_array($result)){//把對(duì)象編程數(shù)組輸出，不然會(huì)報(bào)錯(cuò)哦

#code...

td=$row['id'];/td

td=$row['content'];/td

tdahref="update.phpid=phpecho$row['id'];"更新/a/td

tdahref="delete.phpid=phpecho$row['id'];"刪除/a/td

tdahref="create.php"創(chuàng)建/a/td

/tr

php

/tr

/table

/body

/html

delete.php

php

$link=mysqli_connect('localhost','root','','a');

//然后是指定php鏈接數(shù)據(jù)庫(kù)的字符集

mysqli_set_charset($link,'utf8');

//$sql="DELETEFROM`search`WHERE`id`='$_POST[id]'";

//模糊查詢(xún)出像數(shù)據(jù)庫(kù)中的title或者content里面的值或者說(shuō)像數(shù)據(jù)庫(kù)中的title或者content里面的某一段值相對(duì)應(yīng)的就行了,就可以輸出啦

$result=mysqli_query($link,"DELETEFROMsearchWHEREid='$_GET[id]'");//運(yùn)行sql

$sql="select*fromsearch";

//模糊查詢(xún)出像數(shù)據(jù)庫(kù)中的title或者content里面的值或者說(shuō)像數(shù)據(jù)庫(kù)中的title或者content里面的某一段值相對(duì)應(yīng)的就行了,就可以輸出啦

$result=mysqli_query($link,$sql);//運(yùn)行sql

!--顯示的效果--

!DOCTYPEhtml

htmllang="en"

head

metacharset="UTF-8"

titleDocument/title

/head

body

tableborder="1"cellpadding="5"

tdid/td

td標(biāo)題/td

td內(nèi)容/td

php

while($row=mysqli_fetch_array($result)){//把對(duì)象編程數(shù)組輸出，不然會(huì)報(bào)錯(cuò)哦

#code...

td=$row['id'];/td

td=$row['content'];/td

tdahref="update.phpid==$row['id'];"更新/a/td

tdahref="delete.phpid==$row['id'];"刪除/a/td

tdahref="create.php"創(chuàng)建/a/td

/tr

php

/tr

/table

/body

/html

update.php

!DOCTYPEhtml

htmllang="en"

head

metacharset="UTF-8"

titleDocument/title

/head

body

formaction="update.php"method="GET"

inputtype="hidden"name="id"value="phpecho$_GET['id']"

inputtype="text"name="content"

inputtype="submit"value="搜索"

/form

/body

/html

php

$link=mysqli_connect('localhost','root','','a');

//然后是指定php鏈接數(shù)據(jù)庫(kù)的字符集

mysqli_set_charset($link,'utf8');

//$sql="DELETEFROM`search`WHERE`id`='$_POST[id]'";

//模糊查詢(xún)出像數(shù)據(jù)庫(kù)中的title或者content里面的值或者說(shuō)像數(shù)據(jù)庫(kù)中的title或者content里面的某一段值相對(duì)應(yīng)的就行了,就可以輸出啦

$result=mysqli_query($link,"UPDATEsearchsetcontent='$_GET[content]'WHEREid='$_GET[id]'");//運(yùn)行sql

$sql="select*fromsearch";

//模糊查詢(xún)出像數(shù)據(jù)庫(kù)中的title或者content里面的值或者說(shuō)像數(shù)據(jù)庫(kù)中的title或者content里面的某一段值相對(duì)應(yīng)的就行了,就可以輸出啦

$result=mysqli_query($link,$sql);//運(yùn)行sql

!--顯示的效果--

!DOCTYPEhtml

htmllang="en"

head

metacharset="UTF-8"

titleDocument/title

/head

body

tableborder="1"cellpadding="5"

tdid/td

td標(biāo)題/td

td內(nèi)容/td

php

while($row=mysqli_fetch_array($result)){//把對(duì)象編程數(shù)組輸出，不然會(huì)報(bào)錯(cuò)哦

#code...

td=$row['id'];/td

td=$row['content'];/td

tdahref="update.phpid==$row['id'];"更新/a/td

tdahref="delete.phpid==$row['id'];"刪除/a/td

tdahref="create.php"創(chuàng)建/a/td

/tr

php

/tr

/table

/body

/html

create.php

!DOCTYPEhtml

htmllang="en"

head

metacharset="UTF-8"

titleDocument/title

/head

body

formaction="create.php"method="POST"

inputtype="text"name="content"

inputtype="submit"value="提交"

/form

/body

/html

php

if(!$_POST['content'])

exit();

$content=$_POST['content'];

$l