我正在努力学习OOPHP,我想我已经达到了目的。我只是不知道输出多个数据库行的最佳方式是什么。
我尝试过的第一种方法是在函数中正常地执行输出,但我认为这种方法违背了OOP的目的。
我还尝试在数据库查询将所有数据推送到的类中设置public $list,然后在代码外部的数据中循环,但理想情况下,我希望从查询中创建对象的多个实例,并使用它们的公共变量(在我的测试用例中为I d、name和eyecollour)来获取数据,以便数据始终来自同一个地方。但是,如何从类内的查询创建多个对象,然后如何循环这些对象以显示它们,以及如何区分它们或仅针对具有特定值的特定对象?
我浏览了许多主题,但它们似乎都集中在特定情况下的问题上。我想从这个简单的意义上学习,这样我就可以把它应用到更大的项目中。
这是我一直在玩的代码:

class Ignition {

public function dataConnection() {
    return new PDO('mysql:host=localhost;port=8889;dbname=oop_testing','root','root',array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
    }

}


class People {

private $db;

// Each person has a
public $id;
public $name;
public $eyecolour;
public $list = array();

public function __construct() {
    $this->db = new Ignition();
    $this->db = $this->db->dataConnection();
}

public function getList() {
    echo "People:<br /><br />";
    $sql = $this->db->prepare("SELECT * FROM people");
    $sql->execute();
    //$this->list = $sql->fetch(PDO::FETCH_ASSOC);
    while($person = $sql->fetch(PDO::FETCH_ASSOC)) {
        array_push($this->list, $person);
    }


    /*while($person = $sql->fetch(PDO::FETCH_ASSOC)) {
        echo $person['name'] . "<br />";
    }*/
}

public function getIndividual($search, $by = "id") {
    $sql = $this->db->prepare("SELECT * FROM people WHERE $by = :search");
    //$sql->bindParam(":by", $by);
    $sql->bindParam(":search", $search);
    $sql->execute();
    $individual = $sql->fetch(PDO::FETCH_ASSOC);
    $this->id = $individual['id'];
    $this->name = $individual['name'];
    $this->eyecolour = $individual['eyecolour'];
}

}


$people = new People();
$people->getList();

/*echo "<pre>";
var_dump($people->list);
echo "</pre>";*/

foreach ($people->list as $person) {
    echo $person['name'];
}

$people->getIndividual(1);
echo "<br />Name: " . $people->name;
echo "<br />Eye Colour: " . $people->eyecolour;

最佳答案

最好的选择实际上是得到一个列表的人对象如何做,这取决于你。我会利用PDO::FETCH_类并使用如下静态函数:

class People {
    public $id;
    public $name;
    public $eyecolour;

    public function display() {
        echo "Id: {$this->id} name: {$this->name} eyecolour: {$this->eyecolour} <br>";
    }

    public static function get() {
        $result = self::db()->prepare("select * from people limit 1");
        $result->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE,'People');
        $result->execute();
        return $result->fetch();
    }

    public static function getall() {
        $result = self::db()->prepare("select * from people");
        $result->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE,'People');
        $result->execute();
        return $result->fetchAll();
    }

    public static function db() {
        return new PDO("mysql:host=127.0.0.1;dbname=mydb", 'root', '', array(PDO::ATTR_PERSISTENT => true));
    }
}


$person = People::get();
$person->display();
$all_people = People::getall();

foreach($all_people as $single_person) {
    //$single_person is an instance of People
    $single_person->display();
}

显然,您可以像在函数中那样将搜索条件添加到get()getall()方法中。我只是举个例子。

10-06 04:03
查看更多