Reply to thread

Message

<blockquote data-quote="Skythrust" data-source="post: 475571" data-attributes="member: 87030">I tried this, when I include the php file on the top of the file and I do an echo it works. When I hide the echo and try to add this in the script I will get a blanc page or the message; 'SyntaxError: JSON.parse: unexpected character at line 3 column 1 of the JSON data'My code;[CODE=php]// index.php&lt;?php include 'temp.php'; ?&gt;&lt;!DOCTYPE html&gt;&lt;html&gt;&lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.5.0/Chart.min.js&quot;&gt;&lt;/script&gt;&lt;body&gt;&lt;canvas id=&quot;myChart&quot; style=&quot;width:100%;max-width:600px&quot;&gt;&lt;/canvas&gt;&lt;script&gt;const json = &lt;?php echo $JSONAnalyse; ?&gt;var xValues = json.map(el =&gt; el.DateTime);new Chart(&quot;myChart&quot;, {&nbsp; type: &quot;line&quot;,&nbsp; data: {&nbsp; &nbsp; labels: xValues,&nbsp; &nbsp; datasets: [{&nbsp; &nbsp; &nbsp; &nbsp; data: json.map(el =&gt; el.Kh),&nbsp; &nbsp; &nbsp; borderColor: &quot;blue&quot;,&nbsp; &nbsp; &nbsp; fill: false&nbsp; &nbsp; }]&nbsp; },&nbsp; options: {&nbsp; &nbsp; legend: {display: false}&nbsp; }});&lt;/script&gt;[/CODE][CODE=php]// temp.php&lt;?phpheader('Content-Type: application/json; charset=utf-8');// Aquarium Test Variables Charts$vCalcium = &quot;&quot;;$vCarbonateHardness = &quot;&quot;;&nbsp;&nbsp; $vIodine = &quot;&quot;;$vMagnesium = &quot;&quot;;$vNitrite = &quot;&quot;;$vNitrate = &quot;&quot;;$vAlkanity = &quot;&quot;;$vPhosphate = &quot;&quot;;$vStrontium = &quot;&quot;;$vSodiumChloride = &quot;&quot;;$vDateTime = &quot;&quot;;$conn=mysqli_connect(DATABASE_CONNECTION);$sql = &quot;SELECT * FROM Values ORDER BY DateTime DESC LIMIT 10&quot;;$result = mysqli_query($conn, $sql);&nbsp; &nbsp; while($row = mysqli_fetch_assoc($result))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $vCarbonateHardness = $row[&quot;Kh&quot;];&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $vDateTime = $row[&quot;DateTime&quot;];&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $AnalyseArray[] = array(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;DateTime&quot;=&gt; &quot;$vDateTime&quot;, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;Kh&quot;=&gt; &quot;$vCarbonateHardness&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; mysqli_close($conn);&nbsp; &nbsp; $JSONAnalyse = json_encode($AnalyseArray);&nbsp; &nbsp; //echo $JSONAnalyse;&nbsp; &nbsp; &nbsp; &nbsp; $conn-&gt;close();?&gt;[/CODE][automerge]1669643932[/automerge][USER=73182]@TheGeneral[/USER] can you please help me out with this? <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="Skythrust, post: 475571, member: 87030"] I tried this, when I include the php file on the top of the file and I do an echo it works. When I hide the echo and try to add this in the script I will get a blanc page or the message; 'SyntaxError: JSON.parse: unexpected character at line 3 column 1 of the JSON data' My code; [CODE=php]// index.php <?php include 'temp.php'; ?> <!DOCTYPE html> <html> <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.5.0/Chart.min.js"></script> <body> <canvas id="myChart" style="width:100%;max-width:600px"></canvas> <script> const json = <?php echo $JSONAnalyse; ?> var xValues = json.map(el => el.DateTime); new Chart("myChart", { type: "line", data: { labels: xValues, datasets: [{ data: json.map(el => el.Kh), borderColor: "blue", fill: false }] }, options: { legend: {display: false} } }); </script> [/CODE] [CODE=php]// temp.php <?php header('Content-Type: application/json; charset=utf-8'); // Aquarium Test Variables Charts $vCalcium = ""; $vCarbonateHardness = ""; $vIodine = ""; $vMagnesium = ""; $vNitrite = ""; $vNitrate = ""; $vAlkanity = ""; $vPhosphate = ""; $vStrontium = ""; $vSodiumChloride = ""; $vDateTime = ""; $conn=mysqli_connect(DATABASE_CONNECTION); $sql = "SELECT * FROM Values ORDER BY DateTime DESC LIMIT 10"; $result = mysqli_query($conn, $sql); while($row = mysqli_fetch_assoc($result)) { $vCarbonateHardness = $row["Kh"]; $vDateTime = $row["DateTime"]; $AnalyseArray[] = array( "DateTime"=> "$vDateTime", "Kh"=> "$vCarbonateHardness"); } mysqli_close($conn); $JSONAnalyse = json_encode($AnalyseArray); //echo $JSONAnalyse; $conn->close(); ?>[/CODE] [automerge]1669643932[/automerge] [USER=73182]@TheGeneral[/USER] can you please help me out with this? :) [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members