API tools faq
paste
Advertisement
Transformator

php013

Transformator
Sep 24th, 2014
267
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.10 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE HTML>
  2. <meta charset="utf-8">
  3.  
  4. <style>
  5.  
  6. * {
  7. font-family: "Comic sans ms";
  8. }
  9.  
  10. td { width: 200px; }
  11.  
  12. input { width: 40px; }
  13.  
  14. .today { color: red; }
  15.  
  16. </style>
  17.  
  18. <div id="main">
  19.  
  20. <?php
  21.  
  22. mysql_connect("localhost", "root", "");
  23. mysql_select_db("karlender");
  24.  
  25. $arrayOfDays =
  26. array(
  27. array("01","09","2014"),
  28. array("02","09","2014"),
  29. array("03","09","2014"),
  30. array("04","09","2014"),
  31. array("05","09","2014"),
  32. array("06","09","2014"),
  33. array("07","09","2014"),
  34. array("08","09","2014"),
  35. array("09","09","2014"),
  36. array("10","09","2014"),
  37. array("11","09","2014"),
  38. array("12","09","2014"),
  39. array("13","09","2014"),
  40. array("14","09","2014"),
  41. array("15","09","2014"),
  42. array("16","09","2014"),
  43. array("17","09","2014"),
  44. array("18","09","2014"),
  45. array("19","09","2014"),
  46. array("20","09","2014"),
  47. array("21","09","2014"),
  48. array("22","09","2014"),
  49. array("23","09","2014"),
  50. array("24","09","2014"),
  51. array("25","09","2014"),
  52. array("26","09","2014"),
  53. array("27","09","2014"),
  54. array("28","09","2014"),
  55. array("29","09","2014"),
  56. array("30","09","2014"),
  57.  
  58. array("01","10","2014"),
  59. array("02","10","2014"),
  60. array("03","10","2014"),
  61. array("04","10","2014"),
  62. array("05","10","2014"),
  63. array("06","10","2014"),
  64. array("07","10","2014"),
  65. array("08","10","2014"),
  66. array("09","10","2014"),
  67. array("10","10","2014"),
  68. array("11","10","2014"),
  69. array("12","10","2014"),
  70. array("13","10","2014"),
  71. array("14","10","2014"),
  72. array("15","10","2014"),
  73. array("16","10","2014"),
  74. array("17","10","2014"),
  75. array("18","10","2014"),
  76. array("19","10","2014"),
  77. array("20","10","2014"),
  78. array("21","10","2014"),
  79. array("22","10","2014"),
  80. array("23","10","2014"),
  81. array("24","10","2014"),
  82. array("25","10","2014"),
  83. array("26","10","2014"),
  84. array("27","10","2014"),
  85. array("28","10","2014"),
  86. array("29","10","2014"),
  87. array("30","10","2014"),
  88. array("31","10","2014"),
  89.  
  90. array("01","11","2014"),
  91. array("02","11","2014"),
  92. array("03","11","2014"),
  93. array("04","11","2014"),
  94. array("05","11","2014"),
  95. array("06","11","2014"),
  96. array("07","11","2014"),
  97. array("08","11","2014"),
  98. array("09","11","2014"),
  99. array("10","11","2014"),
  100. array("11","11","2014"),
  101. array("12","11","2014"),
  102. array("13","11","2014"),
  103. array("14","11","2014"),
  104. array("15","11","2014"),
  105. array("16","11","2014"),
  106. array("17","11","2014"),
  107. array("18","11","2014"),
  108. array("19","11","2014"),
  109. array("20","11","2014"),
  110. array("21","11","2014"),
  111. array("22","11","2014"),
  112. array("23","11","2014"),
  113. array("24","11","2014"),
  114. array("25","11","2014"),
  115. array("26","11","2014"),
  116. array("27","11","2014"),
  117. array("28","11","2014"),
  118. array("29","11","2014"),
  119. array("30","11","2014"),
  120.  
  121. array("01","12","2014"),
  122. array("02","12","2014"),
  123. array("03","12","2014"),
  124. array("04","12","2014"),
  125. array("05","12","2014"),
  126. array("06","12","2014"),
  127. array("07","12","2014"),
  128. array("08","12","2014"),
  129. array("09","12","2014"),
  130. array("10","12","2014"),
  131. array("11","12","2014"),
  132. array("12","12","2014"),
  133. array("13","12","2014"),
  134. array("14","12","2014"),
  135. array("15","12","2014"),
  136. array("16","12","2014"),
  137. array("17","12","2014"),
  138. array("18","12","2014"),
  139. array("19","12","2014"),
  140. array("20","12","2014"),
  141. array("21","12","2014"),
  142. array("22","12","2014"),
  143. array("23","12","2014"),
  144. array("24","12","2014"),
  145. array("25","12","2014"),
  146. array("26","12","2014"),
  147. array("27","12","2014"),
  148. array("28","12","2014"),
  149. array("29","12","2014"),
  150. array("30","12","2014"),
  151. array("31","12","2014")
  152. );
  153.  
  154. if(isset($_POST["day"]) && isset($_POST["month"]) && isset($_POST["year"]) && isset($_POST["hour"]) && isset($_POST["hour"]) && isset($_POST["text"]))
  155. {
  156. $day = $_POST["day"];
  157. $month = $_POST["month"];
  158. $year = $_POST["year"];
  159. $hour = $_POST["hour"];
  160. $minute = $_POST["minute"];
  161. $txt = $_POST["text"];
  162.  
  163. mysql_query("INSERT INTO entries (day, month, year, hour, minute, txt) VALUES('$day', '$month', '$year', '$hour', '$minute', '$txt')");
  164. echo mysql_error() . "<br>";
  165. }
  166.  
  167. foreach ($arrayOfDays as $value)
  168. {
  169. $day = $value[0];
  170. $month = $value[1];
  171. $year = $value[2];
  172.  
  173. $date = date("d.m.Y");
  174. if($date == $day . "." . $month . "." . $year)
  175. echo "<b class='today'>" . $day . "." . $month . "." . $year . "</b><br>";
  176. else echo "<b>" . $day . "." . $month . "." . $year . "</b><br>";
  177.  
  178. $result = mysql_query("SELECT * FROM entries WHERE day = '$day' AND month = '$month' AND year = '$year'");
  179.  
  180. while($obj = mysql_fetch_object($result))
  181. {
  182. if($date == $day . "." . $month . "." . $year)
  183. echo "<table class='today'><tr>";
  184. else echo "<table><tr>";
  185. echo "<td>" . $obj->hour . ":" . $obj->minute . "</td>";
  186. echo "<td>" . $obj->txt . "</td>";
  187. echo "</tr></table>";
  188. }
  189. }
  190.  
  191. ?>
  192.  
  193. </div>
  194.  
  195. <p>
  196. <form target="" method="post">
  197. <input type="text" name="day"> .
  198. <input type="text" name="month"> .
  199. <input type="text" name="year"> ->
  200. <input type="text" name="hour"> :
  201. <input type="text" name="minute"> ---
  202. <input type="text" name="text" style="width:200px">
  203. <input type="submit" value="Einfügen" style="width:200px">
  204. </form>
  205. </p>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!