Hi D.
Thanks for you getting back to me!
Yes, I want to make this website for every body (Pilots), for both FAA and EASA.
Ok, this is how my index file looks like. But this is only for displaying the information (I have some data in my DB which I have imported):
<?php require_once('../Connections/logbook.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_logbook, $logbook);
$query_rsMain = "SELECT * FROM air_flight_log ORDER BY DEPARTURE_DATE ASC";
$rsMain = mysql_query($query_rsMain, $logbook) or die(mysql_error());
$row_rsMain = mysql_fetch_assoc($rsMain);
$totalRows_rsMain = mysql_num_rows($rsMain);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table border="0">
<tr>
<td>FLIGHT_ID</td>
<td>Date (dd/mm/yy)</td>
<td>DEP (place)</td>
<td>OFF BLOCK (UTC)</td>
<td>ARR (place)</td>
<td>ON BLOCK (UTC)</td>
<td>TYPE AIRCRAFT OR SYNTHETIC TRANINF DEV.</td>
<td>REGISTRATION</td>
<td>NAME OF PILOT IN COMMAND</td>
<td>TOTAL</td>
<td>NIGHT</td>
<td>SINGLE ENGINE VFR</td>
<td>SINGLE ENGINE IFR</td>
<td>MULTI_ENGINE VFR</td>
<td>MULTI_ENGINE IFR</td>
<td>PILOT IN COMMAND</td>
<td>CO-PILOT</td>
<td>MULTI PILOT</td>
<td>FLIGHT INSTRUCTOR</td>
<td>DUAL (transferred from student appendix)</td>
<td>INSTRUCTOR SYNTHETIC TRAINING DEVICE</td>
<td colspan="2">LANDING</td>
<td>REMARKS AND ENDORSEMENTS</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rsMain['FLIGHT_ID']; ?></td>
<td><?php echo $row_rsMain['DEPARTURE_DATE']; ?></td>
<td><?php echo $row_rsMain['PLACE_OFF']; ?></td>
<td><?php echo $row_rsMain['BLOCK_TIME_START']; ?></td>
<td><?php echo $row_rsMain['PLACE_LANDING']; ?></td>
<td><?php echo $row_rsMain['BLOCK_TIME_END']; ?></td>
<td><?php echo $row_rsMain['AIRCRAFT_TYPE']; ?></td>
<td><?php echo $row_rsMain['AIRCRAFT_CODE']; ?></td>
<td><?php echo $row_rsMain['CREWMEMBER_NAME']; ?></td>
<td><?php echo $row_rsMain['TOTAL_BLOCKTIME']; ?></td>
<td><?php echo $row_rsMain['LANDING_COUNT_NIGHT']; ?></td>
<td><?php echo $row_rsMain['SINGLE_ENGINE_VFR']; ?></td>
<td><?php echo $row_rsMain['SINGLE_ENGINE_IFR']; ?></td>
<td><?php echo $row_rsMain['MULTI_ENGINE_VFR']; ?></td>
<td><?php echo $row_rsMain['MULTI_ENGINE_IFR']; ?></td>
<td><?php echo $row_rsMain['PILOT_IN_COMMAND']; ?></td>
<td><?php echo $row_rsMain['SECOND_PILOT']; ?></td>
<td><?php echo $row_rsMain['MULTI_PILOT']; ?></td>
<td><?php echo $row_rsMain['INSTRUCTOR']; ?></td>
<td><?php echo $row_rsMain['DUAL_FLIGHT_TIME']; ?></td>
<td><?php echo $row_rsMain['SIMULATOR']; ?></td>
<td><?php echo $row_rsMain['LANDING_COUNT_DAY']; ?></td>
<td><?php echo $row_rsMain['LANDING_COUNT_NIGHT']; ?></td>
<td><?php echo $row_rsMain['REMARK']; ?></td>
</tr>
<?php } while ($row_rsMain = mysql_fetch_assoc($rsMain)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($rsMain);
?>