如何用PHP和mysql創建一個ShoutBox
作為一個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 /><!-- I could just send them to index.phpautomatically, but then they'd wonder if it created correctly or not. --> 點擊 <a href='http://www.cgvv.com.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'><!--body,td,th { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;}--></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>
網公網安備