Login   Register  
PHP Classes
elePHPant
Icontem

File: README.md

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of P Guardiario  >  PHP MySQL ActiveRecord class  >  README.md  >  Download  
File: README.md
Role: Documentation
Content type: text/plain
Description: Documentation
Class: PHP MySQL ActiveRecord class
Map objects to MySQL records using ActiveRecord
Author: By
Last change: initial commit
initial commit
Date: 1 year ago
Size: 889 bytes
 

Contents

Class file image Download
PGTable
A 'pretty good' activerecord style mysql abstraction lib for php.
=========
Requirements:
- Php version >= 5.3.0
- Mysql (No mysqli or PDO requirement)
- Tables must bave an id primary key as int auto_increment

```php
require 'pgtable.php';

class Product extends PGTable{
  public static $table_name = 'products';
}

PGTable::initialize('username', 'password', 'database', 'host');

foreach(Product::all() as $product){
  echo $product->attributes['name'] . "\n";
}
```

Magic methods: these don't need to be defined
```php
$product = Product::find_by_foo_and_bar;
$products = Product::find_all_by_foo_and_bar;
```

Check for duplicate before saving
```php
$product = Product::find_by_unique_id($unique_id);
if(!$product) $product = new Product();
$product->update_attributes(array('name' => 'foo', 'price' => '9.95'));
$product->save();
```