OSSTag - A Social Tagging Engine
Copyright (c) 2006 Open Source Development Labs, Inc.
Replaces "'" with "\'" because we use "'" as string-delimiter in our sql querys
Deletes ";" as those have nothing to do in sql-numbers
=cut
sub preventSQLInjectionForNumbers($)
{
my ($text) = @_;
$text =~ s/;//g;
return $text;
}
Replaces "<" with corresponding HTML-Code "<" and ">" with ">"
doUpdate is used to insert or update rows in the database
Parameters:
databaseconnection: DBI-Handler
sqlstring: the sql-string to be executed
Returns:
in case of an insert: primary-key of the inserted row
executeQuery is used to pass select-statements to the database
Parameters:
databaseconnection: DBI-Handler
sqlstring: the sql-string to be executed
Returns:
the result of the sql-query as array of arrays eachrow[eachcolumn[]]
Returns the current date and time as String in the way SQL wants it
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2 as published by the Free Software Foundation.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
Version: 0.1
Date: 26-MAY-2006
Author: Jan Kechel (jan@kechel.de)