Publisher review:A SQL Solution - PHP classes to simplify integrating databases with web pages. The SQL Solution™ is a set of open source PHP classes to simplify integrating databases with web pages. Provides a powerful, user friendly, platform independent API (Application Programming Interface) for MySQL, PostgreSQL, SQLite and ODBC database management systems. Output is XHTML compliant and handicapped accessible. Here's some of its key features: Automatically connecting to hosts and databases. Querying. Trapping errors and providing detailed descriptions about them. Escaping HTML characters before output. Converting Safe Markup tags and URI's into real HTML. Formatting results into HTML tables or lists. Generating HTML form elements based on actual database content. Producing output that's XML/XHTML compliant and accessible by disabled persons. Fostering a portable and ungradable framework.
Connecting and Querying When you use the SQL Solution™ to execute a query, it automatically connects to the database server. You don't need to spend time coding that yourself. In addition to a standard query execution function, we've included functions which both run queries and return results. One example is the RunQuery_NoDuplicates() function, which comes in handy when you need to update information that can't violate unique indexes. Error HandlingThe program is bullet proof. All errors are trapped, a generic message is printed to the screen and program execution halts. Such behavior keeps the public from determining specifics of your system's construction, preventing discovery of means to exploit it. System administrators can turn on SQL Solution's debugging tools, which pinpoint which of your scripts caused the problem and which line to look at as well as displaying the most recent query string and a description of the problem. Escaping HTMLBrowsers and scripts can be tripped up by certain characters. Even worse, Java Scripts that do nasty things can be embedded into your HTML (CERT Advisory CA-2000-02). To safely handle user input heading toward your programs, consider using our Form Solution™, which automatically cleans user input. It also has several handy input validation and form element generation functions. Even if user input is strictly screened via your scripts, there's always the potential for subversion from within your organization or ISP. So, SQL Solution™ offers the option to screen all output, converting HTML special characters (< > & ") into their Character References (< > & "). Safe Markup LanguageUsing the output screening unfortunately eliminates the ability to retrieve HTML content from your databases. So, to establish a secure HTML enabled environment, we've created a Safe Markup Language. The basis of our Safe Markup Language is the "::" delimiter. Anything contained between two pairs of colons, say ::p:: for example, is evaluated as a potential HTML language construct. If the construct is allowed, it's converted from Safe Markup Language into HTML.
A SQL Solution 5.0 is a PHP script for Snippets scripts design by Analysis and Solutions Company.
It runs on following operating system: Windows / Linux / BSD / Solaris.
Operating system:Windows / Linux / BSD / Solaris
A SQL Solution 5.0 script details 
