Jquery Data Passing|

  • Pass Data Value
  • Check DB
  • Model Form (JS)
  • File Insert(Using Ajax)
// Pass Data Value

<script>
    function get_emp_details(code){
    var link="checkproject.php";
    var data="param=emp_dtails&emp_code="+code;
    $.get(link,data,function(resul){
        if(resul){ 
                    resul=resul.split("-");
                    $("#staff_name").val(resul[0]);
                    $("#emp_code").val(resul[1]);
                    $("#designation").val(resul[2]);
                    $("#department").val(resul[3]);
                    $("#tbl_content").html(resul[4]);
                  }
                                
            });
        }
</script>     

<script>
    function checkage(dob){
    var link="checkproject.php";
    var data="param=checkage&dob="+dob;
    $.get(link,data,function(resul){
    if(resul){ 
                $("#age").val(resul);
             }
          });
        }
</script> 

// Check Details in Backend

<?php
ob_start();
include('include/db_pdo.php');

date_default_timezone_set("Asia/Kolkata");
session_start();
error_reporting(E_ALL);
$param=$_GET['param'];

switch ($param) {
    /**Start Check Unit Name****/
    
        case "emp_dtails":
        
            $emp_code=$_GET['emp_code'];
            $query2="SELECT * FROM `employee` WHERE `emp_code`='$emp_code'";
            $exe2 = $conn->prepare($query2);
            $exe2->execute();
            $info = $exe2->fetchAll(PDO::FETCH_ASSOC);
            $array = array();$i=1;
            //echo "<pre>";print_r($info);echo"</pre>";
            foreach($info as $info_data)
            {
                $first_name=$info_data['first_name'];
                $second_name=$info_data['second_name'];
                $des=$info_data['designation'];
                $emp_code=$info_data['emp_code'];

            $query="SELECT * FROM `designation_master` WHERE `id`='$des'";
            $exe = $conn->prepare($query);
            $exe->execute();
            $info2 = $exe->fetch(PDO::FETCH_ASSOC);
            $array = array(); 
            $designation=$info2['name'];

                echo $first_name."-".$emp_code."-".$designation."-".$second_name."-".$cont;
            }
                 
        break;                    


        case "checkage":
            $dob=$_GET['dob'];
            $today = date("Y-m-d");
            $dob_d=date("Y-m-d", strtotime($dob));
            $age=date_diff(date_create($dob_d), date_create($today))->y;
            echo $age;     
        break;                    

    default:
    break;
    }
    ?>

// Model Form (JS)


            <div class="modal fade" id="supModal2" tabindex="-1" role="dialog" aria-labelledby="formModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-lg">
                    <div class="modal-content">
                        <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                            <div class="section-header">
                                <h2 class="text-warning">Payment Mode</h2>
                            </div>
                        </div>
                        <div class="modal-body">
                        <form action="payformajax.php" method="POST" enctype="multipart/form-data" id="payform">
                        <div class='row'>

            <div class='col-md-2' id='cash' style='display:none'><br><input name='amount' placeholder='Amount' class='form-control' id='amount' onKeyUp="this.value=this.value.replace(/[^0-9 ]/g,'');" readonly/>
            </div>
        
            <div class='col-md-4'><br><input name='dd_no' id='dd_no' placeholder='DD Number' class='form-control'/></div>
            <div class='col-md-4'><br><input type='file' name='dd_file' id='fileChooser' placeholder='DD Proof' 
                onchange="ValidateFileUpload()" accept=".jpg,.png,.jpeg,.JPG,.JPEG" /></div>
            

            <br><br><div class='row'><div class='col-md-10'></div>
            <div class='col-md-2'><button type='submit' class='btn btn-success' name='update_qnt'>Submit</button></div></div>
                        </div>
                        </form>    
                    </div><!-- /.modal-content -->
                </div><!-- /.modal-dialog -->
            </div><!-- /.modal -->    
        </div>



<script>
            function accept(){
                var form = $('#payform')[0];
                var data = new FormData(form);
                
            $.ajax({
            type: "POST",
            enctype: 'multipart/form-data',
            url: "payformajax.php",
            data: data,
            processData: false,
            contentType: false,
            cache: false,
            timeout: 600000,
            success: function (data) {
            //alert(data);    
               $("#supModal2").hide();
                window.open("receiptpdf?id="+data);
                window.location="payment_pending";    
            }
            });
                
            }

</script>

// File Insert(Using Ajax)

<?php
 include('db.php');
 $dd_url='';
date_default_timezone_set("Asia/Kolkata"); 
$created_date=date('Y-m-d');
error_reporting(0);
       if(!empty($_FILES["dd_file"]["name"]))
         {
              $file_name = $_FILES['dd_file']['name'];
              $file_tmp =$_FILES['dd_file']['tmp_name'];
              // $file_ext=strtolower(end(explode('.',$_FILES['dd_file']['name'])));
              
              $upload_dir ='documents/'.$_POST['application_id'];
              mkdir($upload_dir);
              $dd_url = 'documents/'.$_POST['application_id'].'/dd.jpg';
              move_uploaded_file($file_tmp, $dd_url);
              
         }  
        
        $query123="UPDATE `applications` SET `paid_status`='1',`payment_mode`='$_POST[visa_status]',`paid_amount`='$_POST[amount]', 
        `dd_no`='$_POST[dd_no]',`receipt_date`='$_POST[receipt_date]',`pay_entry_date`='$created_date', 
        `received_by`='$_POST[usname]',`dd_file`='$dd_url' WHERE `application_id`='$_POST[application_id]'";
        $exe123 = $conn->prepare($query123);
        $exe123->execute();    


?>
<script>
window.open("receiptpdf?id=<?=$_POST[application_id];?>");
window.location="payment_pending";    
</script>