/media/sda-magnetic/david/Dok-15-2023-11-27/informatik/www-intel-compute-stick-2022-06-13/mysocial20220411/install.php

<?php
session_start ();
?>

<link rel="stylesheet" href="./styles/styles.css">
<img src="./styles/ituenix.png" width="40%">
<img src="./styles/mysocial.png" width="20%">
<div class="overall1">

<form method="POST" action="./install.php">
<input type="text" name="databasename"></input>Datenbankname<br>
<input type="text" name="secretdata"></input>Name der Datei mit geheimen Daten<br>
<input type="text" name="benutzername"></input>Benutzername der Datenbank<br>
<input type="password" name="passwort"></input>Passwort des DBMS<br>
<input type="text" name="server"></input>Name des Servers auf dem das DBMS l&auml;ft<br>
<input type="text" name="title"></input>Titel des sozialen Netzwerkes<br>
<input type="text" name="subscription"></input>Beschreibung des sozialen Netzes<br>
<input type="submit"></input>
</form>

<?php 
$databasename = htmlentities ($_POST ["databasename"]);
$secretdatafilename = htmlentities ($_POST ["secretdata"]);
$username = htmlentities ($_POST ["benutzername"]);
$password = htmlentities ($_POST ["passwort"]);
$server = htmlentities ($_POST ["server"]);
$title = htmlentities ($_POST ["title"]);
$subscription = htmlentities ($_POST ["subscription"]);
$configfilename = "./config.php";

$config_file_input_str = "<?php\n\n";
$config_file_input_str .= "\$secretdatafilename = '/home/david/mysqldata.php';\n";
$config_file_input_str .= "include (\$secretdatafilename);\n";
$config_file_input_str .= "\$databasename = '" . $databasename . "';\n";
//$config_file_input_str .= "\$secretdatafilename = '" . $secretdatafilename . "';\n";
$config_file_input_str .= "\$title = '" . $title . "';\n";
$config_file_input_str .= "\$server = '" . $server . "';\n";
$config_file_input_str .= "\$subscription = '" . $subscription . "';\n";
$config_file_input_str .= "?>\n";


$secretdatafilestr = "<?php\n\n";
$secretdatafilestr .= "\$MYSQL_NAME='" . $username . "';\n";
$secretdatafilestr .= "\$MYSQL_PASSWORD='" . $password . "';\n";
$secretdatafilestr .= "?>\n";

$config_file_input_str = $config_file_input_str;
$secretdatafilestr = $secretdatafilestr;

file_put_contents ($configfilename, $config_file_input_str);
//file_put_contents ($secretdatafilename, $secretdatafilestr);

$handle = mysql_connect ($server, $username, $password);
mysql_query ("CREATE DATABASE " . $databasename, $handle);
mysql_select_db ($databasename, $handle);
mysql_query ("CREATE TABLE users (nickname VARCHAR(64), vorname  VARCHAR(64), nachname VARCHAR(64)  , mail     VARCHAR(128), passwort  VARCHAR(128),photo MEDIUMBLOB)", $handle);
mysql_query ("CREATE TABLE freunde (freund1 VARCHAR (64), freund2 VARCHAR (64))", $handle);
mysql_query ("CREATE TABLE freundschaftsanfrage (nicknamevon VARCHAR (64), nicknamezu VARCHAR (64))", $handle);
mysql_query ("CREATE TABLE postings (nickname VARCHAR (64), content TEXT, datetime DATETIME, public TINYINT (1))", $handle);
mysql_close ($handle);
?>