Opdatering/sletning af data i MySQL
Hej.Jeg har postet dette før, men føler ikke, at jeg har fået et endeligt svar.
Jeg vil gerne have mulighed for at kunne opdatere/slette data i MySQL fra min hjemmeside, f.eks. ved denne link-database. Er det noget der er muligt?
Min tabel ser således ud:
CREATE TABLE linkdatabse (
id int(11) NOT NULL auto_increment,
url varchar(255) NOT NULL
beskrivelse varchar(255) NOT NULL
PRIMARY KEY (id)
)
#add.php
<html><head></head><body>
<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="index.php?pageid=7" method="post">
<tr>
<td>URL:</td>
<td><input type="text" name="url"><font color="red">*</font></td>
</tr>
<tr>
<td>Beskrivelse:</td>
<td><input type="text" name="beskrivelse"><font color="red">*</font></td>
</tr>
<tr>
<td></td>
<td><br><input type="submit" name="add" value="Tilføj Link"></td>
</tr>
</form>
</table>
</p>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
</body></html>
# add_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>Tilføj link</b></p></td>
</tr>
<tr>
<td width="3%"></td>
<td width="94%">
<br>
<?php
require("config.php");
$add = &$HTTP_POST_VARS['add'];
if(empty($add)) {
?>
<br><a href="index.php?pageid=5">Tilføj link</a>
<?php
} else {
$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("insert into linkdatabase (url, beskrivelse) values ('$url', '$beskrivelse')")
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>
# 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 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><small>" .$row['beskrivelse']. "</small></p></td>
</tr>
";
}
?>
</table>
</td>
<td width="3%"></td>
</tr>
</table>
</p>
<br>
På forhånd tak.
- Frederik
