preeti.91

Members
  • Content count

    5
  • Joined

  • Last visited

Posts posted by preeti.91


  1. 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>

  2. 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>

  3. 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>