You are not logged in.
Coder Board Community »
Coding »
PHP »wcf.regNote.message
Saturday, November 19th 2005, 3:41pm
|
PHP Source code |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 |
<?
$connect = mysql_connect('localhost', '***', '***');
$db = mysql_select_db('usr_web128_1');
if($addparty == "Senden")
{
$main = mysql_query("INSERT INTO `main` (`dbname`) VALUES ('".$_POST["dbname"]."')");
$create = mysql_query("CREATE TABLE ".$_POST["dbname"]." (
id int(255) NOT NULL auto_increment,
partyid VARCHAR(100) NOT NULL,
name VARCHAR(100) NOT NULL,
date VARCHAR(100) NOT NULL,
location VARCHAR(100) NOT NULL,
path VARCHAR(100) NOT NULL,
amount VARCHAR(100) NOT NULL,
PRIMARY KEY (id)
);");
$newtab = mysql_query("INSERT INTO `bauzen20102005` (`partyid`,`name`,`date`,`location`,`amount`,`path`) VALUES ('".$_POST["partyid"]."','".$_POST["name"]."','".$_POST["date"]."','".$_POST["location"]."','".$_POST["amount"]."','".$_POST["path"]."',)");
}
else
{
?>
<form name="form1" method="post" action="">
<table width="314" height="162" border="1">
<tr>
<td width="140">Name:</td>
<td width="158">
<input type="text" name="name"> </td>
</tr>
<tr>
<td>Datenbank-Name:</td>
<td><input type="text" name="dbname"></td>
</tr>
<tr>
<td>Datum:</td>
<td><input type="text" name="date"></td>
</tr>
<tr>
<td>Ort:</td>
<td><input type="text" name="location"></td>
</tr>
<tr>
<td>Bilderanzahl:</td>
<td><input type="text" name="amount"></td>
</tr>
<tr>
<td>Pfad:</td>
<td><input type="text" name="path"></td>
</tr>
<tr>
<td>Party-ID:</td>
<td><input type="text" name="partyid"></td>
</tr>
</table>
<p>
<input type="submit" name="addparty" value="Senden">
</p>
</form>
<?
}
?>
|
Saturday, November 19th 2005, 5:26pm
|
|
Source code |
1 2 3 4 5 6 7 8 9 10 |
$create = mysql_query("CREATE TABLE ".$_POST["dbname"]." (
id int(255) NOT NULL auto_increment,
partyid VARCHAR(100) NOT NULL,
name VARCHAR(100) NOT NULL,
date VARCHAR(100) NOT NULL,
location VARCHAR(100) NOT NULL,
path VARCHAR(100) NOT NULL,
amount VARCHAR(100) NOT NULL,
PRIMARY KEY (id)
);");
|
|
|
Source code |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
$user_table = ' CREATE TABLE IF NOT EXISTS `users` ( `usrid` int(11) NOT NULL auto_increment, `code` varchar(255) , `username` varchar(11) , `pw` varchar(255) , `mail` varchar(255), `hits` int(11) , `lastIP` varchar(20), `aktiv` char(2), `newsletter` char(1), `guthaben` int(11) , PRIMARY KEY (`usrid`) );'; |
Quoted 
