Subversion-Projekte lars-tiefland.content-management

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed 

<?
        if ($PHP_AUTH_USER == "admin")
        {
                mysql_connect("127.0.0.1:3306","root","pqb33859");
        }
        else
        {
                exit;
        }
        
        $queries=array
        (
                "database"      =>      "CREATE DATABASE IF NOT EXISTS ".$_POST[database].";",
                "user"          =>      "INSERT INTO mysql.user (Host, User, Password) values ('localhost','".$_POST[username]."',password('".$_POST[password]."'));",
                "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');"
        );

        if ($_POST)
        {
                foreach($queries as $query)
                {
                        $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");
                        echo $query."<hr>";
                }
        }
?>
<html>
<head>
<title>Dantenbank + User erstellen</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form action="<?$PHP_SELF;?>" method="post">
  <table border="1" cellspacing="0" cellpadding="3" align="center" width="250">
    <tr> 
      <td width="50%">Datenbank</td>
      <td width="50%"> 
        <input type="text" name="database">
      </td>
    </tr>
    <tr> 
      <td>Usename</td>
      <td> 
        <input type="text" name="username">
      </td>
    </tr>
    <tr> 
      <td>Passwort</td>
      <td> 
        <input type="text" name="password">
      </td>
    </tr>
    <tr align="center"> 
      <td colspan="2"> 
        <input type="reset" name="Zur&uuml;cksetzen" value="Zur&uuml;cksetzen">
        <input type="submit" name="Abschicken" value="Abschicken">
      </td>
    </tr>
  </table>
</form>
</body>
</html>