logo   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;
}




















x
x