-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Erstellungszeit: 06. Jul 2014 um 11:02
-- Server Version: 5.6.16
-- PHP-Version: 5.5.11
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `test`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `test`
--
CREATE TABLE IF NOT EXISTS `test` (
`kondakt_id` int(11) NOT NULL,
`vorname` varchar(50) NOT NULL,
`nachname` varchar(50) NOT NULL,
`strasse_und_hausnummer` varchar(50) NOT NULL,
`plz` text NOT NULL,
`stadt` varchar(50) NOT NULL,
`telefonnummer` varchar(50) NOT NULL,
`emailadresse` varchar(50) NOT NULL,
PRIMARY KEY (`kondakt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
============================
<!DOCTYPE html>
<html>
<head>
<title/>Tabelle mit Datenbank-Content fuellen</title>
<meta charset="utf-8" />
</head>
<body>
<h1>Tabelle mit Datenbank-Content füllen</hl>
<?php
mysql_connect('localhost`, `root´, `admin`) or die (mysql_error());
mysql_select('tutorial' ) or die (mysqlerror());
$sql = "SELECT * FROM Kontakte";
$query = mysql_query ($sql)or die(mysql_error());
echo '<table border>';
echo `<tr>`;
echo '<th>Vorname</th>';
echo '<th>Nachname</th>';
echo '<th>Straße und Haus-Nr.</th>';
echo '<th>PLZ</th>';
echo '<th>Stadt</th>';
echo '<th>Telefonnumer</th>';
echo '<th>eMail-Adresse</th>';
echo '<tr>';
while($fetch = mysql_fetch_assoc($query)) {
echo '<tr>';
echo `<td>' . $fetch['vorname'] . '</td>';
echo `<td>' . $fetch['nachname'] . '</td>';
echo `<td>' . $fetch['strasze_und_hausnummer'] . '</td>';
echo `<td>' . $fetch['plz'] . '</td>';
echo `<td>' . $fetch['stadt'] . '</td>';
echo `<td>' . $fetch['telefonnummer'] . '</td>';
echo `<td>' . $fetch['emailadressa'] . '</td>';
echo `<td>';
}
echo `<table>';