首页 \ 问答 \ 无法返回部分匹配和完全匹配(trouble returning both partial and exact matches)

无法返回部分匹配和完全匹配(trouble returning both partial and exact matches)

 我有这样一张桌子：  
product_id    attribute_id
2             7,8
1             2,7
3             7
 
 我还有一个名为$search_ids的变量，它包含要搜索的值。  
 如果$search_ids的值为7 ，我希望它返回所有3行，但如果它的值为2,7或7,8 ，那么我只想返回该行。  
 我尝试了以下$search_ids的值为7，但这不会返回第二行！ 如果我将行的值从2,7更改为7,2那么它也会返回该行！  
 那么现在以下查询：  
$q = "SELECT product_id FROM product_attributes 
    WHERE attribute_id IN ('$search_ids')
    OR attribute_id IN ($search_ids) 
 
 回报  
2
3
 
 代替  
2
1
3

I have a table like this: 
product_id    attribute_id
2             7,8
1             2,7
3             7
 
I also have a variable called $search_ids which contains values to search for. 
If $search_ids has a value of 7 , I want it to return all 3 rows, but if it has a value of 2,7 or 7,8 I then want to return that row only. 
I tried the following where $search_ids has a value of 7, but this doesn't return the second row! And if I change the row's value from 2,7 to 7,2 then it returns that row also! 
So right now the following query: 
$q = "SELECT product_id FROM product_attributes 
    WHERE attribute_id IN ('$search_ids')
    OR attribute_id IN ($search_ids) 
 
returns  
2
3
 
instead of 
2
1
3

原文：https://stackoverflow.com/questions/22428277

更新时间：2023-02-28 08:02

最满意答案

 在您的代码中执行此操作：  
public void musicPlay(View view) {
    Button music = (Button) findViewById(R.id.music);
        if(isPlaying) {
            music.setPressed(true);
            MusicManager.release()
        }else{
            music.setPressed(false);
            MusicManager.start(this);
        }
    isPlaying = !isPlaying;
}
 
 也在你的xml中：  
<?xml version="1.0" encoding="utf-8"?>
    <selector xmlns:android="http://schemas.android.com/apk/res/android">
        <item android:drawable="@drawable/no_music" android:state_selected="true"/>
        <item android:drawable="@drawable/no_music" android:state_pressed="true"/>
        <item android:drawable="@drawable/music"/>
    </selector>

Do this in your code: 
public void musicPlay(View view) {
    Button music = (Button) findViewById(R.id.music);
        if(isPlaying) {
            music.setPressed(true);
            MusicManager.release()
        }else{
            music.setPressed(false);
            MusicManager.start(this);
        }
    isPlaying = !isPlaying;
}
 
Also in your xml: 
<?xml version="1.0" encoding="utf-8"?>
    <selector xmlns:android="http://schemas.android.com/apk/res/android">
        <item android:drawable="@drawable/no_music" android:state_selected="true"/>
        <item android:drawable="@drawable/no_music" android:state_pressed="true"/>
        <item android:drawable="@drawable/music"/>
    </selector>

无法返回部分匹配和完全匹配(trouble returning both partial and exact matches)

最满意答案

相关问答

状态列表可绘制和禁用状态(State list drawable and disabled state)[2023-12-17]

state_pressed事件在单击时在错误按钮上设置背景(state_pressed event is setting background on wrong button while click)[2022-09-15]

如何更改按下状态的按钮样式？(How to change button style for pressed state?)[2022-07-08]

自定义按钮drawable state_pressed和state_checked无法在CheckBox或RadioButton上运行 - Android(Custom button drawable state_pressed and state_checked not working on CheckBox or RadioButton - Android)[2022-06-20]

以编程方式将SWT按钮设置为按下状态？(Setting the SWT Button to pressed state programmatically?)[2023-02-22]

我们可以在Android xmlLayout中使用state_selected和state_pressed功能来获取ImageButton吗？(Can we use state_selected and state_pressed feature in Android xmlLayout for an ImageButton?)[2023-05-03]

如何根据所选状态未按下状态设置按钮背景和后退(How to set a button background and back according to selected state not pressed state)[2022-06-11]

android：state_pressed无效(android:state_pressed is not working)[2022-04-03]

如何修改状态按下按钮的背景？(How can I modify a button's background for state pressed?)[2023-07-06]

保存按下的按钮状态UITableViewCell(Save pressed button state UITableViewCell)[2024-04-08]

相关文章

最新问答