Reef nutrition

Web dev people (or anyone else), need a script to enter and save water test data

badbread

badbread

Guest
BARcard
Ok, the title sucks.

What I'm looking to do is setup a webpage probably using the PHP/MySQL combo to enter water test information into which will log/save all data I enter and as a bonus run reports, display graphs, etc... I know a little about MySQL and a fair amount of other basic php web stuff.

Does anyone know of a script out there I could use to do something like this?
 
Something similar to this I guess but I want to host it for my use only.

http://www.mta-boise.com/ereeflog/reeflog.shtm

http://www.stugotz.net/log/features.cfm

Really just want to track water test parameters, not all that other funky stuff.
 
Well, I got a start to it...

http://badbread.net/dada/index.php

Now when I have some time I'm going to make it look pretty, probably redo the MySQL database, and try to figure out how to get JPGraphs to pull data from MySQL.
 
Why do you even want to use SQL? Access is EASILY powerful enough to handle that small amount of data. Heck, Excel would be good enough. There's no reason to run a SQL server for this.
 
I don't know, I didn't think Access would interface on the web...

Anywho, after countless hours in an IRC PHP help room, and a very nice CS student from Brazil I'm making some progress. The MySQL is all tidied up and the graphs are graphing (sort of), just need to tidy those up and it should be good to go.

http://badbread.net/amline/
 
OK, two things:
1. Access can be used on the web.
2. Why do you need web access? Are you going to be entering data about your tank remotely?

Sounds like you're trying to kill a fly with a howitzer. I just built an Access DB in 15 minutes that can report and graph all of my tank data. I'm not going to use it, but I did it in 15 minutes.
 
Kill a fly with a howitzer, that's how I roll!

I like to have access to tank data while away from the tank and figure no matter where I am I can look it up this way. I was using the software that came with the RK2 but it kind of sucks.. It really sucks and to access it I would have to have my laptop on me, with Dameware, etc... If the laptop housing all my test data dies, all that data is dead to, on a webserver it's pretty much there forever.

Plus, I'm a bit of a technology geek, and this is cool. :)
 
I've been doing some logging and graphing for my data, but it's for continuously logged data, not manual entry.

For manual entry stuff, I just type it into a text file. :)
 
Good call Gomer, thanks!

So now that I got this going I figure why the hell not try and do what this guy did:
http://reef.pantshead.com/?p=383

My brother is pretty proficient in perl, and it looks like writing a script to pull data from a serial port is pretty straightforward.

Luckily my laptop is right next to my tank so I don't have to worry about all that wireless stuff the guy in the above link did.

I also picked up one of these bad boys:
http://usb.brando.com.hk/prod_detail.php?prod_id=00609

I'm hoping there is a way to pull the data this thing spits out through Perl and add it to the graphs as well.

Why you may ask? Why not, good refresher in Perl, PHP, and MySQL and I always need some sort of project or else I play XBOX all night.
 
[quote author=Gomer link=topic=6004.msg76146#msg76146 date=1232579621]
looks good. Plot alk and salinity on the right axis using a different scale.
[/quote]

I think I'll disagree with this one. If it were me I'd definitely have salinity separated since it is the least likely to fluctuate. BUT...I'd want Alk, CA and Mg vertically aligned with one another so I could more easily see the interaction of the three. This of course could be three separate charts, but since you have the same "x" axis I'd just have a split graph.

Also, can you smooth out the graph? I forget the exact code, but I know there was something I used back in my dev days. Just a personal preference from my days of collecting and analyzing data, nothing important unless you agree.
 
Ok, just about done I think. The data in there now is real data so please don't add anymore test data.

Matt, can you take a look and critique?

http://badbread.net/dada/


Thanks!!!
 
You must log in or register to reply here.
Back
Top