A SQL Solution

Category: PHP - Miscellaneous

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. Date: 08 January, 2012


SQL Solution - SQL Snippets - Php Sql - Sql - Solution - Php

Homepage: http://www.analysisandsolutions.com/

Developer: analysisandsolutions.com

License: Freeware

Operating System: All

Add a Comment

all are required fields

     
What do you think of this resource?

Select Your Rate:

Votes:0

 

Related Scripts Download

Notes2SQL is a PHP script for converting data from Lotus Notes to SQL statements.

developer Developer: px.sklar.com
license License: Freeware
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


Just terminal.

developer Developer: px.sklar.com
license License: Freeware
operating systems Operating System: Windows, Linux, BSD, Solaris


Linux based hosting with very generous storage and bandwidth.

developer Developer: Todd Van Sant
license License: Unknown
operating systems Operating System: Not Available


SQLeonardo is a database query tool written in Java.

developer Developer: Nicky
license License: GNU General Public License (GPL)
operating systems Operating System: Platform Independent


UseBB is an Open Source forum package developed in PHP and using the popular MySQL database back-end to store data.

developer Developer: UseBB Team
license License: Freeware
operating systems Operating System: All


sqlWebArchitect is a Web-Based Open Source SQL Server and MSDE Database Administration tool.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows


The Data Generator is a free, GNU-licensed, open source script written in JavaScript, PHP and MySQL that lets you quickly generate large volumes of custom data in a variety of formats for use in testing software and populating databases.

developer Developer: Benjamin Keen
license License: GNU General Public License (GPL)
operating systems Operating System: All


This is my quick and dirty implementation of the *_fetch_array() functions provided by the mssql & other database libraries.

developer Developer: px.sklar.com
license License: Freeware
operating systems Operating System: All


This code snippet will pass the users screen resolution on to a querystring.

developer Developer: phpbuilder.com
license License: Freeware
operating systems Operating System: All