Recommend this page to a friend! |
Download |
Info | Example | Files | Install with Composer | Download | Reputation | Support forum | Blog | Links |
Ratings | Unique User Downloads | Download Rankings | ||||
Not yet rated by the users | Total: 57 | All time: 10,564 This week: 206 |
Version | License | PHP version | Categories | |||
ontimetable 1.0.1 | Public Domain | 5 | PHP 5, Databases, Data types |
Description | Author | |
This package can manage table data records stored in JSON files. |
<?php |
Trait Tablefor ontime
The OnTime framework is designed to be modular, scalable and comprehensive, so that each new feature integrates without difficulty and maintains a unique class definition (OnTime) and all "additional classes" are "trait" that enrich it, in such a way that an integrated system is obtained, not separate programs which do not necessarily have to behave correctly together. This trait will be need if you wan have tables
Installation in test environment:
1.- Copy all the files in the directory where was instaled ontrime core
2.- With the browser of your preference, locate the directory and enter it
3.- Execute the OntimeInstallerDyR.php file
4.- When executing the file, the files where moved and the required environment was created
Recommendations:
If you know how to create a subdomain that points to the "demo" directory, it is more comfortable and realistic.
After install
When installing, the necessary environment is defined to define access security, I create a User called "Admin" and that his password is "OT2021Free", this environment left the class prepared for definitions of the data dictionary and records.
In this trait, can create tables in any feature, a table is defined like a record that have an unique Key id, when you create a table must especify the record, but more than one table can have the same record, in a record must include at least all the fields that don't is not specy like emty = TRUE, neither can include a fields not included on the record.
In the validation include since this feature
lookin, check that the content of the field exist in defined basic content feature (.bas) lookfrom, check that the content of the field exist in defined table feature (.tas) bringin, check that the content of the field exist in defined basic content feature (.bas), and bring the relate data like %%Field bringfrom, check that the content of the field exist in defined table feature (.tas), , and bring the relate data like %%Field isin, check that the content of the field exist is defined container in basic content feature (.bas) isfrom, check that the content of the field exist is defined container in defined table feature (.tas)
mario.carrocera@hotmail.com
+++++++++++ Basic Table Demo +++++++++++
Create Class
basic content exist +++++++++++ Conecting like admin +++++++++++
Connect('admin','OT2021Free') Connected!!!
+++++++++++ Data Dictionary +++++++++++
Show Data Dictionary
ShwDdd() 1.- FldNme : __________1D.- FldTpe=>K __________1D.- FldDsc=>Field name 1.- FldDsc : __________1D.- FldTpe=>S __________1D.- FldDsc=>Field description 1.- FldTpe : __________1D.- FldTpe=>R __________1D.- FldDsc=>Field type ----------2.- FldVld : ____________________2D.- Name=>lookin ____________________2D.- content=>type ____________________2D.- in=>ddd 1.- FldVld : __________1D.- FldTpe=>A __________1D.- FldDsc=>Field validation 1.- FldLen : __________1D.- FldTpe=>I __________1D.- FldDsc=>Field length 1.- FldEmp : __________1D.- FldTpe=>B __________1D.- FldDsc=>Field bool 1.- FldFmt : __________1D.- FldTpe=>S __________1D.- FldDsc=>Field format 1.- FldCap : __________1D.- FldTpe=>S __________1D.- FldDsc=>Field caption 1.- FldTtt : __________1D.- FldTpe=>S __________1D.- FldDsc=>Field tool tip text 1.- FldDfl : __________1D.- FldTpe=>V __________1D.- FldDsc=>Default Value __________1D.- FldEmp=> Create field RecId in data dictionary
DddAddFld('RecId', array('FldTpe'=>'K','FldDsc'=>'Record Identifier')) Created!!!
Create field Name in data dictionary
DddAddFld('Name', array('FldTpe'=>'S','FldDsc'=>'Store the name')) Created!!!
Create field in in data dictionary
DddAddFld('in', array('FldTpe'=>'S','FldDsc'=>'Store Trait where is instales')) Created!!!
Create field parameters in data dictionary
DddAddFld('parameters', array('FldTpe'=>'I','FldDsc'=>'Number of Parameters')) Created!!!
Create field Dscr in data dictionary
DddAddFld('Dscr', array('FldTpe'=>'S','FldDsc'=>'Store the Description')) Created!!!
Create field DscPrm in data dictionary
DddAddFld('DscPrm', array('FldTpe'=>'S','FldDsc'=>'Description of parameters')) Created!!!
Create field FlDName in data dictionary
DddAddFld('DscErr', array('FldTpe'=>'A','FldDsc'=>'Errors tat can present')) Created!!!
Show Data Dictionary
ShwDdd() 1.- FldNme : __________1D.- FldTpe=>K __________1D.- FldDsc=>Field name 1.- FldDsc : __________1D.- FldTpe=>S __________1D.- FldDsc=>Field description 1.- FldTpe : __________1D.- FldTpe=>R __________1D.- FldDsc=>Field type ----------2.- FldVld : ____________________2D.- Name=>lookin ____________________2D.- content=>type ____________________2D.- in=>ddd 1.- FldVld : __________1D.- FldTpe=>A __________1D.- FldDsc=>Field validation 1.- FldLen : __________1D.- FldTpe=>I __________1D.- FldDsc=>Field length 1.- FldEmp : __________1D.- FldTpe=>B __________1D.- FldDsc=>Field bool 1.- FldFmt : __________1D.- FldTpe=>S __________1D.- FldDsc=>Field format 1.- FldCap : __________1D.- FldTpe=>S __________1D.- FldDsc=>Field caption 1.- FldTtt : __________1D.- FldTpe=>S __________1D.- FldDsc=>Field tool tip text 1.- FldDfl : __________1D.- FldTpe=>V __________1D.- FldDsc=>Default Value __________1D.- FldEmp=> 1.- RecId : __________1D.- FldTpe=>K __________1D.- FldDsc=>Record Identifier 1.- Name : __________1D.- FldTpe=>S __________1D.- FldDsc=>Store the name 1.- in : __________1D.- FldTpe=>S __________1D.- FldDsc=>Store Trait where is instales 1.- parameters : __________1D.- FldTpe=>I __________1D.- FldDsc=>Number of Parameters 1.- Dscr : __________1D.- FldTpe=>S __________1D.- FldDsc=>Store the Description 1.- DscPrm : __________1D.- FldTpe=>S __________1D.- FldDsc=>Description of parameters 1.- DscErr : __________1D.- FldTpe=>A __________1D.- FldDsc=>Errors tat can present Defining Record for sample
Create Record sample in data dictionary
CrtRcd(sample,'sample of ontime') Created!!!
Add field RecId Name to record
RcdAddIn(sample,'RecId', array('FldEmp'=>FALSE)) Created!!!
Add field Name to record
RcdAddIn(sample,'Name', array('FldEmp'=>TRUE)) Created!!!
Add field in to record
RcdAddIn(sample,'in', array('FldEmp'=>FALSE)) Created!!!
Add field parameters to record
RcdAddIn(sample,'parameters', array('FldEmp'=>FALSE)) Created!!!
Add field Dscr to record
RcdAddIn(sample,'Dscr', array('FldEmp'=>TRUE)) Created!!!
Add field DscPrm to record
RcdAddIn(sample,'DscPrm', array('FldEmp'=>TRUE)) Created!!!
Add field DscErr to record
RcdAddIn(sample,'DscErr', array('FldEmp'=>TRUE)) Created!!!
Show record list
ShwRecLst() 0D.- ddd=>Data Dictionary 0D.- sample=>sample of ontime Show record
ShwRec('sample') 1.- definition : __________1D.- key=>RecId ----------2.- RecId : --------------------3.- ByField : ______________________________3D.- FldTpe=>K ______________________________3D.- FldDsc=>Record Identifier --------------------3.- ByRecord : ______________________________3D.- FldEmp=> ----------2.- Name : --------------------3.- ByField : ______________________________3D.- FldTpe=>S ______________________________3D.- FldDsc=>Store the name --------------------3.- ByRecord : ______________________________3D.- FldEmp=>1 ----------2.- in : --------------------3.- ByField : ______________________________3D.- FldTpe=>S ______________________________3D.- FldDsc=>Store Trait where is instales --------------------3.- ByRecord : ______________________________3D.- FldEmp=> ----------2.- parameters : --------------------3.- ByField : ______________________________3D.- FldTpe=>I ______________________________3D.- FldDsc=>Number of Parameters --------------------3.- ByRecord : ______________________________3D.- FldEmp=> ----------2.- Dscr : --------------------3.- ByField : ______________________________3D.- FldTpe=>S ______________________________3D.- FldDsc=>Store the Description --------------------3.- ByRecord : ______________________________3D.- FldEmp=>1 ----------2.- DscPrm : --------------------3.- ByField : ______________________________3D.- FldTpe=>S ______________________________3D.- FldDsc=>Description of parameters --------------------3.- ByRecord : ______________________________3D.- FldEmp=>1 ----------2.- DscErr : --------------------3.- ByField : ______________________________3D.- FldTpe=>A ______________________________3D.- FldDsc=>Errors tat can present --------------------3.- ByRecord : ______________________________3D.- FldEmp=>1 1.- in : Activate Table feature
ShwRec('sample') C0010M007.-Error not defined
Creating tables
CrtTblIn('My sample', 'My Sample', 'sample' Created!!!
CrtTblIn('Sample 2', 'My Sample', 'sample' Created!!!
Show featrures with tables
ShwFtrTbl() 0D.- table=>(table) Table Feature Show features with tables
ShwFtrTbl() 0D.- index=>Main index 0D.- My sample=>My Sample 0D.- Sample 2=>Other sample same record Show tables
ShwTbl('My sample') Insert Records in My Sample
InsTblIn('My sample' , 'rec 1', array('Name'=>'Just a description','in'=>'Mexico City','parameters'=>8)) Show tables
ShwTbl('My sample') Insert Records in My Sample
InsTblIn('My sample' , 'rec 2', array('Name'=>'another description','in'=>'Mexico City','parameters'=>8,'DscPrm'=>'explain what do')) Show tables
ShwTbl('My sample') Insert Records in My Sample
InsTblIn('My sample' , 'rec 3', array('Name'=>'another description','in'=>'Mexico City','parameters'=>8)) Show tables
ShwTbl('My sample') Update and Mix in My Sample
UpmTblIn('My sample' , 'rec 3', array('Name'=>'refresh again description','DscPrm'=>'who cares')) Show tables
ShwTbl('My sample') Update with replace in My Sample
UpdTblIn('My sample' , 'rec 2', array('Name'=>'another description','in'=>'Mexico ','parameters'=>2)) Show tables
ShwTbl('My sample') delete in My Sample
dltTblIn('My sample' , 'rec 1') Show tables
ShwTbl('My sample') +++++++++++ Demo Finish +++++++++++
Files (12) |
File | Role | Description |
---|---|---|
DemoTable.php | Example | Example script |
licencia | Data | Auxiliary data |
license | Lic. | License text |
OnTime.php | Class | Class source |
OnTimeAllways.php | Class | Class source |
OntimeInstallerTable.php | Example | Example script |
OnTimeTableA.php | Class | Class source |
OnTimeTableB.php | Class | Class source |
OnTimetmp.php | Class | Class source |
OnTimeValid.php | Class | Class source |
OTiTable.php | Class | Class source |
README.md | Doc. | Documentation |
The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page. |
Install with Composer |
ontimetable-2021-05-09.zip 12KB | |
ontimetable-2021-05-09.tar.gz 10KB | |
Install with Composer |
Needed packages | ||
Class | Download | Why it is needed | Dependency |
---|---|---|---|
OnTime Core Backend | .zip .tar.gz | This package is the usr and features controler | Required |
HTML Nav bar using PHP on Time | .zip .tar.gz | Implements a Nav Bar | Optional |
HTML LayOut using PHP on Time | .zip .tar.gz | Implement Layout | Optional |
HTML CSS Styles using PHP on Time | .zip .tar.gz | Implements Css Html | Optional |
HTML Google Fonts using PHP on Time | .zip .tar.gz | Implement Google Font on HTML | Optional |
HTML Metatags using PHP on Time | .zip .tar.gz | Html Meta Tag pacakage | Optional |
OnTime PHP Multi Language trait | .zip .tar.gz | Add Multilenguage to the database | Optional |
Easy PHP SOAP Server Web Service | .zip .tar.gz | Add soap webservice server | Optional |
OnTime Debugger Backend Trait | .zip .tar.gz | the speteal debuger | Optional |
HTML Include Images and Text using PHP on Time | .zip .tar.gz | Implement image & text | Optional |
OnTime Group Backend | .zip .tar.gz | This package add group feature | Recommended |
On Time Data Dictionary and Record Trait | .zip .tar.gz | this packega have the logic to Record & data dictionary | Required |
OnTime Timezones and Formats Trait | .zip .tar.gz | This package give the ability to manege date & times | Required |
OnTime Basic Content Trait Backend | .zip .tar.gz | This trait is to control the list on the database | Required |
Version Control | Reuses | Unique User Downloads | Download Rankings | ||||||||||||||||
100% | 8 |
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.
Other classes that need this package |
Class | Why it is needed | Dependency |
---|---|---|
Easy PHP SOAP Server Web Service | multifield table winth record validation | Required |
On Time Data Dictionary and Record Trait | Add table feature with myltiple fields validatied | Optional |
OnTime Basic Content Trait Backend | Add table feature with myltiple fields validatied | Optional |
OnTime Core Backend | Add table feature with myltiple fields validatied | Optional |
OnTime Debugger Backend Trait | Add table feature with myltiple fields validatied | Optional |
OnTime Group Backend | Add table feature with myltiple fields validatied | Optional |
OnTime PHP Multi Language trait | Add Data Dictuionary and record information | Required |
OnTime Timezones and Formats Trait | Add table feature with myltiple fields validatied | Optional |