Unable to get row values along with dropdown list [duplicate]

Question

<thead>
<tr>
    <th>User ID</th>
    <th>User Name</th>
    <th>Designation</th>
    <th>M a r k  A t t e n d a n c e</th>
</tr>
    </thead>
        <tbody>
<?php
    $result = $conn->query("SELECT * FROM userdetails");
    if($result->num_rows > 0){
        while($row = $result->fetch_assoc()){
        ?>
            <tr>
                <td><?php echo $row['userid']; ?></td>
                <td><?php echo $row['username']; ?></td>
                <td><?php echo $row['designation']; ?></td>
        <td>
                   <select name="brandlist[]" id = "brandlist" class=="col-sm-2">
                   <option value="present">Present</option>
                   <option value="absent">Absent</option>
                   <option value="late">Late</option>
                   <option value="absconding">Absconding</option>
                   <option value="resigned">Resigned</option>
                   <option value="terminated">Terminated</option>
                   </select>
        </td>
         </tr>
        <?php 
} 
}else{ 
?>
            <tr><td colspan="5">No Employees Found...</td></tr>
        <?php } ?>
</tbody>
    </table>
</div>
</div>
    <div class="col-12">
        <button type="submit" name = "submit">Submit</button>
    </div>

</form>
    </div>
</div>
</div>

This works all good, I can see rows displayed on screen and I can also select dropdown list and select attendance. Upon selecting submit, Below code runs all good and saves attendance in table.

<?php
if(isset($_POST['submit']));
{
    $attendances = $_POST['brandlist'];
    foreach($attendances as $item)
    {
       $query = "INSERT INTO attendance (attendancemarked) VALUES ('$item')";
        $query_run = mysqli_query($conn, $query); 
        echo "<script language= 'JavaScript'>alert(' . $useriids . ');</script>";
    }
}
?>

This entire code works all good. I am able to get data from userdetails table and display the records in row. I have added dropdown list in every row for marking attendance for employees. When I submit, attendance array saves all the attendance marked but userid, username, designation is not getting saved. I want these 3 fields also to get stored in the table attendance.

Answer 1

There are several problems with your code:

• The values you want are not available as fields in your form, so they are not sent to PHP
• your PHP code doesn't try to read those values from the submitted $_POST data
• your SQL code doesn't try to insert those values into the database table
• your SQL code is written in a way which is insecure and unreliable
• there should be no need to store the user ID and username in the attendance table. Only the ID should be needed - it's sufficienct by itself to uniquely identify which user the attendance record relates to.
• there is a typo: if(isset($_POST['submit'])); needs the ; removing so it doesn't terminate the if block early.

The following example fixes these issues.

Form display: In this section I've added user ID and designation as hidden fields, and given the attendance field a more meaningful name

<thead>
<tr>
    <th>User ID</th>
    <th>User Name</th>
    <th>Designation</th>
    <th>M a r k  A t t e n d a n c e</th>
</tr>
    </thead>
        <tbody>
<?php
    $result = $conn->query("SELECT * FROM userdetails");
    if($result->num_rows > 0){
        while($row = $result->fetch_assoc()){
        ?>
            <tr>
                <td><?php echo $row['userid']; ?></td>
                <td><?php echo $row['username']; ?></td>
                <td><?php echo $row['designation']; ?></td>
                <td>
                  <input type="hidden" name="user[]" value="<?php echo $row['userid']; ?>">
                  <input type="hidden" name="designation[]" value="<?php echo $row['designation']; ?>">
                   <select name="attendance[]" id = "attendance" class=="col-sm-2">
                   <option value="present">Present</option>
                   <option value="absent">Absent</option>
                   <option value="late">Late</option>
                   <option value="absconding">Absconding</option>
                   <option value="resigned">Resigned</option>
                   <option value="terminated">Terminated</option>
                 </select>
               </td>
         </tr>
        <?php 
} 
}else{ 
?>
            <tr><td colspan="5">No Employees Found...</td></tr>
        <?php } ?>
</tbody>
    </table>
</div>
</div>
    <div class="col-12">
        <button type="submit" name = "submit">Submit</button>
    </div>
</form>
</div>
</div>
</div>

Form processing: In this part of the code I've added code to read from all the relevant $_POST values, changed the loop to a for so the loop counter can be used to select the associated values from each of the submitted arrays (there is one for each field), and used prepared statements and parameters to build the query correctly.

if(isset($_POST['submit']))
{
    $attendances = $_POST['attendance'];
    $userIDs = $_POST['user'];
    $designations = $_POST['designation'];

    $query = "INSERT INTO attendance (attendancemarked, userID, designation) VALUES (?, ?, ?)";
    $stmt = $conn->prepare($query);

    for ($i = 0; $i < count($attendances); $i++)
    {
        $stmt->execute([$attendances[$i], $userIDs[$i], $designations[$i]);
        echo "Inserted attendance record for ".htmlspecialchars($userIDs[$i])."<br>";
    }
}