drb88830 2016-09-28 10:40
浏览 47

Bootstrap动态表单工作但不将数据插入数据库

I am working on Bootstrap Dynamic form. But data is not inserting into database. Emp_id is employee id. leave_id is employee's current leave id fetched from other table. Both emp_id & leave_id will be same for every data insertion.

please help me to solve this problem. Thanks in advance.

HTML

<!--Alernative Staff Starts-->
<form id="alernativeForm" name="alernativeForm" role="form" data-leave-id="'.$leaves['id'].'">
  <table class="table table-bordered" id="dynamic_field">
      <thead>
         <tr>
           <td><strong>Day</strong></td>
           <td><strong>Period</strong></td>
           <td><strong>Name of alernate Teacher/Staff</strong></td>
           <td><strong>Add More or Delete</strong></td>
         </tr>
     </thead>
     <tbody id="add_name" name="add_name">
        <tr>
          <td><input type="text" class="form-control day_list" name="day[]" id="day" placeholder="Day"></td>
          <td><input type="text" class="form-control period_list" name="period[]" id="period" placeholder="Period"></td>
          <td><input type="text" class="form-control teacher_list" name="teacher[]" id="teacher" placeholder="Name of alernate Teacher/Staff"></td>
          <td><a class="btn btn-primary" name="add" id="add" role="button">Add More</a></td>
        </tr>
      </tbody>
    </table>
</form>
<!--Alernative Staff Ends-->

My jQuery & AJAX

/*Dynamic Field Starts*/

            var i = 1;
            $("#add").click(function(){
                    i++;
        $("#dynamic_field").append('<tr id="row'+i+'"><td><input type="text" class="form-control day_list" name="day[]" id="day" placeholder="Day"></td><td><input type="text" class="form-control period_list" name="period[]" id="period" placeholder="Period"></td><td><input type="text" class="form-control teacher_list" name="teacher[]" id="teacher" placeholder="Name of alernate Teacher/Staff"></td><td><a class="btn btn-danger btn-remove" name="remove" id="'+i+'" role="button">X</a></td></tr>')
            });

            $(document).on('click', '.btn-remove', function(){
                var btn_remove_id = $(this).attr('id');
                $('#row'+btn_remove_id+'').remove();
            });

          $("#alernativeSubmit").click(function(){
           var dynamic_field = $("#alernativeForm").serialize();
           var leave_id = $('#alernativeForm').attr('data-leave-id');
           var emp_id = <?php echo $userRow['emp_id'];?>; 
           alert($('#alernativeForm').serialize() + "&emp_id=" + emp_id + "&leave_id=" + leave_id)
           $.ajax({  
            url:"core/name.php",  
            method:"POST", 
             cache: false, 
            data: $('#alernativeForm').serialize() + "&emp_id=" + emp_id + "&leave_id=" + leave_id,  
            success:function(data)  
            {  
                alert(data)
                 $('#alernativeForm')[0].reset();
                  $('#alernateStaff').modal('hide');

            }  
       });  

       });
   /*Dynamic Field Ends*/

PHP

<?php
    session_start();
    include_once 'dbconnect.php';

     $day_number = count($_POST['day']);  
     $period_number = count($_POST['period']);  
     $teacher_number = count($_POST['teacher']); 
     $emp_id = $_POST['emp_id'];
     $leave_id = $_POST['leave_id'];


     if($day_number > 0)  
     {  
          for($i=0; $i<$day_number; $i++)  
          {  
               if(trim($_POST["day"][$i] != '') && trim($_POST["period"][$i] != '') && trim($_POST["teacher"][$i] != '') && trim($_POST["emp_id"] != '') && trim($_POST["leave_id"] != ''))  
               {  
                    mysql_query("INSERT INTO alernate(`emp_id`,`leave_id`,`day`,`period`,`teacher`) VALUES('".mysql_real_escape_string($_POST["emp_id"])."', '".mysql_real_escape_string($_POST["leave_id"])."', '".mysql_real_escape_string($_POST["day"][$i])."', '".mysql_real_escape_string($_POST["period"][$i])."', '".mysql_real_escape_string($_POST["teacher"][$i])."')");  
                          echo "Data Inserted";  
               }  
          }  

     }  


    ?>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀
    • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100
    • ¥15 关于#hadoop#的问题