pdo，将php对象插入数据库(pdo, insert php object to database)

pdo，将php对象插入数据库(pdo, insert php object to database)

我无法找到这个问题的答案。

我想将一个php对象保存到mysql数据库中。 例：

class user{ private $id, $email, $pw, $first, $last, $group,.....; // getters and setters } class someclass{ public function someFunction(){ $pdo = new PDO(...); $objUser = new user(); $objUser->setEmail(....); $objUser->setFirst(....); //bla bla bla // and i want to save this user object to DB with something like: $pdo->insert($objUser); //in this case db table equals to class name //instead of building/writing query manually. //for mysql_query i have made a class for building query for insert update delete //but mysq_query is old and deprecated } }

我要求这个的主要原因是因为我不想写一些默认存在的东西。

谢谢。

i cant find answer to this question.

I want to save into mysql database a php object. Example:

class user{ private $id, $email, $pw, $first, $last, $group,.....; // getters and setters } class someclass{ public function someFunction(){ $pdo = new PDO(...); $objUser = new user(); $objUser->setEmail(....); $objUser->setFirst(....); //bla bla bla // and i want to save this user object to DB with something like: $pdo->insert($objUser); //in this case db table equals to class name //instead of building/writing query manually. //for mysql_query i have made a class for building query for insert update delete //but mysq_query is old and deprecated } }

main reason i am asking for this is because i dont want to write something that can exists by default.

Thank you.

最满意答案

我可能会在user类中实现insert，update和delete方法，而不是使它成为数据库类的一个特性来解释给它的对象。

在PHP或mysql PDO类中没有内置的方法，但是有些框架实现了ORM（对象关系映射），允许您在对象类中轻松指定它们与数据库的交互方式。 （ Laravel框架ORM文档 ）

这是您可以实现它的一种非常基本的方法。

class ORM { public function insert($pdo) { // Get object name // Get object properties // Check if database table exists with object name // Generate and run a query to insert a record into that table // using the property names and values } public function update($pdo) { // Like insert, but update } public function delete($pdo) { // Etc... } } class user extends ORM { private $id, $email, $pw, $first, $last, $group,.....; // getters and setters } class someclass{ public function someFunction(){ $pdo = new PDO(...); $objUser = new user(); $objUser->setEmail(....); $objUser->setFirst(....); //bla bla bla $objUser->insert($pdo); } }

I would probably implement insert, update and delete methods in the user class, rather than making it a feature of the database class to interpret the object being given to it.

There is not a built-in method of doing this in PHP or the mysql PDO classes, but some frameworks implement an ORM (object relational mapping) that allow you to specify easily in your object classes how they interact with the database. (Laravel framework ORM docs)

Here's a very basic way you could implement it.

class ORM { public function insert($pdo) { // Get object name // Get object properties // Check if database table exists with object name // Generate and run a query to insert a record into that table // using the property names and values } public function update($pdo) { // Like insert, but update } public function delete($pdo) { // Etc... } } class user extends ORM { private $id, $email, $pw, $first, $last, $group,.....; // getters and setters } class someclass{ public function someFunction(){ $pdo = new PDO(...); $objUser = new user(); $objUser->setEmail(....); $objUser->setFirst(....); //bla bla bla $objUser->insert($pdo); } }