How to return a single value from a function class into foreach loop

Question

I really need help for this one, im new on this php oop. my problem here i can only display a data on a single row of my table. here is my function class

<?php

include('connection.php'); 

class guestDetails{

    public function guest($id){

            $query = mysql_query("SELECT * FROM tb_member WHERE memberID = '{$id}' ");
            $row = mysql_fetch_array($query);

            return $row;


    }
}
?>

And here is where i have foreach loop:

      <table class="table table-bordered" id="table_id">
        <thead>
          <tr>
            <th>Booking No.</th>
            <th>Date</th>
            <th>RoomType</th>
            <th>Guest</th>
            <th>Status</th>
            <th>Payment</th>
            <th></th>
          </tr>
        </thead>
        <tbody>
          <?php
            $lists = new crudBooking;
                    $list = $lists->viewBooking();
            $rows = new guestDetails;
            foreach($list as $key => $value){             
            $id = $value['reserveID'];

            $from = new DateTime( $value['arrival'] );
            $to = new DateTime( $value['departure'] );
          ?>
          <tr>
            <td><?php echo $value['reserveID']; ?></td>
            <td><?php echo $from->format( 'F d, Y' ) . " - " . $to->format( 'F d, Y' ); ?></td>
            <td><?php echo $value['category_id']; ?></td>
            <td>
              <?php 

                $row = $rows->guest($value['reserveID']);
                echo $row['firstname'] . " " . $row['lastname'] . "<br /><a href='#'>" . $row['email'] . "</a>"; 
              ?>
            </td>
            <td><?php echo $value['status']; ?></td>
            <td>to be edited</td>
            <td style="text-align: center;">
              <!-- Split button -->
                <div class="btn-group">
                  <button type="button" class="btn btn-default btn-sm">Action</button>
                    <button type="button" class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                      <span class="glyphicon glyphicon-asterisk"></span>
                      <span class="sr-only">Toggle Dropdown</span>
                    </button>
                  <ul class="dropdown-menu">
                    <li><a href="<?php echo $value['reserveID']; ?>" data-toggle="modal" data-target="#editProduct<?php echo $value['reserveID']; ?>">Check-in</a></li>
                    <li><a href="<?php echo $value['reserveID']; ?>" data-toggle="modal" data-target="#deleteProduct<?php echo $value['reserveID']; ?>">Check-out</a></li>                             
                    <li><a href="<?php echo $value['reserveID']; ?>" data-toggle="modal" data-target="#deleteProduct<?php echo $value['reserveID']; ?>">Cancel</a></li>
                    <li><a href="<?php echo $value['reserveID']; ?>" data-toggle="modal" data-target="#deleteProduct<?php echo $value['reserveID']; ?>">More Details</a></li>
                  </ul>
                </div>
            </td>
            <?php include('includes/modals.php'); ?>
          </tr>
          <?php }  ?>
        </tbody>
      </table>

The problem here is it only return on the first row of my table. This is the code where i call the return value of guest() class:

                <td>
              <?php 

                $row = $rows->guest($value['reserveID']);
                echo $row['firstname'] . " " . $row['lastname'] . "<br /><a href='#'>" . $row['email'] . "</a>"; 
              ?>
            </td>

Here is the table

You should use a while loop on the query (like while ($row=mysql_fetch_array){ ...}; otherwise you will just get the first row returned. Also, I recommend using a prepared statement, rather than writing id directly into your query. — Sablefoste
– Sablefoste, Commented Jul 25, 2015 at 4:39
i tried this but i dont know if its correct but when i tried it only showed the data on first row public function guest($id){ $query = mysql_query("SELECT * FROM tb_member WHERE memberID = '{$id}' "); while($rows = mysql_fetch_array($query)){ $row[] = $rows; } return $row; } — Benjamin Española
– Benjamin Española, Commented Jul 25, 2015 at 4:59

JOE LEE · Accepted Answer · 2015-07-25 05:01:27Z

2

are you sure tb_member.memberID have all reserveID, do something like

 $row = $rows->guest($value['reserveID']);
 if(!$row){
  echo "NO this member,reserveID:".$value['reserveID'];
  }else{
     echo $row['firstname'] . " " . $row['lastname'] . "<br /><a href='#'>" . $row['email'] . "</a>";
 }

if reserveID is not memberID

 $row = $rows->guest($value['YOUR MENBER ID COLUME NAME']);

edited Jul 25, 2015 at 5:01

answered Jul 25, 2015 at 4:54

JOE LEE

1,0581 gold badge6 silver badges6 bronze badges

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

3 Comments

Benjamin Española Over a year ago

no im querying my tb_reserved that has a memberID i just dont know if i need to show that too sorry,.. i just want to show the details about that memberID from tb_reserved

JOE LEE Over a year ago

then uses $rows->guest($value['memberID']);

Benjamin Española Over a year ago

oh my god it works :D tnx a lot what a shame on me huhu for posting this one

Collectives™ on Stack Overflow

How to return a single value from a function class into foreach loop

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related