How to create a PHP loop with an array fetched inside a class?

Question

I'm trying to create a loop in a page that populates a form with several options from a database. In this case the form is intended to create an ASSEMBLY and will require the selection of already existent PARTS in the database.

The approach I'm trying to achieve is the following:

A. I created a class containing the following function in a file called classes.php:

<?php 

$depth = "../";
require_once("connection.php");

////////////////////////////////////////////

class Parts
{
    // SELECTS ALL PARTS FROM DATABASE
    public function getPartInfo() {
        global $con;
        $partinfo = mysqli_query($con,"SELECT * FROM parts ORDER BY name");
        $row = mysqli_fetch_assoc($partinfo);
        return $row;
    }

} // end of Parts

?>

B. In another file (assemblies.php) I'm trying to catch the value of all fields in the array so I can create a loop listing all rows so the user can select the parts required for the assembly. I'm trying the following code with no success:

    <?php
    session_start();

    include "php_includes/classes.php";

    $parts = new Parts();
    $parts_detail = $parts->getPartInfo();

    ?>

    <div class="row">
       <div class="form-group col-md-12">
          <table width="100%" id="partsTable">
             <?php 
                foreach($parts_detail as $row) {
                   echo '<tr>
                         <td><input type="checkbox" name="parts[]" value="'.$row["id"].'" /></td>
                         <td><img src="https://lux365.s3.amazonaws.com/landing-pages/easilite/v1/img/easilite-logo.jpg" alt="" /></td>
                         <td>'.$row["name"].'</td>
                         <td><input type="number" name="partQuantity[]" min="0" /></td>
                         </tr>';
                 }
              ?>
           </table>
        </div>
    </div>

Where $row["name"] is trying to get the field NAME from the parts table and $row["id"] tries to call the field ID from the parts table.

But when I try this, it results in an Illegal string offset error, for both, name and id.

Any help is appreciated since my OOP skills are extremely limited.

Thanks in advance

take a look into isset() - it's not a real error but a warning, it's telling you that $row['name'] isn't in the array var_dump your $row and see what you have access to php.net/manual/en/function.isset.php — treyBake
– treyBake, Commented May 25, 2017 at 10:13

Barmar · Accepted Answer · 2017-05-25 10:16:36Z

2

getPartInfo() just returns the first row returned by the query. Then your for ($parts_detail as $row) loop is looping over the columns in that row, not all the rows. So $row is a string containing a column value, and $row['name'] gets an error because $row isn't an associative array.

It should have a loop and return all the rows.

public function getPartInfo() {
    global $con;
    $partinfo = mysqli_query($con,"SELECT * FROM parts ORDER BY name");
    $result = array();
    while ($row = mysqli_fetch_assoc($partinfo)) {
        $result[] = $row;
    }
    return $result;
}

edited May 25, 2017 at 10:16

answered May 25, 2017 at 10:13

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Comment

L. Paz Over a year ago

And that was the problem... Thank you very much Barmar!

Canh Nguyen · Accepted Answer · 2017-05-25 10:16:44Z

1

Try...

class Parts
{
    // SELECTS ALL PARTS FROM DATABASE
    public function getPartInfo() {
        global $con;
        $partinfo = mysqli_query($con,"SELECT * FROM parts ORDER BY name");
        $arrRow = array();
        while($row = mysqli_fetch_assoc($partinfo)){
            $arrRow[] = $row;
        }
        return $arrRow;
    }

}

answered May 25, 2017 at 10:16

Canh Nguyen

3331 silver badge18 bronze badges

Collectives™ on Stack Overflow

How to create a PHP loop with an array fetched inside a class?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related