Advertisement
swimmerbhs

add

Apr 19th, 2014
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.23 KB | None | 0 0
  1. <?php
  2. session_start();
  3. if(!isset($_SESSION['username']))
  4. {
  5. session_destroy();
  6. header("location:index.php");
  7. }
  8. else{
  9. $results=mysqli_query($con, "select * from Users where `userName` ='$username'");
  10. $id = 'id_cust';
  11. }
  12.  
  13. if(isset($_POST['logout'])){
  14.  
  15. header("location:logout.php");
  16. }
  17. include 'database_connector.php';
  18. if(isset($_POST['insert'])){
  19. $artist = $_POST['artist'];
  20. $place = $_POST['place'];
  21. $hour = $_POST['hour'];
  22. $minute = $_POST['min'];
  23. $year = $_POST['year'];
  24. $month = $_POST['month'];
  25. $day = $_POST['day'];
  26. $price = $_POST['price'];
  27. $open = $_POST['open'];
  28. $time = $hour.':'.$minute;
  29. $date = $year.'-'.$month.'-'.$day;
  30. $result=mysqli_query($con,"insert into Concert values('$id','$artist','$date','$time','$place','$price','$open')");
  31. if($result)
  32. {
  33. echo 'Values updated successfully';
  34. }
  35. ?>
  36. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  37. <html xmlns="http://www.w3.org/1999/xhtml">
  38. <head>
  39. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  40. <title>Add Concert</title>
  41. </head>
  42. <body>
  43. <p>Please Fill out all information</p>
  44. <form name="addconcerts" method="post" action="addconcert.com">
  45. Artist:<input type="text" name="type" /> <br />
  46. Place:<input type="text" name="place" /><br />
  47. Approximant start time<select name="hour">
  48. <option value="">Hour</option>
  49. <option value="01">01</option>
  50. <option value="02">02</option>
  51. <option value="03">03</option>
  52. <option value="04">04</option>
  53. <option value="05">05</option>
  54. <option value="06">06</option>
  55. <option value="07">07</option>
  56. <option value="08">08</option>
  57. <option value="09">09</option>
  58. <option value="10">10</option>
  59. <option value="11">11</option>
  60. <option value="12">12</option>
  61. <option value="13">13</option>
  62. <option value="14">14</option>
  63. <option value="15">15</option>
  64. <option value="16">16</option>
  65. <option value="17">17</option>
  66. <option value="18">18</option>
  67. <option value="19">19</option>
  68. <option value="20">20</option>
  69. <option value="21">21</option>
  70. <option value="22">22</option>
  71. <option value="23">23</option>
  72. <option value="24">24</option>
  73. </selct>
  74. <select name="min">
  75. <option value="">Minute</option>
  76. <option value="00">00</option>
  77. <option value="15">15</option>
  78. <option value="30">30</option>
  79. <option value="45">35</option>
  80. </select>
  81. <select name="month">
  82. <option value="">Month</option>
  83. <option value = "1">January</option>
  84. <option value = "2">February</option>
  85. <option value = "3">March</option>
  86. <option value = "4">April</option>
  87. <option value = "5">May</option>
  88. <option value = "6">June</option>
  89. <option value = "7">July</option>
  90. <option value = "8">August</option>
  91. <option value = "9">September</option>
  92. <option value = "10">October</option>
  93. <option value = "11">November</option>
  94. <option value = "12">December</option>
  95. </select>
  96. <select name="day">
  97. <option value="">Day</option>
  98. <option value="01">01</option>
  99. <option value="02">02</option>
  100. <option value="03">03</option>
  101. <option value="04">04</option>
  102. <option value="05">05</option>
  103. <option value="06">06</option>
  104. <option value="07">07</option>
  105. <option value="08">08</option>
  106. <option value="09">09</option>
  107. <option value="10">10</option>
  108. <option value="11">11</option>
  109. <option value="12">12</option>
  110. <option value="13">13</option>
  111. <option value="14">14</option>
  112. <option value="15">15</option>
  113. <option value="16">16</option>
  114. <option value="17">17</option>
  115. <option value="18">18</option>
  116. <option value="19">19</option>
  117. <option value="20">20</option>
  118. <option value="21">21</option>
  119. <option value="22">22</option>
  120. <option value="23">23</option>
  121. <option value="24">24</option>
  122. <option value="25">25</option>
  123. <option value="26">26</option>
  124. <option value="27">27</option>
  125. <option value="28">28</option>
  126. <option value="29">29</option>
  127. <option value="30">30</option>
  128. <option value="31">31</option>
  129. </select>
  130. <select name="year">
  131. <option value="">Year</option>
  132. <option value="2014">2014</option>
  133. <option value="2015">2015</option>
  134. </select><br />
  135. Price<input type="text" name="price">
  136. Opening Act:<input type="text" name="open"><br><br>
  137. <input type="reset" name="reset" value="Reset">
  138. <input type="submit" name="Insert" value="Insert">
  139. </form>
  140. </body>
  141. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement