Change data in the while loop while looping

Question

I am working in php and right now i am applying while loop to my code. i am fetching data from database. Now i have to apply that data on one Div in the page.

My problem is that "div class="item active"" in the loop it take every time the active class. now i want to change that like after 1st loop process when second gone start i want to change that div to this "div class="item"" .

I am little new at this looping process so i am not able to solve this. need help. Thanks.

<?php 

                $sqlEvent = "SELECT * FROM eventdata WHERE id='$id'";

                $resultEvent = mysqli_query($connection, $sqlEvent);

                if (mysqli_num_rows($resultEvent) > 0) {

                while ($rowEvent = mysqli_fetch_array($resultEvent)) {

                ?><div class="item active"> <img src="images/event/1.jpg" alt="..." class="img-responsive">
                              <div class="carousel-caption wedding-area">
                                <h2><?php echo $rowEvent['eventTitle']; ?></h2>
                                <h4><?php echo $rowEvent['eventDate']; ?></h4>
                                <h4><?php echo $rowEvent['eventTime']; ?></h4>
                                <div class="details hidden-xs">
                                  <p><?php echo $rowEvent['eventDesc']; ?> </p>
                                </div>
                                <a href="#" class="btn btn-default" role="button">Read More</a> </div>
                            </div><?php

                }

                }

                ?>

Use flag is_first and change it after first iteration. Thousands of such questions. — u_mulder
– u_mulder, Commented Jun 24, 2016 at 12:39
Possible duplicate of How to get specific column data SQL for first row only in PHP? — u_mulder
– u_mulder, Commented Jun 24, 2016 at 12:41

Saty · Accepted Answer · 2016-06-24 12:41:38Z

1

Use a counter to check first iteration

$i = 1;// initialized counter
while ($rowEvent = mysqli_fetch_array($resultEvent)) {
    if ($i == 1) {// check for first iteration
        ?><div class="item active"> <img src="images/event/1.jpg" alt="..." class="img-responsive">
    <?php } else { ?>

            <div class="item"> <img src="images/event/1.jpg" alt="..." class="img-responsive">
                <?php
            }
            $i++;// increase counter

        ?>

answered Jun 24, 2016 at 12:41

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

2 Comments

always-a-learner Over a year ago

let me try this one

always-a-learner Over a year ago

Please up the question if it is.

luk_z · Accepted Answer · 2016-06-24 12:56:25Z

You want only the first div of the loop has class "active"... then this code should work for you

Just set variable = "actìve" then at the end of the body loop set = "".

In each iteration print the variable in the class attribute of your div

$sqlEvent = "SELECT * FROM eventdata WHERE id='$id'";

$resultEvent = mysqli_query($connection, $sqlEvent);

if (mysqli_num_rows($resultEvent) > 0) {
    $classActive = "active";
    while ($rowEvent = mysqli_fetch_array($resultEvent)) {
        ?>
            <div class="item <?php echo $classActive; ?>"> 
                <img src="images/event/1.jpg" alt="..." class="img-responsive">
                <div class="carousel-caption wedding-area">
                    <h2><?php echo $rowEvent['eventTitle']; ?></h2>
                    <h4><?php echo $rowEvent['eventDate']; ?></h4>
                    <h4><?php echo $rowEvent['eventTime']; ?></h4>
                    <div class="details hidden-xs">
                      <p><?php echo $rowEvent['eventDesc']; ?> </p>
                </div>
                <a href="#" class="btn btn-default" role="button">Read More</a> </div>
            </div>
        <?php
        $classActive = "";
    }

}

fazi · Accepted Answer · 2016-06-24 19:54:27Z

0

use pdo functions they are easier to use

http://php.net/manual/pl/pdostatement.fetchall.php

and always escape values in sql query!

<?php 


             $sth = $dbh->prepare("SELECT * FROM eventdata WHERE id=?);
             $sth->execute([$id]);
             foreach ($sth->fetchAll(PDO::FETCH_ASSOC) as $i => $rowEvent) {

            ?><div class="item  <?php if(1 === $i) echo 'active';?>"> <img src="images/event/1.jpg" alt="..." class="img-responsive">
                          <div class="carousel-caption wedding-area">
                            <h2><?php echo $rowEvent['eventTitle']; ?></h2>
                            <h4><?php echo $rowEvent['eventDate']; ?></h4>
                            <h4><?php echo $rowEvent['eventTime']; ?></h4>
                            <div class="details hidden-xs">
                              <p><?php echo $rowEvent['eventDesc']; ?> </p>
                            </div>
                            <a href="#" class="btn btn-default" role="button">Read More</a> </div>
                        </div><?php

            }


            ?>

edited Jun 24, 2016 at 19:54

answered Jun 24, 2016 at 12:51

fazi

112 bronze badges

1 Comment

ρяσѕρєя K Over a year ago

Instead of posting links as answer add some text to explanation how this answer help to OP in fixing current issue.Thanks

Collectives™ on Stack Overflow

Change data in the while loop while looping

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related