AppGini Community Forums

Code: Select all

<?php
	$currDir = dirname(__FILE__) . '/..';
	include("$currDir/defaultLang.php");
	include("$currDir/language.php");
	include("$currDir/lib.php");

	$con = mysqli_connect($dbServer, $dbUsername, $dbPassword);
	mysqli_select_db($con,$dbDatabase);


	$mi = getMemberInfo();

	$ajax_var = makesafe($_REQUEST['ajax_var']);

	$result = $con->query("select * from diary where user_name = '{$mi['username']}' and date_s = '{$ajax_var}'");

	$data_table = array();
	$outside = 0;
	$inside = 0;

				    while ($row = $result->fetch_assoc()) {

				                  unset($idx);

				                  $idx = $row['date1'];

				                  $idp = $row['amount'];

				                  
				                  $originalDate = $idx;
						  $newDate = date("Y-m-d", strtotime($originalDate));
								  

								  $data_to_be_inserted=array('date' => $newDate, 'value' => $idp);

									array_push($data_table, $data_to_be_inserted);

									$inside = $inside +1;
									$outside = $outside +1;


					}

					$outside = $outside +1;

					if($outside>$inside){
						echo json_encode($data_table);
					}



?>

Code: Select all

function array_sort_by_column(&$array, $column, $direction = SORT_ASC) {
    $reference_array = array();

    foreach($array as $key => $row) {
        $reference_array[$key] = $row[$column];
    }

    array_multisort($reference_array, $direction, $array);
}
	
	
	array_sort_by_column($data_table, 'date');
	echo json_encode($data_table);
	
	
	

Code: Select all

chart.logo.height = -15000;