<? if($submit){ include ("../../../connections/db_connect.php"); $query="insert into guests"; $query.="(guest_id,guest_name,guest_email,guest_time,guest_message)"; $query.="values(0000,'$name','$email',NULL,'$message')"; $sql=mysql_query($query); echo"insert into database success."; } else{ ?>

<? echo $numguest[0];?>个客户留下墨宝 <? $query="select * from guests order by guest_time desc"; $numguests=mysql_query($query); while($guest=mysql_fetch_array($numguests)){ ?>

姓名:<? echo $guest["guest_name"];?>	email:<? echo $guest["guest_email"];?>	<? $datefromdb=$guest["guest_time"]; $year=substr($datefromdb,0,4); $mon=substr($datefromdb,4,2); $day=substr($datefromdb,6,2); $hour=substr($datefromdb,8,2); $min=substr($datefromdb,10,2); $sec=substr($datefromdb,12,2); $orgdate=date("1FdS,Y h:i A",mktime($hour,$min,$sec,$mon,$day,$year)); echo"时间orgdate\n"; ?>
<? echo $guest["guest_message"];?>