文章詳情頁

如何用PHP和mysql創建一個ShoutBox

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

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

--- 文件 #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';?>

創建一個有四個字段的數據表. 我們命名為shouts. 此前可能你沒有這個SQL文件, 創建一個PHP文件'install.php'. 這個文件用過一次之后，記得要刪除它！

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

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

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

//連接數據庫

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

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

// 現在確定沒有相同名字的表, 創建它$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'....';// 關閉連接$result= @mysql_query($sql,$connection) or die(mysql_error());?><html><head><title>Simply Shouting - 安裝</title></head><body><br />你的安裝過程已經完成.; 請立即從你的服務器上刪除所有安裝文件.; 本程序包含以下安裝文件:<br /><br />1) install.php<br /><br /><br /> 點擊 <a href='http://www.aoyou183.cn/bcjs/index.php'>這里</a>開始.</html>

這是主文件:

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

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

//包含數據庫信息include_once('mysql.inc.php');//連接數據庫$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條留言. 首先，初始化一個計數器$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>

最后, 我們需要一個 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); // 包含數據信息; include_once('dbaccess.php'); // 連接數據庫 $connection= @mysql_connect($host,$user,$password) or die(mysql_error()); $db= @mysql_select_db($name,$connection) or die(mysql_error()); //; 插入留言信息到數據庫 $sql='INSERT INTO `shouts`(`shoutby`,`shout`) VALUES('$shoutby','$shout')';//關閉連接$result= @mysql_query($sql,$connection); }}?><html><head></head><body onLoad='window.open('index.php','_self')'></body></html>

PHP

上一條：不需要mod_rewrite直接使用php實現偽靜態化頁面下一條：在ZendStudio 中開啟PHP 5.2.x 環境的遠程調試功能

排行榜

					
					JavaScript實現通訊錄功能
Docker容器如何更新打包并上傳到阿里云
JetBrains IntelliJ IDEA 配置優化技巧
ASP.NET MVC使用Session會話保持表單狀態
IDEA編譯亂碼Build Output提示信息亂碼
詳解瀏覽器的緩存機制
Django結合使用Scrapy爬取數據入庫的方法示例
asp中response.write("中文")或者js中文亂碼問題
告別AJAX實現無刷新提交表單
ASP腳本組件實現服務器重啟
PHP設計模式中工廠模式深入詳解
				