phpBB.de

Code: Alles auswählen

<!-- PHP -->
// Prüfen ob eine ID übergeben wurde
    if( isset($_GET['userid']) )
    { 
	$userid = $_GET["userid"];
	// Verbindung zum Datenbankserver
	mysql_connect("lalalalala", "dumdidum", "47110815") or die (mysql_error ());

	// Datenbank auswählen
	mysql_select_db("usr_web267_2") or die(mysql_error());

	mysql_query("CREATE TABLE IF NOT EXISTS user_".$userid." (
	  id INT AUTO_INCREMENT,
	  
	  Erstellt DATETIME,
	  Template CHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Header CHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  
	  Vorname CHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Nachname CHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Geschlecht CHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Geburtsdatum DATE,
	  Sterbedatum DATE,
	  
	  Geburtsort CHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Sterbeort CHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  
	  Laengengrad CHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Breitengrad CHAR(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  
	  Text1 TEXT(65000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Text2 TEXT(65000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Text3 TEXT(65000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Text4 TEXT(65000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Text5 TEXT(65000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Text6 TEXT(65000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  Text7 TEXT(65000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	  
	  PRIMARY KEY(id)
	)") Or die(mysql_error());
	mysql_close ();
	echo "Datenbank erstellt.";
	} 
	else
	{
	echo "Wichtige Daten konnten nicht empfangen werden. Somit konnte auch keine Datenbank angelegt, bzw eine vorhandene Datenbank nicht ausgewertet werden.";
	}
<!-- ENDPHP -->

Code: Alles auswählen

global $user;
$userid = $user->data['user_id'];

Code: Alles auswählen

<!-- PHP -->
global $user;
$userid = $user->data['user_id'];
echo $userid;
<!-- ENDPHP -->