PHP/SQL MPG WebApp

[ungawd]

I have written a web application in PHP and sqlite3 for the purpose of mileage tracking, fuel efficiency calculation, statistics accumulation, and performance data among other things. It's in a nearly finished state right now to include secured individual logins and registration. When submitting a fuel fillup, users have the choice to include the fillup in their monthly aggregate for friendly competition. 2 fillups of at least 6.1 gallons are required to be entered monthly which is equivalent to one full tank. Users can choose to exclude all but their best tanks and the system will process an awards listing featuring the most efficient, and least efficient in some cases, tanks that have been submitted by month and overall. Diesel users and our friends overseas are not excluded; the system allows for the input of liters, imperial gallons, and kilometers then converts that to US gallons and miles. Optionally users can enter cost per fuel unit but only in us$ as currency conversion would cause unnecessary bloat. If fuel unit cost is entered the system will calculate that tank's Cost Per Mile and will present your overall average Cost Per Mile for all tanks which have been submitted with a listed fuel unit cost.

CarData is an integral part of this system. It allows users to create and store Loadouts for their vehicle that are task specific. An unlimited number of Loadouts can be created for purposes of fine tuning the efficiency and performance of your vehicle. Users may also browse other people's Loadouts to see what they have done to achieve high efficiency or performance. CarData in combination with the filtering tool allows users to fine tune a search that will present them with a listing of all fuel fillups, and soon to be dragstrip data, that meet their criteria. The data can be filtered to include or exclude by; style, trim, engine, transmission, model year, and a wide assortment of accessories and modifications.

The app is accessible here-> http://173.81.176.133:8080/
TODO:
Complete the dashboard, integrate awards and dragstrip data
Complete the admin code snippets and create an admin panel
Complete the Awards system

 

[ungawd]

Looks perfect to me. To be honest, I am having a hard time getting onto my laptop. It isn't even all the kiddie things going on. All the time I missed going to the hospital has finally caught up.

This would make it simple and easy. You did an amazing job. I might have a suggestion for you, but will take that offline in a PM.

I say fire that bad boy up and let the chips fall. I am a big believer in adjusting on the fly. You can never fully account for the unforeseen.

Can you control who can join and who can't?

Thanks. This should cut the dedicated time down to nil.

Throwing it out to the masses for testing is the next step. Trial by fire is the best way to find problems, although I don't expect anything beyond cosmetics.

I don't quite understand the can and can't join part. Currently the registration process is simply in place to get a login to facilitate individual record integrity. I will write a basic captcha system for registration only as it will cut down on robot logins.

 

[GeneralZod]

Rules? I think you covered it all. I like the 6.1 gallon minimum.

It takes the one gallon crusaders out of the mix.



With your PHP/SQL wizardry, could we have the award listed with .jpegs or .gifs? Almost like badges or ratings... Bahhahahahaha, I can't say more.

Of course this is down the road. But damn do I have some ideas for the awards.

 

[GeneralZod]

I don't quite understand the can and can't join part. Currently the registration process is simply in place to get a login to facilitate individual record integrity. I will write a basic captcha system for registration only as it will cut down on robot logins.

Ahhhh, I thought it would be they are registered here and given a pass to login via PM. Even better, I was under the assumption from a previous posts that logins or monitoring was a concern. Or I could have made that up in my head. At this point I wouldn't be surprised if it was the latter.

 

[ungawd]

Rules? I think you covered it all. I like the 6.1 gallon minimum.

It takes the one gallon crusaders out of the mix.



With your PHP/SQL wizardry, could we have the award listed with .jpegs or .gifs? Almost like badges or ratings... Bahhahahahaha, I can't say more.

Of course this is down the road. But damn do I have some ideas for the awards.

The 6.1 gallon minimum * 2 tanks is to ensure at least a full tank is submitted for each month of competition. The 12.2 gallons is unnecessary and is a simple sanity check. The main test is on tank submission as it won't allow an aggregated submission for a fillup less than 6.1 gallons. It will, however, include the submitted tank in the member's records but not flagged for competition.

Images, albeit small, will be included in the awards listing as well as when viewing a member's dashboard. Member dashboards will show lifetime stats: awards, last mpg, overall mpg, total miles, total gallons, vehicle type, vehicle mods, and whatever else is suggested.

I answered this in your email, but for everyone else: I may include a signature image option to display your mpg or whatever. It simple to code using imagemagik.

 

[ungawd]

Ahhhh, I thought it would be they are registered here and given a pass to login via PM. Even better, I was under the assumption from a previous posts that logins or monitoring was a concern. Or I could have made that up in my head. At this point I wouldn't be surprised if it was the latter.

Nah, it's incorporated in the webapp already. I could reuse forum session data to collect username to avoid a seperate registration / login system. It was easy to write so I went ahead and did it. It makes standalone testing convenient to boot. Another thing I mentioned in the email I sent you was regarding captcha. So everyone else knows, I may, leaning toward likely, incorporate captcha into the registration system to eliminate dummy accounts created by robots.

 

[GeneralZod]

This just got real... Real amazing! :banana:

 

[ungawd]

Chance catch an hour ago; why is my current month leaderboard empty?

$year = date("Y");
$month = date("m");
$monthname = date("F",mktime(0,0,0,$month,1,$year));
echo $monthname.", ".$year;

WTF? It's not May, 2013 yet.
Oh, yeah.

// We should use EST because it's the center of the known universe
date_default_timezone_set('America/New_York');

 

[ungawd]

Award caregories (preliminary)

Best overall MPG
Worst overall MPG
Best MPG with 87 Octane or below
Best MPG by Trim (ls, lt, ltz, rs)
Best MPG with manual
Best MPG with automatic
Best MPG with Diesel
Best MPG with E85
Most miles logged
Least miles logged
Most fuel logged
Least fuel logged
Best cost per mile
Worst cost per mile

I'll merge suggestions and award names into this list.

 

[ungawd]

This can be tested today between 8am and 4:30pm EST.
The data will be wiped, so enter whatever you want. Create as many accounts as you want. Try to break it if you want. As for passwords, they're hashed using sha256 encryption so it is quite secure. If you're untrusting just use 1234 or something (hint: that's the password for mine).

Anyway, here's a link that should work.
* removed link

Comment if you have difficulty accessing the app or find bugs. There are some glaring defects that I haven't sanitized yet, but they're cosmetic and won't affect functionality. It should be surprisingly quick for being hosted by a tablet. I doubt its responses will be any more delayed than any average server that's co-lo.

 

[GeneralZod]

Flawless!

 

[mitdr774]

A little optimistic with a 1.8 at 55.2 mpg??

 

[$ub$onic]

A little optimistic with a 1.8 at 55.2 mpg??

+1 the best I could do was 46 ish and that was hard. I would like to know how he is pulling off 55

 

[mitdr774]

I think it was just inputting information to test the system. My best is 44.9, not really all that hard to do on the freeway.

 

[GeneralZod]

Yeah, he is testing...

 

[$ub$onic]

Works for me

 

[ungawd]

It's all junk data for testing. Input as much of it as you want because it will be cleaned out. It will next be available tomorrow morning at 8am. I'm not sure if I will have time tonight to do very much work on it. I will fix the spammed warnings about undefined variables where a user is viewing the index/dashboard and has no fillup records. Apparently sqlite3 doesn't have a row count function although two are documented; numRows() and rowCount(). I'll fix it by appending COUNT(*) to the query or a nested if and set everything to N/A and 0 if it returns no result. I didn't want to leave it that way all day but I really needed sleep.

 

[$ub$onic]

I made a account and will be using or data base thank you

 

[ungawd]

I made a account and will be using or data base thank you

Its availability will be sporadic until it's hosted on a permanent solution. It will always be available while I'm sleeping or at home. It isn't at a deployable state but should be very usable. I will wipe the data prior to it going fully live so don't count on permanence.

I fixed the error spam once I got here at work. I did what I should have done and initialized all those variables with N/A or 0 so it won't complain. That saves a ton of cpu cycles over a nested if or case statements.

If time permits tonight, which it looks like it may, I'll start on the awards system and throw together a 1/4 mile archive into it. The latter will be a 30 minute task I'm guessing. In the 1/4 mile archive I plan on allowing a picture of the time slip to be uploaded and included in the results.

 

[$ub$onic]

How are you hosting it?