Cacher is the code snippet organizer for pro developers

<?php
//setting header to json
header('Content-Type: application/json');
require_once '../../../../init.php';
//require_once $abs_us_root.$us_url_root.'users/includes/header.php';
//echo($user->data()->id);
//echo($GLOBALS['config']['mysql']['host']);
            //print json_encode($GLOBALS['config']);
            //print_r(array_values($GLOBALS));
//database
define('DB_HOST', $GLOBALS['config']['mysql']['host']);
define('DB_USERNAME', $GLOBALS['config']['mysql']['username']);
define('DB_PASSWORD', $GLOBALS['config']['mysql']['password']);
define('DB_NAME', $GLOBALS['config']['mysql']['db']);
//echo($_GET['id']);
$currentuser=$user->data()->id;
if($currentuser==NULL){
	$currentuser=$_GET['id'];
}
//get connection
$mysqli = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);

$sql  = 'UPDATE `session` SET `sessiondate` = \''.$_POST['sessiondate'].'\', `sessionType` = '.$_POST['sessionType'].', `note` = \''.$_POST['note'].'\', `feeling` = \''.$_POST['feeling'].'\', `extertion` = \''.$_POST['extertion'].'\', `location` = \''.$_POST['location'].'\', `tags` = \''.$_POST['tags'].'\', `pushups` = \''.$_POST['pushups'].'\', `situps` = \''.$_POST['situps'].'\', `squatkicks` = \''.$_POST['squatkicks'].'\', `rundistance` = \''.$_POST['rundistance'].'\', `kumite` = \''.$_POST['kumite'].'\', `kihon` = \''.$_POST['kihon'].'\', `skiprounds` = \''.$_POST['skiprounds'].'\', `skipDuration` = \''.$_POST['skipDuration'].'\', `bagRounds` = \''.$_POST['bagRounds'].'\', `bagDuration` = \''.$_POST['bagDuration'].'\', `complete` = \''.$_POST['complete'].'\', `selfDefence` = \''.$_POST['selfDefence'].'\', `duration1` = \''.$_POST['duration1'].'\', `runtimeMin` = \''.$_POST['runtimeMin'].'\', `runtimeSec` = \''.$_POST['runtimeSec'].'\', `fitnessTimeMin` = \''.$_POST['fitnessTimeMin'].'\', `fitnessTimeSec` = \''.$_POST['fitnessTimeSec'].'\', `rundistance1` = \''.$_POST['rundistance1'].'\' WHERE `session`.`id` = '.$_POST['id'];

echo ($sql);
//echo($_POST['rundistance1']);

if(!$mysqli){
	$response_array['status'] = 'error';
	print json_encode($response_array);
	die("Connection failed: " . $mysqli->error);
}
//$sql = 'Select * FROM session WHERE id='.$_GET['Sid'];
	///////
	//ID,value,goal
	//Pushup,120,150
	//Situp, 100,150
	//
	//

//query to get data from the table
$query = sprintf($sql);

//execute query
$result = $mysqli->query($query);

//loop through the returned data
$data = array();
foreach ($result as $row) {
	$data[] = $row;
}

//free memory associated with result
//$result->close();

//close connection
$mysqli->close();
//respond with success code
//now print the data
if ( $result === false ){
	$response_array['status'] = 'error';
	$response_array['data'] = 'mysql error';
}else{
$response_array['status'] = 'success';
}
print json_encode($response_array);

//print json_encode($data);