API tools faq
paste
Guest User

Untitled

a guest
Jun 20th, 2018
88
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.69 KB | None | 0 0
raw download clone embed print report
  1. <link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.min.css">
  2. <script type="text/javascript" src="js/jquery.min.js"></script>
  3. <script src="bootstrap/js/bootstrap.min.js"></script>
  4. <meta charset="utf-8">
  5. <link href="css/estilos.css" rel="stylesheet" type="text/css" />
  6. <script src="js/jquery-3.2.1.min.js" type="text/javascript"></script>
  7.  
  8.  
  9. <body>
  10.  
  11. <div class="container">
  12. <div class="row">
  13. <div class="col-md-12">
  14. </div>
  15. </div>
  16. <div class="row">
  17. <div class="col-md-6">
  18. <div class="panel-body">
  19.  
  20. <!--Inicio elementos contenedor-->
  21.  
  22. <div class="comment-form-container">
  23. <form id="frm-comment">
  24. <div class="input-row">
  25. <input type="hidden" name="comentario_id" id="commentId"
  26. placeholder="Name" /> <input class="input-field"
  27. type="text" name="name" id="name" placeholder="Nombres" />
  28. </div>
  29. <div class="input-row">
  30. <textarea class="input-field" type="text" name="comment"
  31. id="comment" placeholder="Agregar comentario"> </textarea>
  32. </div>
  33. <div>
  34. <input type="button" class="btn-submit" id="submitButton"
  35. value="Publicar Ahora" /><div id="comment-message">Comentario ha sido agregado exitosamente!</div>
  36. </div>
  37. <div style="clear:both"></div>
  38. </form>
  39. </div>
  40. <div id="output"></div>
  41.  
  42. <script>
  43. var totalLikes = 0;
  44. var totalUnlikes = 0;
  45.  
  46. function postReply(commentId) {
  47. $('#commentId').val(commentId);
  48. $("#name").focus();
  49. }
  50.  
  51. $("#submitButton").click(function () {
  52. $("#comment-message").css('display', 'none');
  53. var str = $("#frm-comment").serialize();
  54.  
  55. $.ajax({
  56. url: "AgregarComentario.php",
  57. data: str,
  58. type: 'post',
  59. success: function (response)
  60. {
  61. var result = eval('(' + response + ')');
  62. if (response)
  63. {
  64. $("#comment-message").css('display', 'inline-block');
  65. $("#name").val("");
  66. $("#comment").val("");
  67. $("#commentId").val("");
  68. listComment();
  69. } else
  70. {
  71. alert("Failed to add comments !");
  72. return false;
  73. }
  74. }
  75. });
  76. });
  77.  
  78. $(document).ready(function () {
  79. listComment();
  80. });
  81.  
  82. function listComment() {
  83. $.post("ListaDeComentarios.php",
  84. function (data) {
  85. var data = JSON.parse(data);
  86.  
  87. var comments = "";
  88. var replies = "";
  89. var item = "";
  90. var parent = -1;
  91. var results = new Array();
  92.  
  93. var list = $("<ul class='outer-comment'>");
  94. var item = $("<li>").html(comments);
  95.  
  96. for (var i = 0; (i < data.length); i++)
  97. {
  98. var commentId = data[i]['comentario_id'];
  99. parent = data[i]['parent_comentario_id'];
  100.  
  101. var obj = getLikesUnlikes(commentId);
  102.  
  103. if (parent == "0")
  104. {
  105. if(data[i]['like_unlike'] >= 1)
  106. {
  107. like_icon = "<img src='img/MeGusta.png' id='unlike_" + data[i]['comentario_id'] + "' class='like-unlike' onClick='likeOrDislike(" + data[i]['comentario_id'] + ",-1)' />";
  108. like_icon += "<img style='display:none;' src='img/NoMeGusta.png' id='like_" + data[i]['comentario_id'] + "' class='like-unlike' onClick='likeOrDislike(" + data[i]['comentario_id'] + ",1)' />";
  109. }
  110. else
  111. {
  112. like_icon = "<img style='display:none;' src='img/MeGusta.png' id='unlike_" + data[i]['comentario_id'] + "' class='like-unlike' onClick='likeOrDislike(" + data[i]['comentario_id'] + ",-1)' />";
  113. like_icon += "<img src='img/NoMeGusta.png' id='like_" + data[i]['comentario_id'] + "' class='like-unlike' onClick='likeOrDislike(" + data[i]['comentario_id'] + ",1)' />";
  114.  
  115. }
  116.  
  117. comments = "
  118. <div class='comment-row'>
  119. <div class='comment-info'>
  120. <span class='commet-row-label'>De</span>
  121. <span class='posted-by'>" + data[i]['comment_sender_name'] + "</span>
  122. <span class='commet-row-label'>a las </span>
  123. <span class='posted-at'>" + data[i]['date'] + "</span>
  124. </div>
  125. <div class='comment-text'>" + data[i]['comment'] + "</div>
  126. <div>
  127. <a class='btn-reply' onClick='postReply(" + commentId + ")'>Responder</a>
  128. </div>
  129. <div class='post-action'> " + like_icon + "&nbsp;
  130. <span id='likes_" + commentId + "'> " + totalLikes + " Me Gusta </span>
  131. </div>
  132. </div>";
  133.  
  134. var item = $("<li>").html(comments);
  135. list.append(item);
  136. var reply_list = $('<ul>');
  137. item.append(reply_list);
  138. listReplies(commentId, data, reply_list);
  139. }
  140. }
  141. $("#output").html(list);
  142. });
  143. }
  144.  
  145. function listReplies(commentId, data, list) {
  146.  
  147. for (var i = 0; (i < data.length); i++)
  148. {
  149.  
  150. var obj = getLikesUnlikes(data[i].comentario_id);
  151. if (commentId == data[i].parent_comentario_id)
  152. {
  153. if(data[i]['like_unlike'] >= 1)
  154. {
  155. like_icon = "<img src='img/MeGusta.png' id='unlike_" + data[i]['comentario_id'] + "' class='like-unlike' onClick='likeOrDislike(" + data[i]['comentario_id'] + ",-1)' />";
  156. like_icon += "<img style='display:none;' src='img/NoMeGusta.png' id='like_" + data[i]['comentario_id'] + "' class='like-unlike' onClick='likeOrDislike(" + data[i]['comentario_id'] + ",1)' />";
  157.  
  158. }
  159. else
  160. {
  161. like_icon = "<img style='display:none;' src='img/NoMeGusta.png' id='unlike_" + data[i]['comentario_id'] + "' class='like-unlike' onClick='likeOrDislike(" + data[i]['comentario_id'] + ",-1)' />";
  162. like_icon += "<img src='img/NoMeGusta.png' id='like_" + data[i]['comentario_id'] + "' class='like-unlike' onClick='likeOrDislike(" + data[i]['comentario_id'] + ",1)' />";
  163.  
  164. }
  165. var comments = "
  166. <div class='comment-row'>
  167. <div class='comment-info'>
  168. <span class='commet-row-label'>De </span>
  169. <span class='posted-by'>" + data[i]['comment_sender_name'] + "</span>
  170. <span class='commet-row-label'>a las </span>
  171. <span class='posted-at'>" + data[i]['date'] + "</span>
  172. </div>
  173. <div class='comment-text'>" + data[i]['comment'] + "</div>
  174. <div>
  175. <a class='btn-reply' onClick='postReply(" + data[i]['comentario_id'] + ")'>Responder</a>
  176. </div>
  177. <div class='post-action'> " + like_icon + "&nbsp;
  178. <span id='likes_" + data[i]['comentario_id'] + "'> " + totalLikes + " Me Gusta </span>
  179. </div>
  180. </div>";
  181.  
  182. var item = $("<li>").html(comments);
  183. var reply_list = $('<ul>');
  184. list.append(item);
  185. item.append(reply_list);
  186. listReplies(data[i].comentario_id, data, reply_list);
  187. }
  188. }
  189. }
  190.  
  191. function getLikesUnlikes(commentId)
  192. {
  193.  
  194. $.ajax({
  195. type: 'POST',
  196. async: false,
  197. url: 'Envio_MeGusta.php',
  198. data: {comentario_id: commentId},
  199. success: function (data)
  200. {
  201. totalLikes = data;
  202. }
  203.  
  204. });
  205.  
  206. }
  207.  
  208.  
  209. function likeOrDislike(comentario_id,like_unlike)
  210. {
  211.  
  212. $.ajax({
  213. url: 'MeGusta_NoMeGusta.php',
  214. async: false,
  215. type: 'post',
  216. data: {comentario_id:comentario_id,like_unlike:like_unlike},
  217. dataType: 'json',
  218. success: function (data) {
  219.  
  220. $("#likes_"+comentario_id).text(data + " likes");
  221.  
  222. if (like_unlike == 1) {
  223. $("#like_" + comentario_id).css("display", "none");
  224. $("#unlike_" + comentario_id).show();
  225. }
  226.  
  227. if (like_unlike == -1) {
  228. $("#unlike_" + comentario_id).css("display", "none");
  229. $("#like_" + comentario_id).show();
  230. }
  231.  
  232. },
  233. error: function (data) {
  234. alert("error : " + JSON.stringify(data));
  235. }
  236. });
  237. }
  238.  
  239.  
  240.  
  241. </script>
  242.  
  243. <?php
  244. require_once ("Conexion.php");
  245. $commentId = isset($_POST['comentario_id']) ? $_POST['comentario_id'] : "";
  246. $comment = isset($_POST['comment']) ? $_POST['comment'] : "";
  247. $commentSenderName = isset($_POST['name']) ? $_POST['name'] : "";
  248. $date = date('Y-m-d H:i:s');
  249.  
  250. $sql = "INSERT INTO comentario(parent_comentario_id,comment,comment_sender_name,date) VALUES ('" . $commentId . "','" . $comment . "','" . $commentSenderName . "','" . $date . "')";
  251.  
  252. $result = mysqli_query($conn, $sql);
  253.  
  254. if (! $result) {
  255. $result = mysqli_error($conn);
  256. }
  257. echo $result;
  258. ?>
  259.  
  260. <?php
  261. require_once ("Conexion.php");
  262.  
  263. $commentId = $_POST['comentario_id'];
  264. $totalLikes = "No ";
  265. $likeQuery = "SELECT sum(like_unlike) AS likesCount FROM megusta_nomegusta WHERE comentario_id=".$commentId;
  266. $resultLikeQuery = mysqli_query($conn,$likeQuery);
  267. $fetchLikes = mysqli_fetch_array($resultLikeQuery,MYSQLI_ASSOC);
  268. if(isset($fetchLikes['likesCount'])) {
  269. $totalLikes = $fetchLikes['likesCount'];
  270. }
  271.  
  272. echo $totalLikes;
  273. ?>
  274.  
  275. <?php
  276. require_once ("Conexion.php");
  277. $memberId = 1;
  278. $sql = "SELECT comentario.*,megusta_nomegusta.like_unlike FROM comentario LEFT JOIN megusta_nomegusta ON comentario.comentario_id = megusta_nomegusta.comentario_id AND member_id = " . $memberId . " ORDER BY parent_comentario_id asc, comentario_id asc";
  279.  
  280. $result = mysqli_query($conn, $sql);
  281. $record_set = array();
  282. while ($row = mysqli_fetch_assoc($result)) {
  283. array_push($record_set, $row);
  284. }
  285. mysqli_free_result($result);
  286.  
  287. mysqli_close($conn);
  288. echo json_encode($record_set);
  289. ?>
  290.  
  291. <?php
  292. require_once ("Conexion.php");
  293.  
  294. $memberId = 1;
  295. $commentId = $_POST['comentario_id'];
  296. $likeOrUnlike = 0;
  297. if($_POST['like_unlike'] == 1)
  298. {
  299. $likeOrUnlike = $_POST['like_unlike'];
  300. }
  301.  
  302. $sql = "SELECT * FROM megusta_nomegusta WHERE comentario_id=" . $commentId . " and member_id=" . $memberId;
  303. $result = mysqli_query($conn, $sql);
  304. $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
  305.  
  306. if (! empty($row))
  307. {
  308. $query = "UPDATE megusta_nomegusta SET like_unlike = " . $likeOrUnlike . " WHERE comentario_id=" . $commentId . " and member_id=" . $memberId;
  309. } else
  310. {
  311. $query = "INSERT INTO megusta_nomegusta(member_id,comentario_id,like_unlike) VALUES ('" . $memberId . "','" . $commentId . "','" . $likeOrUnlike . "')";
  312. }
  313. mysqli_query($conn, $query);
  314.  
  315. $totalLikes = "No ";
  316. $likeQuery = "SELECT sum(like_unlike) AS likesCount FROM megusta_nomegusta WHERE comentario_id=".$commentId;
  317. $resultLikeQuery = mysqli_query($conn,$likeQuery);
  318. $fetchLikes = mysqli_fetch_array($resultLikeQuery,MYSQLI_ASSOC);
  319. if(isset($fetchLikes['likesCount'])) {
  320. $totalLikes = $fetchLikes['likesCount'];
  321. }
  322.  
  323. echo $totalLikes;
  324. ?>
  325.  
  326. <link href="css/estilos.css" rel="stylesheet" type="text/css" />
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!