Redigering af database
Alle bruger skal kunne endre deres oplysninger. men jeg ved ikke hvordan man redigere i databasen så her er al den kode som man skal bruge fra databasen..//////////////////Redigerings formen
<form action="insert.php" method="post">
<input type="hidden" value="insert users" name="do">
<table width="253" border="0" align="center">
<tr bgcolor="#B4B4B4">
<td colspan="2"><div align="center"><font color="#000000">Make new user </font></div></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Username:</div></td>
<td align="center"><input type="text" name="user_name"></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Userpass:</div></td>
<td align="center"><input name="user_pass" type="password"></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Name:</div></td>
<td align="center"><input type="text" name="name"></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Surname:</div></td>
<td align="center"><input type="text" name="surname"></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">E-Mail:</div></td>
<td align="center"><input type="text" name="email"></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Game:</div></td>
<td align="center"><select name="game">
<option value="">Select game</option>
<option value="1">CS</option>
<option value="2">CSS</option>
<option value="3">DOD</option>
<option value="4">Empty</option>
</select>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Class:</div></td>
<td align="center"><select name="class">
<option value="">Select Class</option>
<option value="1">Campaign Leader</option>
<option value="2">General</option>
<option value="3">Spesial Forces</option>
<option value="4">Team Leader</option>
<option value="5">Soldier</option>
<option value="6">Scout</option>
<option value="7">Empty</option>
</select>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Contry:</div></td>
<td align="center"><input type="text" name="contry"></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Time Zone:</div></td>
<td align="center"><select name="time">
<option value="">Select Time Zone</option>
<option value="1">GMT+1</option>
<option value="2">GMT+2</option>
<option value="3">GMT+3</option>
<option value="4">GMT+4</option>
<option value="5">GMT+5</option>
<option value="6">GMT+6</option>
<option value="7">GMT+7</option>
<option value="8">GMT+8</option>
<option value="9">GMT+9</option>
<option value="10">GMT+10</option>
<option value="11">GMT+11</option>
<option value="12">GMT+12</option>
<option value="13">GMT+13</option>
<option value="14">GMT-1</option>
<option value="15">GMT-2</option>
<option value="16">GMT-3</option>
<option value="17">GMT-4</option>
<option value="18">GMT-5</option>
<option value="19">GMT-6</option>
<option value="20">GMT-7</option>
<option value="21">GMT-8</option>
<option value="22">GMT-9</option>
<option value="23">GMT-10</option>
<option value="24">GMT-11</option>
<option value="25">GMT-12</option>
</select>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Team:</div></td>
<td align="center"><select name="team">
<option value="">Select Team</option>
<option value="1">Team 1</option>
<option value="2">Team 2</option>
<option value="3">Team 3</option>
<option value="4">Team 4</option>
<option value="5">Empty</option>
</select>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Reg Date:</div></td>
<td align="center"><input type="text" name="reg"></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Sex:</div></td>
<td align="center"><select name="sex">
<option value="" selected>Select Sex</option>
<option value="1">Male</option>
<option value="2">Female</option>
</select>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Part:</div></td>
<td align="center"><input type="text" name="part" value="1" readonly="readonly"></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">Clan:</div></td>
<td align="center"><input type="text" name="clan" value=""></td>
</tr>
<tr bgcolor="#B4B4B4">
<td width="75"><div align="left">User Type:</div></td>
<td align="center"><select name="state">
<option value="" selected>Select User Type</option>
<option value="1">admin</option>
<option value="2">cs</option>
<option value="3">css</option>
<option value="4">dod</option>
</select>
</tr>
<tr bgcolor="#B4B4B4">
<td colspan="2" align="center"><input type="submit" value="Submit" Java::GoToURL("http://www.gamersloot.dk")>
</td>
</tr>
</table>
<input type="hidden" value="<?=$_SESSION['yes']?>">
</form>
////////////////////////// insert.php
<?
session_start();
include("func.php");
Db::Conn(open);
$do = $_POST['do'];
if($do == "insert users"){
$state = $_POST['state'];
$user_name = $_POST['user_name'];
$user_pass = md5($_POST['user_pass']);
$name = ($_POST['name']);
$surname = $_POST['surname'];
$email = $_POST['email'];
$game = $_POST['game'];
$class = $_POST['class'];
$contry = $_POST['contry'];
$time = $_POST['time'];
$reg = time();
$sex = $_POST['sex'];
$part = $_POST['part'];
$team = $_POST['team'];
$clan = $_POST['clan'];
mysql_query("INSERT INTO users ( state , user_name , user_pass , name , surname , email , game , class , contry, time , reg , sex , part , team , clan ) VALUES ('$state' , '$user_name' , '$user_pass' , '$name' , '$surname' , '$email' , '$game' , '$class' , '$contry' , '$time' , '$reg' , '$sex' , '$part' , '$team' , '$clan' )") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::GoToURL("index.php?p=home");
}elseif($do == "insert news"){
$tittle = $_POST['tittle'];
$text = $_POST['text'];
$game = $_POST['game'];
$part = $_POST['part'];
mysql_query("INSERT INTO news ( tittle , text , game , part ) VALUES ( '$tittle' , '$text' , '$game' , '$part' )") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::GoToURL("index.php?p=home");
}elseif($do == "insert error"){
$page = $_POST['page'];
$part = $_POST['part'];
$text = $_POST['text'];
mysql_query("INSERT INTO error ( page , part , text ) VALUES ( '$page' , '$part' , '$text' )") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::GoToURL("index.php?p=home");
}elseif($do == "insert fight"){
$clan = $_POST['clan'];
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$link = $_POST['link'];
$game = $_POST['game'];
$time = $_POST['time'];
$server = $_POST['server'];
$pass = $_POST['pass'];
$part = $_POST['part'];
$map = $_POST['map'];
mysql_query("INSERT INTO fight ( clan , name , email , phone , link , game , time , server , pass , part , map ) VALUES ( '$clan' , '$name' , '$email' , '$phone' , '$link' , '$game' , '$time' , '$server' , '$pass' , '$part' , '$map' )") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::GoToURL("index.php?p=home");
}elseif($do == "insert links"){
$link = $_POST['link'];
$link_name = $_POST['link_name'];
$text = $_POST['text'];
$part = $_POST['part'];
mysql_query("INSERT INTO links ( link , link_name , text , part ) VALUES ( '$link' , '$link_name' , '$text' , '$part' )") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::GoToURL("index.php?p=home");
}elseif($do == ""){
}
Db::Conn(close);
?>
