weixin_33721427 2016-02-29 10:55 采纳率: 0%
浏览 32

AJAX数组到PHP不起作用

I have a set of checkboxes. If you click them, bits of a SQL string should be send to a php file, when a button is clicked.

The checkbox setup looks as follows:

<input type="checkbox" class="checkboxes" name="checkb[]" value="SYSTEM LIKE '%system%'">

The ajax looks as follows:

$("#button1").click(function(e) {
    var category_id = {};
    category_id['checkboxvalue'] = $('.checkboxes:checked').serialize();
    $.ajax({
        type: "POST",
        url: "allgemein.php",
        data: category_id,
        success: function(response) {
            $("#resulttable").show().html(response);
        }
    });
});

In php i try to call them like this:

$strWhere = '1=1';

if(true === isset($_POST['checkb']) && 0 < sizeof($_POST['checkb']))
{
    $strWhere .= '(';
    foreach($_POST['checkb'] as $checkboxval)
    {
        $strWhere .= '"'.$checkboxval.'" OR ';
    }
    //remove last OR
    $strWhere = substring($strWhere, 0, -3);
    $strWhere .= ')';
}

$strWhere gets added to the WHERE clause of my SQL query.

Can someone say why this is not working? $strWhere is always 1=1, it never enters the if-loop... somehow I'm not calling the array correctly with $_POST['checkb'] and I just can't figure out why.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥50 三种调度算法报错 有实例
    • ¥15 关于#python#的问题,请各位专家解答!
    • ¥200 询问:python实现大地主题正反算的程序设计,有偿
    • ¥15 smptlib使用465端口发送邮件失败
    • ¥200 总是报错,能帮助用python实现程序实现高斯正反算吗?有偿
    • ¥15 对于squad数据集的基于bert模型的微调
    • ¥15 为什么我运行这个网络会出现以下报错?CRNN神经网络
    • ¥20 steam下载游戏占用内存
    • ¥15 CST保存项目时失败
    • ¥20 java在应用程序里获取不到扬声器设备