title: How can i insert html table data into sql database using php?
body: <p>This is my table html code. I tried sending the data using the normal insert but it only sends the last row data. I don't know how to send the full data . Can someone please help me with this.</p>
  
  <pre><code>&lt;form action="admin_schedule_employee.php" id="schedule_employee" method="post" &gt;
             &lt;input type="date" class="input-sm" name="scheduledate" style="margin:10px;"&gt;
             &lt;table class="table-responsive table table striped table-bordered"&gt;
                  &lt;thead&gt;
                      &lt;tr&gt;
                          &lt;th  style="width:20%"&gt;Employee First Name&lt;/th&gt;
                          &lt;th  style="width:20%"&gt;Employee ID&lt;/th&gt;
                          &lt;th  style="width:20%"&gt;Start Time&lt;/th&gt;
                          &lt;th  style="width:20%"&gt;End Time&lt;/th&gt;                            
                      &lt;/tr&gt;
                      &lt;?php while($row = mysqli_fetch_array($search_result)): ?&gt;
                      &lt;tr&gt;
                         &lt;td&gt;&lt;input disabled name="employeename" type="text" value="&lt;?php echo $row['fname']; ?&gt;"&gt;&lt;/input&gt;&lt;/td&gt;
                         &lt;td&gt;&lt;input disabled name="employeeid"   type="number" value="&lt;?php echo $row['employee_id']; ?&gt;"&gt;&lt;/input&gt;&lt;/td&gt;
                         &lt;td&gt;&lt;input name="starttime" type="time"&gt;&lt;/td&gt;
                          &lt;td&gt;&lt;input name="endtime" type="time"&gt;&lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;?php endwhile; ?&gt;
                  &lt;/thead&gt;
                  &lt;tbody&gt;
                 &lt;/tbody&gt;
              &lt;/table&gt;    
              &lt;input type="submit" name="Schedule" value="Schedule"&gt;              
           &lt;/form&gt;[This is how my table look like i want to send the whole data to sql database using php][1]
  </code></pre>