Wednesday, June 24, 2015

json_encode data in php to javascript




I have a function in php
       function GetROFRpl($arr){
             $arr['coursename'] = preg_replace('/\s+/', '',   $arr['coursename']);
             $c = new Connection();
                   $sql0 = "SELECT * FROM rofr_parental_leave WHERE stakeholder_id =   {$this->sanitizeInput($arr['sid'])}
                    AND coursename = {$this->sanitizeInput($arr['coursename'])} ";
                     $result = $c->query($sql0);
                  
                      while($row = $c->getArray($result)){
                              $data[$row['id']] = $row;
                          }
                        return $data;     
                   
        }  
 
which is called by another function and data format to json_encode
   function GetROFRpl($arr){
                $model =  new TeachingContract();
                $data =  $model->GetROFRpl($arr);
                $arrayForJSON = array("count" => count($data), "data" => $data);
                echo json_encode( $arrayForJSON );
    }   

In javascript, I used JSON.parse to parse data to Javascript array
     $('.pl').on('click',  function(){
     
         var row=$(this).parents('tr');

         var sid=row.find('.sid').attr('data-sid');
         var coursename=row.find('.coursename').html();
            
         pldate= "Parental Leave:<table id='pl_table'><tbody>";

         var postdata = {funct: 'GetROFRpl', sid:sid,  coursename:coursename};
         var url = '../_ajaxParts/ROFR/SITAROFR_list.php';

         $.post(url, postdata, function(data) { 
                     var dataarray = JSON.parse(data);
                      var dataarray0 = dataarray['data'];
                     for(var key in dataarray0) {
   
                      var getrow = "<tr class='worksheet' data-id='"+dataarray0[key]['id']+"'><td class='delete' ><span class='btn glyphicon glyphicon-trash'></span></td><td>Start date: <input type='text' class='hasDatepicker pl_start_date' placeholder='yyyy-mm-dd'  name='pl_start_date' value='"+dataarray0[key]['startdate']+"'></td><td>End date: <input type='text'  class='hasDatepicker pl_end_date' placeholder='yyyy-mm-dd' name='pl_end_date' value='"+dataarray0[key]['enddate']+"'></td></tr>";
                      pldate = pldate +getrow;
   
                    }

  pldate0= "<tr class='template' data-id=''><td class='delete' ><span class='btn glyphicon glyphicon-trash'></span></td><td>Start date: <input type='text' class='hasDatepicker pl_start_date' placeholder='yyyy-mm-dd'  name='pl_start_date'></td><td>End date: <input type='text'  class='hasDatepicker pl_end_date' placeholder='yyyy-mm-dd' name='pl_end_date'></td></tr>";
    
             pldate = pldate +pldate0+ '</tbody></table><br /><div class="addRow btn btn-primary">Add Row</div>';    

    });

No comments:

Post a Comment