我正在努力学习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()
方法中。我只是举个例子。