Loading
How to pass datepicker value in form POST methed to PHP ?  
  • class="col-md-6">  
  • class="form-group">  
  • for="text">Set Date & Time:  
  • class="form-group">  
  • class='input-group date' id='datetimepicker1' name="datepicker" value="date">  
  • 'text' class="form-control" id="datepicker1" name="datepicker" value="date"/>  
  • class="input-group-addon">  
  • class="glyphicon glyphicon-calendar">  
  •   
  •   
  •   
  •   
  • class="form-group">  
  • for="text">Department:  
  • "text" class="form-control" name="department" placeholder="Select department " >  
  •   
  • class="form-group">  
  • for="text">Assign to:  
  • "text" class="form-control" name="assign" placeholder="Select" >  
  •   


  •   
  • "submit" name="submitform" class="btn btn-default" style="float:right;width:auto; padding:10px; font-size:16px; background-color:rgba(0,0,0,0.8); color:white;">Submit  
  •   
    • AND Here's PHP
    2. $servername = "localhost";  
    3. $username = "root";  
    4. $password = "";  
    5. $db = "admin";  
    6. // Create connection  
    7. $conn = new mysqli($servername,$username,$password,$db);  
    8. if(isset($_POST['submitform'])){  
    9. $title = $_POST['title'];  
    10. $name = $_POST['name'];  
    11. $department = $_POST['department'];  
    12. $task = $_POST['task'];  
    13. $date =$_POST['datepicker'];  
    14. $assign = $_POST['assign'];  
    15. $now =date('m/d/Y h:i:s a', time());  
    16. $query = "CREATE EVENT IF NOT EXISTS $title  
    17. ON SCHEDULE AT '$date'  
    18. DO  
    19. INSERT INTO task(name,department,task,assign,deadline,created_at) VALUES ('$name','$department','$task','$assign','$date','$now')  
    20. ;";  
    21. mysqli_query($conn,$query);  
    22. echo "

      Event has been created.
       You're notified that this will be fired automatically on your set date !

      Redirecting back in 5 seconds ...";  
    23. header("Refresh: 1; url=test2.php");  
    24. mysqli_close($conn);  
    25. };  
    26. ?>  
    Please guide, Please

    1 Reply

    Know the answer? Post it — somebody with the same question will find it here.