Wow the PHP script is simple

[vollmey]

Thanks Dan for that wonderful PHP script stuff. I know nothing about HTML or website design, but I had this going in 30 mins or so. I've
always wanted to keep some kind of a logbook online without joining a VA and now you can. Good stuff Dan, truly appreciated.

Dave Vollmer
http://www.davevollmer.com

[DanSteph]

you welcome

Dan

[vollmey]

One thing Dan, I want to put total cargo weight on my page. Here is from the script and I added the "Total Cargo Hauled" Where in the
HTML do I put in the math or does it matter. I am tinkering here and really don't feel like screwing it up, but I would like total cargo on the
page.

if(!isset($listflight))
{
echo '<table align="center" width="300" cellspacing="2" cellpadding="2" border="0"><tr><td>My flights, click on flight id to
show detail of one flight.</td></tr></table><br>';

$CompanyFlightTime="00:00:00";
$TotalPassengers=0;

echo $ListStart.$TableTitle;
if($query = "SELECT * FROM flights WHERE 1 ORDER BY id desc")
$result=@mysql_query($query);if(!$result){echo "SQL Error - ".mysql_error();return;}
$NrfFlights=mysql_num_rows($result);
if($NrfFlights==0){echo "No flights to display";return;}
$Line=0;
while ($row = mysql_fetch_assoc($result))
{
echo $TRList;
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo "<a href=\"?action=va&listflight=$row[id]\">".$row["FlightId"]."</a>";
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo $row["FlightDate"];
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo $row["CompanyName"];
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo $row["PilotName"];
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo substr($row["DepartureIcaoName"],0,4);
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo substr($row["ArrivalIcaoName"],0,4);
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo $row["NbrPassengers"];
$TotalPassengers+=$row["NbrPassengers"];
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo $row["AircraftType"];
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo $row["TotalBlockTime"];
$CompanyFlightTime=AddTime($row["TotalBlockTime"],$CompanyFlightTime);
if($Line==0)echo $TDListOdd;else echo $TDListEven;
echo $row["FlightResult"];
echo "</td></tr>";
$Line=!$Line;
}
echo $ListStop;

echo "<br><br>".$ListStart.$TDListOdd."Total Flight made: $NrfFlights<br>Total flight time: $CompanyFlightTime<br>Total passengers
carried: $TotalPassengers<br> Total Cargo Hauled: $TotalCargoweight".$ListStop;
}

[DanSteph]

I do it like that:

Code:

///////////////////// THIS IS THE LIST TABLE OUTPUT ///////////////////////////////////////////////////////////
if(!isset($listflight))
{
    echo '<table align="center" width="300" cellspacing="2" cellpadding="2" border="0"><tr><td>Those are flight made by me or
by the beta tester. Click on flight id to show detail of one flight.</td></tr></table><br>';

$CompanyFlightTime="00:00:00";
$TotalPassengers=0;
$TotalCargo=0;
    
echo $ListStart.$TableTitle;
    if($query = "SELECT * FROM flights WHERE 1 ORDER BY id desc")
    $result=@mysql_query($query);if(!$result){echo "SQL Error - ".mysql_error();return;}
    $NrfFlights=mysql_num_rows($result);
    if($NrfFlights==0){echo "No flights to display";return;}
    $Line=0;
    while ($row = mysql_fetch_assoc($result))
    {
        echo $TRList;
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo "<a href=\"?action=va&listflight=$row[id]\">".$row["FlightId"]."</a>";
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo $row["FlightDate"];
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo $row["CompanyName"];
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo $row["PilotName"];
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo substr($row["DepartureIcaoName"],0,4);
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo substr($row["ArrivalIcaoName"],0,4);
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo $row["NbrPassengers"];
        $TotalPassengers+=$row["NbrPassengers"];
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo $row["AircraftType"];
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo $row["TotalBlockTime"];
        $CompanyFlightTime=AddTime($row["TotalBlockTime"],$CompanyFlightTime);
        if($Line==0)echo $TDListOdd;else echo $TDListEven;
        echo $row["FlightResult"];
        echo "</td></tr>";
        $Line=!$Line;
        settype($row["CargoWeight"],"integer");
        $TotalCargo+=$row["CargoWeight"];
    }
echo $ListStop;

echo "<br><br>".$ListStart.$TDListOdd."Total Flight made: $NrfFlights<br>total flight time: $CompanyFlightTime<br>Total passengers
carried: $TotalPassengers<br>Total Cargo: $TotalCargo kg".$ListStop;
}