utipd/mysqlmodel

一个用于存储和检索MySQL行的最小化PHP模型管理器。不处理模式。允许将mysql行当作文档处理。

0.0.1 2014-08-28 15:25 UTC

This package is not auto-updated.

Last update: 2024-09-24 02:13:42 UTC


README

UTipdMe的MysqlModel组件。

Build Status

一个简单的ORM,用于将MySQL表行映射到PHP模型,并反之。

使用示例

<?php 

// create a class
//   this maps to table user in MySQL (you must create this yourself)
class UserDirectory extends \Utipd\MysqlModel\BaseDocumentMysqlDirectory {

    protected $column_names = ['email'];

}

// pass in your PDO object
$user_directory = new UserDirectory(new \PDO('mysql:dbname=testdb;host=127.0.0.1'));

// find by email
$user = $user_directory->findOne(['email' => 'johny@appleseed.com']);

// access rows and properties
print $user['email']."\n";

// update in MySQL, adding arbitrary columns
$user_directory->update($user, ['firstName' => 'John', 'lastName' => 'Appleseed']);

// get the user again from the database
$user = $user_directory->reload($user);
print $user['firstName']." ".$user['lastName']."\n";