PHP displaying once if repeated data in the field

Question

I know this question has been answered similar to the previous asked question. I have tried the solutions but it seems that no matter what way I have tried I still can't get this to work. I am not sure is my coding structure is wrong somewhere.

Currently it is displaying the result as:

Cafes (Category)
Starbucks

Cafes (Category)
CoffeeBean

But I wanted it to show:

Cafes (Category)
Starbucks
CoffeeBean

Below is my code:

<?php
    $levelArray=array('L1','B1','L2','B2');
        foreach ($levelArray as $i=>$level) {
             $data='';
            $img = "img/".$levelArray[$i];
           $result = mysqli_query($con,"SELECT * FROM floor_directory WHERE level='$levelArray[$i]'");
           while($row = mysqli_fetch_array($result)){
            $data .= '<h1>'.$row['categories'].'</h1>
                        <ul class="shop_listing clearfix">
                            <li class="float_left">'.$row['name'].'</li>
                            <li class="float_right">'.$row['unit_number'].'</li>
                        </ul>';
        }
        echo '<div class="swiper-slide">
            <img src="'.$img.'" alt="" />
                <div class="content_container">'.$data.'</div>
          </div>'

        }

     ?>

Any help will be appreciated. Thanks in advance.

Well, you want to group stuff by category. To do that, introduce a processing step between query and display. In general going directly from query results to HTML is inadequate for anything except tutorials. — Jon
– Jon, Commented Oct 30, 2013 at 9:51
In addition: $levelArray[$i] inside the foreach() is unnecessary, since you are extracting the values in $level, just use $level — Ivan Yonkov
– Ivan Yonkov, Commented Oct 30, 2013 at 9:58

ran · Accepted Answer · 2013-10-30 09:59:47Z

1

$previousVal = "";
while($row = mysqli_fetch_array($result)){
if($previousVal != $row['categories']){
     $data .= '<h1>'.$row['categories'].'</h1>
     $previousVal = $row['categories'];
}
     $data .= '<ul class="shop_listing clearfix">
               <li class="float_left">'.$row['name'].'</li>
               <li class="float_right">'.$row['unit_number'].'</li>
               </ul>';
}

try this one.

answered Oct 30, 2013 at 9:59

ran

111 bronze badge

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

1 Comment

Dr3am3rz Over a year ago

Hi Ran, I have tested it and it worked somehow. I tried to add in 1 more record into the table, it display the latest input data as separated from the previous one. Example, I displayed 2 shop name from Cafe category followed by 1 shop name from Restaurant category. When I input new data into Cafe category, it will display after the Restaurant category instead of showing together with the Cafe category. Hope you get what I mean.

Huey · Accepted Answer · 2015-08-08 03:33:09Z

0

Well, every time you echo the name of a shop, the category is also echoed, because you're printing the $row['categories'] and $row['name'] at the same time.

To fix this, you probably have to separate it, probably by adding a processing step as mentioned by Jon that groups all the shops in the same category together, and echoes the categories once only.

$allCategories = array(); $data='';

while($row = mysqli_fetch_array($result)){
    if(!array_search($row['categories'],$allCategories)){
        array_push($allCategories,$row['categories']);
        $data .= "<h1>{$row['categories']}</h1>";
    }
    $data.= '<ul class="shop_listing clearfix">
                 <li class="float_left">'.$row['name'].'</li>
                 <li class="float_right">'.$row['unit_number'].'</li>
             </ul>';

        }

edited Aug 8, 2015 at 3:33

answered Oct 30, 2013 at 9:56

Huey

5,2206 gold badges36 silver badges45 bronze badges

3 Comments

Ivan Yonkov Over a year ago

If answering, then show a code example, this is nothing much than Jon's comment :)

Dr3am3rz Over a year ago

Thanks huey for the help =) It turns out the same issue that I am facing using Ran's solution. =S Meaning it will display the new data in new line instead of displaying together with the same category whenever there is new data input. Example: (Cafes, Starbucks, Coffeebean) (Restaurant, Swensen) [When adding in new data] -> it displays (Cafes, TCC) behind the Restaurant instead of (Cafes, Starbucks, Coffeebean, TCC)

Huey Over a year ago

Try changing your mySQL query to sort the rows by category. That should resolve it. So it's something like: SELECT * FROM floor_directory WHERE level='$level' ORDER BY categories

Collectives™ on Stack Overflow

PHP displaying once if repeated data in the field

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related