Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
	if ($PHP_AUTH_USER == "admin")
3 
	{
4 
		mysql_connect("127.0.0.1:3306","root","pqb33859");
5 
	}
6 
	else
7 
	{
8 
		exit;
9 
	}
10 
 
11 
	$queries=array
12 
	(
13 
		"database"	=>	"CREATE DATABASE IF NOT EXISTS ".$_POST[database].";",
14 
		"user"		=>	"INSERT INTO mysql.user (Host, User, Password) values ('localhost','".$_POST[username]."',password('".$_POST[password]."'));",
15 
		"db"		=>	"INSERT INTO mysql.db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) values ('localhost', '".$_POST[database]."', '".$_POST[username]."', 'Y', 'Y', 'Y', 'Y');"
16 
	);
17 
 
18 
	if ($_POST)
19 
	{
20 
		foreach($queries as $query)
21 
		{
22 
			$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");
23 
			echo $query."<hr>";
24 
		}
25 
	}
26 
?>
27 
<html>
28 
<head>
29 
<title>Dantenbank + User erstellen</title>
30 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
31 
</head>
32 
 
33 
<body bgcolor="#FFFFFF" text="#000000">
34 
<form action="<?$PHP_SELF;?>" method="post">
35 
  <table border="1" cellspacing="0" cellpadding="3" align="center" width="250">
36 
    <tr>
37 
      <td width="50%">Datenbank</td>
38 
      <td width="50%">
39 
        <input type="text" name="database">
40 
      </td>
41 
    </tr>
42 
    <tr>
43 
      <td>Usename</td>
44 
      <td>
45 
        <input type="text" name="username">
46 
      </td>
47 
    </tr>
48 
    <tr>
49 
      <td>Passwort</td>
50 
      <td>
51 
        <input type="text" name="password">
52 
      </td>
53 
    </tr>
54 
    <tr align="center">
55 
      <td colspan="2">
56 
        <input type="reset" name="Zur&uuml;cksetzen" value="Zur&uuml;cksetzen">
57 
        <input type="submit" name="Abschicken" value="Abschicken">
58 
      </td>
59 
    </tr>
60 
  </table>
61 
</form>
62 
</body>
63 
</html>