Select Not Populating in Dynamically ID'd Bootstrap 4 Modal

Question

Where I Am Now

I have an HTML table with many rows populated by a PHP foreach loop from a SQL statement. The final column of the table contains a drop-down list of buttons, one of which is "Assign Vehicle". This button triggers a bootstrap-4 modal with a select box. The table is a list of vehicles, the select box within the modal is a list of employees.

What I Want to Happen

The user clicks "Assign Vehicle" in the table. The modal pops up allowing the user to select an employee for assignment. The vehicle_id and employee_id are then transported to another page for processing.

The Code



fetchAll() as $row){

            $a++;
            $u++;
        ?>
        
            
                
                    
                        Unassign Confirmation
                        
                    
                    
                        Are you certain that you would like to unassign the 
                         
                        from 
                        ?
                    
                    
                        
                        
                    
                
            
        

            
                
                    
                        Assign Vehicle to User
                        
                    
                    
                        
                    
                    
                        
                        
                    
                
            
        closeCursor(); ?>
    
    
        
            Year
            Make
            Model
            Unit #
            Asset #
            Assignee
            Admin
        
    
    
        
            Year
            Make
            Model
            Unit #
            Asset #
            Assignee
            Admin
        
    
    
        
            
            
            
            
            
            
            
            
            
            Unassigned
            
            
                
                    
                    
                    
                    Unassign Vehicle
                    
                    Assign Vehicle
                    

                    Modify Vehicle
                    Retire Vehicle

The Problem

You'll notice from the code that the "Assign" modal ID is dynamically assigned. I feel as though this is necessary in order to pass on the respective rows vehicle ID to the modal. Unfortunately, as long as the modals ID is assigned dynamically, this solution only works for the very first record (or when the Veh_ID = 1), for any other row the modal shows up with the select box but there are no results, the select box is empty.

The "Unassign" modal works perfectly fine as-written even with the dynamically assigned ID. This only seems to be a problem with the select box from my perspective, though I'm a novice coder at best.

Example

Example page with both functions active.

On the page linked above, for any row in the table, if you hover "Modify Vehicle" you can see the ID in the address bar. Clicking "Assign Vehicle" on any vehicle that doesn't have vehicle_id = 1 will result in an empty select box in the modal. Feel free to assign or unassign as needed.

Don&#39;t Panic · Accepted Answer

Viewing the source of your example page, I see that your modals etc are all being created correctly, the only problem is the list of employees in the select only appearing the first time. So, look at how that is generated - $assign. That is where the problem is.

Checking the docs for fetchall():

fetchAll() returns an array containing all of the remaining rows in the result set

Note remaining. After the first full iteration in the first table row, you've already retrieved all the results. There's nothing left to fetch. So on the next iteration there are no remaining results to fetch, and you get an empty is identical in every row. So rather than repeatedly retrieving your results, it would be much simpler to retrieve them once, outside of your main $vehicle table loop, and set up a $select variable that you can just then echo on every row.

If you want to have the right employee pre-selected on each row, to show who is currently assigned, you could do that with a bit of preg_replace()ing on each row.

One other note - you're also using:

$assign->closeCursor();

So maybe you were intending to make the result set scrollable. The docs describe how to do that, and to make sure that you scroll back to the beginning of the set once you've reached the end. Though AFAIK you'd typically only need this if you intended to retrieve only some of the results, or switch to handling a different query before finishing with the first. You're not doing either of those things so I am not sure using the cursor is required at all.

Note your question has a few elements but each of them more or less has a duplicate here on SO already. It is worth reading through all the answers to the following questions as many of them are helpful and highlight different parts of the problems.

PDO multiple fetching of same query

Resetting array pointer in PDO results

When should I use closeCursor() for PDO statements?

Select Not Populating in Dynamically ID'd Bootstrap 4 Modal

Answers (1)

Related Questions

Select Not Populating in Dynamically ID&#39;d Bootstrap 4 Modal

Answers (1)

Related Questions

Select Not Populating in Dynamically ID'd Bootstrap 4 Modal