Hello,

I am not getting to use placeholders in my PHP code. I have a query which works perfectly without it, but when I try to integrate the placeholder %CURRENT_USER_ID% I am getting errors. I have reviewed the documentation but I didn't find a full example.

Could you please help me with this issue?

The query in PHP:

$cats = $wpdb->get_results("select distinct(category_id) 
    from view_eudp_stats_answers 
    WHERE exam_id in ($exam_ids) and 
    user_id = %CURRENT_USER_ID%");

The error:

[23-May-2018 17:27:17 UTC] Error 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 '%CURRENT_USER_ID%' at line 4 de la base de datos de WordPress para la consulta select distinct(category_id)     from view_eudp_stats_answers     WHERE exam_id in (15,16) and     user_id = %CURRENT_USER_ID% realizada por QM_DB->query

Thanks in advance.

Regards,

Iban.

Hi Bogdan,

I think you are responding to another quetion :) Please, could you check the question of this thread?

Thanks in advance.

Regards,

Iban.

Hi,

eFor examplo, I have this code in my php file that I am using as datasource. I am returning a seralized array, everything works correct, but I need to put a placeholder for the logged user id; I also need another placeholder ('var1', for example) for the exam ids.

The code is the same I posted the first time, which other information do you need? The use case is the one I have explained, and it is a common use case in your plugin... Please, let me know.

$cats = $wpdb->get_results("select distinct(category_id) 
    from view_eudp_stats_answers 
    WHERE exam_id in ($exam_ids) and 
    user_id = %CURRENT_USER_ID%");

Please, do you have an example about how do I have to implement a placeholder in a custom query in my php file, which I use as datasource.

NOTE: What I am renderizing is a chart.

Thanks in advance.

Regards,

Iban.