Hvorfor smider dette update-script et mellemrum ind foran ordene?
Hvorfor smider dette update-script et mellemrum ind foran ordene i hver post?Hver gang jeg skal rette i en post sætter scriptet et _ ind.
eks.
Oprindeligt:
eriksen, knud
rette 1. gang
_eriksen, knud
rette 2. gang
__eriksen, knud
Her er scriptet:
<?php require_once('Connections/local2.php'); ?>
<?php require("tjeklogin.php"); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE second SET land=%s, forfatternavn_efternavn=%s, forfatternavn_fornavn=%s, anden_forfatter_fornavn=%s, anden_forfatter_fornavn1=%s, anden_forfatter_fornavn2=%s, anden_forfatter_fornavn3=%s, anden_forfatter_efternavn=%s, anden_forfatter_efternavn1=%s, anden_forfatter_efternavn2=%s, anden_forfatter_efternavn3=%s, alias=%s, originalvaerkets_titel=%s, udgivelsestidspunkt_original=%s, genre=%s, oversaetterens_efternavn=%s, oversaetterens_fornavn=%s, andre_oversaettere_fornavn=%s, andre_oversaettere_fornavn1=%s, andre_oversaettere_fornavn2=%s, andre_oversaettere_fornavn3=%s, andre_oversaettere_efternavn=%s, andre_oversaettere_efternavn1=%s, andre_oversaettere_efternavn2=%s, andre_oversaettere_efternavn3=%s,
oversættelsens_titel=%s, udgivelsestidspunkt_oversaettelse=%s, udgivelsessted=%s, forlag=%s, antal_sider=%s, antal_bind=%s, bogserie_notat=%s, forkortet_udgave=%s, illustreret_udgave=%s, forord=%s, efterskrift=%s, stort_format_kunstudgave=%s, notater=%s, kilde=%s WHERE id=%s",
GetSQLValueString($HTTP_POST_VARS['land'], "text"),
GetSQLValueString($HTTP_POST_VARS['forfatternavn_efternavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['forfatternavn_fornavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['anden_forfatter_fornavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['anden_forfatter_fornavn1'], "text"),
GetSQLValueString($HTTP_POST_VARS['anden_forfatter_fornavn2'], "text"),
GetSQLValueString($HTTP_POST_VARS['anden_forfatter_fornavn3'], "text"),
GetSQLValueString($HTTP_POST_VARS['anden_forfatter_efternavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['anden_forfatter_efternavn1'], "text"),
GetSQLValueString($HTTP_POST_VARS['anden_forfatter_efternavn2'], "text"),
GetSQLValueString($HTTP_POST_VARS['anden_forfatter_efternavn3'], "text"),
GetSQLValueString($HTTP_POST_VARS['alias'], "text"),
GetSQLValueString($HTTP_POST_VARS['originalvaerkets_titel'], "text"),
GetSQLValueString($HTTP_POST_VARS['udgivelsestidspunkt_original'], "text"),
GetSQLValueString($HTTP_POST_VARS['genre'], "text"),
GetSQLValueString($HTTP_POST_VARS['oversaetterens_efternavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['oversaetterens_fornavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['andre_oversaettere_fornavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['andre_oversaettere_fornavn1'], "text"),
GetSQLValueString($HTTP_POST_VARS['andre_oversaettere_fornavn2'], "text"),
GetSQLValueString($HTTP_POST_VARS['andre_oversaettere_fornavn3'], "text"),
GetSQLValueString($HTTP_POST_VARS['andre_oversaettere_efternavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['andre_oversaettere_efternavn1'], "text"),
GetSQLValueString($HTTP_POST_VARS['andre_oversaettere_efternavn2'], "text"),
GetSQLValueString($HTTP_POST_VARS['andre_oversaettere_efternavn3'], "text"),
GetSQLValueString($HTTP_POST_VARS['oversttelsens_titel'], "text"),
GetSQLValueString($HTTP_POST_VARS['udgivelsestidspunkt_oversaettelse'], "text"),
GetSQLValueString($HTTP_POST_VARS['udgivelsessted'], "text"),
GetSQLValueString($HTTP_POST_VARS['forlag'], "text"),
GetSQLValueString($HTTP_POST_VARS['antal_sider'], "text"),
GetSQLValueString($HTTP_POST_VARS['antal_bind'], "text"),
GetSQLValueString($HTTP_POST_VARS['bogserie_notat'], "text"),
GetSQLValueString($HTTP_POST_VARS['forkortet_udgave'], "text"),
GetSQLValueString($HTTP_POST_VARS['illustreret_udgave'], "text"),
GetSQLValueString($HTTP_POST_VARS['forord'], "text"),
GetSQLValueString($HTTP_POST_VARS['efterskrift'], "text"),
GetSQLValueString($HTTP_POST_VARS['stort_format_kunstudgave'], "text"),
GetSQLValueString($HTTP_POST_VARS['notater'], "text"),
GetSQLValueString($HTTP_POST_VARS['kilde'], "text"),
GetSQLValueString($HTTP_POST_VARS['id'], "int"));
mysql_select_db($database_local2, $local2);
$Result1 = mysql_query($updateSQL, $local2) or die(mysql_error());
$updateGoTo = "sog.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
mysql_select_db($database_local2, $local2);
$query_update = "SELECT * FROM `second` WHERE id = '$_GET[id]' ORDER BY id desc";
$update = mysql_query($query_update, $local2) or die(mysql_error());
$row_update = mysql_fetch_assoc($update);
$totalRows_update = mysql_num_rows($update);
?>
<html>
<head>
<title>Update3</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="css/greenstyle1.css" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
</head>
<body>
<div id="Layer1" style="Z-INDEX: 1; LEFT: 171px; WIDTH: 273px; POSITION: absolute; TOP: 4px; HEIGHT: 23px"><em><strong><font size="2">Update
record </font></strong></em></div>
<div align="left"><em><strong><font size="2"> </font></strong></em></div>
<p align="center"> </p>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
<table align="center">
<tr valign="baseline">
<td width="231" align="right" nowrap><div align="left">Pays:</div></td>
<td width="427"><input name="land" value=" <?php echo $row_update['land']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td height="20" align="right" nowrap> </td>
<td> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left"><strong><em>Edition originale:</em></strong></div></td>
<td> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Auteur (prénom):</div></td>
<td><input name="forfatternavn_fornavn" value=" <?php echo $row_update['forfatternavn_fornavn']; ?>" size="50" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Auteur (nom):</div></td>
<td><input name="forfatternavn_efternavn" value=" <?php echo $row_update['forfatternavn_efternavn']; ?>" size="50" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Autre(s) auteur(s)(prénom):</div></td>
<td>1.<input name="anden_forfatter_fornavn" value=" <?php echo $row_update['anden_forfatter_fornavn']; ?>" size="25" maxlength="100" style="WIDTH: 100px; HEIGHT: 17px"
> 2.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['anden_forfatter_fornavn1']; ?>"
name=anden_forfatter_fornavn1> 3.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['anden_forfatter_fornavn2']; ?>"
name=anden_forfatter_fornavn2> 4.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['anden_forfatter_fornavn3']; ?>"
name=anden_forfatter_fornavn3></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Autre(s) auteur(s)(nom):</div></td>
<td>1.<input name="anden_forfatter_efternavn" value=" <?php echo $row_update['anden_forfatter_efternavn']; ?>" size="25" maxlength="100" style="WIDTH: 100px; HEIGHT: 17px"
> 2.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['anden_forfatter_efternavn1']; ?>"
name=anden_forfatter_efternavn1> 3.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['anden_forfatter_efternavn2']; ?>"
name=anden_forfatter_efternavn2> 4.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['anden_forfatter_efternavn3']; ?>"
name=anden_forfatter_efternavn3></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Pseudonyme:</div></td>
<td><input name="alias" value=" <?php echo $row_update['alias']; ?>" size="50" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Titre original:</div></td>
<td><input name="originalvaerkets_titel" value=" <?php echo $row_update['originalvaerkets_titel']; ?>" size="60" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Date de publication:</div></td>
<td><input name="udgivelsestidspunkt_original" value=" <?php echo $row_update['udgivelsestidspunkt_original']; ?>" size="10" maxlength="50"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Genre:</div></td>
<td><input name="genre" value=" <?php echo $row_update['genre']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td height="30" align="right" nowrap> </td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="23" align="right" nowrap> <div align="left"><em><strong>Edition
traduite:</strong></em></div></td>
<td> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Traducteur (prénom):</div></td>
<td><input name="oversaetterens_fornavn" value=" <?php echo $row_update['oversaetterens_fornavn']; ?>" size="50" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Traducteur (nom):</div></td>
<td><input name="oversaetterens_efternavn" value=" <?php echo $row_update['oversaetterens_efternavn']; ?>" size="50" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Autre(s) traducteur(s)(prénom):</div></td>
<td>1.<input name="andre_oversaettere_fornavn" value=" <?php echo $row_update['andre_oversaettere_fornavn']; ?>" size="25" maxlength="100" style="WIDTH: 100px; HEIGHT: 17px"
> 2.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['andre_oversaettere_fornavn1']; ?>"
name=andre_oversaettere_fornavn1> 3.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['andre_oversaettere_fornavn2']; ?>"
name=andre_oversaettere_fornavn2> 4.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['andre_oversaettere_fornavn3']; ?>"
name=andre_oversaettere_fornavn3></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Autre(s) traducteur(s)(nom):</div></td>
<td>1.<input name="andre_oversaettere_efternavn" value=" <?php echo $row_update['andre_oversaettere_efternavn']; ?>" size="25" maxlength="100" style="WIDTH: 100px; HEIGHT: 17px"
> 2.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['andre_oversaettere_efternavn1']; ?>"
name=andre_oversaettere_efternavn1> 3.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['andre_oversaettere_efternavn2']; ?>"
name=andre_oversaettere_efternavn2> 4.<INPUT
style="WIDTH: 100px; HEIGHT: 17px" maxLength=100 size=25
value=" <?php echo $row_update['andre_oversaettere_efternavn3']; ?>"
name=andre_oversaettere_efternavn3></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Titre de la traduction:</div></td>
<td><input name="oversttelsens_titel" value=" <?php echo $row_update['oversættelsens_titel']; ?>" size="60" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Date de publication:</div></td>
<td><input name="udgivelsestidspunkt_oversaettelse" value=" <?php echo $row_update['udgivelsestidspunkt_oversaettelse']; ?>" size="10" maxlength="50"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Lieu de publication:</div></td>
<td><input name="udgivelsessted" value=" <?php echo $row_update['udgivelsessted']; ?>" size="40" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Editeur:</div></td>
<td><input name="forlag" value=" <?php echo $row_update['forlag']; ?>" size="40" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Nombre de pages:</div></td>
<td><input name="antal_sider" value=" <?php echo $row_update['antal_sider']; ?>" maxlength="200"
></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Nombre de volumes :</div></td>
<td><input name="antal_bind" value=" <?php echo $row_update['antal_bind']; ?>" size="10" maxlength="50"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Série:</div></td>
<td><input name="bogserie_notat" value=" <?php echo $row_update['bogserie_notat']; ?>" size="70" maxlength="200"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Edition abrégée:</div></td>
<td><input name="forkortet_udgave" value=" <?php echo $row_update['forkortet_udgave']; ?>" size="10" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Edition illustrée:</div></td>
<td><input name="illustreret_udgave" value=" <?php echo $row_update['illustreret_udgave']; ?>" size="10" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Préface:</div></td>
<td><input name="forord" value=" <?php echo $row_update['forord']; ?>" size="10" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Postface:</div></td>
<td><input name="efterskrift" value=" <?php echo $row_update['efterskrift']; ?>" size="10" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Grand format/édition d'art:</div></td>
<td><input name="stort_format_kunstudgave" value=" <?php echo $row_update['stort_format_kunstudgave']; ?>" size="10" maxlength="100"></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap> <div align="left">Note sur l'édition:</div></td>
<td><TEXTAREA name=notater rows=5 cols=100><?php echo $row_update['notater'];?></TEXTAREA></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">Source:</div></td>
<td><input name="kilde" value=" <?php echo $row_update['kilde']; ?>" size="70" maxlength="200"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left"></div></td>
<td><input type="submit" value="Update Record"></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1">
<input type="hidden" name="id" value="<?php echo $row_update['id']; ?>">
</form>
<p> </p>
</body>
</html>
<?php
mysql_free_result($update);
?>
