List All Pages
Version 1.0.00
Description
bool close ([ string $strLink [, $intLine= 0 ]] )
Closes a connection function
Parameters
strLink
The identifier for the connection. If let null then it will use the one...
Version 1.0.00
Description
bool actionStart ( string $strUsername, string $strPassword, string $strHost, string $strDatabaseName [, string $strTablePrefix="" [, $intLine= 0 [, $objQuickSettings= ""...
Version 1.0.00
Description
mixed addTableColumn ($strWhat, $strFrom [, $strWhere="" [, $intLine=0 [, $objQuickSettings="" ]]] )
This will add a column to a table
Query Syntax
These functions fill...
Version 1.0.00
Description
string affected_rows ( $strQuery [, $intLine=0 ] )
Returns the number of rows affected by the last query defined by $strQuery
Parameters
strQuery
The query to run the...
Version 1.0.00
Description
mixed alterTable ($strWhat, $strFrom [, $strWhere="" [, $intLine=0 [, $objQuickSettings="" ]]] )
Alter a database table
Query Syntax
The below queries are not specific,...
Version 1.0.00
Description
mixed changeTableColumn ($strWhat, $strFrom [, $strWhere="" [, $intLine=0 [, $objQuickSettings="" ]]] )
This will change a column within a table by either renaming it or...
Version 1.0.00
Description
classEnjin ( )
When selecting the Database Enjin this function makes sure that the sql database that you are running is supported with PHP
Return Values
If your version...
Version 1.0.00
Description
bool connect ( string $strHost, string $strUsername, string $strPassword [, $strNewLink [, $intLine= 0 [, $objQuickSettings= "" ]]] )
Opens a connection to a SQL...
The Supa Enjins connection functions are used to manage and maintain connections to databases. The connect, close and select_db functions do not follow the normal layout of how Supa Comix names...
Below is list of all constants created by Supa Enjin
Constant Name
Description
Introduced in Version
ENJIN_DATABASE_CONNECT
This is defined when a successful database connection is...
Version 1.0.00
Description
mixed countWhat ( $strWhat, $strFrom [, $strWhere="" [, $intLine=0 [, $objQuickSettings="" ]]] )
This will insert data into a database
Query Syntax
MySQL
SELECT...
Version 1.0.00
Description
mixed createTable ($strFrom, $objColumn [, $intLimit=0 [, $intLine=0 [, $objQuickSettings="" ]]] )
This will allow you to create a table. This form of table creation...
Version 1.0.00
Description
mixed delete ( $strFrom [, $strWhere="" [, $intLimit=0 [, $intLine=0 [, $objQuickSettings="" ]]]] )
This will run the delete query
Query Syntax
MySQL
DELETE FROM...
Version 1.0.00
Description
mixed describe ( $strFrom [, $intLine=0 [, $objQuickSettings="" ]] )
This will fetch the columns from a table and return it as a resource and not as an array. For...
Version 1.0.00
Description
mixed dropTable ( $strFrom [, $intLine=0 [, $objQuickSettings="" ]] )
This will remove a table from the database
Query Syntax
MySQL
DROP TABLE...
Version 1.0.00
Description
emptyFunctionStack ( [bool $bolRun= true] )
This function is used to empty the function stack at the end of a successfully run query so that when a new query comes along...
The Supa Enjin Error Reporting Functions are disigned to allow users of Supa Enjin to quickly find errors within the code that they have written to make sure that when an error does occur they can...
Version 1.0.00
Description
array fetch ( $strWhat, $strFrom [, $strWhere="" [, $objExtra="", [, $intLine=0 [, $objQuickSettings="" ]]]] )
This will run a select statement and then return everything...
Version 1.0.00
Description
string fetch_array ( $strQuery [, $intLine=0 [, $strFunction="fetch_assoc" ]] )
Returns an associative array that is called by the value in...
Version 1.0.00
Description
array fetchDatabaseTables ( [ $strDatabaseName [, $intLine=0 [, $objQuickSettings="" ]]] )
This will return an array containing a list of all tables within the...
Version 1.0.00
Description
array fetchFromQuery ( $strQuery [, $intLine=0 [, $objQuickSettings="" ]]] )
This will run a query and then return it's output.
Parameters
strQuery
The query to...
Version 1.0.00
Description
mixed fetchLastInsertID ( $strWhat, $strFrom [, $intLine=0 [, $objQuickSettings="" ]] )
This will fetch the value of the last inserted id.
Query Syntax
MySQL
SELECT...
Version 1.0.00
Description
string fetch_row ( $strQuery [, $intLine=0 ] )
Returns a numerical array that corresponds to the fetched row
Parameters
strQuery
The query to fetch data from
The line...
Version 1.0.00
Description
integer fetchSQLVersion ( )
This will return an integer with the version of the SQL that's running.
Query Syntax
MySQL
SELECT VERSION() as version
MSSQL
SELECT...
Version 1.0.00
Description
array fetchTable ($strFrom [, $intLine=0 [, $objQuickSettings="" ]] )
This will return a lot of information about a table back as an array
Parameters
strFrom
The...
Version 1.0.00
Description
array fetchWhat ( $strWhat, $strFrom [, $strWhere="" [, $intLine=0 [, $objQuickSettings="" ]]] )
This will run a select statement and return a single row's information...
Version 1.0.00
Description
string formatCleanString ( $strString )
This function will clean a string by running it via htmlentities with ENT_QUOTE so that you can clean it before adding it into the...
Version 1.0.00
Description
string formatDebugBacktrace ( )
Outputs an error box with the output of the php function: debug_backtrace()
Return Values
An error box containing a table of everything...
Version 1.0.00
Description
string formatEnjinStatus ( )
Outputs an error box containing the status of the Supa Enjin Class.
Return Values
An error box which will contain information about:
Whether...
Version 1.0.00
Description
string formatErrorBox (string $strBoxUnix, mixed $objErrors [, string $strMsg="Error" [, string $strTopStyle="top" [, string $strDisplay="block" [, string...
Version 1.0.00
Description
string formatFunctionStack ( )
Outputs an error box with a list of every function within the _objFunctionStack
Return Values
Outputs an error box with a list of every...
Version 1.0.00
Description
string formatPrefix ( $strTable, $objQuickSettings="" )
This will turn a table name or a list of table names and add the table prefix to them. The more professional SQL...
Version 1.0.00
Description
mixed formatQuery ( $objArray [, $strFor='insert' ] )
This function will turn the query in $objArray into useable queries for either update or insert queries. This allows...
Version 1.0.00
Description
string formatRevertString ( $strString )
This will clean a string and return it to its original value. This is used to be a counter for the formatCleanString()...
Version 1.0.00
Description
string formatSQLErrors (string $strQuery, string $strErrorName )
Tries to make the error report a bit clearer and more informative for the user.
Parameters
strQuery
The...
Version 1.0.00
Description
string getErrorName ( )
This returns the error string which occured during an SQL Error
Return Values
An error string from the last SQL function ran
See...
Version 1.0.00
Description
string getErrorNumber ( )
Returns an error number from the last SQL function ran.
Return Values
Returns an error number from the last error ran, or a 0 if there was no...
Version 1.0.00
Description
array getQuery ( $strQueryUnix )
Returns an array to be processed by the function readyQuery(). Within this function every query string is stored and will be different...
Version 1.0.00
Description
array getTableColumns ($strFrom [, $intLine=0 [, $objQuickSettings="" ]] )
This will retrieve column information and return it as an array.
Parameters
strFrom
The...
Version 1.0.00
Description
string insert ( $strWhat, $strFrom [, $strWhere="" [, $intLine=0 [, $objQuickSettings="" ]]] )
This will insert data into a database
Query Syntax
MySQL
INSERT INTO...
Version 1.0.00
Description
boolean isTable ($strFrom [, $intLine=0 [, $objQuickSettings="" ]] )
This will return true if the table sent in $strFrom exists within the current database
Query...
Version 1.0.00
Description
bool loadToFunctionStack (string $strFunctionName [, array $objFunctionParameters[, bool $bolEscapeRun= false ]] )
This adds a function to the database and also adds in...
Version 1.0.00
Description
string outputArray ( $objArray [, $bolOutput=true ] )
This will output the values within $objArray as a string. This is used to improve the function print_r as the...
Version 1.0.00
Description
string outputDatabaseError ( string $strQuery [, integer $intLine=0 ] )
When an SQL error occurs this runs to give you all of the information that you may need in order...
Version 1.0.00
Description
string outputJavaCollapse ( )
This will output the code required to use the Collapse ability within the error boxes
Version 1.0.00
Description
string outputJavaCollapseButton ( $strID [, $strAlign='right' [, $strValue='[-]' [, $strHidden='[+]' [, $strStyle='' ]]]] )
This outputs the code required for the...
Version 1.0.00
Description
string outputJavaCollapseStyle ( $strStyleName )
This will return the default styles for the error box.
Parameters
strStyleName
This the name of the style that you wish...
Version 1.0.00
Description
string outputSpecialError ( string $strErrorName [, integer $intLine=0 [, $objExtra="" ]] )
This will output a box which contains error information that is usually...
Version 1.0.00
Description
string query ( $strQuery [, $intLine=0 ] )
Sends a unique query to the current active and selected database that is associated with the class variable...
Version 1.0.00
Description
string readyQuery ($objDetails, $strQueryUnix)
This will return a string which contains a query ready to executed.
Parameters
objDetails
This is an array which is meant...
Version 1.0.00
Description
mixed removeTableColumn ($strWhat, $strFrom [, $intLine=0 [, $objQuickSettings="" ]] )
This will remove a column from a table
Query Syntax
This functions fills the...
Version 1.0.00
Description
mixed renameTable ($strOldName, $strNewName [, $intLine=0 [, $objQuickSettings="" ]]] )
This will rename a table.
Query Syntax
The functions with an asterix (*) fill the...
Version 1.0.00
Description
string schema ( $strType, $objConditions [, $intLine=0 [, $objQuickSettings="" ]] )
This will return a schema (usually an information schema) which allows you to find...
Version 1.0.00
Description
mixed select ( $strWhat, $strFrom [, $strWhere="" [, $intLine=0 [, $objExtra="" [, $objQuickSettings="" ]]]] )
Run a select statement
Query Syntax
MySQL
SELECT...
Version 1.0.00
Description
bool select_db ( string $strDatabaseName [, $strLink="" [, $bolSelectFunction=TRUE [, $intLine= 0 ]]] )
Selects the database to run
Parameters
strDatabaseName
The name...
This is the major part of Supa Enjin. These are the queries which are executed by the function query(). They are mostly named after what they intend to do so that when you write a function you...
Version 1.0.00
Description
mixed truncateTable ( $strFrom [, $intLine=0 [, $objQuickSettings="" ]] )
Empty a table of all its rows.
Query Syntax
MySQL
TRUNCATE TABLE...
Version 1.0.00
Description
string update ( $strWhat, $strFrom [, $strWhere="" [, $intLine=0 [, $objQuickSettings="" ]]] )
This will run an update query in the database
Query Syntax
MySQL
UPDATE...
Functions
loadLanguage($strLang, $strFor) - Load a language into the class
formatLanguage($strCode) - Pass a string through and add in the language replacement.
The RSS Reader is a class created for the reading of XML files, particulary RSS Feeds. It uses the PHP XMLReader class and helps to make the reading of XML files more human friendly. It cuts down...
Version 1.0.00
Description
boolean createUser ( $objInsert )
This function will take the information stored in $objInsert and create a user out of that information so long as the user does not...
Please change this page according to your needs
Please change this page according to your policy (configure first using Site Manager) and remove this note.
Who can join?
You can write here who can become a member of this site.
Join!
So you...
Navigation
Home
SupaKode Modules
Coding Articles
Site Updates
Recent changes
List all pages
Site Manager
Add a new page
edit this panel
Members:
Moderators
Admins
Under...
About
Variables List
Constants
Functions [Sort Alphabetically]
classEnjin - Checks whether your SQL is supported
Connection Functions
connect - Creates a connection
close - Closed a...
Supa Enjin is a Database connection class. It has been created to make sure that queries are easily created and constructed, where output is ready to be used without having to use many unknown...
A
actionStart - Connects, selects a database and more.
addTableColumn - Adds a column to a table
affected_rows - Get a number of affected rows from a query
alterTable - Run an ALTER TABLE...
Class Name: classEnjin
Class Variables
The following variables are used within Supa Enjin.
Variable Name
Type
Description
Section
Included in Version
Default...
The following are a list of user written articles designed to help users interface with some code as well as get to grips with what we're trying to achieve and how we are doing it.
Code Naming...
SupaKode is made up of Major and Minor Modules.
Major Modules
Major Modules are modules that require Minor ones to help them function but they are designed for direct user interface and may be used...
In SupaKode we found that there needed to be some form of convention when it came to creating function names and variable names. The intention is to make sure that code is not duplicated and easily...
Functions:
runReadDir($dirname)
sortFolders($fldrs)
sortFiles($files)
getFile($file)
getFileType($file)
getFileName($file)
Class Functions
set_default( $strTag, $strKey, $mixValue ) - Set the defaults for one of the outputs
Input Functions
input_checkbox( $strName, $mixValue="", $bolChecked=true, $bolPrint=true,...
Variables List
Requirements
Table Structure
Functions:
User Functions
countUser( $strWhere="" ) - Count how many users are in the table, user the $strWhere variable to refine the...
Class Variables
The following variables are used within SupaUser.
Variable Name
Type
Description
Section
Included in Version
Default Value
_strCookie_name
string
The default name of the...
About
Variable List
Functions
loadArray( $objArray, $strName="" ) - Load the data in $objArray into the $cache class. If $strName is set then it will in an array with that name.
isErrors() - Have...
Table of Contents
About
Installation
Installing New Programs
Updating Programs
Developer
Admin Class
Admin Functions
Global Functions
Writing New Plugins
File Structure
The Global Source
Table Of Contents
Variable List
_strTable_admin - A string containing the name of the admin table
Functions:
createAdminLink( $intUID ) - Make the user defined by $intUID an...
Functions
addExtraSource( $strName, $strLink, $strComesWith ) - Add extra source data to the table
fetchExtraSoureLink( $strName ) - Return the link for a specific extra source file
isInstalled(...
Functions
Meta Functions
fetchMeta( $strUnix ) - Fetch meta data from the meta table
updateMeta( $strUnix, $strNewValue ) - Update a Meta's Value
Cookie Functions
bakeCookie( $strName,...
Supa Kode uses a specially assigned file called a source file which contains an array of every file that is to be used by Supa Kode during its operation. This array contains the proper link to each...
Major Modules
The Administrator
SupaBlogg
Minor Modules
SupaEnjin
SupaUser
SupaPhormat
SupaPholda
contact
If you choose to use Supa Enjin for your database queries then you may have gone from using the typical php functions and you need to do a few updates to the code but these can be easily done using...
Welcome to Supa Kode
This website is going to be the basis for anything related with Supa Kode and its projects for a long time. Expect to see large quantities on information about such projects...
According to Wikipedia, the world largest wiki site:
A Wiki ([ˈwiː.kiː] <wee-kee> or [ˈwɪ.kiː] <wick-ey>) is a type of website that allows users to add, remove, or otherwise edit...
