× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Select row where field contains certain values

pred 10 rokmi 1 týždňom #460 od Jan van de Laar
Select row where field contains certain values bolo vytvorené Jan van de Laar
Hi All

I've built a component with two tables, one of them is named  'categorie'. I can select more than one. In the database there is a field "categorie" and it contains " 1, 3 ". So this row matches with categories 1 and 3.
Now I want to select the proper rows in my frontend view and I want to use this where clause:
$query->where($db->quoteName('categorie') . ' = 1 ');

But this only works with value 1, when I try value 3 there are no database results. I tried using LIKE but that doen't work either. Can someone please help me with this?

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 10 rokmi 1 týždňom #461 od Jan van de Laar
Odpoveď od Jan van de Laar na tému Select row where field contains certain values
Just found the solution:

// Construct the search term by escaping the user-supplied string and, if required, adding the % wildcard characters manually.
$cat = '%' . $db->escape( $cat, true ) . '%' ;

// Construct the SQL query
$query = 'SELECT * FROM #__table WHERE `categorie` LIKE ' . $db->quote( $db->escape( $cat ), false );

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

Čas vytvorenia stránky: 0.048 sekúnd
Funguje na Kunena fórum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.