Adressedata
Adressedata vises ofte både på kontaktsiden og i footeren. Oftest er de så ens, at de kan hentes fra samme DBtabel. Tabellen skal som udgangspunkt kun indeholde 1 record.
Kontakt
Vises i liste.
<?php
$query_adr = "SELECT * FROM adresse";
$result_adr = mysqli_query($db_link, $query_adr) or die (mysqli_error ($db_link));
$antal_adr = mysqli_num_rows ($result_adr);
$row_adr = mysqli_fetch_assoc ($result_adr);
echo "<ul class='kontaktadr'>";
echo "<li>". $row_adr['adr_navn']. "</li>";
echo "<li>". $row_adr['adr_adresse']. "</li>";
echo "<li>". $row_adr['adr_postnr'] . " " . $row_adr['adr_by']. "</li>";
echo "<li>tlf: ". $row_adr['adr_tlf']. "</li>";
echo "<li>mail: ". $row_adr['adr_mail']. "</li>";
echo "<ul>";
?>
|
Vises i tabel
<?php
$query = "SELECT * FROM adresse where adr_ref = 1";
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link));
$antal = mysqli_num_rows ($result);
$row = mysqli_fetch_assoc ($result);
if ($antal != 1)
{ echo "<p>Der blev ikke fundet nogen data.<p>"; }
else
{
echo '<table class="txt">';
echo "<tr><td>" . $row['adr_navn'] . "</td></tr>";
echo "<tr><td>" . $row['adr_adresse'] . "</td></tr>";
echo "<tr><td>" . $row['adr_postnr'] . " " . $row['adr_by'] ."</td></tr>";
echo "</table>";
} // slut antal
?>
|
Vises som <p>
<?php
$query = "SELECT * FROM adresse limit 1";
$result = mysqli_query($db_link, $query) or die (mysqli_error ($db_link));
$row = mysqli_fetch_assoc ($result);
echo "<p class='rb12'>" . $row['adr_navn']. "</p>";
echo "<p class='f10'>" . $row['adr_adresse']. "</p>";
echo "<p class='f10'>" . $row['adr_postnr'] ." ". $row['adr_by'] . "</p>";
echo "<br />";
echo "<p class='f10'>Tlf: " . $row['adr_tlf'] . "</p>";
echo "<p class='f10'>Fax: " . $row['adr_fax'] . "</p>";
echo "<br />";
echo "<p class='f10'>Mail: " . $row['adr_mail'] . "</p>";
?>
|
Footer
<?php
$query_adr = "SELECT * FROM adresse";
$result_adr = mysqli_query($db_link, $query_adr) or die (mysqli_error ($db_link));
$antal_adr = mysqli_num_rows ($result_adr);
$row_adr = mysqli_fetch_assoc ($result_adr);
echo "<ul class='footertext txt'>";
echo "<li>". $row_adr['adr_navn']. "</li>";
echo "<li> - </li>";
echo "<li>". $row_adr['adr_adresse']. "</li>";
echo "<li> - </li>";
echo "<li>". $row_adr['adr_postnr']. "</li>";
echo "<li> - </li>";
echo "<li>". $row_adr['adr_by']. "</li>";
echo "<li> - </li>";
echo "<li>tlf: ". $row_adr['adr_tlf']. "</li>";
echo "<li> - </li>";
echo "<li>mail: ". $row_adr['adr_mail']. "</li>";
echo "<ul>";
?>
|
#footer{
width: 740px;
height: 29px;
border-top: 1px solid #8f908a;
background: white;
}
.footertext{
text-align: center;
padding-top: 8px;
}
.footertext li{
text-decoration: none;
display: inline;
font-weight: bold;
}
|
|