After making one page of my original four pages. The update table and add new table won't work.
I tried to rewrite the code with switch.
But it didn't work. So how can I make the update and add new table work?
<?php
session_start();
if($_SESSION['brukernavn'] && $_SESSION['passord'])
{
//Logg on
require("hehe.php");
$connection = @mysql_connect($hostname, $user, $password) or die("Umulig
å få kontakt med database");
@mysql_select_db($db);
//Checking password
$henter_bruker = @mysql_query("SELECT brukerid FROM omc_brukere WHERE brukernavn='{$_SESSION['brukernavn']}'
AND passord='{$_SESSION['passord']}'");
if(@mysql_num_rows($henter_bruker) == 0)
{
print("Wrong username and/or password!");
}
else
{
//User is logged in!
print("You're in");
echo('
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Links</title>
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1" />
</head>
<body>
');
$case = $_GET['case'];
switch ($case) {
default:
echo "what cha want? <a href=linkzzz.php?case=list>List links</a>";
break;
case "list" :
echo 'add new link: <a href="linkzzz.php?case=new">New link</a>';
$links = @mysql_query('SELECT id, linktekst FROM omc_lenker');
if (!$links) {
exit('<p>Error retrieving authors from database!<br />'.
'Error: ' . mysql_error() . '</p>');
}
while ($link = mysql_fetch_array($links)) {
$id = $link['id'];
$linktekst = htmlspecialchars($link['linktekst']);
echo "<li>$linktekst
<a href='linkzzz.php?id=$id&case=edit'>Edit</a>
<a href='linkzzz.php?id=$id&case=delete'>Delete</a></li>";
}
break;
case "edit" :
$id = $_GET['id'];
echo " <p><a href='links.php'>Return to links list</a></p>";
// Allow the user to edit the links
$links = @mysql_query(
"SELECT linktekst, link, katid FROM omc_lenker WHERE id='$id'");
if (!$links) {
exit('<p>Error fetching links details: ' .
mysql_error() . '</p>');
}
$links = mysql_fetch_array($links);
$linkid = $links['katid'];
$linktekst = $links['linktekst'];
$link = $links['link'];
// Convert special characters for safe use
// as HTML attributes.
$linktekst = htmlspecialchars($linktekst);
$link = htmlspecialchars($link);
$kategoris = @mysql_query('SELECT katid, katnavn FROM omc_lkategori');
if (!$kategoris) {
exit('<p>Unable to obtain category list from the database.</p>');
}
echo "
<form action='$_SERVER[PHP_SELF]' method='post'>
<p>Edit the links:</p>
<label>linktekst: <input type='text' name='linktekst1' value='$linktekst' /></label><br />
<label>link: <input type='text' name='link' value='$link' /></label><br />
<p>Kategori:
<select name='lid' size='1'>
";
while ($lkategori = mysql_fetch_array($kategoris)) {
$lid = $lkategori['katid'];
$lname = htmlspecialchars($lkategori['katnavn']);
if ($lid == $linkid) {
echo "<option selected='selected' value='$lid'>$lname</option>\n";
} else {
echo "<option value='$lid'>$lname</option>\n";
}
}
echo "</select>
<input type='hidden' name='id' value='$id' />
<input type='submit' name='submit' value='update' /></p>
</form>
";
break;
case "delete" :
$id = $_GET['id'];
$ok1 = @mysql_query("DELETE FROM omc_lenkerkat WHERE linkid='$id'");
$ok2 = @mysql_query("DELETE FROM omc_lenker WHERE id='$id'");
if ($ok1 and $ok2) {
echo '<p>Link deleted successfully!</p>';
} else {
echo '<p>Error deleting link from database!<br />'.
'Error: ' . mysql_error() . '</p>';
}
break;
case "new" :
// Allow the user to enter a new link
$lkategoris = @mysql_query('SELECT katid, katnavn FROM omc_lkategori');
if (!$lkategoris) {
exit('<p>Unable to obtain author list from the database.</p>');
}
echo "
<form action='$_SERVER[PHP_SELF]' method='post'>
<p>Enter the new link:</p>
<label>linktekst: <input type='text' name='linktekst' /></label><br />
<label>link: <input type='text' name='link' /></label><br />
<p>Kategori:
<select name='kategoris' size='1'>
<option selected value=''>Select One</option>
<option value=''>---------</option>
";
while ($lkategori = mysql_fetch_array($lkategoris)) {
$lid = $lkategori['katid'];
$lnavn = htmlspecialchars($lkategori['katnavn']);
echo "<option value='$lid'>$lnavn</option>\n";
}
echo ("
</select></p>
<input type='submit' name='submit' value='new' />
</form>
");
break;
}
$work = $_GET['submit'];
switch ($work) {
case 'new':
$lid = $_POST['lid'];
$linktekst = $_POST['linktekst1'];
$link = $_POST['link'];
$id = $_POST['id'];
$sql = "UPDATE omc_lenker SET
katid='$lid', linktekst='$linktekst',
link='$link' WHERE id='$id'";
if (@mysql_query($sql)) {
echo '<p>links details updated.</p>';
} else {
echo '<p>Error updating links details: ' .
mysql_error() . '</p>';
}
break;
case 'update':
$lid = $_POST['kategoris'];
$linktekst = $_POST['linktekst'];
$link = $_POST['link'];
$sql = "INSERT INTO omc_lenker SET
linktekst='$linktekst',
link='$link',
katid='$lid'";
if (@mysql_query($sql)) {
echo '<p>New author added</p>';
}
else {
echo '<p>Error adding new author: ' .
mysql_error() . '</p>';
}
$jid = mysql_insert_id();
$kategoris = $_POST['kategoris'];
$sql = "INSERT IGNORE INTO omc_lenkerkat
SET linkid=$jid, catid=$kategoris";
$ok = @mysql_query($sql);
if ($ok) {
} else {
echo "<p>Error inserting articleinto category $lid: " .
mysql_error() . '</p>';
}
echo '
<p><a href="'.$_SERVER['PHP_SELF'].'">Add another link</a></p>
<p><a href="links.php">Return to authors list</a></p>
';
break;
} // End: switch ($_GET['submit'])
echo ('
</body>
</html>
');
}
mysql_close($connection);
}
else
{
print("You must be loggon on to our system!");
}
?>
