PHP留言并展示_php实例之显示留言信息

php实例之显示最新三条留言信息。

代码：

显示留言信息-www.jbxue.com

显示最新的三条留言

$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 ) )

{

?>

名称: <?php echo $row["name"]; ?>	电子邮箱: ?>">
$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; ?>
评论: <?php echo $row["comments"]; ?>

您可能感兴趣的文章：