PHP Classes
elePHPant
Icontem

File: example.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of V. Yanson  >  RS Asset  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/plain
Description: Example script
Class: RS Asset
Easier way to manage data in database
Author: By
Last change:
Date: 8 years ago
Size: 1,757 bytes
 

Contents

Class file image Download
<?php

header
('Content-type: text/plain');

include_once(
'class.asset.php');
include_once(
'class.mysql.php');

$db_conf = array(
   
'host' => 'localhost',
   
'user' => 'undefine_tester',
   
'pass' => 'tester',
   
'db' => 'undefine_tester',
   
'pers' => false // persistent connection?
);
$db = new mysql($db_conf);

$table = 'tester';
$tester_definition = array(
   
'primaryKey' => 'id', // primary key column
   
   
'elements' => array(
       
/*
            please use the following format for element definitions:
           
            'unique name of element' => array(
                'default' => 'default value (if not specified upon adding new record)',
                'sql_path' => 'column name in table',
                'modifiers' => array(
                    'encode' => 'html',
                    'encode' => 'url'
                )
            )
        */
       
       
'id' => array(
           
'sql_path' => 'id'
       
),
       
       
'date' => array(
           
'default' => time(),
           
'sql_path' => 'date',
           
'modifiers' => array(
               
'date_format' => 'F j, Y, g:i a'
           
)
        ),
       
       
'title' => array(
           
'sql_path' => 'title'
       
)
    ),
   
   
// templated sql queries
   
'list_sql' => "select %sql_val% from `" . $table . "` %sql_order% %sql_limit%", // get all values
   
'edit_sql' => "select * from `" . $table . "` where `" . $param . "`='%param%' limit 1", // get single value
   
'save_sql' => "update `" . $table . "` set %update_sql% where `" . $param . "`='%param%' limit 1", // save
   
'add_sql' => "insert into `" . $table . "` (%sql_left%) values (%sql_right%)", // add
   
'delete_sql' => "delete from `" . $table . "` where `" . $param . "` in (%param%)" // delete
);

$tester_asset = new asset($tester_definition, $db);

$test_add = array(
   
'title' => 'test'
);
$tester_asset->add($test_add);

$list = $tester_asset->get();
print_r($list);

?>