Ladder Server: Store and get objects using OSQL query language

Recommend this page to a friend!
  Info   Documentation   View files (235)   Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 90 All time: 9,486 This week: 315
Version License PHP version Categories
ladder-server 1.0GNU General Publi...5.0PHP 5, Databases, Web services
Description Author

This package can store and get objects using OSQL query language.

It consists of server package that takes requests with parameters defined in JSON format to perform queries that can store and retrieve objects in an object database using a query language named OSQL.

The package comes also with client side classes to send HTTP requests to a Ladder server from PHP script.

Picture of Michael J. Fuhrman
Name: Michael J. Fuhrman is available for providing paid consulting. Contact Michael J. Fuhrman .
Classes: 12 packages by
Country: United States United States
Age: ???
All time rank: 44755 in United States United States
Week rank: 771 80 in United States United States
Innovation award
Innovation award
Nominee: 3x

Details
/*	=======================================
	Copyright 1998 .. 2015 - E Net Arch
		www.ENetArch.net - 248-686-1407
		ENetArch on AIM, Yahoo, and Skype

	This program is distributed under the terms of the GNU 
	General Public License (or the Lesser GPL).
	======================================= */


== What is provided: ==

Ladder Server is 90% functional.  This solution serves as a demonstration
server at this time.  A full fledge server will be published when 
applications are written for Ladder.

== Configuration: ==

This version of Ladder works in a LAMP environment.  
First create a database for Ladder to work in.  
The default is "ENetArch_Ladder"

Browse to "Classes / Config / mysql_resource.php".  Adjust the settings
as needed:
	Server Host
	User Name
	Password
	DataBase Name

== Executing Ladder Commands / Queries: ==

You can communicate with Ladder using two interfaces.  The first is an 
API, and the second is through a 4th generation language - OSQL.

=== Ladder API Library ===

Ladder can receive API calls via RPC calls from another server or from 
another client.  Ladder Client, the API RPC interface provided in PHP,
will be distributed in Java, JavaScript, PHP, and C# in the coming 
revisions.  Calls made by this API library are sent to "tree.php", using 
a JSON format:

{
	"szCommand" : "cmdLadder.isInstalled",
	"szParams" :  [],
	"bVerbose" : false
}

To issue these commnands manual, for testing purposes, use "tree.html"

For a list of commands supported, browse to: "Classes / Commands"

=== OSQL Interface ===

Ladder uses an OSQL Interface to execute queries through the Ladder Server
Library at this time.  Coming is an OSQL to SQL version library, as well
as additional libraries to map Ladder objects into a Memory File, vs using
a SQL server for storage.

This library is not complete.  Many of the features have yet to completely
coded.  What was insured to function were simple AND queries in the WHERE
clause.

Future versions will migrate the debugging code to debug statements, as 
applications are built on top of Ladder.

== Documentation ==

At this time, DocFoo is not complete.  My goal is to complete DocFoo
within a month of this publication.

== Testing == 

At this time, Testing is not complete.  My goal is to provide detailed
tests by January 2016.


== Supporting This Project ==

If you appreciate the work being put into this project and want to help 
support it. Please contact E Net Arch via info@enetarch.net, 248-686-1407,
or via Skype as ENetArch.

  Files  
File Role Description
documentation (5 files, 4 directories)
LadderClnt (8 files, 2 directories)
LadderSrvr (9 files, 2 directories)
README.md Data Auxiliary data

  Files  /  documentation  
File Role Description
images (10 files)
Install (1 file)
Ladder (20 files, 13 directories)
LadderSrvr (1 file)
   catalog.htm Doc. Documentation
   home.htm Doc. Documentation
   home2.htm Doc. Documentation
   index.htm Doc. Documentation
   styles.css Data Auxiliary data

  Files  /  documentation  /  images  
File Role Description
   blank.gif Icon Icon image
   Compass_w_Ladder.png Icon Icon image
   Ladder_Tree.png Icon Icon image
   Object_Model_Tree.png Icon Icon image
   SQL_Tree.png Icon Icon image
   t-r.gif Icon Icon image
   t-t-r.gif Icon Icon image
   t-tb-r.gif Icon Icon image
   tb-r.gif Icon Icon image
   tb.gif Icon Icon image

  Files  /  documentation  /  Install  
File Role Description
   index.htm Doc. Documentation

  Files  /  documentation  /  Ladder  
File Role Description
Class (1 file)
Classes (1 file)
Class_Definition (1 file)
Folder (16 files)
Folders (1 file)
Item (9 files)
Items (1 file)
Links (3 files)
Properties (24 files)
Reference (3 files)
References (1 file)
Template (1 file)
Templates (1 file)
   connect.htm Doc. Documentation
   createClass.htm Doc. Documentation
   createRoots.htm Doc. Documentation
   createTable.htm Doc. Documentation
   disconnect.htm Doc. Documentation
   error.htm Doc. Documentation
   getClass.htm Doc. Documentation
   getClasses.htm Doc. Documentation
   getError.htm Doc. Documentation
   getItem.htm Doc. Documentation
   getObject.htm Doc. Documentation
   getRoots.htm Doc. Documentation
   index.htm Doc. Documentation
   install.htm Doc. Documentation
   installClasses.htm Doc. Documentation
   isInstalled.htm Doc. Documentation
   rootExists.htm Doc. Documentation
   uninstall.htm Doc. Documentation
   updateItem.htm Doc. Documentation
   updateLink.htm Doc. Documentation

  Files  /  documentation  /  Ladder  /  Class  
File Role Description
   index.htm Doc.

  Files  /  documentation  /  Ladder  /  Classes  
File Role Description
   index.htm Doc.

  Files  /  documentation  /  Ladder  /  Class_Definition  
File Role Description
   index.htm Doc.

  Files  /  documentation  /  Ladder  /  Folder  
File Role Description
   Copy.htm Doc.
   Count.htm Doc.
   Create.htm Doc.
   Delete.htm Doc.
   Duplicate.htm Doc.
   Exists.htm Doc.
   getChildren.htm Doc.
   getFolder.htm Doc.
   getFolders.htm Doc.
   getItem.htm Doc.
   getItems.htm Doc.
   getReference.htm Doc.
   getReferences.htm Doc.
   index.htm Doc.
   Item.htm Doc.
   Move.htm Doc.

  Files  /  documentation  /  Ladder  /  Folders  
File Role Description
   index.htm Doc.

  Files  /  documentation  /  Ladder  /  Item  
File Role Description
   Create.htm Doc.
   Delete.htm Doc.
   getData.htm Doc.
   getField.htm Doc.
   getStructure.htm Doc.
   getTableName.htm Doc.
   index.htm Doc.
   saveData.htm Doc.
   Store.htm Doc.

  Files  /  documentation  /  Ladder  /  Items  
File Role Description
   index.htm Doc.

  Files  /  documentation  /  Ladder  /  Properties  
File Role Description
   Connect.htm Doc.
   Create.htm Doc.
   dateCreated.htm Doc.
   Delete.htm Doc.
   getBaseType.htm Doc.
   getClassFolder.htm Doc.
   getClassID.htm Doc.
   getDescription.htm Doc.
   getGUID.htm Doc.
   getID.htm Doc.
   getLeaf.htm Doc.
   getName.htm Doc.
   getParent.htm Doc.
   getSize.htm Doc.
   getState.htm Doc.
   index.htm Doc.
   ipCreated.htm Doc.
   isFolder.htm Doc.
   isItem.htm Doc.
   isReference.htm Doc.
   Path.htm Doc.
   setState.htm Doc.
   Store.htm Doc.
   uidCreated.htm Doc.

  Files  /  documentation  /  Ladder  /  Reference  
File Role Description
   Create.htm Doc.
   getFolder.htm Doc.
   index.htm Doc.

  Files  /  documentation  /  Ladder  /  References  
File Role Description
   index.htm Doc.

  Files  /  documentation  /  Ladder  /  Template  
File Role Description
   index.htm Doc.

  Files  /  documentation  /  Ladder  /  Templates  
File Role Description
   index.htm Doc.

  Files  /  documentation  /  LadderSrvr  
File Role Description
   index.htm Doc. Documentation

  Files  /  LadderClnt  
File Role Description
Classes (21 files)
Ladder (14 files)
   list_dir.php Aux. Auxiliary script
   test.php Aux. Auxiliary script
   test_01.php Example Example script
   test_02.php Example Example script
   test_03.php Example Example script
   test_04.php Example Example script
   test_05.php Example Example script
   test_06.php Example Example script

  Files  /  LadderClnt  /  Classes  
File Role Description
   Install_AccountsRecievables_Classes.php Example Example script
   Install_Ads_Classes.php Example Example script
   Install_Articles_Classes.php Example Example script
   Install_Clients_Classes.php Example Example script
   Install_Common_Classes.php Example Example script
   Install_Company_Classes.php Example Example script
   Install_Credits_Classes.php Example Example script
   Install_Functions.inc Data Auxiliary data
   Install_Inventory_Classes.php Example Example script
   Install_Invoices_Classes.php Example Example script
   Install_Ladder.php Class Class source
   Install_LineItems_Classes.php Example Example script
   Install_Orders_Classes.php Example Example script
   Install_Payments_Classes.php Example Example script
   Install_Returns_Classes.php Example Example script
   Install_RMAs_Classes.php Example Example script
   Install_Security_Classes.php Example Example script
   Install_Shippers_Classes.php Example Example script
   Install_ShoppingCart_Classes.php Example Example script
   Install_Site_Classes.php Example Example script
   Install_Template_Classes.php Example Example script

  Files  /  LadderClnt  /  Ladder  
File Role Description
   Error.php Class Class source
   functions.php Class Class source
   Ladder_Class.php Class Class source
   Ladder_Classes.php Class Class source
   Ladder_Folder.php Class Class source
   Ladder_Folders.php Class Class source
   Ladder_Globals.php Class Class source
   Ladder_Item.php Class Class source
   Ladder_Ladder.php Class Class source
   Ladder_Links.php Class Class source
   Ladder_Properties.php Class Class source
   Ladder_Reference.php Class Class source
   Ladder_Version.php Class Class source
   rpc.php Class Class source

  Files  /  LadderSrvr  
File Role Description
classes (4 directories)
init (6 files)
   GPL.txt Doc. Documentation
   install.php Class Class source
   query.html Doc. Documentation
   query.php Appl. Application script
   readme.txt Doc. Documentation
   test.php Test Unit test script
   tree.html Doc. Documentation
   tree.php Appl. Application script
   _app.php Conf. Configuration script

  Files  /  LadderSrvr  /  classes  
File Role Description
Commands (6 files)
config (3 files, 1 directory)
ENetArch (1 file, 3 directories)
Tests (4 files, 1 directory)

  Files  /  LadderSrvr  /  classes  /  Commands  
File Role Description
   cmdFolder.php Class Class source
   cmdItem.php Class Class source
   cmdLadder.php Class Class source
   cmdProperties.php Class
   cmdSecurity.php Class
   cmdTemplate.php Class

  Files  /  LadderSrvr  /  classes  /  config  
File Role Description
Resources (2 files)
   connect_resources.php Conf.
   mysql_server.php Conf.
   resources.txt Doc.

  Files  /  LadderSrvr  /  classes  /  config  /  Resources  
File Role Description
   Ladder_Client.php Class
   Ladder_Server.php Class

  Files  /  LadderSrvr  /  classes  /  ENetArch  
File Role Description
Common (6 files)
Ladder (2 directories)
Service (4 files)
   ENetArch.php Class

  Files  /  LadderSrvr  /  classes  /  ENetArch  /  Common  
File Role Description
   DocFoo.php Class
   docFoo1.php Class
   Error.php Class
   Functions.php Class
   RPC.php Class
   TraceLog.php Class

  Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  
File Role Description
OSQL (3 directories)
Server (11 files)

  Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  /  OSQL  
File Role Description
Parser (5 files)
Scanner (11 files)
VM (1 file)

  Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  /  OSQL  /  Parser  
File Role Description
   miniParser.php Class
   osqlParser.php Class
   OSQL_syntax.json Data
   TokenCodes.php Class
   Version.php Class

  Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  /  OSQL  /  Scanner  
File Role Description
   ByteCode.php Class
   CharCode.php Class
   ErrorMsgs.php Class
   Literal.php Class
   LiteralType.php Class
   ReservedWord.php Class
   ReservedWords.php Class
   Scanner.php Class
   Token.php Class
   TokenCodes.php Class
   Version.php Class

  Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  /  OSQL  /  VM  
File Role Description
   exec.php Class

  Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  /  Server  
File Role Description
   Folder.php Class
   Folders.php Class
   Globals.php Class
   Item.php Class
   Items.php Class
   Ladder.php Class
   Links.php Class
   Properties.php Class
   Reference.php Class
   References.php Class
   Version.php Class

  Files  /  LadderSrvr  /  classes  /  ENetArch  /  Service  
File Role Description
   Install.php Class
   Query.php Class
   Service.php Class
   Version.php Class

  Files  /  LadderSrvr  /  classes  /  Tests  
File Role Description
Ladder (1 directory)
   Test.php Test
   Tests.php Test
   test_set_001.php Test
   test_set_002.php Test

  Files  /  LadderSrvr  /  classes  /  Tests  /  Ladder  
File Role Description
OSQL (3 directories)

  Files  /  LadderSrvr  /  classes  /  Tests  /  Ladder  /  OSQL  
File Role Description
Parser (12 files)
Scanner (8 files)
VM (2 files)

  Files  /  LadderSrvr  /  classes  /  Tests  /  Ladder  /  OSQL  /  Parser  
File Role Description
   osql_scripts.php Test
   test_ErrorMsgs.php Class
   test_initGlobals.php Class
   test_initTokens.php Class
   test_miniParser.php Class
   test_osqlParser.php Class
   test_Param.php Class
   test_Params.php Class
   test_Parser.php Class
   test_ReservedWord.php Class
   test_TokenCodes.php Class
   test_Version.php Class

  Files  /  LadderSrvr  /  classes  /  Tests  /  Ladder  /  OSQL  /  Scanner  
File Role Description
   test_ByteCode.php Class
   test_ErrorMsgs.php Class
   test_ReservedWord.php Class
   test_ReservedWords.php Class
   test_Scanner.php Class
   test_Token.php Class
   test_TokenCodes.php Class
   test_Version.php Class

  Files  /  LadderSrvr  /  classes  /  Tests  /  Ladder  /  OSQL  /  VM  
File Role Description
   Filter_Tests.json Data
   SELECT_FIELDS.json Data

  Files  /  LadderSrvr  /  init  
File Role Description
   autoloader.php Appl. Application script
   error_handler.php Aux. Auxiliary script
   global_Error.php Aux. Auxiliary script
   global_Ladder.php Aux. Auxiliary script
   global_TraceLog.php Aux. Auxiliary script
   json_error.php Aux. Auxiliary script

 Version Control Unique User Downloads Download Rankings  
 100%
Total:90
This week:0
All time:9,486
This week:315

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