phpBlamework php framework reference documantation |
sqlSQL library for using sql servers in phpBlamework. Now is possible to use only mysql. Release: $Name: $ Edit by: $Author: mcbig $ Edit Date: $Date: 2007/01/02 16:13:12 $ Version: $Revision: 1.3 $ Summary
SQL_Error
add sql error to buffer SQL_Errors PopSQL_Errors
Pop SQL_Errors buffer SQLClassBase SQL class, it’s contains only basic variables and definitions of common methods, which could be usable in others children. Summary
SQLClass
Create simple SQLClass class. MySQLConfigclass base on MySQLClass, constructor don’t neet params, cause it reads from SQL_server from config.php TODO: in future this class probably will be top of all SQLClasses (mysql, sqlite etc), technology will be using according to SQL_server.Type. Summary ComboName2Id
Returns Id of name, which finds in table.
ComboSelect
return array of pair values Id => Name. This array is good for create combo boxs.
|
buffer for sql errors
$GLOBALS['SQL_Errors']
add sql error to buffer SQL_Errors
function SQL_Error( $isError )
Pop SQL_Errors buffer
function PopSQL_Errors()
Hostname or file or another server definition
var $lsServer
var $lsUser
var $lsPass
var $lsDatabase
var $lpConnection
this is for error encoding
var $lsEncoding
Create simple SQLClass class.
function SQLClass( $isServer, $isUser, $isPass, $isDatabase )
Open conection with database
function Open()
Close conection with database (or close file)
function Close()
SQL Query
function Query()
function MySQLClass( $isServer, $isUser, $isPass, $isDatabase )
function Close()
returns what gets from mysql_query
function Query( $lsQuery )
Configuration of SQL Server.
$SQL_server
function MySQLConfig()
Returns Id of name, which finds in table.
function ComboName2Id( $ioSql, $isColId, $isTable, $isName, $isRow = 'Name' )
return array of pair values Id => Name.
function ComboSelect( $ioSql, $isColId, $isTable, $isRow = 'Name' )