weinerwad3000

events.php

Jun 24th, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.50 KB | None | 0 0
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
  2. <html><head>
  3. <?php
  4.  
  5. include('db.php');
  6.  
  7. $sqlget = "SELECT * FROM user WHERE SelectDate = "params['selectDate'];
  8. $sqldata = mysql_query($sqlget);
  9.  
  10. ?>
  11.  
  12. <script type="text/javascript">
  13. var myVar = 'Hello';
  14. function displayMyVar(targetElementId) {
  15. document.getElementById(targetElementId).innerHTML = myVar;
  16. }
  17. </script><title>Calendar of Events</title>
  18. <center><h1 id="title">
  19.  
  20. </h1></center>
  21.  
  22. <script type="text/JavaScript" language="JavaScript">
  23.  
  24. function objectFromQueryString(string){
  25. var has = Object.prototype.hasOwnProperty;
  26.  
  27. if (arguments.length = 0) {
  28. string = window.location.search;
  29. }
  30.  
  31. // remove the leading "?"
  32. if (string[0] === "?") {
  33. string = string.slice(1);
  34. }
  35.  
  36. var parts = string.split("&");
  37. var obj = {};
  38.  
  39. parts.forEach(function(pair){
  40. var tmp = pair.split("=");
  41. var key = decodeURIComponent(tmp[0]);
  42. var value = decodeURIComponent(tmp[1]);
  43.  
  44. if (has.call(obj, key)) {
  45. if (typeof obj[key].push) {
  46. obj[key].push(value);
  47. }
  48. else {
  49. obj[key] = [obj[key], value];
  50. }
  51. }
  52. else {
  53. obj[key] = value;
  54. }
  55. });
  56.  
  57. return obj;
  58. }
  59.  
  60. </script></head><body style="background-color: transparent;" onload="changedate('return') ">
  61.  
  62. <script type="text/JavaScript" language="JavaScript">
  63. var params = objectFromQueryString(location.search);
  64. console.log(params['selectDate']);
  65. title.textContent = "Events for " + params['selectDate'];
  66.  
  67. </script>
  68.  
  69. <center>
  70. <a href="evtcalendar.htm">Go to Calendar</a><br>
  71. <br>
  72. &nbsp;
  73. <table style="width: 1584px; height: 1159px;" id="evtcal" border="0" cellpadding="0" cellspacing="0">
  74. <tbody>
  75. <tr>
  76. <td style="padding-top: 3px; padding-bottom: 3px; width: 600px; vertical-align: top; text-decoration: none; background-color: rgb(255, 255, 200); text-align: left;"><br>
  77. <form id="myForm" action="userInfo.php" method="post">
  78. Name &#8195;&#8195;&#8195;&#8195;&#8195;&#8195;: <input name="name" type="text"> Phone Number : <input name="phonenum" type="text">
  79. Number of People : <input name="numpeople" type="text">
  80. Tables &#8195;&#8195;&#8195;&nbsp;&#8195;: <input name="tables" type="text"><br><br>
  81. BBQ &#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&nbsp;&nbsp;: <input name="bbq" type="text">&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;&#8195;
  82. Notes &#8195;&#8195;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8195;: <textarea name="notes" type="text" rows="2" cols="30"></textarea>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  83. <input name="SelectDate" id="date" value="">
  84. <script type="text/JavaScript" language="JavaScript">
  85. date.value = params['selectDate'];
  86. </script>
  87. <button id="sub" style="width: 200px; height: 50px; font-size: 30px;">Save </button><br></form>
  88. <span id="result"></span>
  89. <table style="text-align: left; width: 100%; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="2">
  90. <tbody>
  91. <th>#</th>
  92. <th>Name</th>
  93. <th>Number of People</th>
  94. <th>Barbeque</th>
  95. <th>Tables</th>
  96. <th>Phone Number</th>
  97. <th>Notes</th>
  98.  
  99. <?php
  100.  
  101. while($user=mysql_fetch_assoc($sqldata)){
  102.  
  103. $i=1;
  104. echo "<tr>";
  105. echo "<td>"i"</td>";
  106. echo "<td>".$user['name']."</td>";
  107. echo "<td>".$user['numpeople']."</td>";
  108. echo "<td>".$user['tables']."</td>";
  109. echo "<td>".$user['bbq']."</td>";
  110. echo "<td>".$user['phonenum']."</td>;
  111. echo "<td>".$user['notes']."</td>;
  112. echo "</tr>";
  113. }
  114. ?>
  115.  
  116.  
  117. </tbody>
  118. </table>
  119. <br>
  120. <p style="font-family: Arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 11px; line-height: normal; font-size-adjust: none; font-stretch: normal;" align="center">This free script provided by<br>
  121. <a href="http://www.javascriptkit.com">JavaScript Kit</a> </p>
  122. </td>
  123. </tr>
  124. </tbody>
  125. </table>
  126. <span style="text-decoration: underline;"></span>
  127. <form id="eventform" name="eventform" action="#" method="get"></form>
  128. </center>
  129. <script src="script/jquery-1.8.1.min.js" type="text/javascript"></script>
  130. <script src="script/my_script/my_script.js" type="text/javascript"></script>
  131. </body></html>
Add Comment
Please, Sign In to add comment