CDM
[ class tree: CDM ] [ index: CDM ] [ all elements ]

Class: SqlUtility

Source Location: /modules/xbs_cdm/include/sqlutility.php

Class Overview


provide some utility methods for databases


Author(s):

Copyright:

  • copyright (c) 2000-2003 XOOPS.org

Methods



Class Details

[line 23]
provide some utility methods for databases

This is an copy of the function found in xoops/class/database/sqlutility.php




Tags:

copyright:  copyright (c) 2000-2003 XOOPS.org
author:  Kazumi Ono <onokazu@xoops.org>, extension to function A Kitson


[ Top ]


Class Methods


method prefixQuery [line 156]

mixed prefixQuery( string $query, string $prefix, string $lang)

add a prefix.'_' to all tablenames in a query

This is a copy of the function found in xoops/class/database/sqlutility.php except that the search pattern for commands has been extended to include DELETE FROM the @lang parameter has also been added so that we can set the langauge for a code




Tags:

return:  FALSE on failure
author:  A Kitson (http://xoobs.net)


Parameters:

string   $query   valid SQL query string
string   $prefix   prefix to add to all table names
string   $lang   language code to replace @lang in sql string

[ Top ]

method splitMySqlFile [line 37]

boolean splitMySqlFile( array &$ret, string $sql)

Function from phpMyAdmin (http://phpwizard.net/projects/phpMyAdmin/)

Removes comment and splits large sql files into individual queries

Last revision: September 23, 2001 - gandon




Tags:

return:  always true
access:  public


Parameters:

array   &$ret   the splitted sql commands
string   $sql   the sql commands

[ Top ]


Documentation generated on Fri, 03 Mar 2006 08:56:06 +0000 by phpDocumentor 1.3.0RC3