jpgraph: Send parameters to query for combo graph/data page?

Joseph_Sliker

Hi yet again;

jpgraph is very cool and I've been able to get going with it pretty quickly but I have one problem. I'm posting this question here rather than the jpgraph forum because there seems to be a lot more traffic/more responsive folks frequenting here.

I want the user to be able to hit the "submit" button of a form and have the action return a page that contains two basic elements: 1) the jpgraph generated by database results that were filtered based upon what the user input in the form, and 2) a table of numbers reflecting the same data. I can do each thing by itself, but it would be nice to get both on the same page with a single button punch.

The problem is this: the "submit" action of calling the "wrapper(?)" page that would contain both the jpgraph and the data table does not seem to give me any way to pass the parameters on to the call for the query that would be needed for the jpgraph.

I (think) I've been using the inline method...I'm pretty confused about the whole cache thing at the moment...cripes, I wish I were in school and actually had time to study stuff again!

I appreciate any suggestions. Be very concrete...

Thanks!

Here's an example of the code from my jumping off page. As you can see, I have already passed some parameters from a prior page...the purpose of the page at hand is to give the user a selection of specific charts/data sets for the set of students in question:

<HTML>
<HEAD>
<TITLE>STUDENT DATA SYSTEM</TITLE>
</HEAD>
<BODY bgcolor="#FFFFCC">

<p align="center"><b><font face="Arial Narrow">&nbsp;</font></b><a href="http://www.etc.etc.etc.com/psi/data"><img border="0" src="http://www.etc.etc.etc.com/psi/images/4StepSpinSm.gif" width="70" height="70" align="top"></a></p>

<?php

//Get variable from post data
$SCHOOLID = $HTTP_POST_VARS[SCHOOLID];
$GRADE = $HTTP_POST_VARS[GRADE];
$ROOM = $HTTP_POST_VARS[ROOM];
$TESTPHASE = $HTTP_POST_VARS[TESTPHASE];
$LANG = $HTTP_POST_VARS[LANG];

//just a reminder of the group we are selecting
print "$SCHOOLID ";
print "$GRADE ";
print "$ROOM ";
print "$TESTPHASE ";
print "$LANG";

print ("<form method=\"POST\" action=\"http://www.etc.etc.etc.com/psi/jpgraph/src/cbmorf1.php\"><p align=\"left\"><input type=\"submit\" value=\"Oral Reading Fluency\" name=\"B1\"</p>");
print ("<input type=\"hidden\" name=\"SCHOOLID\" value=$SCHOOLID'>");  

print ("<input type=\"hidden\" name=\"GRADE\" value='$GRADE'>");
print ("<input type=\"hidden\" name=\"ROOM\" value='$ROOM'>");
print ("<input type=\"hidden\" name=\"TESTPHASE\" value='$TESTPHASE'>");
print ("<input type=\"hidden\" name=\"LANG\" value='$LANG'>");
print ("</form>");

print ("<form method=\"POST\" action=\"http://www.etc.etc.etc.com/psi/jpgraph/src/cbmmath1.php\"><p align=\"left\"><input type=\"submit\" value=\"Arithmetic Calculation Fluency\" name=\"B1\"</p>");
print ("<input type=\"hidden\" name=\"SCHOOLID\" value=$SCHOOLID'>");  

print ("<input type=\"hidden\" name=\"GRADE\" value='$GRADE'>");
print ("<input type=\"hidden\" name=\"ROOM\" value='$ROOM'>");
print ("<input type=\"hidden\" name=\"TESTPHASE\" value='$TESTPHASE'>");
print ("<input type=\"hidden\" name=\"LANG\" value='$LANG'>");   

print ("</form>");

print ("<form method=\"POST\" action=\"http://www.etc.etc.etc.com/psi/jpgraph/src/cbmwrit1.php\"><p align=\"left\"><input type=\"submit\" value=\"Writing Fluency\" name=\"B1\"</p>");
print ("<input type=\"hidden\" name=\"SCHOOLID\" value=$SCHOOLID'>");  

print ("<input type=\"hidden\" name=\"GRADE\" value='$GRADE'>");
print ("<input type=\"hidden\" name=\"ROOM\" value='$ROOM'>");
print ("<input type=\"hidden\" name=\"TESTPHASE\" value='$TESTPHASE'>");   

print ("<input type=\"hidden\" name=\"LANG\" value='$LANG'>");   

print ("</form>");

?>

</BODY>
</HTML>

dngzone

I use JPGraph quite a bit for statistics reports and such...

I'd suggest passing your form to a standard php page then call the jpgraph script using an img src call....
You can then pass the variables to jpgraph and still post the table as you wish all on the same page...

ie:
<html>
etc etc....
<img src="jpgraph_script.php?var=1&var2=2" border="0">
etc etc...
<table>
<tr><td>var1</td></tr>
<tr><td>var2</td></tr>
</table>

Hope this helps....

Joseph_Sliker

Thanks so much for your reply.

it's the array passing thing that still confuses me.

I can call a select query and have the results end up in a a nice table, but what I don't quite get is how to pass the variables I need into the <img src="jpgraph_script.php?var=1&var2=2" border="0"> line:

For example:Here is a php page that follows a page like the one from the previous post It seems to me there must be things in here that I could recycle in to that <img> line, but I don't quite get how.

Would it be something like:

and where would the line go? Inside or outside the PHP tags?

<HTML>
<HEAD>
<TITLE>DIBELS Data Table</TITLE>
</HEAD>
<BODY>

<?php
//Get filter values from prior page
$SCHOOLID = $HTTP_POST_VARS['SCHOOLID'];
$GRADE = $HTTP_POST_VARS['GRADE'];
$ROOM = $HTTP_POST_VARS['ROOM'];
$TESTPHASE = $HTTP_POST_VARS['TESTPHASE'];
$LANG = $HTTP_POST_VARS['LANG'];

// Set the variables for the database access:
$Host = "localhost";
$User = "qqqqq";
$Password = "######";
$DBName = "****";
$TableName = "DATATABLE";

$Link = mysql_connect ($Host, $User, $Password);

$Query = "SELECT * from $TableName WHERE SCHOOLID LIKE '$SCHOOLID' AND GRADE LIKE '$GRADE' AND ROOM LIKE '$ROOM' AND TESTPHASE LIKE '$TESTPHASE' ORDER BY SCHOOLID, GRADE, ROOM, FIRST, LAST, TESTDATE";
$Result = mysql_db_query ($DBName, $Query, $Link);

// Create a table.
print ("<TABLE BORDER=1 WIDTH=\"90%\" CELLSPACING=2 CELLPADDING=2 style= font-family: Arial; font-size 10 pt><tr><td colspan=12 bgcolor=white><left><p><font face=Century Schoolbook size=5 color=red><b><i>RAW Data (DATA TABLE)</i></b></font></p></left></td></tr>\n");
print ("<tr>");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>SCHID</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>GRD</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>ROOM</TD>\n");
print ("<TD COLSPAN=2 ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>STUDENT NAME</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>TESTDATE</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>PHASE</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>IS_FINAL</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>WORD_USE</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>LETTER_NAMING</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>DATANOTE</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>LANG</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>PROBLEV</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>DATAPOINTID</TD>\n");
print ("</tr>");

//Fetch the results from the database and set them in their cells.
while ($Row = mysql_fetch_array ($Result))
 {
 	print ("<TR ALIGN=LEFT VALIGN=TOP>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[SCHOOLID]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[GRADE]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[ROOM]</TD>\n");
print ("<TD COLSPAN=2 ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[FIRST] $Row[LAST]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[TESTDATE]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[TESTPHASE]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[IS_FINAL]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[WORD_USE]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[LETTER_NAMING]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[DATANOTE]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[LANG]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[PROBLEV]</TD>\n");
print ("<TD ALIGN=LEFT VALIGN=TOP><font face=Arial size=3>$Row[DATAPOINTID]</TD>\n");
print ("</TR>\n");
}
mysql_close ($Link);

//this makes a button that passes the filter variables back to the chart selection page
print ("<TR><form method=\"POST\" action=\"chartpick.php\"><p align=\"left\"><input type=\"submit\" value=\"RETURN TO CHART SELECTION PAGE\" name=\"B1\"</p>");
print ("<input type=\"hidden\" name=\"SCHOOLID\" value='$SCHOOLID'>");  

print ("<input type=\"hidden\" name=\"GRADE\" value='$GRADE'>");
print ("<input type=\"hidden\" name=\"ROOM\" value='$ROOM'>");
print ("<input type=\"hidden\" name=\"TESTPHASE\" value='$TESTPHASE'>");   

print ("<input type=\"hidden\" name=\"LANG\" value='$LANG'>");   

print ("</form></TR>");
print ("</TABLE>");
?>

</BODY>
</HTML>

Actually what would be really nice would be to have the single button from the previous page go to this page and have it contain not only the data table but ALL the related charts (there are about 5 or 6).

It would be nice to be a little clearer on this...I'm getting real sick of trial and error!

Thanks

dngzone

unfortunetly you can't pass the array via the img call.
I would create a string which contains the array data..

ie: $array1 = array("1","2","3","4","5");

then bring the array all into a string and seperate the values using dashs or something you can the split back into an array inside of the jpgraph script:

for ($i = 0; $i < count($array_name); $i++) { 
    $array1str .= "$arrayname[$i]--"; 
    }

If I wrote that right.. the $array1str string would end up like this:
$array1str = "1--2--3--4--5--";

then inside the jpgraph script, split the array1str back into an array or however you need to format the string:
$array1 = split("--", $array1str);

<img src=jpgraph.php4?array1str=<?=$array1str;?>&array2str=<?=$array2str;?>" border="0">

Hope that shows you how the pass the values of your array into the img script for jpg graph.... remember you can add extra code within the jpgraph script to help complete the arrangement/format of the data to be used for your graphs....

Joseph_Sliker

Thanks for that detailed reply. It makes sense. I'm thinking that the contents of some of the variables returned by the select query would already act in place of your first line of code:

$array1 = array("1","2","3","4","5"); ?

So I might accomplish building the arrays to be passed by running the following loops

//fill array with strings to give person's full name
for ($i = 0; $i < count($FIRST); $i++) { 
    $arrayN.= "$FIRST $LAST[$i]--"; 
    }

//fill another array with scores on the task in question
for ($i = 0; $i < count($WORD_USE); $i++) { 
    $arrayWU .= "$WORD_USE[$i]--"; 
    }

and then I would pass this in the img line like this?

<img src=jpgraph.php4?arrayN=<?=$arrayN;?>&arrayWU=<?=$arrayWU;?>" border="0">

Is that the idea?

I assume this line must be outside the php tags that enclosed the code that returned the data table? Or should I enclose it in the

print(" ");

wrapper within php?

Obviously I'm gonna try it this way....but if you or anyone else spots error here, lay it on me.

Thanks.

Joseph_Sliker

It seems to be on the verge of working...

$Link = mysql_connect ($Host, $User, $Password);

mysql_select_db($DBName);
$Result= mysql_query($Query, $Link);

while ($Row = mysql_fetch_array ($Result))
 {
//fill array with strings to give person's full name
for ($i = 0; $i < count($FIRST); $i++) { 
    $arrayN.= "$FIRST $LAST[$i]--"; 
    }

//fill another array with scores on the task in question
for ($i = 0; $i < count($ORF_MWRC); $i++) { 
    $arrayMWRC.= "$ORF_MWRC[$i]--"; 
    }
//fill another array with scores on the task in question
for ($i = 0; $i < count($ORF_ERR); $i++) { 
    $arrayERR.= "$ORF_ERR[$i]--"; 
    }
 }

//I think the problem is in this statement   

print ("<center><img src=http://www2.milwaukee.k12.wi.us/psi/jpgraph/src/cbmorf2.php?$arrayN=<?$arrayN;?>&$arrayMWRC=<?$arrayMWRC;?>&$arrayERR=<?$arrayERR;?> border=\"0\"></center>"); 

mysql_close ($Link);

The empty chart comes up, which seems to mean it is getting some data (I'm not getting the no data points error) but it does not seem to be getting the contents of the last two variables because right next to the bottom of the chart is the following code fragment. Something in the syntax of the img statement?

&=&= border="0">

dngzone

try this: you have to remove the '$' before the variable names as they are declared variables via the img string.
And I would suggest breaking out of PHP is set the img call.
?>

<center><img src="http://www2.milwaukee.k12.wi.us/psi/jpgraph/src/cbmorf2.php?arrayN=<?$arrayN;?>&arrayMWRC=<?$arrayMWRC;?>&arrayERR=<?$arrayERR;?>" border="0"></center>