Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Get List of objects from database [duplicate]

I have a class called Person, with its getters and setters, and I want to know how I can return a List from Data Layer. In C# I use List and I can return the list, but in PHP I don't know how.

function AllPersons()
{
    try 
    {
        $objConn = new Connection();
        $conn = $objConn ->Connect();
        $sql = "SELECT * FROM PERSON";
        $answer= mysqli_query($cn, $sql);
        if(mysqli_num_rows($answer) > 0)
        {
            while($row = mysqli_fetch_array($answer)) 
            {
                /*here i want to do something like in C#
                  List<Person>listPerson;
                  listPerson.add(objPerson);*/
            }
        }
        else
        {
            return null;

        }
    } 
    catch (Exception $e) 
    {
        //FB::log("nada");
    }
}
like image 811
Luis Pavez Avatar asked Oct 15 '25 03:10

Luis Pavez


1 Answers

Create an array and fill it.

$listPerson = [];   
while($row = mysqli_fetch_array($answer)) {
    $listPerson[] = new Person($row);
}
like image 60
Martin Kuchyňár Avatar answered Oct 17 '25 22:10

Martin Kuchyňár