updating single field through ajax


javascript ------------->
$('.update_invoice_button').click(function(){
		var new_invoice_no = $(this).parent().find('.new_invoice_no').attr("value");		
		var fee_id = $(this).parent().find('.new_invoice_no').attr("width");		
		
		//return false;
		
			var form_data 	= {'table':'fee',
						   'where_column':'id',
						   'where_value':fee_id,
						   'update_column':'invoice_no',
						   'new_value':new_invoice_no
						   };		
			$.ajax({
				async: false,
				type: "POST",
				url: site_url+"/modules/reports/index.php?page=ajax_actions&action_page=update_field",
				data: form_data,
				success: function(result){
					var resultObj = jQuery.parseJSON(result);    		
					alert(resultObj.message)
				}
			});
		
	});

php on update_field -------------->
<?
$table 			= $_REQUEST['table'];
$where_column 	= $_REQUEST['where_column'];
$where_value 	= $_REQUEST['where_value'];
$update_column 	= $_REQUEST['update_column'];
$new_value 		= $_REQUEST['new_value'];

$sql = "UPDATE $table SET $update_column ='$new_value' WHERE $where_column=$where_value ";

$returnArray = array();
if(mysql_query($sql)){
	$returnArray['status'] = "success";	
	$returnArray['message'] = ucfirst($update_column)." updated successfully";
}else{
	$returnArray['status'] = "failure";
	$returnArray['message'] = "Error in updating, please contact admin";
}
echo json_encode($returnArray);
die;

Leave a Reply

Your email address will not be published. Required fields are marked *