Sujet Précédent Sujet Suivant

Sélectionnez la liste déroulante avec les valeurs de la bdd

Fermé
NOUR_2003 Messages postés 6 Date d'inscription mardi 30 août 2022 Statut Membre Dernière intervention 31 août 2022 - 30 août 2022 à 23:19
 NOUR - 31 août 2022 à 20:07

bonsoir,

Je voulais afficher tous les iduser enregistrer dans bbd table users dans un select html dans page task.php.

les code sources  ⇓:

A voir également:

7 réponses

Réponse 1 / 7
NOUR_2003 Messages postés 6 Date d'inscription mardi 30 août 2022 Statut Membre Dernière intervention 31 août 2022
30 août 2022 à 23:21

<?php

   class Database

   {

      private $servername = "localhost";

      private $username   = "root";

      private $password   = "";

      private $dbname = "register";

      public $con;

      public $customerTable = "tasks";

      public function __construct()

      {

         try {

            $this->con = new mysqli($this->servername, $this->username, $this->password, $this->dbname);

         } catch (Exception $e) {

            echo $e->getMessage();

         }

      }

      // Insert customer data into customer table

      public function insertRecond($IdUser,$IdProject,$tasks, $StartDate, $EndDate)

      {

         $sql = "INSERT INTO $this->customerTable (IdUser,IdProject,tasks, StartDate,EndDate) VALUES('$IdUser','$IdProject','$tasks','$StartDate','$EndDate')";

         $query = $this->con->query($sql);

         if ($query) {

            return true;

         }else{

            return false;

         }

      }

      // Fetch customer records for show listing

      public function displayRecord()

      {

         $sql = "SELECT * FROM $this->customerTable";

         $query = $this->con->query($sql);

         $data = array();

         if ($query->num_rows > 0) {

            while ($row = $query->fetch_assoc()) {

               $data[] = $row;

            }

            return $data;

         }else{

            return false;

         }

      }

      // Fetch single data for edit from customer table

      public function getRecordById($IdTask)

      {

         $query = "SELECT * FROM $this->customerTable WHERE IdTask = '$IdTask'";

         $result = $this->con->query($query);

         if ($result->num_rows > 0) {

            $row = $result->fetch_assoc();

            return $row;

         }else{

            return false;

         }

      }


 

      public function totalRowCount(){

         $sql = "SELECT * FROM $this->customerTable";

         $query = $this->con->query($sql);

         $rowCount = $query->num_rows;

         return $rowCount;

      }


 

      // Update customer data into customer table

      public function updateRecord( $IdTask,$IdUser ,$IdProject, $tasks , $StartDate,  $EndDate)

      {

         $sql = "UPDATE $this->customerTable SET IdUser = '$IdUser',IdProject = '$IdProject',tasks = '$tasks', StartDate = '$StartDate', EndDate = '$EndDate'

         WHERE IdTask = '$IdTask'";

         $query = $this->con->query($sql);

         if ($query) {

            return true;

         }else{

            return false;

         }

      }

      // Delete customer data from customer table

      public function deleteRecord($IdTask)

      {

         $sql = "DELETE FROM $this->customerTable WHERE IdTask = '$IdTask'";

         $query = $this->con->query($sql);

         if ($query) {

            return true;

         }else{

            return false;

         }

      }

   }

?>
0
Réponse 2 / 7
NOUR_2003 Messages postés 6 Date d'inscription mardi 30 août 2022 Statut Membre Dernière intervention 31 août 2022
30 août 2022 à 23:22

<?php

   // Include config.php file

   include_once('config4.php');

   $dbObj = new Database();

   // Insert Record

   if (isset($_POST['action']) && $_POST['action'] == "insert") {

    $IdUser = $_POST['IdUser'];

    $IdProject = $_POST['IdProject'];

      $tasks = $_POST['tasks'];

      $StartDate = $_POST['StartDate'];

      $EndDate = $_POST['EndDate'];

      $dbObj->insertRecond( $IdUser, $IdProject,$tasks, $StartDate, $EndDate);

   }

   // View record

   if (isset($_POST['action']) && $_POST['action'] == "view") {

      $output = "";

      $customers = $dbObj->displayRecord();

      if ($dbObj->totalRowCount() > 0) {

         $output .="<table class='table table-striped table-hover ' style='background-color: #FEFEFF;'>

                 <thead>

                   <tr>

                   <th>IdTask</th>

                   <th>IdUser</th>

                     <th>IdProject</th>

                     <th style='width: 30%;' >  Tasks</th>

                     <th>Start Date</th>

                     <th>End Date</th>

                     <th>Action</th>

                   </tr>

                 </thead>

                 <tbody>";

         foreach ($customers as $customer) {

         $output.="<tr>

                     <td>".$customer['IdTask']."</td>

                     <td>".$customer['IdUser']."</td>

                     <td>".$customer['IdProject']."</td>

                     <td>".$customer['tasks']."</td>

                     <td>".date('d-M-Y', strtotime($customer['StartDate']))."</td>

                     <td>".date('d-M-Y', strtotime($customer['EndDate']))."</td>

                     <td>

                       <a href='#editModal' style='color:green' data-toggle='modal'

                       class='editBtn' id='".$customer['IdTask']."'><i class='fa fa-edit' ></i></a>&nbsp;

                       <a href='' style='color:red' class='deleteBtn' id='".$customer['IdTask']."'>

                       <i class='fa fa-trash' style='margin-left:30px' ></i></a>

                     </td>

                 </tr>";

            }

         $output .= "</tbody>

            </table>";

            echo $output;

      }else{

         echo '<h3 class="text-center mt-5">No records found</h3>';

      }

   }

   // Edit Record

   if (isset($_POST['editId'])) {

      $editId = $_POST['editId'];

      $row = $dbObj->getRecordById($editId);

      echo json_encode($row);

   }


 

   // Update Record

   if (isset($_POST['action']) && $_POST['action'] == "update") {

      $IdTask = $_POST['IdTask'];

      $IdUser = $_POST['uIdUser'];

      $IdProject = $_POST['uIdProject'];

      $tasks = $_POST['utasks'];

      $StartDate = $_POST['uStartDate'];

      $EndDate = $_POST['uEndDate'];

      $dbObj->updateRecord($IdTask,$IdUser,$IdProject, $tasks, $StartDate, $EndDate);

   }


 

   // Edit Record

   if (isset($_POST['deleteBtn'])) {

      $deleteBtn = $_POST['deleteBtn'];

      $dbObj->deleteRecord($deleteBtn);

   }


 

?>
0
Réponse 3 / 7
NOUR_2003 Messages postés 6 Date d'inscription mardi 30 août 2022 Statut Membre Dernière intervention 31 août 2022
30 août 2022 à 23:22

<!DOCTYPE html>
<html lang="en">
<head>
<title>Primatec | Projects</title>

  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <link rel="stylesheet" href="https://pro.fontawesome.com/releases/v5.10.0/css/all.css"/>
  <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/bs4/dt-1.10.22/datatables.min.css"/>
  <link rel="stylesheet" href="https://pro.fontawesome.com/releases/v5.10.0/css/all.css"/>

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro%3A300%2C400%2C400i%2C700&display=fallback">

<link rel="stylesheet" href="../../plugins/fontawesome-free/css/all.min.css">

<link rel="stylesheet" href="../../plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="../../plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
<link rel="stylesheet" href="../../plugins/datatables-buttons/css/buttons.bootstrap4.min.css">

<link rel="stylesheet" href="../../dist/css/adminlte.min.css?v=3.2.0">
<script nonce="a9d663a8-e4cb-4143-a992-b0d1f78309c1">(function(w,d){!function(a,e,t,r){a.zarazData=a.zarazData||{};a.zarazData.executed=[];a.zaraz={deferred:[]};a.zaraz.q=[];a.zaraz._f=function(e){return function(){var t=Array.prototype.slice.call(arguments);a.zaraz.q.push({m:e,a:t})}};for(const e of["track","set","ecommerce","debug"])a.zaraz[e]=a.zaraz._f(e);a.zaraz.init=()=>{var t=e.getElementsByTagName(r)[0],z=e.createElement(r),n=e.getElementsByTagName("title")[0];n&&(a.zarazData.t=e.getElementsByTagName("title")[0].text);a.zarazData.x=Math.random();a.zarazData.w=a.screen.width;a.zarazData.h=a.screen.height;a.zarazData.j=a.innerHeight;a.zarazData.e=a.innerWidth;a.zarazData.l=a.location.href;a.zarazData.r=e.referrer;a.zarazData.k=a.screen.colorDepth;a.zarazData.n=e.characterSet;a.zarazData.o=(new Date).getTimezoneOffset();a.zarazData.q=[];for(;a.zaraz.q.length;){const e=a.zaraz.q.shift();a.zarazData.q.push(e)}z.defer=!0;for(const e of[localStorage,sessionStorage])Object.keys(e||{}).filter((a=>a.startsWith("_zaraz_"))).forEach((t=>{try{a.zarazData["z_"+t.slice(7)]=JSON.parse(e.getItem(t))}catch{a.zarazData["z_"+t.slice(7)]=e.getItem(t)}}));z.referrerPolicy="origin";z.src=""+btoa(encodeURIComponent(JSON.stringify(a.zarazData)));t.parentNode.insertBefore(z,t)};["complete","interactive"].includes(e.readyState)?zaraz.init():a.addEventListener("DOMContentLoaded",zaraz.init)}(w,d,0,"script");})(window,document);</script>
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/5.0.0-alpha2/css/bootstrap.min.css">
  <script src="https://stackpath.bootstrapcdn.com/bootstrap/5.0.0-alpha2/js/bootstrap.bundle.min.js"></script>

  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto%7CVarela+Round%7COpen+Sans">
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
  <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
  <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
  <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"></script>
  <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>


  <!-- Google Font: Source Sans Pro -->
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro%3A300%2C400%2C400i%2C700&display=fallback">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="../../plugins/fontawesome-free/css/all.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="../../dist/css/adminlte.min.css">
<link rel="shortcut icon" type="image/x-icon" href="../../dist/img/logo.png" >
 </head>
<body class="hold-transition sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
  <!-- Navbar -->
  <nav class="main-header navbar navbar-expand navbar-white navbar-light">
    <!-- Left navbar links -->
    <ul class="navbar-nav">
      <li class="nav-item">
        <a class="nav-link" data-widget="pushmenu" href="#" role="button"><i class="fas fa-bars"></i></a>
      </li>

    </ul>

    <!-- Right navbar links -->
    <ul class="navbar-nav ml-auto">
      <!-- Navbar Search -->
      <li class="nav-item">
        <a class="nav-link" data-widget="navbar-search" href="#" role="button">
          <i class="fas fa-search"></i>
        </a>
        <div class="navbar-search-block">
          <form class="form-inline">
            <div class="input-group input-group-sm">
              <input class="form-control form-control-navbar" type="search" placeholder="Search" aria-label="Search">
              <div class="input-group-append">
                <button class="btn btn-navbar" type="submit">
                  <i class="fas fa-search"></i>
                </button>
                <button class="btn btn-navbar" type="button" data-widget="navbar-search">

                </button>
              </div>
            </div>
          </form>
        </div>
      </li>

      <!-- Messages Dropdown Menu -->
      <li class="nav-item dropdown">
        <a class="nav-link" data-toggle="dropdown" href="#">
           <i class="far fa-comments"></i>
          <span class="badge badge-danger navbar-badge">3</span>
        </a>
        <div class="dropdown-menu dropdown-menu-lg dropdown-menu-right">
          <a href="#" class="dropdown-item">
            <!-- Message Start -->
            <div class="media">
              <img src="" alt="User Avatar" class="img-size-50 mr-3 img-circle">
              <div class="media-body">
                <h3 class="dropdown-item-title">
                  Brad Diesel
                  <span class="float-right text-sm text-danger"><i class="fas fa-star"></i></span>
                </h3>
                <p class="text-sm">Call me whenever you can...</p>
                <p class="text-sm text-muted"><i class="far fa-clock mr-1"></i> 4 Hours Ago</p>
              </div>
            </div>
            <!-- Message End -->
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <!-- Message Start -->
            <div class="media">
              <img src="" alt="User Avatar" class="img-size-50 img-circle mr-3">
              <div class="media-body">
                <h3 class="dropdown-item-title">
                  John Pierce
                  <span class="float-right text-sm text-muted"><i class="fas fa-star"></i></span>
                </h3>
                <p class="text-sm">I got your message bro</p>
                <p class="text-sm text-muted"><i class="far fa-clock mr-1"></i> 4 Hours Ago</p>
              </div>
            </div>
            <!-- Message End -->
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <!-- Message Start -->
            <div class="media">
              <img src="" alt="User Avatar" class="img-size-50 img-circle mr-3">
              <div class="media-body">
                <h3 class="dropdown-item-title">
                  Nora Silvester
                  <span class="float-right text-sm text-warning"><i class="fas fa-star"></i></span>
                </h3>
                <p class="text-sm">The subject goes here</p>
                <p class="text-sm text-muted"><i class="far fa-clock mr-1"></i> 4 Hours Ago</p>
              </div>
            </div>
            <!-- Message End -->
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item dropdown-footer">See All Messages</a>
        </div>
      </li>
      <!-- Notifications Dropdown Menu -->
      <li class="nav-item dropdown">
        <a class="nav-link" data-toggle="dropdown" href="#">
          <i class="far fa-bell"></i>
        <span class="badge badge-info navbar-badge">4</span>
        </a>
        <div class="dropdown-menu dropdown-menu-lg dropdown-menu-right">
          <span class="dropdown-item dropdown-header">15 Notifications</span>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <i class="fas fa-envelope mr-2"></i> 4 new messages
            <span class="float-right text-muted text-sm">3 mins</span>
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <i class="fas fa-users mr-2"></i> 8 friend requests
            <span class="float-right text-muted text-sm">12 hours</span>
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <i class="fas fa-file mr-2"></i> 3 new reports
            <span class="float-right text-muted text-sm">2 days</span>
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item dropdown-footer">See All Notifications</a>
        </div>
      </li>
      <li class="nav-item">
        <a class="nav-link" data-widget="fullscreen" href="#" role="button">
          <i class="fas fa-expand-arrows-alt"></i>
        </a>
      </li>
      <li class="nav-item">
        <a class="nav-link" data-widget="control-sidebar" data-slide="true" href="#" role="button">
          <i class="fas fa-th-large"></i>
        </a>
           </li>
    <li class="nav-item">
            <a class="nav-link" data-slide="true" href="../examples/login.php" role="button">
              <i class="fa fa-sign-out-alt " style="font-size:25px"  ></i>
            </a>
      </li>
    </ul>
  </nav>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
  <aside class="main-sidebar sidebar-dark-primary elevation-4">
    <!-- Brand Logo -->
      <a href="#" class="brand-link" style="height: 75px ;">

      <img src="" alt="AdminLTE Logo" >
  </a>
    <!-- Sidebar -->
    <div class="sidebar">
      <!-- Sidebar user (optional) -->
      <div class="user-panel mt-3 pb-3 mb-3 d-flex">
        <div class="image">
          <img src="" class="img-circle elevation-2" alt="User Image">
        </div>
        <div class="info">
          <a href="../examples/profile.html" class="d-block">Alexander Pierce</a>


        </div>
      </div>

      <!-- SidebarSearch Form -->
      <div class="form-inline">
        <div class="input-group" data-widget="sidebar-search">
          <input class="form-control form-control-sidebar" type="search" placeholder="Search" aria-label="Search">
          <div class="input-group-append">
            <button class="btn btn-sidebar">
              <i class="fas fa-search fa-fw"></i>
            </button>
          </div>
        </div>
      </div>

      <!-- Sidebar Menu -->
      <nav class="mt-2">
        <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
          <!-- Add icons to the links using the .nav-icon class
               with font-awesome or any other icon font library -->
             <li class="nav-item">
                      <a href="../index.php" class="nav-link ">

           <i class="nav-icon fa fa-home" aria-hidden="true"></i><p>

                    Home
                  </p>
                </a>
              </li>

          <li class="nav-item">
            <a href="../calendar.php" class="nav-link">
              <i class="nav-icon far fa-calendar-alt"></i>
              <p>
                    Calendar
                <span class="badge badge-danger right">2</span>
              </p>
            </a>
          </li>

          <li class="nav-item">
            <a href="../index2.html" class="nav-link ">
               <i class="nav-icon fa fa-signal" aria-hidden="true"></i>
<p>
                Statistics
                <span class="badge badge-light right">5</span>              </p>
            </a>
          </li>

          <li class="nav-item">
            <a href="#" class="nav-link">
              <i class="nav-icon far fa-envelope"></i>
              <p>
                Mailbox
                <i class="fas fa-angle-left right"></i>
              </p>
            </a>
            <ul class="nav nav-treeview">
              <li class="nav-item">
                <a href="../mailbox/mailbox.html" class="nav-link">
                 <i class="nav-icon fa fa-inbox" aria-hidden="true"></i>
                  <p>Inbox</p>
                </a>
              </li>
              <li class="nav-item">
                <a href="../mailbox/compose.html" class="nav-link">
                  <i class="nav-icon fa fa-sticky-note" aria-hidden="true"></i>
                  <p>Compose</p>
                </a>
              </li>
              <li class="nav-item">
                <a href="../mailbox/read-mail.html" class="nav-link">
                 <i class="nav-icon fa fa-envelope-open" aria-hidden="true"></i>
                  <p>Read</p>
                </a>
              </li>
            </ul>
          </li>
          <li class="nav-item menu-open">
                <a href="#" class="nav-link active">
                     <i class="fa fa-sitemap" aria-hidden="true"></i>
                  <p>
                    Projects
                    <i class="fas fa-angle-left right"></i>
                  </p>
                </a>
                <ul class="nav nav-treeview">
      <li class="nav-item">
        <a href="../examples/projects.php" class="nav-link ">
     <i class="nav-icon fa fa-list" aria-hidden="true"></i>               <p>List</p>
                    </a>
                  </li>
      <li class="nav-item">
        <a href="../examples/position.php" class="nav-link">
                      <i class="nav-icon fa fa-user" aria-hidden="true"></i>
              <p>Position User</p>

                    </a>
                  </li>
                  <li class="nav-item">
        <a href="../examples/task.php" class="nav-link active">
 <i class="nav-icon fa fa-list-ol" aria-hidden="true"></i>

         <p>Tasks</p>

                    </a>
                  </li>
                </ul>
              </li>
              <li class="nav-item">
                <a href="../examples/AllTeams.php"   class="nav-link">
                 <i class="fa fa-users" aria-hidden="true"></i>
                    <p>
                      Teams
                    </p>
                </a>
              </li>

        </ul>
      </nav>
      <!-- /.sidebar-menu -->
    </div>
    <!-- /.sidebar -->
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper" >
  <div class="container" style="padding-top: 20px;">
  <div class="row">
    <div class="col-lg-6">
      <h2>All Tasks</h2>
    </div>
    <div class="col-lg-6">
      <button type="button" class="btn btn-primary m-1 float-right" data-toggle="modal" data-target="#addModal">
      <i class="fa fa-plus"></i> Add New Task</button>

    </div>
  </div><br>
</div>
    </section>


<div class="container">
  <div class="row">
    <div class="col-lg-12 col-md-12 col-sm-12">
      <div class="table-responsive" id="tableData">
        <h3 class="text-center text-success" style="margin-top: 150px;">Loading...</h3>
      </div>
    </div>
  </div>
</div>

<!-- Add Record  Modal -->
<div class="modal" id="addModal">
  <div class="modal-dialog">
    <div class="modal-content">
      <!-- Modal Header -->
      <div class="modal-header">
        <h4 class="modal-title">Add New Task</h4>
        <button type="button" class="close" data-dismiss="modal">&times;</button>
      </div>
      <!-- Modal body -->
      <div class="modal-body">
        <form id="formData">
        <div class="form-group">
            <label for="IdUser">IdUser :</label>
        <select type="text" class="form-control" name="IdUser" placeholder="Enter IdUser" required="">
        </select>
        </div>
           <div class="form-group">
            <label for="IdProject">IdProject :</label>
            <input type="text" class="form-control" name="IdProject" placeholder="Enter IdProject" required="">
          </div>
          <div class="form-group">
            <label for="tasks">Task :</label>
            <input type="text" class="form-control" name="tasks" placeholder="Enter Task " required="">
          </div>
          <div class="form-group">
            <label for="StartDate">Start Date :</label>
            <input type="date" class="form-control" name="StartDate" placeholder="Enter StartDate" required="">
          </div>
          <div class="form-group">
            <label for="EndDate">End Date :</label>
            <input type="date" class="form-control" name="EndDate" placeholder="Enter EndDate" required="">
          </div>
          <hr>
          <div class="form-group float-right">
            <button type="submit" class="btn btn-success" id="submit">Submit</button>
            <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
          </div>
        </form>
      </div>
    </div>
  </div>
</div>

<!-- Edit Record  Modal -->
<div class="modal" id="editModal">
  <div class="modal-dialog">
    <div class="modal-content">
      <!-- Modal Header -->
      <div class="modal-header">
        <h4 class="modal-title">Edit Task</h4>
        <button type="button" class="close" data-dismiss="modal">&times;</button>
      </div>
      <!-- Modal body -->
      <div class="modal-body">
        <form id="EditformData">
          <input type="hidden" name="IdTask" id="edit-form-id">
          <div class="form-group">
            <label for="IdUser">IdUser :</label>
            <input type="text" class="form-control" name="uIdUser" id="IdUser" placeholder="Enter IdUser" required="">
          </div>
           <div class="form-group">
            <label for="IdProject">IdProject :</label>
            <input type="text" class="form-control" name="uIdProject" id="IdProject" placeholder="Enter IdProject" required="">
          </div>
          <div class="form-group">
            <label for="tasks">Task :</label>
            <input type="text" class="form-control" name="utasks" id="tasks" placeholder="Enter Task " required="">
          </div>
          <div class="form-group">
            <label for="StartDate">Start Date :</label>
            <input type="date" class="form-control" name="uStartDate" id="StartDate" placeholder="Enter StartDate" required="">
          </div>
          <div class="form-group">
            <label for="EndDate">End Date :</label>
            <input type="date" class="form-control" name="uEndDate" id="EndDate" placeholder="Enter EndDate" required="">
          </div>
          <hr>
          <div class="form-group float-right">
            <button type="submit" class="btn btn-primary" id="update">Update</button>
            <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
          </div>
        </form>
      </div>
    </div>
  </div>
</div>
</div>

  <!-- /.content-wrapper -->

  <footer class="main-footer">
    <div class="float-right d-none d-sm-block">
      <b>@ Primatec 2022</b>
    </div>
   </footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->

<script src=""></script>

<script src=""></script>

<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>

<script src=""></script>

<script src=""></script>

<script>
  $(function () {
    $("#example1").DataTable({
      "responsive": true, "lengthChange": false, "autoWidth": false,
      "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
    }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/v/bs4/dt-1.10.22/datatables.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@10"></script>

<script type="text/javascript">
  $(document).ready(function(){

  showAllCustomer();
  //View Record
  function showAllCustomer(){
    $.ajax({
      url : "action4.php",
      type: "POST",
      data : {action:"view"},
      success:function(response){
          $("#tableData").html(response);
          $("table").DataTable({
            order:[0, 'DESC']
          });
        }
      });
    }

    //insert ajax request data
    $("#submit").click(function(e){
        if ($("#formData")[0].checkValidity()) {
          e.preventDefault();
          $.ajax({
            url : "action4.php",
            type : "POST",
            data : $("#formData").serialize()+"&action=insert",
            success:function(response){
              Swal.fire({
                icon: 'success',
                title: 'Task added successfully',
              });
              $("#addModal").modal('hide');
              $("#formData")[0].reset();
              showAllCustomer();
            }
          });
        }
    });

    //Edit Record
    $("body").on("click", ".editBtn", function(e){
      e.preventDefault();
      var editId = $(this).attr('id');
      $.ajax({
        url : "action4.php",
        type : "POST",
        data : {editId:editId},
        success:function(response){
          var data = JSON.parse(response);
          $("#edit-form-id").val(data.IdTask);
          $("#IdUser").val(data.IdUser);
          $("#IdProject").val(data.IdProject);
          $("#tasks").val(data.tasks);
          $("#StartDate").val(data.StartDate);
          $("#EndDate").val(data.EndDate);
        }
      });
    });


    //update ajax request data
    $("#update").click(function(e){
      if ($("#EditformData")[0].checkValidity()) {
        e.preventDefault();
        $.ajax({
          url : "action4.php",
          type : "POST",
          data : $("#EditformData").serialize()+"&action=update",
          success:function(response){
            Swal.fire({
              icon: 'success',
              title: 'Task updated successfully',
            });
            $("#editModal").modal('hide');
            $("#EditformData")[0].reset();
            showAllCustomer();
          }
        });
      }
    });

    //Delete Record
    $("body").on("click", ".deleteBtn", function(e){
      e.preventDefault();
      var tr = $(this).closest('tr');
      var deleteBtn = $(this).attr('id');
      if (confirm('Are you sure want to delete this Task')) {
        $.ajax({
          url : "action4.php",
          type : "POST",
          data : {deleteBtn:deleteBtn},
          success:function(response){
            tr.css('background-color','#ff6565');
            Swal.fire({
              icon: 'success',
              title: 'Task delete successfully',
            });
            showAllCustomer();
          }
        });
      }
    });
  });
</script>
</body>
</html>
0
Réponse 4 / 7
NOUR_2003 Messages postés 6 Date d'inscription mardi 30 août 2022 Statut Membre Dernière intervention 31 août 2022
30 août 2022 à 23:25

voila mon probléme!! j'ai une liste deroulante <select> alimenté grace a un table dans ma base je veux récuperer la valeur choisi par l'utilisateur pour l'utliser et voila mon code!!! svp aidez moi j'ai passé pas mal de temps a chercher pour resoudre se probléme
0

Vous n’avez pas trouvé la réponse que vous recherchez ?

Posez votre question
Réponse 5 / 7
jordane45 Messages postés 38449 Date d'inscription mercredi 22 octobre 2003 Statut Modérateur Dernière intervention 8 mars 2025 4 739
30 août 2022 à 23:29

Bonjour

A l'avenir, merci d'utiliser les balises de code pour poster du code sur le forum .. là .. c'est illisible.

Ensuite, tu dis :

j'ai une liste deroulante <select> alimenté grace a un table dans ma base je veux récuperer la valeur choisi par l'utilisateur 

Récupérer... à quel moment ?

Pour l'utiliser où ?

PS: Il aurait également été bien de donner le nom des fichiers de chaque code que tu nous as montré ..
0
Réponse 6 / 7
NOUR_2003 Messages postés 6 Date d'inscription mardi 30 août 2022 Statut Membre Dernière intervention 31 août 2022
31 août 2022 à 14:52

Bonjour,

Merci pour la reponse et je m'excuse pour la manque des information et les fautes.

Bon ,voila mon probleme:

je ne peut pas avoir dans select de ma formilaire de Add  et Edit comme montre mon code tous les idusers enregistrees dans bdd.

Cordialement.

              Nour

Donc j'ai besion de trouver une solution pour que je choisis user a partir des iduser enregistrees dans table users dans bdd.

task.php
____________________________________________________________________________________________________
<!DOCTYPE html>
<html lang="en">
<head>
<title>Primatec | Projects</title>

  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <link rel="stylesheet" href="https://pro.fontawesome.com/releases/v5.10.0/css/all.css"/>
  <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/bs4/dt-1.10.22/datatables.min.css"/>
  <link rel="stylesheet" href="https://pro.fontawesome.com/releases/v5.10.0/css/all.css"/>

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro%3A300%2C400%2C400i%2C700&display=fallback">

<link rel="stylesheet" href="../../plugins/fontawesome-free/css/all.min.css">

<link rel="stylesheet" href="../../plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="../../plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
<link rel="stylesheet" href="../../plugins/datatables-buttons/css/buttons.bootstrap4.min.css">

<link rel="stylesheet" href="../../dist/css/adminlte.min.css?v=3.2.0">
<script nonce="a9d663a8-e4cb-4143-a992-b0d1f78309c1">(function(w,d){!function(a,e,t,r){a.zarazData=a.zarazData||{};a.zarazData.executed=[];a.zaraz={deferred:[]};a.zaraz.q=[];a.zaraz._f=function(e){return function(){var t=Array.prototype.slice.call(arguments);a.zaraz.q.push({m:e,a:t})}};for(const e of["track","set","ecommerce","debug"])a.zaraz[e]=a.zaraz._f(e);a.zaraz.init=()=>{var t=e.getElementsByTagName(r)[0],z=e.createElement(r),n=e.getElementsByTagName("title")[0];n&&(a.zarazData.t=e.getElementsByTagName("title")[0].text);a.zarazData.x=Math.random();a.zarazData.w=a.screen.width;a.zarazData.h=a.screen.height;a.zarazData.j=a.innerHeight;a.zarazData.e=a.innerWidth;a.zarazData.l=a.location.href;a.zarazData.r=e.referrer;a.zarazData.k=a.screen.colorDepth;a.zarazData.n=e.characterSet;a.zarazData.o=(new Date).getTimezoneOffset();a.zarazData.q=[];for(;a.zaraz.q.length;){const e=a.zaraz.q.shift();a.zarazData.q.push(e)}z.defer=!0;for(const e of[localStorage,sessionStorage])Object.keys(e||{}).filter((a=>a.startsWith("_zaraz_"))).forEach((t=>{try{a.zarazData["z_"+t.slice(7)]=JSON.parse(e.getItem(t))}catch{a.zarazData["z_"+t.slice(7)]=e.getItem(t)}}));z.referrerPolicy="origin";z.src=""+btoa(encodeURIComponent(JSON.stringify(a.zarazData)));t.parentNode.insertBefore(z,t)};["complete","interactive"].includes(e.readyState)?zaraz.init():a.addEventListener("DOMContentLoaded",zaraz.init)}(w,d,0,"script");})(window,document);</script>
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/5.0.0-alpha2/css/bootstrap.min.css">
  <script src="https://stackpath.bootstrapcdn.com/bootstrap/5.0.0-alpha2/js/bootstrap.bundle.min.js"></script>

  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto%7CVarela+Round%7COpen+Sans">
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
  <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
  <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
  <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"></script>
  <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>


  <!-- Google Font: Source Sans Pro -->
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro%3A300%2C400%2C400i%2C700&display=fallback">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="../../plugins/fontawesome-free/css/all.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="../../dist/css/adminlte.min.css">
<link rel="shortcut icon" type="image/x-icon" href="../../dist/img/logo.png" >
 </head>
<body class="hold-transition sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
  <!-- Navbar -->
  <nav class="main-header navbar navbar-expand navbar-white navbar-light">
    <!-- Left navbar links -->
    <ul class="navbar-nav">
      <li class="nav-item">
        <a class="nav-link" data-widget="pushmenu" href="#" role="button"><i class="fas fa-bars"></i></a>
      </li>

    </ul>

    <!-- Right navbar links -->
    <ul class="navbar-nav ml-auto">
      <!-- Navbar Search -->
      <li class="nav-item">
        <a class="nav-link" data-widget="navbar-search" href="#" role="button">
          <i class="fas fa-search"></i>
        </a>
        <div class="navbar-search-block">
          <form class="form-inline">
            <div class="input-group input-group-sm">
              <input class="form-control form-control-navbar" type="search" placeholder="Search" aria-label="Search">
              <div class="input-group-append">
                <button class="btn btn-navbar" type="submit">
                  <i class="fas fa-search"></i>
                </button>
                <button class="btn btn-navbar" type="button" data-widget="navbar-search">

                </button>
              </div>
            </div>
          </form>
        </div>
      </li>

      <!-- Messages Dropdown Menu -->
      <li class="nav-item dropdown">
        <a class="nav-link" data-toggle="dropdown" href="#">
           <i class="far fa-comments"></i>
          <span class="badge badge-danger navbar-badge">3</span>
        </a>
        <div class="dropdown-menu dropdown-menu-lg dropdown-menu-right">
          <a href="#" class="dropdown-item">
            <!-- Message Start -->
            <div class="media">
              <img src="" alt="User Avatar" class="img-size-50 mr-3 img-circle">
              <div class="media-body">
                <h3 class="dropdown-item-title">
                  Brad Diesel
                  <span class="float-right text-sm text-danger"><i class="fas fa-star"></i></span>
                </h3>
                <p class="text-sm">Call me whenever you can...</p>
                <p class="text-sm text-muted"><i class="far fa-clock mr-1"></i> 4 Hours Ago</p>
              </div>
            </div>
            <!-- Message End -->
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <!-- Message Start -->
            <div class="media">
              <img src="" alt="User Avatar" class="img-size-50 img-circle mr-3">
              <div class="media-body">
                <h3 class="dropdown-item-title">
                  John Pierce
                  <span class="float-right text-sm text-muted"><i class="fas fa-star"></i></span>
                </h3>
                <p class="text-sm">I got your message bro</p>
                <p class="text-sm text-muted"><i class="far fa-clock mr-1"></i> 4 Hours Ago</p>
              </div>
            </div>
            <!-- Message End -->
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <!-- Message Start -->
            <div class="media">
              <img src="" alt="User Avatar" class="img-size-50 img-circle mr-3">
              <div class="media-body">
                <h3 class="dropdown-item-title">
                  Nora Silvester
                  <span class="float-right text-sm text-warning"><i class="fas fa-star"></i></span>
                </h3>
                <p class="text-sm">The subject goes here</p>
                <p class="text-sm text-muted"><i class="far fa-clock mr-1"></i> 4 Hours Ago</p>
              </div>
            </div>
            <!-- Message End -->
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item dropdown-footer">See All Messages</a>
        </div>
      </li>
      <!-- Notifications Dropdown Menu -->
      <li class="nav-item dropdown">
        <a class="nav-link" data-toggle="dropdown" href="#">
          <i class="far fa-bell"></i>
        <span class="badge badge-info navbar-badge">4</span>
        </a>
        <div class="dropdown-menu dropdown-menu-lg dropdown-menu-right">
          <span class="dropdown-item dropdown-header">15 Notifications</span>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <i class="fas fa-envelope mr-2"></i> 4 new messages
            <span class="float-right text-muted text-sm">3 mins</span>
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <i class="fas fa-users mr-2"></i> 8 friend requests
            <span class="float-right text-muted text-sm">12 hours</span>
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item">
            <i class="fas fa-file mr-2"></i> 3 new reports
            <span class="float-right text-muted text-sm">2 days</span>
          </a>
          <div class="dropdown-divider"></div>
          <a href="#" class="dropdown-item dropdown-footer">See All Notifications</a>
        </div>
      </li>
      <li class="nav-item">
        <a class="nav-link" data-widget="fullscreen" href="#" role="button">
          <i class="fas fa-expand-arrows-alt"></i>
        </a>
      </li>
      <li class="nav-item">
        <a class="nav-link" data-widget="control-sidebar" data-slide="true" href="#" role="button">
          <i class="fas fa-th-large"></i>
        </a>
           </li>
    <li class="nav-item">
            <a class="nav-link" data-slide="true" href="../examples/login.php" role="button">
              <i class="fa fa-sign-out-alt " style="font-size:25px"  ></i>
            </a>
      </li>
    </ul>
  </nav>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
  <aside class="main-sidebar sidebar-dark-primary elevation-4">
    <!-- Brand Logo -->
      <a href="#" class="brand-link" style="height: 75px ;">

      <img src="" alt="AdminLTE Logo" >
  </a>
    <!-- Sidebar -->
    <div class="sidebar">
      <!-- Sidebar user (optional) -->
      <div class="user-panel mt-3 pb-3 mb-3 d-flex">
        <div class="image">
          <img src="" class="img-circle elevation-2" alt="User Image">
        </div>
        <div class="info">
          <a href="../examples/profile.html" class="d-block">Alexander Pierce</a>


        </div>
      </div>

      <!-- SidebarSearch Form -->
      <div class="form-inline">
        <div class="input-group" data-widget="sidebar-search">
          <input class="form-control form-control-sidebar" type="search" placeholder="Search" aria-label="Search">
          <div class="input-group-append">
            <button class="btn btn-sidebar">
              <i class="fas fa-search fa-fw"></i>
            </button>
          </div>
        </div>
      </div>

      <!-- Sidebar Menu -->
      <nav class="mt-2">
        <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
          <!-- Add icons to the links using the .nav-icon class
               with font-awesome or any other icon font library -->
             <li class="nav-item">
                      <a href="../index.php" class="nav-link ">

           <i class="nav-icon fa fa-home" aria-hidden="true"></i><p>

                    Home
                  </p>
                </a>
              </li>

          <li class="nav-item">
            <a href="../calendar.php" class="nav-link">
              <i class="nav-icon far fa-calendar-alt"></i>
              <p>
                    Calendar
                <span class="badge badge-danger right">2</span>
              </p>
            </a>
          </li>

          <li class="nav-item">
            <a href="../index2.html" class="nav-link ">
               <i class="nav-icon fa fa-signal" aria-hidden="true"></i>
<p>
                Statistics
                <span class="badge badge-light right">5</span>              </p>
            </a>
          </li>

          <li class="nav-item">
            <a href="#" class="nav-link">
              <i class="nav-icon far fa-envelope"></i>
              <p>
                Mailbox
                <i class="fas fa-angle-left right"></i>
              </p>
            </a>
            <ul class="nav nav-treeview">
              <li class="nav-item">
                <a href="../mailbox/mailbox.html" class="nav-link">
                 <i class="nav-icon fa fa-inbox" aria-hidden="true"></i>
                  <p>Inbox</p>
                </a>
              </li>
              <li class="nav-item">
                <a href="../mailbox/compose.html" class="nav-link">
                  <i class="nav-icon fa fa-sticky-note" aria-hidden="true"></i>
                  <p>Compose</p>
                </a>
              </li>
              <li class="nav-item">
                <a href="../mailbox/read-mail.html" class="nav-link">
                 <i class="nav-icon fa fa-envelope-open" aria-hidden="true"></i>
                  <p>Read</p>
                </a>
              </li>
            </ul>
          </li>
          <li class="nav-item menu-open">
                <a href="#" class="nav-link active">
                     <i class="fa fa-sitemap" aria-hidden="true"></i>
                  <p>
                    Projects
                    <i class="fas fa-angle-left right"></i>
                  </p>
                </a>
                <ul class="nav nav-treeview">
      <li class="nav-item">
        <a href="../examples/projects.php" class="nav-link ">
     <i class="nav-icon fa fa-list" aria-hidden="true"></i>               <p>List</p>
                    </a>
                  </li>
      <li class="nav-item">
        <a href="../examples/position.php" class="nav-link">
                      <i class="nav-icon fa fa-user" aria-hidden="true"></i>
              <p>Position User</p>

                    </a>
                  </li>
                  <li class="nav-item">
        <a href="../examples/task.php" class="nav-link active">
 <i class="nav-icon fa fa-list-ol" aria-hidden="true"></i>

         <p>Tasks</p>

                    </a>
                  </li>
                </ul>
              </li>
              <li class="nav-item">
                <a href="../examples/AllTeams.php"   class="nav-link">
                 <i class="fa fa-users" aria-hidden="true"></i>
                    <p>
                      Teams
                    </p>
                </a>
              </li>

        </ul>
      </nav>
      <!-- /.sidebar-menu -->
    </div>
    <!-- /.sidebar -->
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper" >
  <div class="container" style="padding-top: 20px;">
  <div class="row">
    <div class="col-lg-6">
      <h2>All Tasks</h2>
    </div>
    <div class="col-lg-6">
      <button type="button" class="btn btn-primary m-1 float-right" data-toggle="modal" data-target="#addModal">
      <i class="fa fa-plus"></i> Add New Task</button>

    </div>
  </div><br>
</div>
    </section>


<div class="container">
  <div class="row">
    <div class="col-lg-12 col-md-12 col-sm-12">
      <div class="table-responsive" id="tableData">
        <h3 class="text-center text-success" style="margin-top: 150px;">Loading...</h3>
      </div>
    </div>
  </div>
</div>

<!-- Add Record  Modal -->
<div class="modal" id="addModal">
  <div class="modal-dialog">
    <div class="modal-content">
      <!-- Modal Header -->
      <div class="modal-header">
        <h4 class="modal-title">Add New Task</h4>
        <button type="button" class="close" data-dismiss="modal">&times;</button>
      </div>
      <!-- Modal body -->
      <div class="modal-body">
        <form id="formData">
        <div class="form-group">
            <label for="IdUser">IdUser :</label>
        <select type="text" class="form-control" name="IdUser" placeholder="Enter IdUser" required="">
        </select>
        </div>
           <div class="form-group">
            <label for="IdProject">IdProject :</label>
            <input type="text" class="form-control" name="IdProject" placeholder="Enter IdProject" required="">
          </div>
          <div class="form-group">
            <label for="tasks">Task :</label>
            <input type="text" class="form-control" name="tasks" placeholder="Enter Task " required="">
          </div>
          <div class="form-group">
            <label for="StartDate">Start Date :</label>
            <input type="date" class="form-control" name="StartDate" placeholder="Enter StartDate" required="">
          </div>
          <div class="form-group">
            <label for="EndDate">End Date :</label>
            <input type="date" class="form-control" name="EndDate" placeholder="Enter EndDate" required="">
          </div>
          <hr>
          <div class="form-group float-right">
            <button type="submit" class="btn btn-success" id="submit">Submit</button>
            <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
          </div>
        </form>
      </div>
    </div>
  </div>
</div>

<!-- Edit Record  Modal -->
<div class="modal" id="editModal">
  <div class="modal-dialog">
    <div class="modal-content">
      <!-- Modal Header -->
      <div class="modal-header">
        <h4 class="modal-title">Edit Task</h4>
        <button type="button" class="close" data-dismiss="modal">&times;</button>
      </div>
      <!-- Modal body -->
      <div class="modal-body">
        <form id="EditformData">
          <input type="hidden" name="IdTask" id="edit-form-id">
          <div class="form-group">
            <label for="IdUser">IdUser :</label>
            <input type="text" class="form-control" name="uIdUser" id="IdUser" placeholder="Enter IdUser" required="">
          </div>
           <div class="form-group">
            <label for="IdProject">IdProject :</label>
            <input type="text" class="form-control" name="uIdProject" id="IdProject" placeholder="Enter IdProject" required="">
          </div>
          <div class="form-group">
            <label for="tasks">Task :</label>
            <input type="text" class="form-control" name="utasks" id="tasks" placeholder="Enter Task " required="">
          </div>
          <div class="form-group">
            <label for="StartDate">Start Date :</label>
            <input type="date" class="form-control" name="uStartDate" id="StartDate" placeholder="Enter StartDate" required="">
          </div>
          <div class="form-group">
            <label for="EndDate">End Date :</label>
            <input type="date" class="form-control" name="uEndDate" id="EndDate" placeholder="Enter EndDate" required="">
          </div>
          <hr>
          <div class="form-group float-right">
            <button type="submit" class="btn btn-primary" id="update">Update</button>
            <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
          </div>
        </form>
      </div>
    </div>
  </div>
</div>
</div>

  <!-- /.content-wrapper -->

  <footer class="main-footer">
    <div class="float-right d-none d-sm-block">
      <b>@ Primatec 2022</b>
    </div>
   </footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->

<script src=""></script>

<script src=""></script>

<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>
<script src=""></script>

<script src=""></script>

<script src=""></script>

<script>
  $(function () {
    $("#example1").DataTable({
      "responsive": true, "lengthChange": false, "autoWidth": false,
      "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
    }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/v/bs4/dt-1.10.22/datatables.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@10"></script>

<script type="text/javascript">
  $(document).ready(function(){

  showAllCustomer();
  //View Record
  function showAllCustomer(){
    $.ajax({
      url : "action4.php",
      type: "POST",
      data : {action:"view"},
      success:function(response){
          $("#tableData").html(response);
          $("table").DataTable({
            order:[0, 'DESC']
          });
        }
      });
    }

    //insert ajax request data
    $("#submit").click(function(e){
        if ($("#formData")[0].checkValidity()) {
          e.preventDefault();
          $.ajax({
            url : "action4.php",
            type : "POST",
            data : $("#formData").serialize()+"&action=insert",
            success:function(response){
              Swal.fire({
                icon: 'success',
                title: 'Task added successfully',
              });
              $("#addModal").modal('hide');
              $("#formData")[0].reset();
              showAllCustomer();
            }
          });
        }
    });

    //Edit Record
    $("body").on("click", ".editBtn", function(e){
      e.preventDefault();
      var editId = $(this).attr('id');
      $.ajax({
        url : "action4.php",
        type : "POST",
        data : {editId:editId},
        success:function(response){
          var data = JSON.parse(response);
          $("#edit-form-id").val(data.IdTask);
          $("#IdUser").val(data.IdUser);
          $("#IdProject").val(data.IdProject);
          $("#tasks").val(data.tasks);
          $("#StartDate").val(data.StartDate);
          $("#EndDate").val(data.EndDate);
        }
      });
    });


    //update ajax request data
    $("#update").click(function(e){
      if ($("#EditformData")[0].checkValidity()) {
        e.preventDefault();
        $.ajax({
          url : "action4.php",
          type : "POST",
          data : $("#EditformData").serialize()+"&action=update",
          success:function(response){
            Swal.fire({
              icon: 'success',
              title: 'Task updated successfully',
            });
            $("#editModal").modal('hide');
            $("#EditformData")[0].reset();
            showAllCustomer();
          }
        });
      }
    });

    //Delete Record
    $("body").on("click", ".deleteBtn", function(e){
      e.preventDefault();
      var tr = $(this).closest('tr');
      var deleteBtn = $(this).attr('id');
      if (confirm('Are you sure want to delete this Task')) {
        $.ajax({
          url : "action4.php",
          type : "POST",
          data : {deleteBtn:deleteBtn},
          success:function(response){
            tr.css('background-color','#ff6565');
            Swal.fire({
              icon: 'success',
              title: 'Task delete successfully',
            });
            showAllCustomer();
          }
        });
      }
    });
  });
</script>
</body>
</html>
__________________________________________________________________________________________________action4.php

__________________________________________________________________________________________________
<?php
   // Include config.php file
   include_once('config4.php');

   $dbObj = new Database();

   // Insert Record
   if (isset($_POST['action']) && $_POST['action'] == "insert") {
    $IdUser = $_POST['IdUser'];
    $IdProject = $_POST['IdProject'];
      $tasks = $_POST['tasks'];
      $StartDate = $_POST['StartDate'];
      $EndDate = $_POST['EndDate'];
      $dbObj->insertRecond( $IdUser, $IdProject,$tasks, $StartDate, $EndDate);
   }

   // View record
   if (isset($_POST['action']) && $_POST['action'] == "view") {
      $output = "";

      $customers = $dbObj->displayRecord();

      if ($dbObj->totalRowCount() > 0) {
         $output .="<table class='table table-striped table-hover ' style='background-color: #FEFEFF;'>
                 <thead>
                   <tr>
                   <th>IdTask</th>
                   <th>IdUser</th>
                     <th>IdProject</th>
                     <th style='width: 30%;' >  Tasks</th>
                     <th>Start Date</th>
                     <th>End Date</th>
                     <th>Action</th>
                   </tr>
                 </thead>
                 <tbody>";
         foreach ($customers as $customer) {
         $output.="<tr>
                     <td>".$customer['IdTask']."</td>
                     <td>".$customer['IdUser']."</td>
                     <td>".$customer['IdProject']."</td>
                     <td>".$customer['tasks']."</td>
                     <td>".date('d-M-Y', strtotime($customer['StartDate']))."</td>
                     <td>".date('d-M-Y', strtotime($customer['EndDate']))."</td>
                     <td>
                       <a href='#editModal' style='color:green' data-toggle='modal'
                       class='editBtn' id='".$customer['IdTask']."'><i class='fa fa-edit' ></i></a>&nbsp;
                       <a href='' style='color:red' class='deleteBtn' id='".$customer['IdTask']."'>
                       <i class='fa fa-trash' style='margin-left:30px' ></i></a>
                     </td>
                 </tr>";
            }
         $output .= "</tbody>
            </table>";
            echo $output;
      }else{
         echo '<h3 class="text-center mt-5">No records found</h3>';
      }
   }

   // Edit Record
   if (isset($_POST['editId'])) {
      $editId = $_POST['editId'];
      $row = $dbObj->getRecordById($editId);
      echo json_encode($row);
   }


   // Update Record
   if (isset($_POST['action']) && $_POST['action'] == "update") {
      $IdTask = $_POST['IdTask'];
      $IdUser = $_POST['uIdUser'];
      $IdProject = $_POST['uIdProject'];
      $tasks = $_POST['utasks'];
      $StartDate = $_POST['uStartDate'];
      $EndDate = $_POST['uEndDate'];
      $dbObj->updateRecord($IdTask,$IdUser,$IdProject, $tasks, $StartDate, $EndDate);
   }


   // Edit Record
   if (isset($_POST['deleteBtn'])) {
      $deleteBtn = $_POST['deleteBtn'];
      $dbObj->deleteRecord($deleteBtn);
   }


?>
__________________________________________________________________________________________________config4.php

__________________________________________________________________________________________________
<?php

   class Database
   {
      private $servername = "localhost";
      private $username   = "root";
      private $password   = "";
      private $dbname = "register";
      public $con;
      public $customerTable = "tasks";

      public function __construct()
      {
         try {
            $this->con = new mysqli($this->servername, $this->username, $this->password, $this->dbname);
         } catch (Exception $e) {
            echo $e->getMessage();
         }
      }

      // Insert customer data into customer table
      public function insertRecond($IdUser,$IdProject,$tasks, $StartDate, $EndDate)
      {
         $sql = "INSERT INTO $this->customerTable (IdUser,IdProject,tasks, StartDate,EndDate) VALUES('$IdUser','$IdProject','$tasks','$StartDate','$EndDate')";
         $query = $this->con->query($sql);
         if ($query) {
            return true;
         }else{
            return false;
         }
      }

      // Fetch customer records for show listing
      public function displayRecord()
      {
         $sql = "SELECT * FROM $this->customerTable";
         $query = $this->con->query($sql);
         $data = array();
         if ($query->num_rows > 0) {
            while ($row = $query->fetch_assoc()) {
               $data[] = $row;
            }
            return $data;
         }else{
            return false;
         }
      }

      // Fetch single data for edit from customer table
      public function getRecordById($IdTask)
      {
         $query = "SELECT * FROM $this->customerTable WHERE IdTask = '$IdTask'";
         $result = $this->con->query($query);
         if ($result->num_rows > 0) {
            $row = $result->fetch_assoc();
            return $row;
         }else{
            return false;
         }
      }


      public function totalRowCount(){
         $sql = "SELECT * FROM $this->customerTable";
         $query = $this->con->query($sql);
         $rowCount = $query->num_rows;
         return $rowCount;
      }


      // Update customer data into customer table
      public function updateRecord( $IdTask,$IdUser ,$IdProject, $tasks , $StartDate,  $EndDate)
      {
         $sql = "UPDATE $this->customerTable SET IdUser = '$IdUser',IdProject = '$IdProject',tasks = '$tasks', StartDate = '$StartDate', EndDate = '$EndDate'
         WHERE IdTask = '$IdTask'";
         $query = $this->con->query($sql);
         if ($query) {
            return true;
         }else{
            return false;
         }
      }

      // Delete customer data from customer table
      public function deleteRecord($IdTask)
      {
         $sql = "DELETE FROM $this->customerTable WHERE IdTask = '$IdTask'";
         $query = $this->con->query($sql);
         if ($query) {
            return true;
         }else{
            return false;
         }
      }
   }

?>
0
Réponse 7 / 7
blackmefias_3350 Messages postés 709 Date d'inscription dimanche 20 septembre 2020 Statut Membre Dernière intervention 26 novembre 2024 63
Modifié le 31 août 2022 à 17:17

bonjour, 

je pense que le simple serait tout bêtement   de demander à l'utilisateur si les informations  qu'il a rempli dans le formulaire sont exactes  (utiliser un formulaire de vérification) ,  si  l'utilisateur à confirmé   , alors  mettre la valeur sélectionnée (valeur de la liste déroulante)  par l'utilisateur dans une variable. Sinon, demander à l'utilisateur de recommencer le formulaire (redirection) .              
0
NOUR
31 août 2022 à 20:07

Bonjour,

Merci pour votre réponse mais c'est pas ça

Mon but de sélectionner un utilisateur de ma liste (qui a déjà rempli par tous les utilisateurs enregistrés dans bdd) affecté pour cette tache.

Cordialement.

0

Discussions similaires

Tri les lettres d'un mot par ordre alphabétique
labejau37 -
DjiDji59430 -

9 réponses
Suppression listes déroulantes
Archa -
Sam -

5 réponses
Supprimer liste déroulante Excel
SamAlex -
b@bd -

8 réponses
Effacer le contenue d'une cellule avec liste déroulante
lebutters -
lebutters -

7 réponses
ordre alphabetique sous word
raro -
gogo -

27 réponses