Scriptcase
Encyclopedia
ScriptCase is a development platform for PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...

 applications. It is a tool that allows the use of a graphical interface accessed directly via browser
Web browser
A web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier and may be a web page, image, video, or other piece of content...

. Using ScriptCase, PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...

 developers can generate complete systems faster and swiftly.

Once it is a web
World Wide Web
The World Wide Web is a system of interlinked hypertext documents accessed via the Internet...

 oriented, it may allow more than one developer using the platform at the same time, it can be installed in a server
Server (computing)
In the context of client-server architecture, a server is a computer program running to serve the requests of other programs, the "clients". Thus, the "server" performs some computational task on behalf of "clients"...

 in the internet
Internet
The Internet is a global system of interconnected computer networks that use the standard Internet protocol suite to serve billions of users worldwide...

 making it accessible to anyone who has access to the internet
Internet
The Internet is a global system of interconnected computer networks that use the standard Internet protocol suite to serve billions of users worldwide...

.

The product creates forms, queries
Information retrieval
Information retrieval is the area of study concerned with searching for documents, for information within documents, and for metadata about documents, as well as that of searching structured storage, relational databases, and the World Wide Web...

 and other applications to manipulate data from databases. Practically all the databases are supported. In development, AJAX
Ajax
- Mythology :* Ajax , son of Telamon, ruler of Salamis and a hero in the Trojan War, also known as "Ajax the Great"* Ajax the Lesser, son of Oileus, ruler of Locris and the leader of the Locrian contingent during the Trojan War.- People :...

 features are used, such as navigation between pages
Pages
Pages is a word processor and page layout application developed by Apple. It is part of the iWork productivity suite and runs on the Mac OS X & iOS operating systems. The first version of Pages was announced on January 11, 2005, and was released one month later. The most recent Macintosh version,...

 / sections, automatic validation of fields such as Date, Currency
Currency
In economics, currency refers to a generally accepted medium of exchange. These are usually the coins and banknotes of a particular government, which comprise the physical aspects of a nation's money supply...

, zip code
ZIP Code
ZIP codes are a system of postal codes used by the United States Postal Service since 1963. The term ZIP, an acronym for Zone Improvement Plan, is properly written in capital letters and was chosen to suggest that the mail travels more efficiently, and therefore more quickly, when senders use the...

, social security number
Social Security number
In the United States, a Social Security number is a nine-digit number issued to U.S. citizens, permanent residents, and temporary residents under section 205 of the Social Security Act, codified as . The number is issued to an individual by the Social Security Administration, an independent...

, among others.

Another feature of ScriptCase are the reports / queries raised just stating a command in SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....

. Complex SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....

 statements can be used (subselect, join
Join (SQL)
An SQL join clause combines records from two or more tables in a database. It creates a set that can be saved as a table or used as is. A JOIN is a means for combining fields from two tables by using values common to each. ANSI standard SQL specifies four types of JOINs: INNER, OUTER, LEFT, and RIGHT...

s and even stored procedures). ScriptCase allows you to write PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...

 to handle exceptions and create more complex validation
Data validation
In computer science, data validation is the process of ensuring that a program operates on clean, correct and useful data. It uses routines, often called "validation rules" or "check routines", that check for correctness, meaningfulness, and security of data that are input to the system...

).

It is also possible to create programs for the infrastructure systems, such as menus, login screen, type programs tabs to group forms / queries being executed on the same page.

Versions

The development of the platform began in 2000. Since then, the tool has been receiving periodic updates and improvements.

1.0 - "Fossil Version". (Release 2000)
2.0 - Major changes, CSS
CSS
-Computing:*Cascading Style Sheets, a language used to describe the style of document presentations in web development*Central Structure Store in the PHIGS 3D API*Closed source software, software that is not distributed with source code...

 Editor schemes was introduced (Release 2003)
3.0 - Version that introduced generation with native support for AJAX
Ajax
- Mythology :* Ajax , son of Telamon, ruler of Salamis and a hero in the Trojan War, also known as "Ajax the Great"* Ajax the Lesser, son of Oileus, ruler of Locris and the leader of the Locrian contingent during the Trojan War.- People :...

 (Release 2006)
4.0 - Support for internationalization, Master-Detail
Master-detail
In computer user interface design, a master–detail interface displays a master list and the details for the currently selected item.A master area can be a form, list or tree of items, and a detail area can be a form, list or tree of items typically placed either below or next to the master area...

 Application (Release year 2008)
5.0 - Graphics Flash
Adobe Flash
Adobe Flash is a multimedia platform used to add animation, video, and interactivity to web pages. Flash is frequently used for advertisements, games and flash animations for broadcast...

 Creation of container
Container
Container may refer to:* Items used to contain, store, and transport products, such as:** Carton** Bottle** Can , several meanings* Shipping containers include** Crate** Wooden box...

applications; Creating Batch
Batch processing
Batch processing is execution of a series of programs on a computer without manual intervention.Batch jobs are set up so they can be run to completion without manual intervention, so all input data is preselected through scripts or command-line parameters...

 Applications, Including object
Object (computer science)
In computer science, an object is any entity that can be manipulated by the commands of a programming language, such as a value, variable, function, or data structure...

 captcha
CAPTCHA
A CAPTCHA is a type of challenge-response test used in computing as an attempt to ensure that the response is generated by a person. The process usually involves one computer asking a user to complete a simple test which the computer is able to generate and grade...

 forms;
Mount menus dynamically; Menu
Menu
In a restaurant, a menu is a presentation of food and beverage offerings. A menu may be a la carte – which guests use to choose from a list of options – or table d'hôte, in which case a pre-established sequence of courses is served....

 with option to "refresh" Menu Tree (Treeview) Automatic generation of application security
Security
Security is the degree of protection against danger, damage, loss, and crime. Security as a form of protection are structures and processes that provide or improve security as a condition. The Institute for Security and Open Methodologies in the OSSTMM 3 defines security as "a form of protection...

, creation Automatic access log
Log
Log, LOG, or LoG may refer to:*Wooden log, also known as timber, wood from trees used for construction, fuel, or wood pulp for paper production...

;
query
Information retrieval
Information retrieval is the area of study concerned with searching for documents, for information within documents, and for metadata about documents, as well as that of searching structured storage, relational databases, and the World Wide Web...

 definition using CSS
CSS
-Computing:*Cascading Style Sheets, a language used to describe the style of document presentations in web development*Central Structure Store in the PHIGS 3D API*Closed source software, software that is not distributed with source code...

 (Release year 2009)
5.1 - Several innovations such as support JQuery
JQuery
jQuery is a cross-browser JavaScript library designed to simplify the client-side scripting of HTML. It was released in January 2006 at BarCamp NYC by John Resig...

, Calendar
Calendar
A calendar is a system of organizing days for social, religious, commercial, or administrative purposes. This is done by giving names to periods of time, typically days, weeks, months, and years. The name given to each day is known as a date. Periods in a calendar are usually, though not...

, Google Maps
Google Maps
Google Maps is a web mapping service application and technology provided by Google, free , that powers many map-based services, including the Google Maps website, Google Ride Finder, Google Transit, and maps embedded on third-party websites via the Google Maps API...

, Quick Search, bar codes, flash graphics, Container
Container
Container may refer to:* Items used to contain, store, and transport products, such as:** Carton** Bottle** Can , several meanings* Shipping containers include** Crate** Wooden box...

,
YouTube
YouTube
YouTube is a video-sharing website, created by three former PayPal employees in February 2005, on which users can upload, view and share videos....

 videos, new schemes, etc.. (Release 2010)

5.2 - It has mainly focused on changes in the treatment of editing fields of application form: new formatting of fields, tabs, validation, among others.
6.0 - Going to be released in the end of 2011, the major improvement about this version it is the processing speed, it will get at least 800% faster then
the old version, new graph/charts module, new security module, brand new log module, it will come now with a database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...

 editor making it easier to manipulate the
database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...

table, more news about the version 6.0 scriptcase can be readed in this link

These are the "major software versions", but minor releases or new builds are often available for download at bringing new features and minor bug-fixes.

Major Benefits

Standards development
Speed
Ease of use
High Portability
Multilanguage
Runs in the browser

Key features

AJAX
Editable grid
Master / Detail
Forms
Consultations
Reports
Menus
Tabs
Customizable Layouts
Documentation generator
Data Dictionary
Language Editor
Import HTML template
Jquery
javascript

ScriptCase still allows the advanced settings for the generated applications meet the requirements of complex systems. There is also a documentation generator that can integrate the whole team, a great advantage of the tool.
The source of this article is wikipedia, the free encyclopedia.  The text of this article is licensed under the GFDL.
 
x
OK