Advertisement
Different55

jQuery PHP MySQL and stuff

Mar 24th, 2012
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. $(document).ready(function(){
  2.  
  3. $(".reload").click(function() {
  4. $("div#update").fadeOut("fast")
  5. .load("home.php div#update").fadeIn("fast")
  6. });
  7. });
  8.  
  9. function statusUpdate() {
  10.  
  11. $service_query = mysql_query("SELECT * FROM service ORDER BY status");
  12. $service_num = mysql_num_rows($service_query);
  13.  
  14. for ($x=1;$x<=$service_num;$x++) {
  15. $service_row = mysql_fetch_row($service_query);
  16.  
  17. $second_query = mysql_query("SELECT * FROM service WHERE sid='$service_row[0]'");
  18. $row = mysql_fetch_row($second_query);
  19.  
  20. $socket = @fsockopen($row[3], $row[4], $errnum, $errstr, 0.01);
  21. if ($errnum >= 1) { $status = 'offline'; } else { $status = 'online'; }
  22.  
  23. mysql_query("UPDATE service SET status='$status' WHERE sid='$row[0]'")
  24. or die(mysql_error());
  25.  
  26. ?>
  27.  
  28. <ul><li style="min-width:190px;"><?php echo $row[1]; ?></li>
  29. <li style="min-width: 190px;" title="DNS: <?php echo $row[2]; ?>">
  30. <?php echo $row[3] . ':' . $row[4]; ?></li>
  31. <li class="<?php echo $status; ?>" style="min-width:80px;"><div id="update">
  32. <?php echo $status; ?></div></li></ul>
  33.  
  34. <?php
  35.  
  36. }
  37. }
  38.  
  39. ?>
  40.  
  41. <?php statusUpdate(); ?>
  42.  
  43. $(document).ready(function(){
  44.  
  45. $(".reload").click(function() {
  46. $("div#update").fadeOut("fast");
  47. $.ajax({
  48. url:'home.php',
  49. data:{type:'getStatus'},
  50. type;'post',
  51. success:function(data){
  52. $('div#update').html(data).fadeIn('fast');
  53. }
  54. });
  55. });
  56. });
  57.  
  58. <?php
  59. $type= $_POST['type'];
  60. if($type=="getStatus")
  61. {
  62. //get statuses from data base and return only formatted statuses in html
  63. }
  64. else
  65. {
  66. //your page codes here
  67. //like tags <html>,<body> etc, all regular tags
  68. //<script> tags etc
  69. }
  70. ?>
  71.  
  72. .load("home.php div#update").fadeIn("fast")
  73.  
  74. $('div#update').load('home.php', function(data) {
  75. $('div#update').html(data).fadeIn("fast");
  76. });
  77.  
  78. var $data = $('div#update');
  79. $data.fadeOut('slow', function() {
  80. $data.load('home.php div#update', function() {
  81. $data.fadeIn('slow');
  82. });
  83. });
  84.  
  85. var $data = $('div#update');
  86. $data.fadeOut('slow', function() {
  87. $data.load('phpcode.php div#update', function() {
  88. $data.fadeIn('slow');
  89. });
  90. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement