[PHP][MySQL] PHPLOT + SQL Opcje

[rembasow1]

Witam, chciałbym stworzyć wykres na podstawie danych z tabeli z bazy MySQL. Problem polega na tym ze wykres jest pusty i nie uzupelnia sie danymi z tabeli. Błędy są zapewne w linijce 21-22 jednak nie wiem jak sobie z nimi poradzić. Bardzo proszę o pomoc i z góry dziękuję (IMG:style_emoticons/default/smile.gif)

[PHP] pobierz, plaintext 
<?php
//Include the code
require_once 'phplot.php';
 
mysql_connect("localhost", "root", "pass");
mysql_select_db("db");
//Define the object
$query = mysql_query("SELECT ID, X1, X2, X3, X4, X5 FROM pomiary");
 
 
$plot = new PHPlot(1000,750);
 
//Set titles
$plot->SetTitle("A 3-Line Plot\nMade with PHPlot");
$plot->SetXTitle('X Data');
$plot->SetYTitle('Y Data');
 
WHILE($row = mysql_fetch_assoc($query))
{
//Define some data$row['']
$example_data = array(
     array($row['ID'],$row['x1'],$row['x2'],$row['x3'],$row['x4'],$row['x5']),
 
);
}
$plot->SetDataValues($example_data);
 
//Turn off X axis ticks and labels because they get in the way:
$plot->SetXTickLabelPos('none');
$plot->SetXTickPos('none');
 
//Draw it
$plot->DrawGraph();
[PHP] pobierz, plaintext 

[rad11]

Spróbuj:

[PHP] pobierz, plaintext 
$example_data[] = array($row['ID'],$row['x1'],$row['x2'],$row['x3'],$row['x4'],$row['x5']);
[PHP] pobierz, plaintext 

Ten post edytował rad11 18.11.2016, 12:28:19

[rembasow1]

Na szybko: nadpisujesz pętlą while za każdym razem (ile wierszy zwróci zapytanie) zmienną $example_data

Problem w tym ze wiersze będą dodawane na bierząco (co godzine)

Spróbuj:

[PHP] pobierz, plaintext 
$example_data[] = array(
     array($row['ID'],$row['x1'],$row['x2'],$row['x3'],$row['x4'],$row['x5']),
 
);
[PHP] pobierz, plaintext 

krzaki wyskakują :

Warning: explode() expects parameter 2 to be string, array given in /z4/phplot.php on line 1789

Warning: Invalid argument supplied for foreach() in /z4/phplot.php on line 1789

Warning: explode() expects parameter 2 to be string, array given in /z4/phplot.php on line 1789

Warning: Invalid argument supplied for foreach() in /z4/phplot.php on line 1789

Warning: explode() expects parameter 2 to be string, array given in /z4/phplot.php on line 1789

Warning: Invalid argument supplied for foreach() in /z4/phplot.php on line 1789

Warning: explode() expects parameter 2 to be string, array given in /z4/phplot.php on line 1789

Warning: Invalid argument supplied for foreach() in /z4/phplot.php on line 1789

Warning: explode() expects parameter 2 to be string, array given in /z4/phplot.php on line 1789

Warning: Invalid argument supplied for foreach() in /z4/phplot.php on line 1789

Warning: explode() expects parameter 2 to be string, array given in /z4/phplot.php on line 1789

Warning: Invalid argument supplied for foreach() in /z4/phplot.php on line 1789

Warning: Cannot modify header information - headers already sent by (output started at /z4/phplot.php:1789) in /z4/phplot.php on line 2288

Warning: Cannot modify header information - headers already sent by (output started at /z4/phplot.php:1789) in /z4/phplot.php on line 2289

Warning: Cannot modify header information - headers already sent by (output started at /z4/phplot.php:1789) in /z4/phplot.php on line 2290

Warning: Cannot modify header information - headers already sent by (output started at /z4/phplot.php:1789) in /z4/phplot.php on line 2291

Warning: Cannot modify header information - headers already sent by (output started at /z4/phplot.php:1789) in /z4/phplot.php on line 2311
�PNG  IHDR��@��� PLTE�������g��IDATx���A��6Fa�07]9�|�C:{s�!G�Q+r�7��
���M���gJ�e�`)ffff��y����Ա������]zUm�Y�g�2OK��q{����R��C��9��r[��N��ڎ޹�mЧ���\�8ק�VȨ_��x^��>��ɻ�[����K���3��ב�����������{�}|�iK[�:�1��_�/��{gffff��:����������2�mz돱ۥ���>��en˼���{���0?GD�}�w+��oS�{�mj�m}���7G��u�������ӝ��m�z��V�i?���ů��Q��>�;�6���m�_�u\׷�������0�>�Q/Hz�����N����\W�~�ߖ� �/�u�����>m���֟k���Χ���������G}�׶���_���D/�q���{��/P���tDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtD�n��߰�3�^������x�SG}�^�z�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�IO�=�g.�ʥp�}&����J~��0��9u����"��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$�S�F����Q����k%�j����"��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$�#�q��%jOdzm��k%�j;?��QӋtHғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtD.V:Z��?��[��|�Zɯ�\�y��鐤'鈤'鈤O��xܞ��;�r�����tD�s�~��#����� �T?���Ho�+|�>���U�HO@�wnD:��L��޹���9�g��{���x0=IG$=IG$=IGt�����sD:�Y0|��/sI:"�I:"��J/G�p��>�I��/���I�#'qS���#���#���#���#���#���#���#���#���#���#���#���#���#���#���#���#���#���#�>:q��ٍ���[��|�2ѯ�~<���:�^�C���#���#���#���#���#���#���#���#���#���#���#���#���#���#���#���#���#���#r:��D-xbg_����k%�j{��>����"��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$��$�S�F����~�3��_+�U���e��z�ҋtHғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtD��;O��z�ɼ�V��6G}t�ҋtHғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtDғtD�n}���^�����t����u>���R�ޏ��2]$�t�����^��w��MK��������^յ�z�傣��c�G���>����m���x33�/����+�DIEND�B`�