Description
Located in File: seo.class.php
SEO_DataBase Class
The SEO_DataBase class provides abstraction so the databaes can be accessed without having to use tep API functions. This class has minimal error handling so make sure your code is tight!
- author: - Bobby Easland
- copyright: - Copyright 2005, Bobby Easland
- link: - osCommerce-Freelancers
- version: - 1.1
- license: - GNU Public License
$db (line Class Constants
Summary:Method Detail
Summary:
void
ConnectDB
()
resource
DBPerform
(string $table, array $data, [string $action = 'insert'], [string $parameters = ''])
integer
InsertID
()
resoource
SelectDB
()
Constructor SEO_DataBase (line 66)
SEO_DataBase SEO_DataBase( string $host, string $user, string $db, string $pass)
MySQL_DataBase class constructor
Parameters
- string $host:
- string $user:
- string $db:
- string $pass:
Info
- version - 1.0
- author - Bobby Easland
Method ConnectDB (line 80)
void ConnectDB( )
Function to connect to MySQL
Info
- version - 1.1
- author - Bobby Easland
Method DBPerform (line 170)
resource DBPerform( string $table, array $data, [string $action = 'insert'], [string $parameters = ''])
Function to perform DB inserts and updates - abstracted from osCommerce-MS-2.2 project
Parameters
- string $table: Database table
- array $data: Associative array of columns / values
- string $action: insert or update
- string $parameters:
Info
- version - 1.0
- author - Bobby Easland
Method FetchArray (line 113)
array FetchArray( resource $resource_id, [string $type = MYSQL_BOTH])
Function to fetch array
Parameters
- resource $resource_id:
- string $type: MYSQL_BOTH or MYSQL_ASSOC
Info
- version - 1.0
- author - Bobby Easland
Method Free (line 145)
boolean Free( resource $resource_id)
Function to free the resource
Parameters
- resource $resource_id:
Info
- version - 1.0
- author - Bobby Easland
Method InsertID (line 134)
integer InsertID( )
Function to fetch the last insertID
Info
- version - 1.0
- author - Bobby Easland
Method NumRows (line 124)
mixed NumRows( resource $resource_id)
Function to fetch the number of rows
Parameters
- resource $resource_id:
Info
- version - 1.0
- author - Bobby Easland
Method Query (line 101)
resource Query( string $query)
Function to perform queries
Parameters
- string $query: SQL statement
Info
- version - 1.0
- author - Bobby Easland
Method SelectDB (line 90)
resoource SelectDB( )
Function to select the database
Info
- version - 1.0
- author - Bobby Easland
Method Slashes (line 156)
string Slashes( string $data)
Function to add slashes
Parameters
- string $data:
Info
- version - 1.0
- author - Bobby Easland