Class SEO_DataBase

(line 30)

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!



Class Variables

Summary:
string $db
string $host
resource $link_id
string $pass
string $user

$db (line 45)

Data type : string

Database name

$host (line 35)

Data type : string

Database host (localhost, IP based, etc)

$link_id (line 55)

Data type : resource

Database link

$pass (line 50)

Data type : string

Database password

$user (line 40)

Data type : string

Database user

Class Constants

Summary:

Method Detail

Summary:
SEO_DataBase SEO_DataBase (string $host, string $user, string $db, string $pass)
void ConnectDB ()
resource DBPerform (string $table, array $data, [string $action = 'insert'], [string $parameters = ''])
array FetchArray (resource $resource_id, [string $type = MYSQL_BOTH])
boolean Free (resource $resource_id)
integer InsertID ()
mixed NumRows (resource $resource_id)
resource Query (string $query)
resoource SelectDB ()
string Slashes (string $data)

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

Inherited Variables

Inherited Class Variable Summary

Inherited Methods

Inherited Method Summary


Documentation generated on Sun, 12 Jun 2005 14:35:29 -0400 by phpDocumentor 1.3.0RC3