Untitled

Displaying database contents on a html webpage
<HTML>

<HEAD>

<TITLE> LOG INFORMATION FOR ALL customers </TITLE>

</HEAD>


<BODY>

<H1> LOG INFORMATION FOR ENTIRE DATABASE </H1>

<?php


$database="mobile_app_tracking_log";

mysql_connect(localhost);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tablename";
$result=mysql_query($query);


mysql_close();
?>

<table border="2" cellspacing="7" cellpadding="7">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Index</font></th>
<th><font face="Arial, Helvetica, sans-serif">Identification Number</font></th>
<th><font face="Arial, Helvetica, sans-serif">Date</font></th>
<th><font face="Arial, Helvetica, sans-serif">Time</font></th>
<th><font face="Arial, Helvetica, sans-serif">Application</font></th>
<th><font face="Arial, Helvetica, sans-serif">Usage</font></th>
<th><font face="Arial, Helvetica, sans-serif">Latitude</font></th>
<th><font face="Arial, Helvetica, sans-serif">Longitude</font></th>
<th><font face="Arial, Helvetica, sans-serif">Address</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {


$f1=mysql_result($result,$i,"Index");
$f2-name=mysql_result($result,$i,"Identification Number");
$f3-name=mysql_result($result,$i,"Date");
$f4-name=mysql_result($result,$i,"Time");
$f5-name=mysql_result($result,$i,"Application");
$f6-name=mysql_result($result,$i,"Usage");
$f7-name=mysql_result($result,$i,"Latitude");
$f8-name=mysql_result($result,$i,"Longitude");
$f9-name=mysql_result($result,$i,"Address");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f9; ?></font></td>
</tr>


<?php

$i++;
}

?>

echo $f2-name;
echo $f3-name;
// etc

<HTML>
<HEAD>
<TITLE> LOG INFORMATION FOR ALL customers </TITLE>
</HEAD>
<BODY>
<H1> LOG INFORMATION FOR ENTIRE DATABASE </H1>

<?php
$user = 'root';
$password = '';
$database="test";

mysql_connect(localhost,$user, $password);
@mysql_select_db($database) or die( "Unable to select database");
echo $query = "SELECT * FROM customer";
$result = mysql_query($query);

mysql_close();
?>

<table border="2" cellspacing="7" cellpadding="7">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Index</font></th>
<th><font face="Arial, Helvetica, sans-serif">Customer Name</font></th>
<th><font face="Arial, Helvetica, sans-serif">Sex</font></th>
</tr>

<?php

while ($row = mysql_fetch_assoc($result)) {

?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $row[id]; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $row[customer_name]; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $row[sex]; ?></font></td>
</tr>


<?php
}
?>