Float Array from Java to HTML/PHP

[Betabot]

Hey, so I've got an issue I can't seem to solve or find a way around and would love any help anyone can give.

 

I have a Java Servlet that contains a database connection and gathers values from the database into an Array. I'm just wondering how to get this array back to php so I can populate a HTML table with the data. I realise that I can just get the database in the php page and easily do it there, but the requirements say the Servlet has to do the data collection.

 

The values are Float and a basic database/table structure would look like this.

[table][tr]	[th]ID[/th]	[th]Time Stamp[/th]	[th]Value[/th][/tr][tr]	[td]1 (Int)[/td]	[td](randomTime) (BigInt)[/td]	[td](Value) (Float)[/td][/tr][/table] 

[Neil]

Yeah... Gonna need a lot more information about this entire thing.

 

Why are you getting DB info from Java, and passing it to PHP?

 

Need example code.

[Betabot]

Yeah... Gonna need a lot more information about this entire thing.

 

Why are you getting DB info from Java, and passing it to PHP?

 

Need example code.

 

Ok here's a bit more to go off.

It's a project and the requirement is to have a Java Servlet that does all the database related stuff and then pass back what you need. So I have a .php webpage that meta refreshes every 10 seconds, which is when I want it to keep updating a html table on the .php webpage as new data is added to the database in the background.

 

Here's the Java Servlet's code to get the data from the database (without connection details):

res3 = st.executeQuery("SELECT * FROM sensorData WHERE `sensorID` = '3'");while (res3.next()) {    lightDataArray.add((float) res3.getInt("sensorID"));    lightDataArray.add((float) res3.getLong("timeStamp"));    lightDataArray.add(res3.getFloat("recordedValue"));    if (res3.isLast()) {        currentLightValue = res3.getFloat("recordedValue");    }}

[Neil]

 

Ok here's a bit more to go off.

It's a project and the requirement is to have a Java Servlet that does all the database related stuff and then pass back what you need. So I have a .php webpage that meta refreshes every 10 seconds, which is when I want it to keep updating a html table on the .php webpage as new data is added to the database in the background.

 

Here's the Java Servlet's code to get the data from the database (without connection details):

res3 = st.executeQuery("SELECT * FROM sensorData WHERE `sensorID` = '3'");while (res3.next()) {    lightDataArray.add((float) res3.getInt("sensorID"));    lightDataArray.add((float) res3.getLong("timeStamp"));    lightDataArray.add(res3.getFloat("recordedValue"));    if (res3.isLast()) {        currentLightValue = res3.getFloat("recordedValue");    }}

 

So make your java code write out the data array as a json object, have your PHP one read it in and prase it into an array/object with json_decode, and then you have the data.

[Betabot]

So make your java code write out the data array as a json object, have your PHP one read it in and prase it into an array/object with json_decode, and then you have the data.

 

Well I have tried to get that working, but it never seems to actually work properly. Could you give me a little bit of example code on the java and php side to work off?

[Maccle415]

Not sure if you have done this already or not. I have never worked with jsp stuff before, but can't you make the jsp page print the result from the database when it is called?

 

Basically I am thinking that you could do something like this in php

$result = file_get_contents('localhost/javaservlet.jsp');

Not sure if that would work or not. Just a thought. And like Neil said you can just make it return a JSON object.