Nr. på flere sider
Hej EksperterJeg er ved at lave et lille system hvor man kan indtaste et nr og når man trykker på ok hentes de pågældende informationer i en database. Dette fungerer også efter hensigten. På den side man bliver ført videre til bliver det der er hentet i databasen lavet om til links og disse links linker til en anden side. Den side de linker til er en informations side og de informationer hentes i databasen men de skal hentes ud fra det nr man taster på den første side.
Her kommer kildekoden:
indtastning vaelg_kunstvaerk.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Nordjyllands Kunstmuseum</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<SCRIPT LANGUAGE='JavaScript'>
var displayText = ""
// Write to display
function addDisplay(n){
document.calc.display.value = ""
displayText += n
document.calc.display.value = displayText
}
// Clear the display
function clearDisplay() {
displayText = ""
document.calc.display.value = ""
}
</SCRIPT>
</head>
<body>
<table width="230" height="20" border="0" align="center">
<tr>
<td> <img src="image/lyd.gif" width="20" height="20">
<?php
for ($antal = 1; $antal < 2 ; $antal++){
printf ("<img src='image/hul.gif' width='20' height='20'>");
} ?>
<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong> <a href="java script:history.back()"><Tilbage</a> <a href="dkmenu.php">[Menu]</a> </strong></font>
<?php
for ($antal = 1; $antal < 2 ; $antal++){
printf ("<img src='image/hul.gif' width='20' height='20'>");
} ?>
<img src="image/Help.gif" width="20" height="20"></td>
</tr>
</table>
<table width="230" height="220" border="0" align="center">
<tr>
<td align="center"><font size="4" face="Geneva, Arial, Helvetica, sans-serif"><strong>Indtast inventar nr.</strong></font><br><br>
<?php echo '<form name=calc method="post" action="picinfo.php">' ?>
<input name="display" type="text" size="5" maxlength="4">
<br>
<input type="submit" name="Submit" value="OK">
<input type="reset" name="clear" onClick=clearDisplay() value="Slet">
<br>
<br>
<input type="button" name="one" onClick="addDisplay(1)" value=" 1 ">
<input type="button" name="two" onClick="addDisplay(2)" value=" 2 ">
<input type="button" name="three" onClick="addDisplay(3)"value=" 3 ">
<br>
<input type="button" name="four" onClick="addDisplay(4)" value=" 4 ">
<input type="button" name="five" onClick="addDisplay(5)" value=" 5 ">
<input type="button" name="six" onClick="addDisplay(6)" value=" 6 ">
<br>
<input type="button" name="seven" onClick="addDisplay(7)" value=" 7 ">
<input type="button" name="eight" onClick="addDisplay(8)" value=" 8 ">
<input type="button" name="nine" onClick="addDisplay(9)" value=" 9 ">
<br>
<input type="button" name="zero" onClick="addDisplay(0)" value=" 0 ">
</form> </td>
</tr>
</table>
</body>
</html>
Her kommer den første side man bliver ført videre til picinfo.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Nordjyllands Kunstmuseum</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
mysql_connect("127.0.0.1", "root","") or die("Could not connect");
mysql_select_db("nkm") or die("Could not select database");
$nr = $_REQUEST[display];
$result = mysql_query("SELECT * FROM data WHERE inventar_nr=$nr");
if(mysql_fetch_array($result)){
echo '<table width="230" height="20" border="0" align="center"><td> <img src="image/lyd.gif" width="20" height="20">';
for ($antal = 1; $antal < 2 ; $antal++){
printf ("<img src='image/hul.gif' width='20' height='20'>");
}
echo '<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong> <a href="java script:history.back()"><Tilbage</a> <a href="dkmenu.php">[Menu]</a> </strong></font> ';
for ($antal = 1; $antal < 2 ; $antal++){
printf ("<img src='image/hul.gif' width='20' height='20'>");
}
echo '<img src="image/Help.gif" width="20" height="20"></td></tr></table>
<table width="230" height="220" border="0" align="center"><tr><td><font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Titel:</strong></font><br>';
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'>%s</font>\n", mysql_result($result,0,"image_titel"));
echo '<br><br><font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Kunstner:</strong></font><br>';
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'><a href='kunstner.php'>%s </a></font>", mysql_result($result,0,"kunstner_fornavn"));
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'><a href='kunstner.php'>%s </a></font>", mysql_result($result,0,"kunstner_efternavn"));
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'><a href='kunstner.php'>%s</a></font>\n", mysql_result($result,0,"leve_year"));
echo '<br><br>
<font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Kunstværk:</strong></font><br>';
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'><a href='kunstvaerk.php'>%s </a></font>", mysql_result($result,0,"image_titel"));
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'><a href='kunstvaerk.php'>%s</a></font>\n", mysql_result($result,0,"year"));
echo '<br><br>
<font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Teknik:</strong></font><br>';
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'><a href='teknik.php'>%s</a></font>\n", mysql_result($result,0,"teknik"));
echo '<br><br>
<font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Samling:</strong></font><br>';
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'><a href='samling.php'>%s</a></font>", mysql_result($result,0,"samling"));
echo ' </td>
</tr>
</table>';
}else{
echo '<table width="230" height="20" border="0" align="center"><td> <img src="image/lyd.gif" width="20" height="20">';
for ($antal = 1; $antal < 2 ; $antal++){
printf ("<img src='image/hul.gif' width='20' height='20'>");
}
echo '<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong> <a href="java script:history.back()"><Tilbage</a> <a href="dkmenu.php">[Menu]</a> </strong></font> ';
for ($antal = 1; $antal < 2 ; $antal++){
printf ("<img src='image/hul.gif' width='20' height='20'>");
}
echo '<img src="image/Help.gif" width="20" height="20"></td></tr></table>
<table width="230" height="220" border="0" align="center">
<tr>
<td align="center" valign="top"><br>
<p><font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Inventar nr:</strong> ';
echo $_REQUEST[display];
echo ' </font>
<br>
<br>
<font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Det ønskede kunstværk findes ikke.</strong></font>
<br>
<br>
<form name="form1" method="post" action="vaelg_kunstvaerk.php">
<input type="submit" name="Submit" value="Tilbage">
</form>
<p> <br>
</td>
</tr>
</table>';
}
?>
</body>
</html>
og til sidst den side hvor det ikke fungerer endnu pga. at den ikke ved hvor nr skal hentes fra. kunstner.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Nordjyllands Kunstmuseum</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
mysql_connect("127.0.0.1", "root","") or die("Could not connect");
mysql_select_db("nkm") or die("Could not select database");
$nr = $_REQUEST[display];
$result = mysql_query("SELECT * FROM data WHERE inventar_nr=$nr");
if(mysql_fetch_array($result)){
echo '<table width="230" height="20" border="0" align="center"><td> <img src="image/lyd.gif" width="20" height="20">';
for ($antal = 1; $antal < 2 ; $antal++){
printf ("<img src='image/hul.gif' width='20' height='20'>");
}
echo '<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong> <a href="java script:history.back()"><Tilbage</a> <a href="dkmenu.php">[Menu]</a> </strong></font> ';
for ($antal = 1; $antal < 2 ; $antal++){
printf ("<img src='image/hul.gif' width='20' height='20'>");
}
echo '<img src="image/Help.gif" width="20" height="20"></td></tr></table>
<table width="230" height="220" border="0" align="center"><tr><td><font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Kunstner:</strong></font><br>';
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'>%s </font>", mysql_result($result,0,"kunstner_fornavn"));
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'>%s</font>", mysql_result($result,0,"kunstner_efternavn"));
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'>%s</font>", mysql_result($result,0,"leve_year"));
echo '<br><br>';
printf("<font size='4' face='Verdana, Arial, Helvetica, sans-serif'>%s </font>\n", mysql_result($result,0,"kunstner_info"));
echo ' </td>
</tr>
</table>';
}
?>
</body>
</html>
