Login   Register  
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: 7 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);

?>