edit funktion!
Hep hey... jeg har et stort problem med min edit side... hver gang jeg editere noget så gør den det på samtlige brugere... går ud fra det er noget med IDét men dunno... :) den første der kommer med en løsning får lige 200 i kasse :] jeg vil poste alt min kode her... :D::::KODE::::
----------logind.php----------
<?php
session_start();
?>
<?
if ($_SESSION['level'] == "admin") {
include ("side1.php");
} else {
?>
<style type="text/css">
.css {font-family:verdana; font-size:8pt; background-color:#ffffff; border-bottom:dotted 1px;border-color:#000000; border-left:dotted 1px; border-color:#000000; border-right:dotted 1px; border-color:#000000; border-top:dotted 1px; border-color:#000000;}
</style>
<form action="dologin.php" method="post">
<font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="hidden" name="logind" value="logind">
Username<br>
<input type="text" name="navn">
<br>
Password: <br>
<input type="password" name="password">
<br>
<input type="submit" name="submit" class="css" value="Log ind">
</font>
</form>
<font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?php
if (isset($_GET['error']) && $_GET['error'] == "fejl") {
echo"<b>Fejl i brugernavn eller password!</b>";
}
?>
</font></html>
<?
}
?>
----------Slut logind.php----------
----------dologin.php--------------
<?php
session_start();
//hvis form er submittet
if (isset($_POST['logind'])) {
//password i databasen er krypteret, så det gøres også med indtastet password
$dopass = md5($_POST['password']);
//skift selv bruger og pass til databasen.
$db = mysql_connect("localhost", "eterno_dk", "tropådet") or die ("Desværre ingen forbindelse til databasen");
mysql_select_db("eterno_dk", $db) or die ("Kunne ikke vælge databasetabel");
$tjek = mysql_query("SELECT navn, password FROM brugere WHERE navn='$_POST[navn]' AND password='$dopass'") or die ("Kunne ikke vælge felter i database-tabellen");
if(mysql_num_rows($tjek) != 0) {
$id = mysql_query("SELECT id FROM brugere WHERE navn='$_POST[navn]' AND password='$dopass'") or die (mysql_error());
$_SESSION['id'] = mysql_result($id,0);
$_SESSION['sessionnr'] = session_id();
$_SESSION['Name'] = $_POST['navn'];
$_SESSION['level'] = "admin";
session_register("level");
header("Location:side1.php");
exit;
}else{
header("Location:logind.php?error=fejl");
exit;
}
}else{
header("Location:logind.php");
exit;
}
?>
----------Slut dologin.php--------------
----------tjeklogin.php--------------
<?php
session_start();
if (!isset($_SESSION['Name'], $_SESSION['sessionnr']) || $_SESSION['sessionnr'] != session_id()) {
header("Location:logind.php");
}
function logud_og_links() {
echo"<a href=\"side1.php\">bab</a><br>\n";
echo"<form action=\"logud.php\" method=\"post\">\n";
echo"<input type=\"submit\" value=\"Log ud\">\n";
echo"</form>\n";
}
function filnavn() {
$vistnavn = explode(".", basename($_SERVER['PHP_SELF']));
echo $vistnavn[0];
}
?>
----------Slut tjeklogin.php--------------
----------edit.php--------------
<?php
session_start();
?>
<?php require("tjeklogin.php"); ?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<style type="text/css">
body,input {
font: 10px verdana,arial,sans-serif;
}
.frmobj {
padding-top: 3px;
float: left;
width: 120px;
}
</style>
</head>
<body>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
<?php
$conn = mysql_connect("localhost", "eterno_dk", "tropådet");
mysql_select_db("eterno_dk");
$hent = mysql_query("SELECT * FROM brugere WHERE id='$_SESSION[id]' AND navn='$_SESSION[Name]'") or die ("Kunne ikke vælge felter i database-tabellen");
$row = mysql_fetch_array($hent);
?>
<div class="frmobj">Nick:</div> <input type="text" name="navn" value="<?php echo $row['navn']; ?>"><br>
<div class="frmobj">Position:</div> <input type="text" name="position" value="<?php echo $row['position']; ?>"><br>
<div class="frmobj">Joined:</div> <input type="text" name="joined" value="<?php echo $row['joined']; ?>"><br>
<div class="frmobj">Status:</div> <input type="text" name="status" value="<?php echo $row['status']; ?>"><br>
<div class="frmobj">Former:</div> <input type="text" name="former" value="<?php echo $row['former']; ?>"><br>
<div class="frmobj">Real name:</div> <input type="text" name="name" value="<?php echo $row['name']; ?>"><br>
<div class="frmobj">Location:</div> <input type="text" name="location" value="<?php echo $row['location']; ?>"><br>
<div class="frmobj">Age:</div> <input type="text" name="age" value="<?php echo $row['age']; ?>"><br>
<div class="frmobj">Mail:</div> <input type="text" name="mail" value="<?php echo $row['mail']; ?>"><br>
<div class="frmobj">Icq:</div> <input type="text" name="icq" value="<?php echo $row['icq']; ?>"><br>
<div class="frmobj">Cpu:</div> <input type="text" name="cpu" value="<?php echo $row['cpu']; ?>"><br>
<div class="frmobj">Memory:</div> <input type="text" name="memory" value="<?php echo $row['memory']; ?>"><br>
<div class="frmobj">Grafix card:</div> <input type="text" name="gfx" value="<?php echo $row['gfx']; ?>"><br>
<div class="frmobj">Mouse:</div> <input type="text" name="mouse" value="<?php echo $row['mouse']; ?>"><br>
<div class="frmobj">Mouse Pad:</div> <input type="text" name="pad" value="<?php echo $row['pad']; ?>"><br>
<div class="frmobj">Resolution in CS:</div> <input type="text" name="resolution" value="<?php echo $row['resolution']; ?>"><br>
<div class="frmobj">Connection:</div> <input type="text" name="connection" value="<?php echo $row['connection']; ?>"><br>
<div class="frmobj">Config file:</div> <input type="text" name="cfg" value="<?php echo $row['cfg']; ?>"><br>
<div class="frmobj">Quote:</div> <input type="text" name="quote" value="<?php echo $row['quote']; ?>"><br>
<div class="frmobj">Picture:</div> <input type="text" name="pic" value="<?php echo $row['pic']; ?>"><br>
<input type="hidden" name="op" value="ds">
<input type="submit" value="Opdater">
</form>
<?php
if ($_POST['op'] == 'ds') {
mysql_query("UPDATE brugere SET navn='$_POST[navn]', position='$_POST[position]', joined='$_POST[joined]', status='$_POST[status]', former='$_POST[former]', name='$_POST[name]', location='$_POST[location]', age='$_POST[age]', mail='$_POST[mail]', icq='$_POST[icq]', cpu='$_POST[cpu]', memory='$_POST[memory]', gfx='$_POST[gfx]', mouse='$_POST[mouse]', pad='$_POST[pad]', resolution='$_POST[resolution]', connection='$_POST[connection]', cfg='$_POST[cfg]', quote='$_POST[quote]', pic='$_POST[pic]'") or die ("Af en eller anden årsag blev der ikke opdateret");
echo 'Dine settings er opdateret...';
}
?>
</body>
</html>
----------Slut edit.php--------------
----------side1.php--------------
<?php require("tjeklogin.php"); ?>
<body>
<p><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Hello <?php echo $_SESSION['Name']; ?>!</font><br>
<font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size: 1.1em; color: navy;">
<br>
::Mathes::</span></font><br>
<font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">-
add match<br>
- edit match</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><br>
<br>
</font><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size: 1.1em; color: navy;">::News::<br>
</span></font><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">-
add news<br>
- edit news</font></p>
<p><font color="#333333" size="1" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size: 1.1em; color: navy;">::Personal::<br>
</span></font><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">-
add pic<br>
- <a href="edit.php?id=<?php echo $_SESSION['id']; ?>">edit profile</a><br>
<br>
</font></p>
<form name="form1" method="post" action="logud.php">
<input type="submit" name="Submit" value="logout">
</form>
<p><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font></p>
<p> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font>
</body></html>
----------Slut side1.php--------------
:::::KODE SLUT::::
