Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <head>
- <title>HTML-Liste</title>
- <meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1' />
- <!--
- <meta http-equiv='Content-Type' content='text/html; charset=utf-8' />
- -->
- <link rel='stylesheet' type='text/css' href='./css/liste.css' />
- </head>
- <html>
- <body>
- <?php
- $hostname = 'localhost';
- $username = 'root';
- $password = 'RdbmS';
- $database = 'onlineshop';
- $sql = 'select * from view_1';
- print"<h1><p align = 'center'>MySQL Connect!</h1>";
- $con1 = mysql_connect ($hostname, $username, $password); // or die ("Keine Verbindung");
- echo"<p>";
- if ($con1 > 0) {
- echo"<br><h3>Verbunden!</h3>";
- echo"<h4>Verbindungs_ID:" . $con1 . "</h4>";
- $myDBid = mysql_select_db($database);
- if ($myDBid > 0) {
- echo"<br><h3>Datenbank vorhanden!</h3>";
- echo"<h4>Verbindungs_ID:" . $con1 . "</h4>";
- } else {
- echo"<h3>Datenbank nicht vorhanden!</h3>";
- }
- } else {
- echo"<h3>Nicht verbunden!</h3>";
- }
- /* Aus der Datenbank was anzeigen */
- if ($con1 != '' and $database != '') {
- $gid = mysql_query ($sql, $con1);
- $zeilen = mysql_num_rows ($gid);
- $spalten = mysql_num_fields ($gid);
- echo "<br>Es sind $zeilen Zeile(n) und $spalten Spalte(n).";
- $schubladen_schrank = mysql_fetch_array ($gid, MSSQL_BOTH);
- $feldname = mysql_field_name ($gid, 2);
- echo "<br><br> $feldname. $schubladen_schrank[$feldname]";
- /* @var $schubladen_schrank type */
- echo "<br><br> $feldname. $schubladen_schrank[2]";
- for ($i = 0; $i < $spalten; $i ++)
- {
- echo "<br> Spalte ".($i + 1).": ".$spalten[$i];
- }
- } else {
- echo "Fehler!";
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement