如何用PHP和mysql创建一个ShoutBox

作者佚名技术来源 NET编程浏览发布时间 2012-05-26

ROM `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 id="newshout" name="newshout" action="newshout.php" method="post"><input name="shoutby" type="text" id="shoutby" onClick="javascript:this.value=''''" value="Enter your name here" size="24" maxlength="50" />
<br><br><input name="shout" type="text" id="shout" onClick="javascript:this.value=''''" value="Click & Shout!" size="24" maxlength="50" />
<br><br><input id="submit" 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= 如何用PHP和mysql创建一个ShoutBox - 凌众科技

网站建设|独享带宽服务器|优惠促销机型|付款方式|联系我们

快速业务通道

欢迎光临凌众科技，我们将竭诚为您提供最优质的服务！业务电话：0592-5908028 技术支持电话：0592-5908020

技术文章 > Web编程 > PHP编程 > 正文

文件 -1 text win2 服务域名

如何用PHP和mysql创建一个ShoutBox

作者佚名技术来源 NET编程浏览发布时间 2012-05-26

content

凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!