dongqiangse6623 2016-06-05 18:20
浏览 65
已采纳

带有ajax的多个复选框

i have multiple checkboxes that the've been echoed to html like this and then i can select more than one of them

 <?php  $got=mysqli_query($con, "SELECT * FROM JobChoose"); $checkbox =
 '';  while($row = mysqli_fetch_assoc($got)) {   $checkbox .=
 '<li><input type="checkbox" id="chkbox" name="chkbox[]" value =
 "'.$row['Job'].'">'.$row['Job'].'</input></li>'; }
?> 
<ul> <?php echo $checkbox;?>  <li><input type="checkbox" id="check"
 name="chkbox[]" value ="else">else</input></li>

Then in ajax i use this

 $("#registerwth").click(function() {
    var surname = $("#search_text").val();
    var name = $("#name").val();
    var custId = $("#custId").val();
    var company_name = $("#company_name").val();
    var firm = $("#firm").val();
    var address = $("#address").val();
    var town = $("#town").val();
    var country = $("#country").val();
    var telephone = $("#telephone").val();
    var fax = $("#fax").val();
    var mobile = $("#mobile").val();
        var mail = $("#mail").val();
            var web_site = $("#web_site").val();
                var barcode = $("#barcode").val();
                 var checkbox = []
        $("input[name='chkbox[]']:checked").each(function ()
        {
            checkbox.push(parseInt($(this).val()));
        });

       $.ajax({
            url: "insertnew.php",
            method: "POST",
       data: {surname:surname,name:name,custId:custId,company_name:company_name,firm:firm,address:address,town:town,country:country,telephone:telephone,fax:fax,mobile:mobile,mail:mail,web_site:web_site,barcode:barcode,checkbox:checkbox} , 
dataType:"text",   
            success: function(data)
                        {                       
                        }
        });
             $(':input[type="text"]').val('');
    $('input:checkbox').removeAttr('checked');
    });

In php i use this to insert the values to db. The cell that contains the checkbox values is $Job

<?php
require('config.php');
include("auth.php");
date_default_timezone_set('Europe/Athens');
if(! $con ) {
die('Could not connect: ' . ((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
}

$custId=mysqli_real_escape_string($con,$_POST['custId']);
$surname=mysqli_real_escape_string($con,$_POST['surname']);
$name= mysqli_real_escape_string($con,$_POST['name']);
$company_name=mysqli_real_escape_string($con,$_POST['company_name']);
$firm=mysqli_real_escape_string($con,$_POST['firm']);
$address= mysqli_real_escape_string($con,$_POST['address']);   
$town=mysqli_real_escape_string($con,$_POST['town']);
$country=mysqli_real_escape_string($con,$_POST['country']);
$telephone= mysqli_real_escape_string($con,$_POST['telephone']);
$fax=mysqli_real_escape_string($con,$_POST['fax']);
$mobile=mysqli_real_escape_string($con,$_POST['mobile']);
$mail= mysqli_real_escape_string($con,$_POST['mail']);
$web_site=mysqli_real_escape_string($con,$_POST['web_site']);
$barcode=mysqli_real_escape_string($con,$_POST['barcode']);
$Job=mysqli_real_escape_string($con,$_POST['checkbox']);


$ins_query2="insert into base (surname,name,custId,company_name,firm,address,town,country,telephone,fax,mobile,mail,web_site,barcode,Job)
 values ('".$surname."','".$name."','".$custId."','".$company_name."','".$firm."','".$address."','".$town."','".$country."','".$telephone."','".$fax."','".$mobile."','".$mail."','".$web_site."','".$barcode."','".$checkbox."')"; 
$retval = mysqli_query( $con ,  $ins_query2);

All the other values are inserted except Job checkbox value Thank you

  • 写回答

2条回答 默认 最新

  • donvo24600 2016-06-06 14:07
    关注

    I got it working by this

     var chkbox = new Array(); $("input:checked").each(function() {   
     chkbox.push($(this).val()); });
    

    and then in php

    $Job= mysqli_real_escape_string($con,$_REQUEST['Job']);
    $chkbox = $_POST['chkbox'];
    $chkNew = "";  
    foreach($chkbox as $chkNew1)  
    {$chkNew .= $chkNew1 . ",";  
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥35 平滑拟合曲线该如何生成
  • ¥100 c语言,请帮蒟蒻写一个题的范例作参考
  • ¥15 名为“Product”的列已属于此 DataTable
  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 自己瞎改改,结果现在又运行不了了
  • ¥15 链式存储应该如何解决
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站