Populate combobox dynamically

[fmax]

Hi All

Using MVC Model i am stuck on multiple dependent combobox, My first combobox model code is as follows

function getCompanyName(object $pdo){
    $query = "SELECT * FROM MASTER_COMPANY;";
    $companyNameStmt = $pdo->prepare($query);
    $companyNameStmt->execute();
    $companyNameresult = $companyNameStmt->fetchAll(PDO::FETCH_ASSOC);
    return $companyNameresult;
}

I want to populate to a combobox

 

<select name="FCompName" id="company-id" class="form-select" required="">
<option value="" disabled selected>--- SELECT COMPANY ---</option>
                                <?php
                                    
                                ?>
</select>

 

[Barand]

Loop through the returned results of your function and output the options

<?php
    foreach (getCompanyName($pdo) as $row)   {
        echo "<option value='{$row['id']}'>{$row['name']}</option>" ;
    }
?>

 

[fmax]

8 minutes ago, Barand said:

Loop through the returned results of your function and output the options

<?php
    foreach (getCompanyName($pdo) as $row)   {
        echo "<option value='{$row['id']}'>{$row['name']}</option>" ;
    }
?>

 

(): Argument #1 ($pdo) must be of type object, null given

[Barand]

Then use the actual name of your PDO connection object instead of $pdo. My apologies for not being psychic.