File: examples/activerecord/example.php

Recommend this page to a friend!
  Classes of Haseeb Ahmad Basil  >  PHP Skeleton Framework  >  examples/activerecord/example.php  >  Download  
File: examples/activerecord/example.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP Skeleton Framework
Extensive Web application development framework
Author: By
Last change:
Date: 5 years ago
Size: 1,853 bytes
 

Contents

Class file image Download
<?php
include '../config.php';
#include 'A/Db/MySQL.php';
#include 'A/Db/Activerecord.php';

class projects extends A_Db_ActiveRecord
{
    public function
__construct($db=null)
    {
       
$this->setColumns(array (
           
'id',
           
'username',
           
'password',
           
'first_name',
           
'last_name',
           
'email',
           
'active'
       
));
       
$this->table('projects'); // optional in this case because base AR class will use class name as table name
       
$this->key('id'); // optional in this case because 'id' is the default key name
       
parent::__construct($db);
    }

    public function
getFullname()
    {
        return
$this->data['title'].', '.$this->data['name'].' '.$this->data['surname'];
    }
}

$db = new A_Db_MySQL($config['db']);
$db->connect();
if (
$db->isError()) die('ERROR: ' . $db->getMessage());

Projects::setDb($db);
$project = new Projects();

#$project->find("id='3'");
$project->find("client_id='2'");

#$project->set('title', 'Mr');
#$project->set('name', 'Frodo');
#$project->set('surname', 'Baggins');
#$project->set('email', 'frodo@the-shire.com');
//User::getInstance();
echo 'table=' . $project->getTable() . '<br/>';
dump($project->toArray());

/*

$project->insert();

$project->unsetAttr();

$rs = $project->getAll();
foreach ( $rs as $result ) {
    echo $result->get('fullname') ."\n";
    // OR
    echo $result->fullname ."\n";
}

$project->unsetAttr();

$project->set('name', 'Frodo');
$project->delete();

$project->unsetAttr();

$project->set('projectID', 1);
$project->set('title', 'title');
$project->set('name', 'name');
$project->set('surname', 'surname');
$project->set('email', 'email');
$project->update();

$newUser = new User(1);
echo $newUser->fullname ."\n";

*/

For more information send a message to info at phpclasses dot org.