Advertisement
Guest User

Untitled

a guest
Oct 11th, 2016
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.63 KB | None | 0 0
  1. if(!isset($_SESSION["name"]) || empty($_SESSION["name"])) {
  2. header("Location: http://www.google");
  3. die();
  4. } else {
  5. $servername = "localhost";
  6. $username = "user";
  7. $password = "123";
  8.  
  9. // Create connection
  10. $conn = new mysqli($servername, $username, $password);
  11. $conn2 = new mysqli($servername, $username, $password);
  12. $conn3 = new mysqli($servername, $username, $password);
  13. $conn4 = new mysqli($servername, $username, $password);
  14. $conn5 = new mysqli($servername, $username, $password);
  15. $conn6 = new mysqli($servername, $username, $password);
  16.  
  17. if ($conn4->connect_error) {
  18. die("Connection failed: " . $conn4->connect_error);
  19. }
  20. $sql4 = "SELECT * FROM tableT WHERE date(ftdate) = curdate()";
  21. $result4 = $conn4->query($sql4);
  22. $row4 = $result4->fetch_assoc();
  23. $conn4->close();
  24. date_default_timezone_set("Asia/Kuala_Lumpur");
  25.  
  26. if ($result4->num_rows < 1) {
  27. if ($conn3->connect_error) {
  28. die("Connection failed: " . $conn3->connect_error);
  29. }
  30. $date = date("Y-m-d");
  31. $sql3 = 'INSERT INTO tableT (`id`, `date`) VALUES (Null, "' . $date . '")';
  32.  
  33. if ($conn3->query($sql3) === TRUE) {
  34. header("Location: http://google.com");
  35. die();
  36. } else {
  37. echo "Error: " . $sql3 . "<br>" . $conn3->error;
  38. }
  39. $conn3->close();
  40. } Else {
  41. // Check connection
  42. if ($conn->connect_error) {
  43. die("Connection failed: " . $conn->connect_error);
  44. }
  45. if ($conn2->connect_error) {
  46. die("Connection failed: " . $conn2->connect_error);
  47. }
  48.  
  49. $sql = "SELECT * FROM tableB WHERE something = '0'";
  50. $sql2 = "SELECT * FROM tableP WHERE id=1";
  51.  
  52. $result = $conn->query($sql);
  53. $conn->close();
  54.  
  55. $result2 = $conn2->query($sql2);
  56. $row2 = $result2->fetch_assoc();
  57. $conn2->close();
  58.  
  59.  
  60. if ($conn5->connect_error) {
  61. die("Connection failed: " . $conn5->connect_error);
  62. }
  63. $month = date("m");
  64. $sql5 = "SELECT * FROM tableB WHERE month(date) = '" . $month . "' AND something = '1' ORDER BY fid";
  65. $result5 = $conn5->query($sql5);
  66.  
  67. if ($result5->num_rows > 0) {
  68. $x = 1;
  69. $monthlyt = 0;
  70.  
  71. $y = 0;
  72. $dailyt = 0;
  73. $day = date("Y-m-d");
  74.  
  75. while($row5 = $result5->fetch_assoc()) {
  76. $monthlyt = $row5[ftotal] + $monthlyt;
  77. $x = $x + 1;
  78.  
  79. $dbdate = date("Y-m-d", strtotime($row5[fdate]));
  80.  
  81. if ($dbdate == $day) {
  82. $y = $y + 1;
  83. $dailyt = $row5[total] + $dailyt;
  84. }
  85. }
  86. $damount = ($y / $row2[something]) * 100;
  87. $dtotal = ($dailyt / $row2[some]) * 100;
  88. $mtotal = ($monthlyt / $row2[blah]) * 100;
  89. }
  90. $conn5->close();
  91.  
  92. if ($conn6->connect_error) {
  93. die("Connection failed: " . $conn6->connect_error);
  94. }
  95.  
  96. $sql6 = 'UPDATE tableT SET something="' . $y . '", some="' . $blah. '" WHERE tdate="' . $day . '"';
  97.  
  98. if ($conn6->query($sql6) === TRUE) {
  99. //done
  100. } else {
  101. echo "Error: " . $sql6 . "<br>" . $conn6->error;
  102. }
  103. $conn6->close();
  104. }
  105. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement