Opdatering af indhold i MySQL via PHP
Hej.Jeg får et fejlmeddelelse når jeg prøver at opdatere min link database. Det ser fint ud med at vælge det link der skal rettes, men når jeg trykker opdater får fejlmeddelesen
Parse error: syntax error, unexpected T_LOGICAL_OR in C:\webserver\local\edit_ok.php on line 33
#links.php#
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#7a9294" width="100%" colspan="3"><p align="center"><b>Links</b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td>
<?
include("links/add.php");
?>
</td>
</tr>
</table><br>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#656565" width="100%">
<p align="center"><font color="#FFFFFF"><b>Link Oversigt</b></font></td>
</tr>
<?
require("config.php");
$query = mysql_query("SELECT url, beskrivelse, id FROM linkdatabase ORDER BY id, url, beskrivelse") or die(mysql_error());
while($row = mysql_fetch_assoc($query)) {
echo"
<tr>
<td width=\"100%\"><p align=\"left\"><a href=\"http://".$row['url']."\"><b>".$row['url']. "</b></a><br>" .$row['beskrivelse']. "<br><a href=\"admin.php?id=".$row['id']."\">Ret/Slet</a></p></td>
</tr>
";
}
?>
</table>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
#admin.php#
<html><head></head><body>
<?
include('config.php');
if( isset( $_GET['id'] ) )
$id = $_GET['id'];
else
$id = null;
if( $id !== null ) {
$query = mysql_query("SELECT url, beskrivelse, id FROM linkdatabase WHERE id = '$id'") or die(mysql_error());
$query = mysql_fetch_array($query);
if( $query == null )
die("Fandt ikke linket");
?>
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#656565" width="100%" colspan="3"><p align="center"><b><font color="#ffffff">Tilføj Link</font></b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1">
<form action="edit_ok.php" method="post">
<input type="hidden" value="<? echo $query[id] ?>" name="id">
<tr>
<td>URL:</td>
<td><input type="text" VALUE="<? echo"$query[url]";?>" name="url"><font color="red">*</font></td>
</tr>
<tr>
<td>Beskrivelse:</td>
<td><input type="text" VALUE="<? echo"$query[beskrivelse]"; ?>" name="beskrivelse"><font color="red">*</font></td>
</tr>
<tr>
<td></td>
<td><br><input type="submit" name="edit_link" value="Opdater"></td>
</tr>
<?php
}
else {
echo "Fejl";
}
?>
</form>
</table>
</p>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
</body></html>
#edit_ok.php#
<p align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td bgcolor="#7a9294" width="100%" colspan="3"><p align="center"><b>BLa bla</b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<?php
require("config.php");
$add = &$HTTP_POST_VARS['edit_link'];
if(empty($edit_link)) {
?>
<br><a href="index.php?pageid=5">Link oversigt</a>
<?php
} else {
$id = &$HTTP_POST_VARS['id'];
$url = &$HTTP_POST_VARS['url'];
$beskrivelse = &$HTTP_POST_VARS['beskrivelse'];
if(empty($url) OR empty($beskrivelse)) {
echo '<font color="red"><b>Fejl!</b></font><br>Felterne markeret med en <font color="red">*</font> <u>skal</u> udfyldes!<br><br>
<a href="index.php?pageid=5"><b>Tilbage</b></a>';}
else {
mysql_connect($mysql_host, $mysql_user, $mysql_pw);
mysql_select_db($mysql_db);
mysql_query("UPDATE linkdatabase SET url = '$url', beskrivelse = '$beskrivelse' WHERE id='$id'");
or die(mysql_error());
print "Hjemmesiden <b>\"$url\"</b> er nu tilføjet til databasen.";
?>
<br>
Gå til <a href="index.php?pageid=5"><b>Link Oversigt</b></a>
<?php
}
}
?>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
- Frederik
