How to can I search range of products using between

Perhaps something wrong with your incoming variable? try without $variable. simply with already setted value and check results.

  'value' => array(100,10000)

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)