nielsj.net: links-edit
links-edit
//debug $debug = 1; $linksHome ="./links/"; $linksUrl ="/links.html"; //vars $tableName = "links"; //database connection include "$linksHome/includes/config.php"; include "$linksHome/includes/database.php"; include "$linksHome/includes/colorVars.php"; $cat = $_GET[cat]; if ( $cat == '' ) { $cat = $_POST[cat]; }; $Action = $_GET[Action]; if ($Action == '' ) { $Action = $_POST[Action]; } $url = $_GET[url]; if ($url == '' ) { $url = $_POST[url]; } $omschrijving = $_GET[omschrijving]; if ($omschrijving == '' ) { $omschrijving = $_POST[omschrijving]; } $id = $_GET[id]; if ($id == '' ) { $id = $_POST[id]; } $ip = $_SERVER['REMOTE_ADDR']; if ($cat == 0 ) { echo "geen cat"; exit(); } elseif ( ! is_numeric($cat)) { echo "Nan"; exit(); } if ($id == '' ) { echo "geen id"; } elseif ( ! is_numeric($id)) { echo "Nan"; exit(); } //main if ($ip == "192.168.1.20") { #paul } elseif ($ip == "82.217.155.204") { #niels thuis } elseif ($ip == "82.197.214.27") { #niels telegraaf } elseif ($ip == "217.196.45.116") { #wouter } elseif ($ip == "82.92.41.197") { } else { echo "hallo gebruiker@ $ipje ip adress staat niet als lokaal bekend, en daarom kan je niet editen. wil je dat wel, waarschuw niels even."; exit(); } if ($Action == "delcat"){ $query="DELETE FROM links WHERE catId=$cat;"; if ($debug) echo "SQL: $query
\n"; $result = mysql_query($query) or die(mysql_error()); $query="DELETE FROM linksCat WHERE id=$cat;"; if ($debug) echo "SQL: $query
\n"; $result = mysql_query($query) or die(mysql_error()); Header ("Location: $mainpage"); exit(0) ; } if ($Action == "delete"){ $query="DELETE FROM $tableName WHERE id=$id;"; $result = mysql_query($query) or die(mysql_error()); Header ("Location: $mainpage"); exit(0); } if ($Action == "update"){ $query="UPDATE $tableName SET url='$url', omschrijving='$omschrijving' WHERE id=$id;"; $result = mysql_query($query) or die(mysql_error()); Header ("Location: $mainpage"); exit(0); } if ($Action == "add"){ $query="insert into $tableName (catId, url, omschrijving, hits) VALUES (\"$cat\",\"$url\",\"$omschrijving\",\"0\");"; $result = mysql_query($query) or die(mysql_error()); Header ("Location: $mainpage"); exit (0); } $query="SELECT * from $tableName WHERE catId = $cat;"; if ($debug) echo "SQL: $query
\n"; $result = mysql_query($query) or die(mysql_error()); #include "./layout/header.php"; #echo ""; echo "