Hi,

I just started using ARI Tables and was told I could use parameters in the SELECT clause.

What I am trying to do is

SELECT * FROM {$UserLogin}

If possible.

Thanks

Edit: in debug mode it seems to think my username is the name on the account.

I need to be able to use the name used to log in in the query.

Edit2:

I have gotten it to grab the username but it for some reason is not loading the data despite the query looking to be correct.

(mysqli): SET NAMES 'UTF8'
Error (0):

(mysqli): SELECT * FROM 'shahij';
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''shahij'' at line 1
No data available.

Edit3:

I have pinpointed the issue to the pair of '' around shahij is there any way to remove it?

Hello,

Open <joomla_directory>/modules/mod_aridatatables/includes/kernel/DataTables/Models/class.DataTablesDataSqlModel.php file and replace the following code:

'UserLogin' => $db->Quote($user->get('username')),

with the following one:

'UserLogin' => $user->get('username'),

Regards,
ARI Soft

Hi it works now!!!

Thank you so much!!!