Adsense
Popular Posts
- Install APXS in Redhat Linux
- MySQL workbench -"Could not decrypt password cache"
- Transfer modules between sites
- JavaScript, remove trailing insignificant zeros after toFixed function
- Set Windows path command line
- datatable order by nunmeric
- MySQL date created and date modified
- super(props) in React
- PHP, dump varailbes in a format way
- React: connect(mapStateToProps, mapDispatchToProps)
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>';
});
Labels:
JSON
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment