php实例之显示留言信息
php实例之显示最新三条留言信息。
代码:
<html> <head> <title>显示留言信息-www.jbxue.com</title> </head> <body> <h3>显示最新的三条留言</h3> <?php $rs = @mysql_connect( "localhost", "userName", "password" )or die( "Could not connect to MySQL" ); $rs = @mysql_select_db( "my_database" ) or die( "Could not select database" ); $sql = "select * from guestbook order by time desc limit 3"; $rs = @mysql_query( $sql ) or die( "Could not execute SQL query" ); while ( $row = mysql_fetch_array( $rs ) ) { ?> <table> <tr> <td><b>名称:</b> <?php echo $row["name"]; ?></td> <td><b>电子邮箱:</b> <a href="mailto:<?php echo $row["email"]; ?>"> <?php echo $row["email"]; ?></a> </td><tr> <tr><td colspan="2"> <?php $datetime = $row["time"]; $year = substr( $datetime, 0, 4 ); $mon = substr( $datetime, 4, 2 ); $day = substr( $datetime, 6, 2 ); $hour = substr( $datetime, 8, 2 ); $min = substr( $datetime, 10, 2 ); $sec = substr( $datetime, 12, 2 ); $orgdate = date("l F dS, Y h:i A",mktime( $hour, $min, $sec, $mon, $day, $year ) ); ?> 日期: <?php echo $orgdate; ?></td></tr> <tr><td colspan="2"><b>评论:</b> <?php echo $row["comments"]; ?></td></tr> </table> <br> <?php } ?> </body> </html>
您可能感兴趣的文章:
php实例之显示留言信息
php留言板功能模块有哪些
php xml留言板实例教程一
jsp+mysql留言本实例(2)
jsp+mysql留言本实例(2)-读取留言
WordPress常用的函数、方法汇总
js确认删除函数多实例
PHP导出csv,身份证出现科学计数法的问题
phpcms留言模块添加发送到邮箱提醒的功能
C#入门学习笔记之事件和委托的实例