Advertisement
Guest User

Untitled

a guest
Mar 10th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.70 KB | None | 0 0
  1. <script type="text/javascript" src="jquery.js"></script>
  2.  
  3. <script type="text/javascript">
  4. var auto_refresh = setInterval(
  5. function(){
  6. $('#message_display').load('show_messages_public.php');
  7. }, 5000);
  8. </script>
  9.  
  10. <?php
  11. session_start();
  12.  
  13. function show_messages()
  14. {
  15. $mysql_host = "******";
  16. $mysql_database = "*******";
  17. $mysql_user = "*****";
  18. $mysql_password = "*****";
  19.  
  20. $link= mysql_connect($mysql_host, $mysql_user, $mysql_password);
  21.  
  22. if (!$link) {
  23. die('could not connect:' . mysql_error());
  24. }
  25.  
  26. $db_selected= mysql_select_db($mysql_database);
  27.  
  28. if (!$db_selected) {
  29. die('can't use' . $mysql_database . ':' . mysql_error());
  30. }
  31.  
  32. $query= "SELECT * FROM public_chat ORDER BY time DESC LIMIT 2";
  33. $result= mysql_query($query) or die(mysql_error());
  34. while($row= mysql_fetch_array ($result)) {
  35. echo '<br/><font color="black">' .$row['time'] . "<br>" . '<b><big>' . '<font color="black">' . $row['user'] . ':' . '</big></b>' . " <br> " . $row['message'] .'</font>';
  36. echo "<br/><hr width="95%"<br/>"/*"<hr width="90%">"*/;
  37. }
  38. }
  39. ?>
  40.  
  41. $('#message_display').load('show_messages_public.php?startInt=1&repeatTimes=5&incrementIncrease=3');
  42.  
  43. <?
  44. var startInt = $_GET['startInt'];
  45. var repeatTimes = $_GET['repeatTimes'];
  46. var incrementIncrease = $_GET['incrementIncrease'];
  47.  
  48. var str = "";
  49. for (var i = startInt; i < repeatTimes * incrementIncrease + startInt; i += incrementIncrease) {
  50. str .= i."|";
  51. }
  52.  
  53. echo str;
  54. ?>
  55.  
  56. setInterval(function() {
  57. $('#message_display').load('show_messages_public.php?callfunc=true');
  58. }, 5000);
  59.  
  60. if ($_GET['callfunc'] == "true")
  61. show_messages();
  62.  
  63. $('#message_display').load('show_messages_public.php', {showmsg: 'public'});
  64.  
  65. switch($_POST['showmsg']) {
  66. case 'public':
  67. show_messages();
  68. break;
  69. }
  70.  
  71. <?php
  72. session_start();
  73.  
  74. $mysql_host = "******";
  75. $mysql_database = "*******";
  76. $mysql_user = "*****";
  77. $mysql_password = "*****";
  78.  
  79. $link= mysql_connect($mysql_host, $mysql_user, $mysql_password);
  80.  
  81. if (!$link) {
  82. die('could not connect:' . mysql_error());
  83. }
  84.  
  85. $db_selected= mysql_select_db($mysql_database);
  86.  
  87. if (!$db_selected) {
  88. die('can't use' . $mysql_database . ':' . mysql_error());
  89. }
  90.  
  91. $query= "SELECT * FROM public_chat ORDER BY time DESC LIMIT 2";
  92. $result= mysql_query($query) or die(mysql_error());
  93. while($row= mysql_fetch_array ($result)) {
  94. echo '<br/><font color="black">' .$row['time'] . "<br>" . '<b><big>' . '<font color="black">' . $row['user'] . ':' . '</big></b>' . " <br> " . $row['message'] .'</font>';
  95. echo "<br/><hr width="95%"<br/>"/*"<hr width="90%">"*/;
  96. }
  97. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement