Migration from localhost to hosting server – JSON dont load

This topic has 3 replies, 2 voices, and was last updated 11 years, 1 month ago by Sunil Urs.

Viewing 4 posts - 1 through 4 (of 4 total)

September 28, 2013 at 2:35 am #5319

Savak

Hi all… hi Sunil

I’ve migrated my app to live hosting server…but json data dont show up!!
Anyone experienced the same???

I have a index.php like this:

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Autárquicas 2013</title>
<link rel="stylesheet" href="assets/css/ui-lightness/jquery-ui-1.10.3.custom.css" />
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.min.js"></script>
<script src="assets/scripts/canvasjs.js"></script>
<link rel="stylesheet" href="assets/css/style.css"/>
<script src="assets/scripts/refreshDivs.js"></script>
<!-- -->
<script type="text/javascript">

	function geral() {
	$(document).ready(function () {

		CanvasJS.addColorSet("eleicoes",
                [//colorSet Array
                //PPD/PSD-CDS/PP
                "#E67817",
                //PS
                "#FBA6A5",
                //BLOCO ESQUERDA
                "#FE0002",
                //CDU
                "#005C9F",
                //TINO DE RANS
                "#90EE90",  
                //CORAGEM DE MUDAR
                "#60AC16",  
                //BRANCOS
                "#e1e1e1"                 
                ]);
	$.getJSON("includes/graph_geral-data.php", function (result) {
	var chart = new CanvasJS.Chart("chartContainer", {
	colorSet: "eleicoes",
	axisX: {	
	labelAngle: 0,
	labelFontSize: 12,
	labelFontColor: "black",
	},
	axisY: {	
	title: "N.º Votos",
	labelFontSize: 12,
	labelFontColor: "black",
	titleFontSize: 18,
	titleFontWeight: "bold",
	titleFontColor: "black",
	},
	data: [
	{
	type:"column",
	toolTipContent: "Votos: {y} - {name}" ,   
	dataPoints: result,
	}
	]
	});
	$("#concelho_CM tbody").html("");
	//CRIA LISTAGEM
  	$.each(result, function(key, val){
  			if (val.label == 'Abstenção'){
  				var tblRow =
						"<tr>"
						+"<td width=150px style='text-align:left; text-indent:10px; background-color: #c6c6c6; color: #000'><font face='Arial' size='2'>"+val.label+"</td>"
						+"<td width=100px style='text-align:center; text-indent:10px; background-color: #c6c6c6; color: #000'><font face='Arial' size='2'>"+val.y+"</td>"
						+"<td width=60px style='text-align:center; text-indent:10px; background-color: #c6c6c6; color: #000; font-weight:bold;'><font face='Arial' size='2'>"+val.name+"</td>"
						+"</tr>"
					$(tblRow).appendTo("#concelho_CM tbody");
  			} else  {

  				var tblRow =
						"<tr>"
						+"<td width=150px style='text-indent:10px;'><font face='Arial' size='2'>"+val.label+"</td>"
						+"<td width=100px style='text-indent:10px; text-align:center;'><font  face='Arial' size='2'>"+val.y+"</td>"
						+"<td width=60px style='text-indent:10px; text-align:center; font-weight:bold;'><font face='Arial' size='2'>"+val.name+"</td>"
						+"</tr>"
					$(tblRow).appendTo("#concelho_CM tbody");
  			}
			});
	chart.render();
	setTimeout(geral, 10000);
	});
	});
	}
	geral();
</script>
</head>
<body>
<div id="wrapper">
	<!-- ##### GRÁFICO GERAL #####-->
	<div id="container">
			<div id="chartContainer" style="width: 800px; height:280px; margin-top:15px; float:left; "></div>
			<div id="dados">
				<table id="concelho_CM" border="0">
					<thead style="background-color: #534902; color: #ffffff; font-size: 12px; ">
						<th><font face="Arial" size="2">Partido</th>
						<th><font face="Arial" size="2">Votos</th>
						<th><font face="Arial" size="2">%</th>
					</thead>
					<tbody style="font-size: 12px;">
					</tbody>
				</table>
		</div>
	</div>
	<!-- ##### END - GRÁFICO GERAL #####-->
</div>
</body>
</html>

And data retrieved by this file:

<?php
header("Content-Type: application/json; charset=utf-8"); 
$con = mysqli_connect('localhost','user', 'pass','database');
// Check connection
if (mysqli_connect_errno($con))
{
echo "Failed to connect to DataBase: " . mysqli_connect_error();
}else
{
$data_points = array();
$result = mysqli_query($con, 
"SELECT sum( cmv2013.PSD ) AS 'PPD/PSD-PPM', 
	sum( cmv2013.PS ) AS 'PS', 
	sum( cmv2013.BE ) AS 'BE', 
	sum( cmv2013.CDS ) AS 'CDS/PP', 
	sum( cmv2013.CDU ) AS 'CDU', 
	sum( cmv2013.Nulos ) AS 'Nulos', 
	sum( cmv2013.Brancos ) AS 'Brancos',
	sum( cmv2013.Abstencao ) AS 'Abstenção' FROM cmv2013
");
$total = mysqli_query($con, 
	"SELECT sum(cmv2013.PSD + cmv2013.PS + cmv2013.BE + cmv2013.CDS + cmv2013.CDU + cmv2013.Nulos + cmv2013.Brancos) as TOTAL 
	FROM cmv2013"
	);
$linhaTotal = mysqli_fetch_row($total);
$teste = $linhaTotal[0];
$totalAbst = mysqli_query($con, 
	"SELECT sum(cmv2013.inscritos) as ABST FROM cmv2013 WHERE closed = 1"
	);
$linhaTotalAbst = mysqli_fetch_row($totalAbst);
$testeAbst = $linhaTotalAbst[0];
$row = mysqli_fetch_assoc($result);
foreach( $row as $key => $value){
	if ($key == "Abstenção"){
		$point = array("label" => $key, "name" => (round((($value / $testeAbst) * 100), 2)  . '%'), "y" => $value);
		array_push($data_points, $point);
	} else {
		$point = array("label" => $key, "name" => (round((($value / $teste) * 100), 2)  . '%'), "y" => $value);
		array_push($data_points, $point);
	}
}
echo json_encode($data_points, JSON_NUMERIC_CHECK);
}
mysqli_close($con);
?>

Everything works perfect in localhost…. but not online!!! :(
Anyone can point me to what can i do to solve this??

September 30, 2013 at 11:32 am #5321

Sunil Urs

Savak,

If its working fine on the localhost, then the issue is most probably with on the server side. Try the following steps.

1. Using chrome developer tools find out if you are getting response from the server for the ajax request. If there is any issue on the server side, you’ll get appropriate errors in the response.
2. If you are not receiving data, then try to access the URL directly to see if the URL that you are accessing is right.
3. If the URL is right, then issue is probably in the PHP script. Try to debug the same.

Hope this helps

—
Sunil Urs

October 8, 2013 at 2:14 pm #5345

Savak

Sorry for my late reply…
The problem was :( … PHP 5.2 in my server!!

And i needed to maintain 5.2… so i was able to fix this by changing the code a bit…

All is functional now.. you can check it here

http://www.autarquicas2013.cm-valongo.pt

I’ve taken the refresh’s (the charts we’re updating every 10 seconds) as the event already finished..

Thanks for your help.

October 9, 2013 at 6:38 pm #5351

Sunil Urs

Savak,

You have a nice dashboard there! Am glad that you were able to resolve the issue.

—
Sunil

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

FORUMS

Migration from localhost to hosting server – JSON dont load

Quick Links

Server Side Technologies

Front Side Technologies

Contact

FORUMS

Login to Ask a Question or Reply

Migration from localhost to hosting server – JSON dont load