php framework for administering database content for

PHP Framework for Administering

Database Content for Dynamic

Applications

Copyright 2013 4 Basic Questions, LLC – All rights reserved. February 25, 2013

Framework Background


Model View Controller Framework RESTful Web API Ajax Enabled Response Objects Object Serialization through

Javascript/JSON OOP Extendable Library Admin Objects Namespace Library Autoloader CSS for Custom Styling Parametric Queries to Prevent SQL

Injections and XSS Copyright 2013 4 Basic Questions, LLC – All rights reserved. February 25, 2013

• Developed with NetBeans IDE

• Fully Documented Code Base

• PHP Unit Tests

• Database Scripts for Fast

Startup


Model-View-Controller

«interface»IConnection

AConnection

«interface»IDatabase

ADatabase

«interface»AStatements

AStatements

«interface»IResponse

AResponse«implementation class»

SqlServerResponseController

«implementation class»SqlServerConnection

«implementation class»SqlServerDatabase

«implementation class»SqlServerStatements

«interface»IView

AView«implementation class»

TableFormView

«interface»IModel

AModel«implementation class»

Model_Instance


Table Form Functionality


• Handles SQL Server, MySql,

Oracle and Access databases.

• Handles multiple administration

objects on one page.

• Handles different databases on

the same page.


• Performs Paging

• Performs Searching

• Performs Sorting

• Handles Complete CRUD

• Handles Data Validation


• Configuration Setting for

Number of Records Per Page.

• Maintains Paging During

CRUD Process.

• Styling Through CSS.


• Inline data editing.

• Data state maintained

through Ajax/JSON API.

• Data validation performed

on all transactions.


• Notifications inform user of status.

• Custom messages can be configured.


• Search performs a like search on

all searchable fields.

• Searches can be performed on

individual fields.


• Sorts can be performed on

individual sortable fields.


• Customizable field validation.

• Multiple validation checks can be

performed on a single field.

• Handles Regular Expressions.

• Custom Validation Messages.


• Delete Confirmation.


Table Form Model Builder


Builds Model Class Code Through

Graphical User Selectors.

Eliminates Building Code By Hand.

Allows User to See Sample Query

Results.

Allows User to Graphically Build Field

Object Parameters.


• Connect by Entering

Connection Properties.

• Or if the Default

connection Properties

are set in the

Configuration File

Connect by Selecting

Default Check Box.


• Select the base table.


• Once you select a base

table you can build Joins,

Where Clauses and Order

By Statements.

• The Query String Window

Updates as you build your

Query.


• Build Joins, Where Clauses

and Orderings through

Selectors.

• See Updated Query in

Query String View.

• Preview a Sample of Results

by Checking Show Results.


• Select which Fields to

Include.

• Set their parameters such as

Alias, Field Size, Order,

Default Values, Validations,

etc.


• Model Builder Generates the

Model Code.


aoClientPage

aoResponsePage

Instantiate Response Controllers

Response ControllerResponse LoaderResponse Actions and

State

Admin Objects Model

View (i.e. Table Form View)


php framework for administering database content for

Documents