dtf76989 2016-04-05 09:28
浏览 45
已采纳

如何从Mysql中选择逗号分隔变量

I Have a MySql Database Structure and values samples as shown below:

sno     firstname      status
1        John            Active
2        Kelly           Inactive
3        Harri           Passive
4        Kris            Dormant

Now that I need to execute a Sql query from a PHP page, and the Status Values are from multiple checkbox which I have assigned as an array.

I have used Implode function for this array:

$status = $_POST['status'];    
$mstat= implode (',', $status);
$query="SELECT * FROM USER WHERE status IN '$mstat'";
$result=mysql_query($query);

while ($members = mysql_fetch_assoc($result))
        { 
        $fname= $members['firstname'];
        echo $fname;
        echo '</br>';
        }

The problem is that I'm not getting any results. What could be the problem. Or If anyone could suggest/Advice for an alternative.

When I echo $mstat; I get Active,Passive,Dormant (That is based on my checkbox selection)

  • 写回答

3条回答 默认 最新

  • dtvnbe1428 2016-04-05 09:30
    关注

    status are strings. You need to wrap them with quotes. And IN needs () to wrap the string values. Try -

    $mstat= "'" . implode ("','", $status) . "'";
    $query="SELECT * FROM USER WHERE status IN ($mstat)";
    

    Assuming $status contains some or all of those values showed in database in array format.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥50 swiftui @query 报错
  • ¥50 怎么解决刷卡或扫码后,点击软件输入框,win10屏幕键盘不会自动弹出的问题
  • ¥15 如何使用arcgispro的训练深度模型,发现water和nowater精度为0?(相关搜索:深度学习)
  • ¥20 matlab作业不太懂呀有问题能给个代码吗
  • ¥15 自制电路图为何无法驱动ESP01S?
  • ¥15 前端加access数据库
  • ¥15 ARCGIS 多值提取到点 ERROR 999999
  • ¥15 mysql异常断电, [MY-011971] [InnoDB]
  • ¥15 uni.onBluetoothDeviceFound熄屏不运行
  • ¥15 求PHDA糖尿病并发症数据集,有偿