Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- if(!isset($_SESSION['username']))
- {
- session_destroy();
- header("location:index.php");
- }
- else{
- $results=mysqli_query($con, "select * from Users where `userName` ='$username'");
- $id = 'id_cust';
- }
- if(isset($_POST['logout'])){
- header("location:logout.php");
- }
- include 'database_connector.php';
- if(isset($_POST['insert'])){
- $artist = $_POST['artist'];
- $place = $_POST['place'];
- $hour = $_POST['hour'];
- $minute = $_POST['min'];
- $year = $_POST['year'];
- $month = $_POST['month'];
- $day = $_POST['day'];
- $price = $_POST['price'];
- $open = $_POST['open'];
- $time = $hour.':'.$minute;
- $date = $year.'-'.$month.'-'.$day;
- $result=mysqli_query($con,"insert into Concert values('$id','$artist','$date','$time','$place','$price','$open')");
- if($result)
- {
- echo 'Values updated successfully';
- }
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Add Concert</title>
- </head>
- <body>
- <p>Please Fill out all information</p>
- <form name="addconcerts" method="post" action="addconcert.com">
- Artist:<input type="text" name="type" /> <br />
- Place:<input type="text" name="place" /><br />
- Approximant start time<select name="hour">
- <option value="">Hour</option>
- <option value="01">01</option>
- <option value="02">02</option>
- <option value="03">03</option>
- <option value="04">04</option>
- <option value="05">05</option>
- <option value="06">06</option>
- <option value="07">07</option>
- <option value="08">08</option>
- <option value="09">09</option>
- <option value="10">10</option>
- <option value="11">11</option>
- <option value="12">12</option>
- <option value="13">13</option>
- <option value="14">14</option>
- <option value="15">15</option>
- <option value="16">16</option>
- <option value="17">17</option>
- <option value="18">18</option>
- <option value="19">19</option>
- <option value="20">20</option>
- <option value="21">21</option>
- <option value="22">22</option>
- <option value="23">23</option>
- <option value="24">24</option>
- </selct>
- <select name="min">
- <option value="">Minute</option>
- <option value="00">00</option>
- <option value="15">15</option>
- <option value="30">30</option>
- <option value="45">35</option>
- </select>
- <select name="month">
- <option value="">Month</option>
- <option value = "1">January</option>
- <option value = "2">February</option>
- <option value = "3">March</option>
- <option value = "4">April</option>
- <option value = "5">May</option>
- <option value = "6">June</option>
- <option value = "7">July</option>
- <option value = "8">August</option>
- <option value = "9">September</option>
- <option value = "10">October</option>
- <option value = "11">November</option>
- <option value = "12">December</option>
- </select>
- <select name="day">
- <option value="">Day</option>
- <option value="01">01</option>
- <option value="02">02</option>
- <option value="03">03</option>
- <option value="04">04</option>
- <option value="05">05</option>
- <option value="06">06</option>
- <option value="07">07</option>
- <option value="08">08</option>
- <option value="09">09</option>
- <option value="10">10</option>
- <option value="11">11</option>
- <option value="12">12</option>
- <option value="13">13</option>
- <option value="14">14</option>
- <option value="15">15</option>
- <option value="16">16</option>
- <option value="17">17</option>
- <option value="18">18</option>
- <option value="19">19</option>
- <option value="20">20</option>
- <option value="21">21</option>
- <option value="22">22</option>
- <option value="23">23</option>
- <option value="24">24</option>
- <option value="25">25</option>
- <option value="26">26</option>
- <option value="27">27</option>
- <option value="28">28</option>
- <option value="29">29</option>
- <option value="30">30</option>
- <option value="31">31</option>
- </select>
- <select name="year">
- <option value="">Year</option>
- <option value="2014">2014</option>
- <option value="2015">2015</option>
- </select><br />
- Price<input type="text" name="price">
- Opening Act:<input type="text" name="open"><br><br>
- <input type="reset" name="reset" value="Reset">
- <input type="submit" name="Insert" value="Insert">
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement