PHP Dropdown List Causing Endless Loop

Question

I am trying to dynamically populate a drop down list in PHP and it is causing an endless loop and my browser to crash. I do not know how to correctly get it to show all the rows in one table but I would think this would be a relatively simple fix. The while loop might be throwing it off. Let me know if you need more information I am following this example but mine is written in PDO:

Dynamic drop down list using html and php

<h3>Company Listing</h3>
           <select name='companies'>
            <option value="">--- Select ---</option>
          <?php
          //gets user's info based off of a username.
    $query = "SELECT business_name FROM Businesses";

    try 
    {
        $stmt   = $db->prepare($query);
        $result = $stmt->execute($query_params);

    }
    catch (PDOException $ex) {
    }

//fetching all the rows from the query
$profileRow = $stmt->fetch();
while ($profileRow) 
{ 
?>

<option value="<?php echo $profileRow['business_name']?>"><?php echo $profileRow['business_name']?></option>

<?php
}
?>
    </select>
          <p></p>

anurupr · Accepted Answer · 2014-03-16 22:57:01Z

4

$profileRow is not changing . so it will always be true

You need to do it like this

while($profileRow = $stmt->fetch())

answered Mar 16, 2014 at 22:57

anurupr

2,3442 gold badges20 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2793987 Over a year ago

That's it! Thanks! I will mark your answer as the correct one as soon as I can.

faintsignal · Accepted Answer · 2014-03-16 22:57:35Z

4

Change

$profileRow = $stmt->fetch();
while ($profileRow) 
{

to

while ($profileRow = $stmt->fetch()) 
{

so that $profilerow keeps changing and eventually evaluates to something equivalent FALSE inside the while condition when there are no more rows left. In your version $profilerow becomes an object and never changes. An object evaluates to TRUE in the while condition.

answered Mar 16, 2014 at 22:57

faintsignal

1,8363 gold badges22 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP Dropdown List Causing Endless Loop

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related