GW PHP Read Only SQL Structure

Répondre
iz1kbp
Membre
Messages : 83
Inscription : dim. mars 16, 2008 1:14 pm

GW PHP Read Only SQL Structure

Message par iz1kbp »

Hi Antoine,sorry for troubble!
I'm trying to use your SQL version of GW with CLIENTRAW.TXT Weather Display file (I've got a DAvis VP2 station)
I have made a little php utiliy that extract data form clientraw file saved on my website and insert the values in a mysql dbase (see attched php file)
I've follow the SQL structure find in your CONFIG.PHP (Read Only SQL version) to build my Weatherinfo table.
The problem is that...do not work (he he he)..no particular error..only IMAGE WRONG
Your opinion about my project?

Thank's and sorry again for troubble.

Mario
Avatar de l’utilisateur
jturlier
Membre
Messages : 3149
Inscription : mar. août 22, 2006 8:38 am
Localisation : 34410 Sérignan - Languedoc
Contact :

Re: GW PHP Read Only SQL Structure

Message par jturlier »

Hi Mario,
I will be back and have a look next week on yr pb.
I may have a different full solution for you to store yr SQL data.
Rgds
Jean
iz1kbp
Membre
Messages : 83
Inscription : dim. mars 16, 2008 1:14 pm

Re: GW PHP Read Only SQL Structure

Message par iz1kbp »

ok !!thank's a lot jean!!
I'm pending from your..... keyboard! :D :D :D

mario
iz1kbp
Membre
Messages : 83
Inscription : dim. mars 16, 2008 1:14 pm

Re: GW PHP Read Only SQL Structure

Message par iz1kbp »

risultato.jpg
Hi Jean...this is the resul for my configuration!! :(
In my Dbase data are present form 00:00 to 24.00 at 5 minute step time.
All is out of regular position and nothing is graph!! :(
Wind seem to be right..but...i dont know...i don't want investigate now.
I've tryed to manipulate the php files but...without success!! :oops:

Mario
Vous ne pouvez pas consulter les pièces jointes insérées à ce message.
iz1kbp
Membre
Messages : 83
Inscription : dim. mars 16, 2008 1:14 pm

Re: GW PHP Read Only SQL Structure

Message par iz1kbp »

I've found a topic but...not in english...and I've understand that is may be a problem due a recent release of Jpgraph.
I've found these correction :
sscanf($list[8],"%4d%1s%2d%1s%2d%2d%1s%2d%1s%2d",$a_year,$nul,
$a_month,$nul,$a_day,$a_hours,$nul,$a_minutes,$nul,$a_seconds);

to apply to grph weather and graph.php and now I obtain these resul (see image)
risultato2.jpg
Any suggest is wellcome!! :cry: :cry: :cry: :cry: :cry: :cry: :cry:
Vous ne pouvez pas consulter les pièces jointes insérées à ce message.
Avatar de l’utilisateur
jturlier
Membre
Messages : 3149
Inscription : mar. août 22, 2006 8:38 am
Localisation : 34410 Sérignan - Languedoc
Contact :

Re: GW PHP Read Only SQL Structure

Message par jturlier »

Ciao Mario,i'll get in touch with you directly.

Jean
Répondre