php ajax.$post实现攒,顶,踩的功能_PHP教程

立即学习“PHP免费学习笔记（深入）”；

 header("Content-type:text/html;charset=utf-8");

 include "finger_ajax.php";

 $sql = "select * from finger_ajax";

 $res = mysql_query($sql,$link);

 while($row = mysql_fetch_array($res)){

  echo "

".$row['title']." @@##@@攒一下(".$row['finger'].")

 }

?>

 /**"攒" 功能 响应ajax请求*/

 //配置

 $dbHost = "localhost";

 $dbUser = "root";

 $dbPass = "dddddd";

 $dbName = "test";

 $dbCharset = "utf8";

 $link = mysql_connect($dbHost,$dbUser,$dbPass) or die(mysql_error());

 mysql_query("set names ".$dbCharset);

 mysql_select_db($dbName);

 // End

 //接受对应的id

 if(!empty($_POST['id'])){

  $id = $_POST['id'];

  //“攒”加1

  $sql = "update finger_ajax set finger=finger+1 where id=$id;";

  if(mysql_query($sql,$link)){

ViiTor实时翻译

AI实时多语言翻译专家！强大的语音识别、AR翻译功能。

116

查看详情

   echo "ok";

  }else{

   echo "failed";

  }

 }

?>

function finger(topic_id){

 $.post("finger_ajax.php", { "id": topic_id },

   function(data){

     if(data=="ok"){

   alert("感谢您的支持！");

  }else{

   alert("对不起，失败了！");

  }

   }, "text"); 

 //获取当前“攒”的次数并加1

 var finger = parseInt($(".finger"+topic_id).html())+1;

 //更新“攒”的次数

 $(".finger"+topic_id).html(finger);

}

DROP TABLE IF EXISTS `finger_ajax`;

CREATE TABLE `finger_ajax` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(50) NOT NULL DEFAULT '',

  `finger` int(11) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of finger_ajax

-- ----------------------------

INSERT INTO `finger_ajax` VALUES ('1', '今天天气还不错哦！去做点什么好呢？', '10');

INSERT INTO `finger_ajax` VALUES ('2', '欢迎来到 www.bKjia.c0m，国庆将至，祝大家国庆节快乐！！', '3');