×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Select row where field contains certain values
Jan van de Laar
Yeni Üye
Posts: 5
10 yıl 1 hafta önce #460
Yazan: Jan van de Laar
Select row where field contains certain values, Jan van de Laar tarafından oluşturuldu
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:
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?
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?
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Jan van de Laar
Yeni Üye
Posts: 5
10 yıl 1 hafta önce #461
Yazan: Jan van de Laar
Jan van de Laar tarafından Select row where field contains certain values konusunda yanıtlandı
Just found the solution:
// Construct the search term by escaping the user-supplied string and, if required, adding the % wildcard characters manually.
// Construct the SQL query
// 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 );
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Sayfa oluşturma süresi: 0.049 saniye