invisio v2.0

<?php
	session_start();
	include('innerpageheader.php');
	include("config.php");
	$empids = $_SESSION['empids'];
	
$con = mysql_connect("50.62.209.50:3306","iseecrm","iseecrm123!@#");
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	
	mysql_select_db("iseecrm", $con);
	
	$result = mysql_query("SELECT * FROM employees WHERE empid = '$empids'");
	
	while($row = mysql_fetch_array($result))
	  {
	  	$ename = $row['empname'];
	  }
									
	date_default_timezone_set('Asia/Muscat');
 	$de = date('Y-m-d');
	
	
			
?>

<!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">
<script type="text/javascript" src="datepickercontrol.js"></script>
<link type="text/css" rel="stylesheet" href="datepickercontrol.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

<div class="container" style="background-color:#1B75BB; width:95%; margin-left:30px; margin-top:-22px; padding:25px;color:#fff; text-transform:uppercase;">
	<div class="card-body border-left-secondary border-bottom-secondary">
       <center><span class="btn btn-primary btn-user btn-block" style="background-color:#F6921E; border-color:#F6921E; width:30%">ADD THINGS TO DO</span></center>
	   <hr>
    <form method="post" action="save_thingstodo.php" class="user">
  
    <div class="form-group row">
      <div class="col-sm-12">
      		<center>Things to do</center>
           <textarea name="editor1" id="editor1" style="width:100%"></textarea>
         </div>
  </div>
   <div class="form-group row">
   <div class="col-sm-2 mb-3 mb-sm-0">
          <center>Date</center>
              <input type="date" class="form-control form-control-user" id="tdate" name="tdate" required style="background-color:#EFEFEF;">
          </div>
  <div class="col-sm-5">
      <center>Task By</center>
     <select name="frmemp" id="frmemp" class="form-control" style="height:48px; border-radius:25px;" required>
          <option value='<?php echo $empids;?>' selected="selected"><?php echo $ename ?></option> 
          <option value="" >Select Employee</option>
          <?php
             
              $con = mysql_connect("50.62.209.50:3306","iseecrm","iseecrm123!@#");
              //$con = mysql_connect("localhost","root","");
          
              if (!$con)
                {
                  die('Could not connect: ' . mysql_error());
                }
              mysql_select_db("iseecrm", $con);
              
              $result = mysql_query("SELECT * FROM employees WHERE empid != 'admin' ORDER BY empname");
              
              while($row = mysql_fetch_array($result))
                {
                      $id = $row['empid'];
                      $name = strtoupper($row['empname']);
                      echo "<option value=$id>$name</option>";
                }
          ?>

</select>
  
  </div>
  <div class="col-sm-5">
      <center>To Be Handled By</center>
     <select name="toemp" id="toemp" class="form-control" style="height:48px; border-radius:25px;" required>
          <option value="" >Select Employee</option>
          <?php
             
              $con = mysql_connect("50.62.209.50:3306","iseecrm","iseecrm123!@#");
              //$con = mysql_connect("localhost","root","");
          
              if (!$con)
                {
                  die('Could not connect: ' . mysql_error());
                }
              mysql_select_db("iseecrm", $con);
              
              $result = mysql_query("SELECT * FROM employees ORDER BY empname");
              
              while($row = mysql_fetch_array($result))
                {
                      $id = $row['empid'];
                      $name = strtoupper($row['empname']);
                      echo "<option value=$id>$name</option>";
                }
          ?>

</select>
  
  </div>
  </div>
   <input type="submit" value="Save Things To DO" class="btn btn-primary btn-user btn-block"  style="background-color:#F6921E; border-color:#F6921E;">
    </form><BR /><BR /><BR />

</tbody>
                                </table>
                            </div>
                        </div>
                    </div>

</div>

</div>

<?php
				include("footer.php");
		   ?>

</div>

</div>

<a class="scroll-to-top rounded" href="#page-top">
        <i class="fas fa-angle-up"></i>
    </a>

<div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
                <div class="modal-footer">
                    <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
                    <a class="btn btn-primary" href="login.html">Logout</a>
                </div>
            </div>
        </div>
    </div>

<script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

<script src="vendor/jquery-easing/jquery.easing.min.js"></script>

<script src="js/sb-admin-2.min.js"></script>

<script src="vendor/datatables/jquery.dataTables.min.js"></script>
    <script src="vendor/datatables/dataTables.bootstrap4.min.js"></script>

<script src="js/demo/datatables-demo.js"></script>

</body>

</html>