PHP Classes
elePHPant
Icontem

Ladder Server: Store and get objects using OSQL query language

Recommend this page to a friend!
  Info   View files Documentation   View files View files (235)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2015-08-02 (1 year ago) RSS 2.0 feedNot enough user ratingsTotal: 85 All time: 8,521 This week: 1,027Up
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 <contact>
Classes: 12 packages by
Country: 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 folder image Files  
File Role Description
Files folder imagedocumentation (5 files, 4 directories)
Files folder imageLadderClnt (8 files, 2 directories)
Files folder imageLadderSrvr (9 files, 2 directories)
Plain text file README.md Data Auxiliary data

  Files folder image Files  /  documentation  
File Role Description
Files folder imageimages (10 files)
Files folder imageInstall (1 file)
Files folder imageLadder (20 files, 13 directories)
Files folder imageLadderSrvr (1 file)
  HTML file catalog.htm Doc. Documentation
  HTML file home.htm Doc. Documentation
  HTML file home2.htm Doc. Documentation
  HTML file index.htm Doc. Documentation
  Plain text file styles.css Data Auxiliary data

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

  Files folder image Files  /  documentation  /  Install  
File Role Description
  HTML file index.htm Doc. Documentation

  Files folder image Files  /  documentation  /  Ladder  
File Role Description
Files folder imageClass (1 file)
Files folder imageClasses (1 file)
Files folder imageClass_Definition (1 file)
Files folder imageFolder (16 files)
Files folder imageFolders (1 file)
Files folder imageItem (9 files)
Files folder imageItems (1 file)
Files folder imageLinks (3 files)
Files folder imageProperties (24 files)
Files folder imageReference (3 files)
Files folder imageReferences (1 file)
Files folder imageTemplate (1 file)
Files folder imageTemplates (1 file)
  HTML file connect.htm Doc. Documentation
  HTML file createClass.htm Doc. Documentation
  HTML file createRoots.htm Doc. Documentation
  HTML file createTable.htm Doc. Documentation
  HTML file disconnect.htm Doc. Documentation
  HTML file error.htm Doc. Documentation
  HTML file getClass.htm Doc. Documentation
  HTML file getClasses.htm Doc. Documentation
  HTML file getError.htm Doc. Documentation
  HTML file getItem.htm Doc. Documentation
  HTML file getObject.htm Doc. Documentation
  HTML file getRoots.htm Doc. Documentation
  HTML file index.htm Doc. Documentation
  HTML file install.htm Doc. Documentation
  HTML file installClasses.htm Doc. Documentation
  HTML file isInstalled.htm Doc. Documentation
  HTML file rootExists.htm Doc. Documentation
  HTML file uninstall.htm Doc. Documentation
  HTML file updateItem.htm Doc. Documentation
  HTML file updateLink.htm Doc. Documentation

  Files folder image Files  /  documentation  /  Ladder  /  Class  
File Role Description
  HTML file index.htm Doc.

  Files folder image Files  /  documentation  /  Ladder  /  Classes  
File Role Description
  HTML file index.htm Doc.

  Files folder image Files  /  documentation  /  Ladder  /  Class_Definition  
File Role Description
  HTML file index.htm Doc.

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

  Files folder image Files  /  documentation  /  Ladder  /  Folders  
File Role Description
  HTML file index.htm Doc.

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

  Files folder image Files  /  documentation  /  Ladder  /  Items  
File Role Description
  HTML file index.htm Doc.

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

  Files folder image Files  /  documentation  /  Ladder  /  Reference  
File Role Description
  HTML file Create.htm Doc.
  HTML file getFolder.htm Doc.
  HTML file index.htm Doc.

  Files folder image Files  /  documentation  /  Ladder  /  References  
File Role Description
  HTML file index.htm Doc.

  Files folder image Files  /  documentation  /  Ladder  /  Template  
File Role Description
  HTML file index.htm Doc.

  Files folder image Files  /  documentation  /  Ladder  /  Templates  
File Role Description
  HTML file index.htm Doc.

  Files folder image Files  /  documentation  /  LadderSrvr  
File Role Description
  HTML file index.htm Doc. Documentation

  Files folder image Files  /  LadderClnt  
File Role Description
Files folder imageClasses (21 files)
Files folder imageLadder (14 files)
  Plain text file list_dir.php Aux. Auxiliary script
  Plain text file test.php Aux. Auxiliary script
  Plain text file test_01.php Example Example script
  Plain text file test_02.php Example Example script
  Plain text file test_03.php Example Example script
  Plain text file test_04.php Example Example script
  Plain text file test_05.php Example Example script
  Plain text file test_06.php Example Example script

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

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

  Files folder image Files  /  LadderSrvr  
File Role Description
Files folder imageclasses (4 directories)
Files folder imageinit (6 files)
  Plain text file GPL.txt Doc. Documentation
  Plain text file install.php Class Class source
  HTML file query.html Doc. Documentation
  Plain text file query.php Appl. Application script
  Plain text file readme.txt Doc. Documentation
  Plain text file test.php Test Unit test script
  HTML file tree.html Doc. Documentation
  Plain text file tree.php Appl. Application script
  Plain text file _app.php Conf. Configuration script

  Files folder image Files  /  LadderSrvr  /  classes  
File Role Description
Files folder imageCommands (6 files)
Files folder imageconfig (3 files, 1 directory)
Files folder imageENetArch (1 file, 3 directories)
Files folder imageTests (4 files, 1 directory)

  Files folder image Files  /  LadderSrvr  /  classes  /  Commands  
File Role Description
  Plain text file cmdFolder.php Class Class source
  Plain text file cmdItem.php Class Class source
  Plain text file cmdLadder.php Class Class source
  Plain text file cmdProperties.php Class
  Plain text file cmdSecurity.php Class
  Plain text file cmdTemplate.php Class

  Files folder image Files  /  LadderSrvr  /  classes  /  config  
File Role Description
Files folder imageResources (2 files)
  Plain text file connect_resources.php Conf.
  Plain text file mysql_server.php Conf.
  Plain text file resources.txt Doc.

  Files folder image Files  /  LadderSrvr  /  classes  /  config  /  Resources  
File Role Description
  Plain text file Ladder_Client.php Class
  Plain text file Ladder_Server.php Class

  Files folder image Files  /  LadderSrvr  /  classes  /  ENetArch  
File Role Description
Files folder imageCommon (6 files)
Files folder imageLadder (2 directories)
Files folder imageService (4 files)
  Plain text file ENetArch.php Class

  Files folder image Files  /  LadderSrvr  /  classes  /  ENetArch  /  Common  
File Role Description
  Plain text file DocFoo.php Class
  Plain text file docFoo1.php Class
  Plain text file Error.php Class
  Plain text file Functions.php Class
  Plain text file RPC.php Class
  Plain text file TraceLog.php Class

  Files folder image Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  
File Role Description
Files folder imageOSQL (3 directories)
Files folder imageServer (11 files)

  Files folder image Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  /  OSQL  
File Role Description
Files folder imageParser (5 files)
Files folder imageScanner (11 files)
Files folder imageVM (1 file)

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

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

  Files folder image Files  /  LadderSrvr  /  classes  /  ENetArch  /  Ladder  /  OSQL  /  VM  
File Role Description
  Plain text file exec.php Class

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

  Files folder image Files  /  LadderSrvr  /  classes  /  ENetArch  /  Service  
File Role Description
  Plain text file Install.php Class
  Plain text file Query.php Class
  Plain text file Service.php Class
  Plain text file Version.php Class

  Files folder image Files  /  LadderSrvr  /  classes  /  Tests  
File Role Description
Files folder imageLadder (1 directory)
  Plain text file Test.php Test
  Plain text file Tests.php Test
  Plain text file test_set_001.php Test
  Plain text file test_set_002.php Test

  Files folder image Files  /  LadderSrvr  /  classes  /  Tests  /  Ladder  
File Role Description
Files folder imageOSQL (3 directories)

  Files folder image Files  /  LadderSrvr  /  classes  /  Tests  /  Ladder  /  OSQL  
File Role Description
Files folder imageParser (12 files)
Files folder imageScanner (8 files)
Files folder imageVM (2 files)

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

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

  Files folder image Files  /  LadderSrvr  /  classes  /  Tests  /  Ladder  /  OSQL  /  VM  
File Role Description
  Plain text file Filter_Tests.json Data
  Plain text file SELECT_FIELDS.json Data

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

 Version Control Unique User Downloads Download Rankings  
 100%
Total:85
This week:0
All time:8,521
This week:1,027Up