preeti.91
Members-
Content count
5 -
Joined
-
Last visited
About preeti.91
-
Rank
Forum Newbie
-
By using the attached folder and running index.php file, I am just getting Chart written on the browser.
-
Relative URLs are not at all working and i am getting a lot of errors by specifying the relative path. And yes, my all js files are in the same folder.
-
I just see the message 'Connected Successfully' and 'Chart' when I run my php file, but not seeing any chart. Please help. Here is my code: <?php include("D:/FusionCha/FusionCharts.php"); include("D:/FusionCha/DBConn.php"); ?> <html> <title> FusionChart</title> <head> <script language="javascript" src="D:/FusionCha/FusionCharts.js"></script> </head> <body> <center> <?php //connect to the DB $link= connectToDB(); //$strXML will be used to store the entire XML document generated //Generate the graph element $strXML = "<graph caption='Worklog repor' subCaption='Month wise' xaxisname='Current Month' yaxisname='Blood Pressure' yAxisMaxValue='200' animation='1'>"; //Fetch records from database $query= "select Password,info_r3_c1 from work_data1"; $result = mysql_query($query) or die(mysql_error()); //echo $result; $row=mysql_fetch_array($result); //Generate the setname and value //echo $row['Date']; //$date=; //$sr=; //echo $date; //echo $row['Systole_reading']; //$strXML.="<set name='' value='". $row['systole_reading']."'/>"; //$strXML.="<set name='ondate' value".$result['ondate']."'/>"; $strXML .="<set name='" . $row['Password'] . "' value='" . $row['info_r3_c1'] . "' />"; mysql_free_result($result); //Finally, close <graph> element $strXML .= "</graph>"; //Create the chart - Pie 3D Chart with data from $strXML echo renderChart("D:/FusionCharts/Column2D.swf", "", $strXML, "Password", 650, 450,false,true); //echo renderChartHTML("./Charts/FCF_Bar2D.swf", "", $strXML, "ad", 800, 600, false); ?> </center> </body> </html>
-
Hi, I can't view Chart created. I am just getting the message 'Connected Successfully' Please help. Here is my code: <?php include("D:/FusionCha/FusionCharts.php"); include("D:/FusionCha/DBConn.php"); ?> <html> <title> FusionChart</title> <head> <script language="javascript" src="D:/FusionCha/FusionCharts.js"></script> </head> <body> <center> <?php //connect to the DB $link= connectToDB(); //$strXML will be used to store the entire XML document generated //Generate the graph element $strXML = "<graph caption='Worklog repor' subCaption='Month wise' xaxisname='Current Month' yaxisname='Blood Pressure' yAxisMaxValue='200' animation='1'>"; //Fetch records from database $query= "select Password,info_r3_c1 from work_data1"; $result = mysql_query($query) or die(mysql_error()); //echo $result; $row=mysql_fetch_array($result); //Iterate through each patient blood pressure systole //Generate the setname and value //echo $row['Date']; //$date=; //$sr=; //echo $date; //echo $row['Systole_reading']; //$strXML.="<set name='' value='". $row['systole_reading']."'/>"; //$strXML.="<set name='ondate' value".$result['ondate']."'/>"; $strXML .="<set name='" . $row['Password'] . "' value='" . $row['info_r3_c1'] . "' />"; mysql_free_result($result); //Finally, close <graph> element $strXML .= "</graph>"; //Create the chart - Pie 3D Chart with data from $strXML echo renderChartHTML("D:/FusionCha/FusionCharts/Column2D.swf", "", $strXML, "Password", 650, 450,false); //echo renderChartHTML("./Charts/FCF_Bar2D.swf", "", $strXML, "ad", 800, 600, false); ?> </center> </body> </html>
-
Mysql, Converting Data Into A Pie Chart
preeti.91 replied to AquaTeamV3's topic in FusionCharts and PHP
Hi I am trying to get data from MySql loctated on a server. I am getting following error: ( ! ) Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\www\Database.php on line 41 Please tell me the solution: And also the chart can't be generated. Here is my code: <?php include("includes/FusionCharts.php"); include("includes/DBConn.php"); ?> <html> <title> FusionChart</title> <head> <script language="javascript" src="includes/FusionCharts.js"></script> </head> <body> <center> <?php //connect to the DB $link= connectToDB(); //$strXML will be used to store the entire XML document generated //Generate the graph element $strXML = "<graph caption='Worklog repor' subCaption='Month wise' xaxisname='Current Month' yaxisname='WorkData' yAxisMaxValue='200' animation='1'>"; //Fetch records from database $query= "select Password,info_r3_c1 from work_data1"; $result = mysql_query($query) or die(mysql_error()); //echo $result; $row=mysql_fetch_array($result) //Iterate through each patient blood pressure systole //Generate the setname and value //echo $row['Date']; //$date=; //$sr=; //echo $date; //echo $row['Systole_reading']; //$strXML.="<set name='' value='". $row['systole_reading']."'/>"; //$strXML.="<set name='ondate' value".$result['ondate']."'/>"; $strXML .="<set name='" . $row['Password'] . "' value='" . $row['info_r3_c1'] . "' />"; mysql_free_result($result); //Finally, close <graph> element $strXML .= "</graph>"; //Create the chart - Pie 3D Chart with data from $strXML echo renderChartHTML("Includes/FusionCharts/Column2D.swf", "", $strXML, "Password", 650, 450,false); //echo renderChartHTML("./Charts/FCF_Bar2D.swf", "", $strXML, "ad", 800, 600, false); ?> </center> </body> </html>