Skip to content
This repository has been archived by the owner on Dec 8, 2019. It is now read-only.

6 Select

AtjonTV edited this page Nov 21, 2018 · 2 revisions

Select

Function executeSelect():

The executeSelect method can be used to select from Tables.

The function requieres the full SQL-Query without the SELECT keyword.

This method is SQL-Injection save by default. To disable SQL-Injection-Prevention in order to use escapecharacters like ', you need to supply a true boolean value.

Structure:

  1. SQL-Query

Example:

// Example with escapecharacters denyed
$msql->executeSelect('* FROM Users WHERE name="AtjonTV"');
$msql->executeSelect('* FROM Users WHERE name="AtjonTV"', false);

// Example with escapecharacters allowed
$msql->executeSelect('* FROM Users WHERE name="AtjonTV"', true);

SQL-Query:

SELECT * FROM Users WHERE name="AtjonTV";