Class XoopsMySQLDatabaseProxy

`extends`	`XoopsMySQLDatabase`

Read-Only connection to a MySQL database.

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

Located at class\database\mysqldatabase.php

Methods


					
	public

query(string $sql, int $limit = 0, int $start = 0): mysqli_result|bool

perform a query on the database

this method allows only SELECT queries for safety.

`$sql`	a valid MySQL query
`$limit`	number of records to return
`$start`	offset of first record to return

query result or FALSE if successful or TRUE if successful and no result

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

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

Properties inherited from XoopsMySQLDatabase
`$conn`

Properties inherited from XoopsDatabase
`$prefix, $logger, $allowWebChanges`