http://dukes.internetmaximum.com/gas2.php
gas2.php:
- Code: Select all
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<HTML>
<HEAD><TITLE> Duce's Gas Mileage Chart v2!! </TITLE>
</HEAD>
<BODY>
<?php
$link = mysql_connect("localhost", "dbusername", "dbpassword")
or die("Could not connect: " . mysql_error());
mysql_select_db (dbname);
$dir= "asc";
if (isset($_GET["sort_val"])) $get = $_GET["sort_val"];
else $get = "id";
if ($_GET["sort_dir"] == "asc") $dir = "desc";
$sql = "SELECT * from mileage2 order by $get $dir ";
$result = mysql_query($sql);
echo mysql_error();
if (mysql_num_rows($result) == 1) print "Your SELECT query was successful.";
elseif (mysql_num_rows($result) == 0)
{
print "Your SELECT query was not successful.";
exit;
}
print "<TABLE BORDER=1>
<TR>
<TD><A HREF=gas2.php?sort_val=id&sort_dir=$dir>id</A></TD>
<TD><A HREF=gas2.php?sort_val=fill_date&sort_dir=$dir>time</A></TD>
<TD><A HREF=gas2.php?sort_val=odometer&sort_dir=$dir>Odometer</A></TD>
<TD><A HREF=gas2.php?sort_val=lp100km&sort_dir=$dir>L/100km</A></TD>
<TD><A HREF=gas2.php?sort_val=mpg&sort_dir=$dir>MPG</A></TD>
<TD><A HREF=gas2.php?sort_val=cpkm&sort_dir=$dir>$/km</A></TD>
<TD><A HREF=gas2.php?sort_val=kilometers&sort_dir=$dir>trip</A></TD>
<TD><A HREF=gas2.php?sort_val=liters&sort_dir=$dir>Liters</A></TD>
<TD><A HREF=gas2.php?sort_val=gas_rate&sort_dir=$dir>Gas Price</A></TD>
<TD><A HREF=gas2.php?sort_val=fill_cost&sort_dir=$dir>Fill Cost</A></TD>
<TD><A HREF=gas2.php?sort_val=station&sort_dir=$dir>Station</A></TD>
<TD><A HREF=gas2.php?sort_val=notes&sort_dir=$dir>Drive Notes</A></TD>
<TD><A HREF=gas2.php?sort_val=business&sort_dir=$dir>Business Use</A></TD>
</TR>
";
$total_km = 0;
$total_liters = 0;
$total_price = 0;
$total_cost = 0;
$total_mpg = 0;
$total_lp = 0;
if ($row = mysql_fetch_array($result))
{
do
{
echo "
<TR>
<TD>" . $row[0] . "</TD>
<TD>" . $row[1] . "</TD>
<TD>" . $row[2] . "</TD>
<TD>" . $row[3] . "</TD>
<TD>" . $row[4] . "</TD>
<TD>$".round($row[5],4)."</TD>
<TD>" . $row[6] . "</TD>
<TD>" . $row[7] . "</TD>
<TD>" . $row[8] . "</TD>
<TD>$".round($row[9],2)."</TD>
<TD>" . $row[10] . "</TD>
<TD>" . $row[11] . "</TD>
<TD>" . $row[12] . "</TD>
</TR>";
$total_lp = $total_lp + $row[3];
$total_km = $total_km + $row[6];
$total_liters = $total_liters + $row[7];
$total_price = $total_price + $row[8];
$total_cost = $total_cost + $row[9];
$total_mpg = $total_mpg + $row[4];
$total_cpkm = $total_cpkm + $row[5];
}
while($row = mysql_fetch_array($result));
}
else print "Sorry, no records were found!";
$num_rows = mysql_num_rows($result);
$avg_km = $total_km / ($num_rows - 1);
$avg_liters = $total_liters / ($num_rows - 1);
$avg_price = $total_price / ($num_rows - 1);
$avg_cost = $total_cost / ($num_rows - 1);
$avg_mpg = $total_mpg / ($num_rows - 1);
$avg_lp = $total_lp / ($num_rows - 1);
$avg_cpkm = $total_cpkm / ($num_rows - 1);
echo "
<TR>
<TD COLSPAN=13><CENTER>...:Statistics:...</CENTER></TD>
</TR>
<TR>
<TD COLSPAN=3>Totals::</TD>
<TD></TD>
<TD></TD>
<TD></TD>
<TD>".round($total_km,2)." km</TD>
<TD>".round($total_liters,2)." L</TD>
<TD></TD>
<TD>$".round($total_cost,2)."</TD>
</TR>
<TR>
<TD COLSPAN=3>Averages::</TD>
<TD>".round($avg_lp,2)." L/100km</TD>
<TD>".round($avg_mpg,2)." MPG</TD>
<TD>$".round($avg_cpkm,4)."/km</TD>
<TD>".round($avg_km,2)." km</TD>
<TD>".round($avg_liters,2)." L</TD>
<TD>$".round($avg_price,3)."</TD>
<TD>$".round($avg_cost,2)."</TD>
</TR>
";
echo "</TABLE>";
?>
<BR>
<FORM METHOD=get ACTION=gas2-entry.php>
<TABLE border=0>
<TR>
<TD>Date:</TD>
<TD><INPUT TYPE=text NAME=filldate MAXLENGTH=19></TD>
</TR>
<TR>
<TD>Odometer:</TD>
<TD><INPUT TYPE=text NAME=odometer MAXLENGTH=6></TD>
</TR>
<TR>
<TD>Gas rate:</TD>
<TD><INPUT TYPE=text NAME=gas_rate MAXLENGTH=6></TD>
</TR>
<TR>
<TD>Liters:</TD>
<TD><INPUT TYPE=text NAME=liters MAXLENGTH=6></TD>
</TR>
<TR>
<TD>Gas Station:</TD>
<TD><INPUT TYPE=text NAME=station MAXLENGTH=255></TD>
</TR>
<TR>
<TD>Drive Notes:</TD>
<TD><INPUT TYPE=text NAME=notes MAXLENGTH=1023></TD>
</TR>
<TR>
<TD>Business Use?</TD>
<TD>Yes <INPUT TYPE=radio NAME=business value=yes>No <INPUT TYPE=radio NAME=business value=no></TD>
</TR>
<TR>
<TD>Password:</TD>
<TD><INPUT TYPE=password NAME=password MAXLENGTH=255></TD>
</TR>
<TR>
<TD COLSPAN=2><CENTER>
<INPUT TYPE=hidden NAME="username" value="red">
<INPUT TYPE=submit VALUE="Enter New Fill Data"></CENTER></TD>
</TR>
</TABLE>
</FORM>
<FORM METHOD=GET ACTION=calc.php>
<TABLE BORDER=1>
<TR>
<TD>
kilometers: <INPUT TYPE=text NAME=KM>
liters: <INPUT TYPE=text NAME=L>
<INPUT VALUE="Calculate MPG" TYPE=submit>
</TD>
</TR>
</TABLE>
</FORM>
<?
mysql_close($link);
?>
</BODY>
</HTML>
gas2-entry.php:
- Code: Select all
<?php
$link = mysql_connect("localhost", "dbusername", "dbpassword")
or die("Could not connect: " . mysql_error());
mysql_select_db (dbname);
$filldate = $_GET['filldate'];
$odometer = $_GET['odometer'];
$gas_rate = $_GET['gas_rate'];
$station = $_GET['station'];
$liters = $_GET['liters'];
$notes = $_GET['notes'];
$business = $_GET['business'];
$password = $_GET['password'];
if($password != "formpassword")
{
echo "Go away!"; exit;
}
$result = mysql_query("SELECT odometer from mileage2 ORDER BY id desc limit 1");
$row = mysql_fetch_array($result);
$last_odometer = $row[0];
$kilometers = $odometer - $last_odometer;
$mpg = $kilometers / 1.609344 / $liters * 3.7854;
$lp100km = $liters / $kilometers * 100;
$fill_cost = $gas_rate * $liters;
$cpkm = $fill_cost / $kilometers;
if($business == "yes")
{
$business = '1';
}
mysql_query("
INSERT into mileage2 (fill_date,odometer,lp100km,mpg,cpkm,kilometers,liters,gas_rate,fill_cost,station,notes,business)
VALUES('$filldate','$odometer','$lp100km','$mpg','$cpkm','$kilometers','$liters','$gas_rate','$fill_cost','$station','$notes','$business')
");
echo mysql_error();
echo "Old Odometer Reading = " . $last_odometer . "<BR>";
echo "New Odometer Reading = " . $odometer . "<BR>";
echo "MPG = " . $mpg . "<BR>";
echo "$/km = " . $cpkm . "<BR>";
echo "L/100km = " . $lp100km . "<BR>";
echo "kilometers = " . $kilometers . "<BR>";
echo "Liters = " . $liters . "<BR>";
echo "Gas Price = " . $gas_rate . "<BR>";
echo "Fill Cost = " . $fill_cost . "<BR>";
echo "Station = " . $station . "<BR>";
echo "Drive Notes = " . $notes . "<BR>";
mysql_close($link);
?>
<HTML>
<HEAD>
<meta http-equiv="Refresh" content="1;URL=gas2.php">
</HEAD>
</HTML>
And the SQL query to set up the tables:
- Code: Select all
-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
--
-- Table structure for table `mileage2`
--
CREATE TABLE `mileage2` (
`id` int(255) NOT NULL auto_increment,
`fill_date` datetime default NULL,
`odometer` int(255) NOT NULL default '0',
`lp100km` double(16,4) NOT NULL default '0.0000',
`mpg` double(16,4) NOT NULL default '0.0000',
`cpkm` varchar(16) NOT NULL default '',
`kilometers` int(255) NOT NULL default '0',
`liters` double(16,4) NOT NULL default '0.0000',
`gas_rate` double(16,4) NOT NULL default '0.0000',
`fill_cost` double(16,4) NOT NULL default '0.0000',
`station` text NOT NULL,
`notes` text NOT NULL,
`business` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `id_2` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;
--
-- Dumping data for table `mileage2`
--
INSERT INTO `mileage2` VALUES (1, '2005-05-28 08:32:24', 262737, 0.0000, 0.0000, '', 0, 0.0000, 0.0000, 0.0000, 'Centex - 16th Ave', 'Initial Fill', 0);
