diff _xampp/contrib/mysql.php @ 0:b12c99b7c3f0

commit for previous development
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Mon, 19 Jan 2015 17:13:49 +0100
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/_xampp/contrib/mysql.php	Mon Jan 19 17:13:49 2015 +0100
@@ -0,0 +1,31 @@
+<html>
+<head>
+<title>PHP und MySQL</title>
+</head>
+<body>
+<h1>PHP und MySQL</h1>
+<table border="1">
+<tr>
+    <th>Vorname</th>
+    <th>Nachname</th>
+    <th>Telefonnummer</th>
+</tr>
+<?php
+    mysql_connect("localhost", "oswald", "geheim");
+    mysql_select_db("phonebook");
+
+    $query = "SELECT * FROM users";
+    $result = mysql_query($query);
+    while ($row = mysql_fetch_array  ($result))
+    {
+        echo "<tr>";
+        echo "<td>".$row['firstname']."</td>";
+        echo "<td>".$row['lastname']."</td>";
+        echo "<td>".$row['phone']."</td>";
+        echo "</tr>";
+    }
+
+?>
+</table>
+</body>
+</html>