alchemy MySQL Data Access API

General Theology

Design Philosophy Regarding the MySQL Data Access API

The design philosophy is rather simple. Submit a valid SQL query and specify the format your want the data returned. Currently the API supports delivering the recordset in the following formats

Array - Data only (default)
Array - Data, first elem = col name
Array - 2D Array, data only
String - Delimited, newline as row seperator
String - Used for grid control, returns html table tr stub
Assoc Array - Key/Value hash key=col val=data

Why I took this approach?

The goal of the api is to better deliver the data in a format pertaining to the user interface controls or output that is desired by the consumer. This strategy makes application development a lot easier.

If you find this site useful and are a book buyer/reader...

Abe Books is one of my affiliates. I only use affiliates that I also purchase products from. I love Abe books. I have purchased many books from them originally cost $40 to $60 for as little as $5 to $10 dollars including shipping costs.

By accessing Abe books and clicking on one of my links I receive a small commission on your purchase that helps pay for this site. You pay no more for your books than if you accessed their site directly. Thanks for your support.