Mercurial > hg > extraction-interface
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>