Lave script om til en redigeringsform
Kan det lade sig gøre at lave understående script om til en form, hvori jeg kan redigere valgte poster fra en databasen? Det vil sige når scriptet kører er felterne allerede udfyldte og klar til redigeing.<?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_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO second (forfatternavn_fornavn, forfatternavn_efternavn, originalvaerkets_titel, udgivelsestidspunkt_original, genre, oversaetterens_fornavn, oversaetterens_efternavn, udgivelsessted, forlag, udgivelsestidspunkt_oversaettelse, antal_sider, antal_bind, bogserie_notat, oversættelsens_titel, notater, forkortet_udgave, illustreret_udgave, forord, efterskrift, stort_format_kunstudgave, land) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['forfatternavn_fornavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['forfatternavn_efternavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['originalvaerkets_titel'], "text"),
GetSQLValueString($HTTP_POST_VARS['udgivelsestidspunkt_original'], "date"),
GetSQLValueString($HTTP_POST_VARS['genre'], "text"),
GetSQLValueString($HTTP_POST_VARS['oversaetterens_fornavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['oversaetterens_efternavn'], "text"),
GetSQLValueString($HTTP_POST_VARS['udgivelsessted'], "text"),
GetSQLValueString($HTTP_POST_VARS['forlag'], "text"),
GetSQLValueString($HTTP_POST_VARS['udgivelsestidspunkt_oversaettelse'], "date"),
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['oversttelsens_titel'], "text"),
GetSQLValueString($HTTP_POST_VARS['notater'], "text"),
GetSQLValueString(isset($HTTP_POST_VARS['forkortet_udgave']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($HTTP_POST_VARS['illustreret_udgave']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($HTTP_POST_VARS['forord']) ? "true" : "", "defined","'Y'","'N'"),
GetSQLValueString(isset($HTTP_POST_VARS['efterskrift']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($HTTP_POST_VARS['stort_t_kunstudgave']) ? "true" : "", "defined","'Y'","'N'"),
GetSQLValueString($HTTP_POST_VARS['land'], "text"));
mysql_select_db($database_local2, $local2);
$Result1 = mysql_query($insertSQL, $local2) or die(mysql_error());
$insertGoTo = "/show_all.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>
<html>
<head>
<title>indtast post</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="position:absolute; left:149px; top:4px; width:273px; height:23px; z-index:1"><em><strong><font size="2">Créer
une nouvelle source</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; ?>">
<div align="center">
<table width="926" align="left">
<tr valign="baseline">
<td height="47" align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Pays:</div></td>
<td> <select name="land" id="land">
<option>le Danemark</option>
<option>la Norvége</option>
<option>la Suède</option>
<option>Finlande</option>
<option>l´ Islande</option>
</select></td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="24" align="right" nowrap> </td>
<td align="right" nowrap><div align="left"><strong><em>Edition originale:</em></strong></div></td>
<td> </td>
<td> </td>
</tr>
<tr valign="baseline">
<td width="131" height="21" align="right" nowrap> </td>
<td width="247" align="right" nowrap><div align="left">Auteur (prénom):</div></td>
<td width="494"><input name="forfatternavn_efternavn" type="text" value="" size="50" maxlength="100"></td>
<td width="34"> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap><div align="left"></div></td>
<td align="right" nowrap><div align="left">Auteur (nom):</div></td>
<td><input name="forfatternavn_fornavn" type="text" value="" size="50" maxlength="100"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Titre original:</div></td>
<td><input name="originalvaerkets_titel" type="text" value="" size="60" maxlength="100"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Date de publication:</div></td>
<td><input name="udgivelsestidspunkt_original" type="text" value="" size="10" maxlength="20"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="69" align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Genre:</div></td>
<td> <select name="genre">
<option>Roman </option>
<option>Nouvelle </option>
<option>Théâtre</option>
<option>Poésie</option>
</select></td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="25" align="right" nowrap> </td>
<td align="right" nowrap><div align="left"><em><strong>Edition traduite:</strong></em></div></td>
<td> </td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Traducteur (prénom):</div></td>
<td><input type="text" name="oversaetterens_efternavn" value="" size="50"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Traducteur (nom):</div></td>
<td><input name="oversaetterens_fornavn" type="text" value="" size="50" maxlength="100"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Titre de la traduction:</div></td>
<td><input name="oversttelsens_titel" type="text" value="" size="60" maxlength="100"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Date de publication:</div></td>
<td><input name="udgivelsestidspunkt_oversaettelse" type="text" value="s.d." size="10" maxlength="20"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Lieu de publication:</div></td>
<td><input name="udgivelsessted" type="text" value="" size="40" maxlength="100"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Editeur:</div></td>
<td><input name="forlag" type="text" value="" size="40" maxlength="100"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="23" align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Nombre de pages:</div></td>
<td><input name="antal_sider" type="text" value="" size="10" maxlength="10"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="21" align="right" valign="top" nowrap> </td>
<td align="right" valign="baseline" nowrap><div align="left">Nombre de
volumes :</div></td>
<td><input name="antal_bind" type="text" id="antal_bind" size="10" maxlength="40"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="21" align="right" valign="top" nowrap> </td>
<td align="right" valign="baseline" nowrap> <div align="left">Série:</div></td>
<td><input name="bogserie_notat" type="text" value="" size="60" maxlength="100"></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Edition abrégée:</div></td>
<td><input type="checkbox" name="forkortet_udgave" value="" ></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Edition illustrée:</div></td>
<td><input type="checkbox" name="illustreret_udgave" value="" ></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Préface:</div></td>
<td><input type="checkbox" name="forord" value="" ></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Postface:</div></td>
<td><input type="checkbox" name="efterskrift" value="" ></td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="20" align="right" nowrap> </td>
<td align="right" nowrap><div align="left">Grand format/édition
d'art:</div></td>
<td><input type="checkbox" name="stort_format_kunstudgave" value="" ></td>
<td> </td>
</tr>
<tr valign="baseline">
<td height="63" align="right" valign="top" nowrap> </td>
<td align="right" valign="top" nowrap> <div align="left">Note sur l'édition:</div></td>
<td><textarea name="notater" cols="100" rows="3"></textarea></td>
<td> </td>
</tr>
<tr valign="baseline">
<td align="right" nowrap><div align="left"></div></td>
<td align="right" nowrap> </td>
<td colspan="2"><input type="submit" value="Conserver les données"></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</div>
</form>
<p align="center"> </p>
</body>
</html>
Jeg håber at der nogen som kan hjælpe....
