php网站开发学习收获交流 (php软件开发参考文献)

效果展示

数据库设计

CREATE DATABASE comments; //建立数据库

//创建comments表以及字段
$sql = "CREATE TABLE `comments` (
 `id` int(11) NOT NULL auto_increment,
 `user` varchar(30) NOT NULL,
 `comment` varchar(200) NOT NULL,
 `addtime` datetime NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM; " ;

数据库设计

主页面index创建

<style type="text/css">
 .demo{
 width:500px;
 margin: 0 auto;
 }
 h3{
 font-size:18px
 }
 #comments{
 margin:10px auto
 }
 #post{
 margin-top:10px
 }
 #comments p,#post p{
 line-height:30px
 }
 #comments p span{
 margin:4px; color:#999
 }
 #message{
 position:absolute;
 top: 50%;
 left: 50%;
 display:none;
 width:300px;
 height: 80px;
 padding:4px;
 background: rgba(0,0,0,0.5);
 color: #fff;
 text-align: center;
 line-height: 80px;
 z-index:1001;
 font-size: 30px;
 border-radius: 10px;
 }
 </style>

 <div id="post">
	 <h3>发表评论</h3>
	 <p>昵称：</p>
	 <p><input type="text" class="input" id="user" /></p>
	 <p>评论内容：</p>
	 <p><textarea class="input" id="txt" style="width:100%; height:80px"></textarea></p>
	 <p><input type="submit" value="发表" id="add"/></p>
	 <div id="message"></div>
 </div>
 	 <div id="comments">
	 <h3>评论列表</h3>
	 </div>
</div>

<script type="text/javascript" src="jQuery.js"></script>

<script type="text/javascript">
	
 $(function(){
 	var count = 0;
 var comments = $("#comments");

 //从数据库获取数据展示
 $.ajax({
 	type:’get’,
 	url:’server.php’,
 	dataType:’json’,
 	success:function(data){
 console.log(data);
 count = data.length;
 $.each(data,function(i,v){
 var txt = "<p><span>第"+(i+1)+"条</span><strong>"+v.user+"</strong>："+v.comment+"<span>"+v.addtime+"</span></p>";
 comments.append(txt);
 })
 	}
 });
 
 //点击发表评论，并把数据展示
 	 $("#add").click(function(){
 	 	var user = $("#user").val();
 	 	var txt = $("#txt").val();
 	 	$.ajax({
 	 		type:’POST’,
 	 		url:"comment.php",
 	 		data:"user="+user+"&txt="+txt,
 	 		success:function(msg){
 	 			 if(msg==1){
 var str = "<p><span>第"+(count+1)+"条</span><strong>"+user+"</strong>："+txt+"<span>刚刚</span></p>";
 comments.append(str);
 $("#message").show().html("发表成功！").fadeOut(2000);
 $("#txt,#user").attr("value","");
 }else{
 $("#message").show().html(msg).fadeOut(2000);
 }
 	 		}
 	 	})
 	 })
 })
</script>

comment.php页面创建 数据库插入数据

<?php
	header("Content-type:text/html;charset=utf-8"); //设置编码
	$user = htmlspecialchars(trim($_POST[’user’]));
	$txt = htmlspecialchars(trim($_POST[’txt’]));
	$time = date("Y-m-d H:i:s");
	if(empty($user)){
	 echo "昵称不能为空！";
	 exit;
	}
	if(empty($txt)){
	 echo "评论内容不能为空！";
	 exit;
	}
	$conn=mysqli_connect("localhost","root","root","comments");

	mysqli_set_charset($conn,"utf8");

	$sql="insert into comments(user,comment,addtime)values(’$user’,’$txt’,’$time’)";

	$que=mysqli_query($conn,$sql);
	
	if($que) echo "1"; //写入数据返回判断
?>

servephp页面创建 数据读取页面

<?php
	header("Content-type:text/html;charset=utf-8"); //设置编码
	$conn=mysqli_connect("localhost","root","root","comments");
	mysqli_set_charset($conn,"utf8");
	$sql="SELECT * from comments";
	$que=mysqli_query($conn,$sql);
	while($row=mysqli_fetch_array($que)){

	 $comments[] = array("id"=>$row["id"],"user"=>$row["user"],"comment"=>$row["comment"],"addtime"=>$row["addtime"]);

	}
 
	echo json_encode($comments); //返回数据
?>