文章詳情頁

如何用PHP和mysql創(chuàng)建一個(gè)ShoutBox

瀏覽：192日期：2024-02-25 09:15:46

作為一個(gè)PHP開發(fā)人員，我有時(shí)被要求作個(gè)shoutbox 。; 如果同樣的事情也發(fā)生在你身上，這里有一個(gè)快速指南。顯然，您要為它添加您自己的CSS在上面，但這里是基本思路。; 我們需要一個(gè)MySQL數(shù)據(jù)庫表和三個(gè)PHP文件。首先，我們需要一個(gè)文件保存數(shù)據(jù)庫信息

--- 文件 #1:mysql.inc.php---

<?php# Simply Shouting - ashoutboxexample# File name:mysql.inc.php# Description: A file to hold database info.$host='localhost';$user='database_user_name';$password='database_user_password';$name='database_name';?>

創(chuàng)建一個(gè)有四個(gè)字段的數(shù)據(jù)表. 我們命名為shouts. 此前可能你沒有這個(gè)SQL文件, 創(chuàng)建一個(gè)PHP文件'install.php'. 這個(gè)文件用過一次之后，記得要?jiǎng)h除它！

-- 文件 #2: install.php--

<?php# Simply Shouting - ashoutboxexample# File name: install.php# Description: Creates the database table.

// include the database info fileinclude('mysql.inc.php');

//連接數(shù)據(jù)庫

$connection= @mysql_connect($host,$user,$password) or die(mysql_error());$db= @mysql_select_db($name,$connection) or die(mysql_error());

//如果我們已經(jīng)有一個(gè)表名字叫做'shouts', 需要先刪除它$sql='DROP TABLE IF EXISTS `shouts`';$result= @mysql_query($sql,$connection) or die(mysql_error());

// 現(xiàn)在確定沒有相同名字的表, 創(chuàng)建它$sql='CREATE TABLE `shouts` ( `id` int(11) NOT NULL auto_increment, `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `shoutby` varchar(50) default NULL, `shout` varchar(50) default NULL, PRIMARY KEY `id` (`id`)) TYPE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1';echo'Creating table: 'shouts'....';// 關(guān)閉連接$result= @mysql_query($sql,$connection) or die(mysql_error());?><html><head><title>Simply Shouting - 安裝</title></head><body><br />你的安裝過程已經(jīng)完成.; 請(qǐng)立即從你的服務(wù)器上刪除所有安裝文件.; 本程序包含以下安裝文件:<br /><br />1) install.php<br /><br /><br /> 點(diǎn)擊 <a href='http://www.b3g6.com/bcjs/index.php'>這里</a>開始.</html>

這是主文件:

--- 文件 #3: index.php---

<?# Simply Shouting - ashoutboxexample# File name: index.php# Description: Main page to display our shouts.

//包含數(shù)據(jù)庫信息include_once('mysql.inc.php');//連接數(shù)據(jù)庫$connection= @mysql_connect($host,$user,$password) or die(mysql_error());$db= @mysql_select_db($name,$connection) or die(mysql_error());?><html><head><meta http-equiv='Content-Type' content='text/html; charset=utf-8'><style type='text/css'></style><body><div style='width:500px;height 400px; border:thin groove #519554;'><?// 顯示最新10條留言. 首先，初始化一個(gè)計(jì)數(shù)器$counting=0;

// we need a counter because I want to show our shouts in ASC order// (like a chat room)

$sql=mysql_query('SELECT * FROM `shouts`');while($data=mysql_fetch_array($sql)){//counts every row$counting=$counting+1;} //end while

// if the count comes back greater than 10, then we select the last// 10 shouts for display.

if($counting>10){$countlessten=$counting-9;$sql=mysql_query('SELECT * FROM `shouts` ORDER BY `shouts`.`id` ASC LIMIT $countlessten,10');}else{//else it doesn't matter, there's less than 10!$sql=mysql_query('SELECT * FROM `shouts` ORDER BY `shouts`.`id` ASC LIMIT 10');}while($data=mysql_fetch_array($sql)){//my timestamp field in the database is basically useless to me unless //I parse it. The following code parses the timestamp into things I //can use.$timestamp=$data['timestamp'];$postedyear=substr($timestamp,0,4);$postedmonth=substr($timestamp,5,2);$postedday=substr($timestamp,8,2);$postedtime=substr($timestamp,11,5);$newpostedtime='';$nomilitary=substr($postedtime,0,2);

// the hour is greater than 12, so we need to switch back to 1-12 and // add a 'pm'if($nomilitary>=13){ $nomilitary=$nomilitary-12; $newpostedtime=$nomilitary; $newpostedtime.=':'; $newpostedtime.=substr($postedtime,3,2) ; $newpostedtime.=' pm'; } if($newpostedtime!=''){ $postedtime=$newpostedtime; }else{ $postedtime.=' am'; }//now that we have the time, let's get the shout and the shouter

$shoutby=$data['shoutby'];$shout=$data['shout']; echo$postedmonth.'/'.$postedday.'/'.$postedyear.' at '.$postedtime.' - <strong>'.$shoutby.' said: </strong>'.$shout.'<br><br>';// looks like: 12/1/2008 at 5:02pm - Josh said: Yo Yo Yo!}//below is the HTML form for creating the shouts?><form name='newshout' action='newshout.php' method='post'><input name='shoutby' type='text' onClick='javascript:this.value=''' value='Enter your name here' size='24' maxlength='50' /><br><br><input name='shout' type='text' onClick='javascript:this.value=''' value='Click & Shout!' size='24' maxlength='50' /><br><br><input name='submit' type='submit' value='Shout!' /></form></div></body></html>

最后, 我們需要一個(gè) PHP 文件處理表單.

-- 文件#4: newshout.php--

<?# Simply Shouting - ashoutboxexample# File name: newshout.php# Description: Process the HTML form on index.phpand redirect.

//得到留言者姓名$shoutby=$_POST['shoutby'];if($shoutby=='Enter your name here'||$shoutby==''){//如果沒有輸入名字 $shoutby='Visitor';}if($_POST['shout']){// 留言信息 if($_POST['shout'] !='Click & Shout!'){ //they didn't shout the default, so continue processing $shout=$_POST['shout']; //替換掉'<'和'>'以阻止黑客 $shout=str_replace('<',' ',$shout); $shout=str_replace('>',' ',$shout); // 包含數(shù)據(jù)信息; include_once('dbaccess.php'); // 連接數(shù)據(jù)庫 $connection= @mysql_connect($host,$user,$password) or die(mysql_error()); $db= @mysql_select_db($name,$connection) or die(mysql_error()); //; 插入留言信息到數(shù)據(jù)庫 $sql='INSERT INTO `shouts`(`shoutby`,`shout`) VALUES('$shoutby','$shout')';//關(guān)閉連接$result= @mysql_query($sql,$connection); }}?><html><head></head><body onLoad='window.open('index.php','_self')'></body></html>

PHP

上一條：不需要mod_rewrite直接使用php實(shí)現(xiàn)偽靜態(tài)化頁面下一條：在ZendStudio 中開啟PHP 5.2.x 環(huán)境的遠(yuǎn)程調(diào)試功能

排行榜

					
					IntelliJ IDEA導(dǎo)入項(xiàng)目的方法
Spring Cloud Alibaba整合Sentinel的實(shí)現(xiàn)步驟
Android View 事件防抖的兩種方案
ASP常用源代碼的總結(jié)（下）
基于Java實(shí)現(xiàn)記事本功能
Java 實(shí)現(xiàn)定時(shí)任務(wù)的三種方法
docker鏡像完全卸載的操作步驟
vue 組件簡(jiǎn)介
IntelliJ IDEA配置Tomcat服務(wù)器的方法
IntelliJ IDEA導(dǎo)入jar包的方法
idea刪除項(xiàng)目的操作方法
				