多个复选框插入数据库与json


multiple checkbox insert on db with json

我正在使用一个表单验证插件,在我的js文件中,我有这个输入和复选框值传递到json

$('form').submit(function(event) {
    $('.form-group').removeClass('has-error'); // remove the error class
    $('.help-block').remove(); // remove the error text
    var chkbox = new Array();
    $('input:checked').each(function() {
        chkbox.push(parseint($(this).val()));
    });
    var formData = {
        'company_name': $('input[name=company_name]').val(),
    }
    $.ajax({
        type: 'POST', // define the type of HTTP verb we want to use (POST for our form)
        url: 'process.php',
        data: formData,chbox,
        dataType: 'json',
        encode: true
    }).done(function(data) {
        console.log(data); 
        if ( ! data.success) {
            if (data.errors.company_name) {
                $('#company_name-group').addClass('has-error');
                $('#company_name-group').append('<div class="help-block">' + data.errors.company_name + '</div>');

然后在php

$errors         = array(); 
$data           = array(); 
                if (empty($_POST['company_name']))
                    $errors['company_name'] = 'Company Name is required.';
                if ( ! empty($errors)) {
                    // if there are items in our errors array, return those errors
                    $data['success'] = false;
                    $data['errors']  = $errors;
                } else {
                    $company_name=mysqli_real_escape_string($con,$_POST['company_name']);
                    $chkbox = $_POST['chkbox'];
                    $chkNew = "";  
                foreach($chkbox as $chkNew1)  
                {
                    $chkNew .= $chkNew1 . ",";  
                }  
                $ins_query="insert into xxx(`company_name`,`Job`)values('company_name','$chkNew');"
                retval = mysqli_query( $con ,  $ins_query);
                $data['success'] = true;
                $data['message'] = 'Success!';
            }
            echo json_encode($data);

这个工作完全可以在db值上插入表单值,但它停止在我的process.php文件中,不显示页面上的消息。当我从js文件中删除chkbox时,表单被验证并显示消息成功插入到db .

$chkNew的最后一个字符是,

你应该把它去掉。

尝试在foreach:

之后添加这个
$chkNew= trim($chkNew, ',');