Class ProtectorMySQLDatabase

Read-Only connection to a MySQL database.

This class allows only SELECT queries to be performed through its query() method for security reasons.

PHP version 5.3

XoopsDatabase

XoopsMySQLDatabase

ProtectorMySQLDatabase

Package: MySQLDatabaseProxy
Deprecated: since version 2.6.0 - alpha 3. Switch to doctrine connector.
Category: Xoops\Class\Database\MySQLDatabaseProxy
Copyright: 2013 XOOPS Project (http://xoops.org)
License: GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
Author: Kazumi Ono onokazu@xoops.org
Author: readheadedrod redheadedrod@hotmail.com
Author: Richard Griffith richard@geekwright.com
Version: Release: 2.6
Since: 2.6.0
Link: http://xoops.org
Located at odules/protector/class/ProtectorMysqlDatabase.class.php

Methods summary
`public`	# `ProtectorMySQLDatabase( )`
`public`	# `injectionFound( $sql )`
`public`	# `separateStringsInSQL( $sql )`
`public`	# `checkSql( string $sql )` Parameters `$sql`
`public resource`	# `query( string $sql, integer $limit = 0 , integer $start = 0 )` perform a query on the database perform a query on the database this method allows only SELECT queries for safety. Parameters `$sql` a valid MySQL query `$limit` number of records to return `$start` offset of first record to return Returns resource query result or FALSE if unsuccessful Overrides `XoopsMySQLDatabaseProxy::query()`

Methods inherited from XoopsMySQLDatabase
`close(), connect(), deprecated(), errno(), error(), escape(), fetchArray(), fetchBoth(), fetchObject(), fetchRow(), freeRecordSet(), genId(), getAffectedRows(), getFieldName(), getFieldType(), getFieldsNum(), getInsertId(), getRowsNum(), queryF(), queryFromFile(), quote(), quoteString()`

Methods inherited from XoopsDatabase
`prefix(), setPrefix()`

Properties summary
`public array`	`$doubtful_requests`	# `array()`
`public array`	`$doubtful_needles`	# `array( // 'order by' , 'concat' , 'information_schema' , 'select' , 'union' , '/' , /*/ '--' , '#' , )`

Properties inherited from XoopsMySQLDatabase
`$conn`

Properties inherited from XoopsDatabase
`$allowWebChanges, $prefix`