Jeg kan ikke få det til at virke så brugeren kan rette sin info..
============ Functions.inc.php ============<?php
function hent_elever() {
$tissetrold = @mysql_query("SELECT * FROM elever ORDER BY id desc")or die (mysql_error());
while($pik = mysql_fetch_array($tissetrold)) {
print("<table width='340'><tr><td bgcolor='#C4C4C4'><font size=1 face=verdana><a href='index.php?mode=elev&id=".$pik[id]."'><b>".$pik[navn]."</b></a> (".$pik[vis].")</font></td></tr></table>");
}
}
function hent_een_elev($hej) {
$tissetrold = @mysql_query("SELECT * FROM elever WHERE id = '$hej'")or die (mysql_error());
$pik = mysql_fetch_array($tissetrold);
$urin = mysql_num_rows($tissetrold);
if($urin == "") {
print("<h1>JAJA SMARTE!!! FUCK NU AF MED DIG!!!!!!</h1>");
}else{
print("<font size=1 face=verdana>");
print("<table width='350'><tr><td bgcolor='#C4C4C4'><font size=1 face=verdana>Navn:</font></td></tr></table><b> ".$pik[navn]."</b><br>");
print("<table width='350'><tr><td bgcolor='#C4C4C4'><font size=1 face=verdana>Email:</font></td></tr></table><b><a href='mailto:".$pik[email]."'>".$pik[email]."</a></b><br>");
print("<table width='350'><tr><td bgcolor='#C4C4C4'><font size=1 face=verdana>By:</font></td></tr></table><b> ".$pik[bynavn]."</b><br>");
print("<table width='350'><tr><td bgcolor='#C4C4C4'><font size=1 face=verdana>Adresse:</font></td></tr></table><b> ".$pik[adresse]."</b><br>");
print("<table width='350'><tr><td bgcolor='#C4C4C4'><font size=1 face=verdana>Tlf:</font></td></tr></table><b> ".$pik[tlf]."</b><br>");
$ny_pik = $pik[vis]+1;
@mysql_query("UPDATE elever SET vis = '$ny_pik' WHERE id = '$hej'")or die (mysql_error());
}
}
function skriv_en_smule($a,$b,$c,$d,$e) {
@mysql_query("INSERT INTO elever (navn,adresse,bynavn,tlf,email,vis) VALUES('$a', '$b', '$c', '$d', '$e', '0')")or die (mysql_error());
}
function list_elever() {
$tissetrold = @mysql_query("SELECT * FROM elever ORDER BY id desc")or die (mysql_error());
while($pik = mysql_fetch_array($tissetrold)) {
print("<font size=1 face=verdana><a href='index.php?mode=ret&id=".$pik[id]."'><b>".$pik[navn]."</b></a> (".$pik[vis].")</font><br>");
}
}
function se_dem($x) {
$tissetrold = @mysql_query("SELECT * FROM elever WHERE id = '$x'")or die (mysql_error());
$pik = mysql_fetch_array($tissetrold);
print("<form action='?mode=rettet' method='post'>");
print("<font size=1 face=verdana>");
print("<font size=1 face=verdana>Dit navn: </font><br><input type='text' name='navn' value='".$pik[navn]."'><br>");
print("<font size=1 face=verdana>Dit email: </font><br><input type='text' name='email' value='".$pik[email]."'><br>");
print("<font size=1 face=verdana>Din adresse: </font><br><input type='text' name='adresse' value='".$pik[adresse]."'><br>");
print("<font size=1 face=verdana>Bynavn: </font><br><input type='text' name='bynavn' value='".$pik[bynavn]."'><br>");
print("<font size=1 face=verdana>Tlf: </font><br><input type='text' name='tlf' value='".$pik[tlf]."'><br>");
print("<input type='hidden' name='id' value='".$x."'>");
print("<input type='submit' value='send'></form>");
}
function ret($a,$b,$c,$d,$e) {
mysql_query("UPDATE elever SET navn='$a', adresse='$b', bynavn='$c', tlf='$d', email='$e' WHERE id = '$f'")or die (mysql_error());
}
?>
===================================
============ Index.php ============
<?php
include('functions.inc.php');
include('conn.inc.php');
print("<font size=1 face=verdana><center><b>Elever -> </b></center></font><br>");
print("<table width='340'><tr><td bgcolor='#D4D4D4'><font size=2 face=verdana><center><b><a href='index.php'>Forside</a></b></center></font></td></tr></table><br><br>");
if(!$mode) {
hent_elever();
}
if($mode == "elev") {
hent_een_elev($id);
}
if($mode == "new") {
print("<form action='?mode=sperm' method='post'>");
print("<font size=1 face=verdana>");
print("Dit navn:<br><input type='text' name='navn'><br>");
print("Din email:<br><input type='text' name='email'><br>");
print("Din adresse:<br><input type='text' name='adresse'><br>");
print("Bynavn:<br><input type='text' name='bynavn'><br>");
print("Tlf:<br><input type='text' name='tlf'><br>");
print("<input type='submit' value='Send'></form>");
}
if($mode == "sperm") {
if($navn && $adresse && $bynavn && $tlf && $email) {
print("Dine oplysninger er indsat");
skriv_en_smule($navn,$adresse,$bynavn,$tlf,$email);
}else{
print("<h1>Du har ikke udfyldt det hele... Prøv igen</h1>");
}
}
if($mode == "liste") {
list_elever();
}
if($mode == "ret") {
se_dem($id);
}
if($mode == "rettet") {
print("DONE");
ret($navn,$adresse,$bynavn,$tlf,$email,$id);
}
?>
===================================
