PHP Classes

PHP MySQL ActiveRecord class: Map objects to MySQL records using ActiveRecord

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2021-11-07 (23 days ago) RSS 2.0 feedNot yet rated by the usersTotal: 525 All time: 5,639 This week: 429Up
Version License PHP version Categories
pgtable 1.0GNU General Publi...5.3.0PHP 5, Databases, Design Patterns
Description Author

This class can map objects to MySQL records using ActiveRecord design pattern.

It can create records in a given MySQL table using values of object variables with the same name of the table fields.

The class can also perform other operations of mapping the table records to objects like retrieving one record with a given id or some other table field, retrieve all table records, retrieve records using a given SQL query, update records with the values of the changed object variables.

Picture of P Guardiario
Name: P Guardiario <contact>
Classes: 6 packages by
Country: Philippines Philippines
Age: ???
All time rank: 164118 in Philippines Philippines
Week rank: 327 Up2 in Philippines Philippines Up

Details
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();
```

  Files folder image Files  
File Role Description
Plain text file pgtable.php Class Class source
Accessible without login Plain text file README.md Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 100%
Total:525
This week:0
All time:5,639
This week:429Up
User Comments (1)
msql extension is deprecated as of PHP 5.
8 years ago (Evgeniy Tkachenko)
15%Star
 
For more information send a message to info at phpclasses dot org.