Søge scripts kan jeg gører sårn så man kun kun tilføje via admin

Her er admin delen:


<?
// Misko
// Misko
// Misko.
?>

<?
    $dbhost = "mysql.gullestrupnet.dk"; // ADRESSEN TIL MYSQL
    $database = "my-city"; // Database
    $dbuser = "my-city"; // Bruger
    $dbpass = "hemmelig"; // Kode

    mysql_connect($dbhost,$dbuser,$dbpass);
    mysql_select_db($database);
?>

<?
if ($_POST[action] == "update"){
    $url = ($_POST[url]);
    $navn = ($_POST[navn]);
    $bes = ($_POST[bes]);
    $katekori = ($_POST[katekori]);
    $email = ($_POST[email]);
    mysql_query("INSERT INTO links SET navn = '$navn',url = '$url',bes = '$bes',email = '$email',katekori = '$katekori'");
}
?>
<meta name="generator" content="Namo WebEditor v5.0(Trial)">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<table border="1">
    <tr>
        <td width="712">&nbsp;<a>&nbsp;&nbsp;&nbsp;&nbsp;
<?
if ($m == "saadan") {
?><br>

<font color="red" size="2" face="verdana">* Dit Link er Tilføjet - &nbsp; <font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><a href="soeg.php?value=<?=$row[navn]?>">OK lad mig se siden</a>
<?
}
?>
            </font></font></font></font></font></font></font><form action=tilfoej.php?m=saadan method=post>
<font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><font color="red" size="2" face="verdana"><input type="hidden" name="action" value="update">
  </font></font></font></font></font></font></font><table border="0" width="493" height="1" cellspacing="0" cellpadding="0">
    <tr>
      <td width="493" height="24" colspan="2">
        <p align="center"><font size="2" face="Verdana">Tilføj Til Databasen</font></td>
    </tr>
    <tr>
      <td width="303" height="13">
        <p align="center"><font size="2" face="Verdana">Linket's Navn :</font></td>
      <td width="174" height="13">



<font size="2" face="Verdana"><input type="text" name="navn" size="20" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; font-weight: bold; border: 1 solid #000000"></font></td>
    </tr>
    <tr>
      <td width="303" height="18">
        <p align="center"><font size="2" face="Verdana">Linket :</font></td>
      <td width="174" height="18"><font size="2" face="Verdana"><input type="text" name="url" size="20" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; font-weight: bold; border: 1 solid #000000"></font></td>
    </tr>
    <tr>
      <td width="303" height="4">
        <p align="center"><font size="2" face="Verdana">Din Email</font></td>
      <td width="174" height="4"><font size="2" face="Verdana"><input type="text" name="email" size="20" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; font-weight: bold; border: 1 solid #000000"></font></td>
    </tr>
    <tr>
      <td width="303" height="9">
        <p align="center"><font size="2" face="Verdana">KateKori</font></td>
      <td width="174" height="9">
<font size="2" face="Verdana"><select size="1" name="katekori" style="font-size: 13 px; font-family: Verdana; background-color: #FFFFFF; color: #000000">
  <option selected>Vælg Katekori :</option>
  <option>Programmering</option>
  <option>Erotik</option>
  <option>Chat / SMS</option>
  <option>WebSider MM.</option>
  <option>CounterStrike</option>
  <option>SøgeMaskiner</option>
  <option>Andrer Spil</option>
  <option>HH Avis</option>
 
</select>
        </font></td>
    </tr>
    <tr>
      <td width="303" height="3">
        <p align="center"></td>
      <td width="174" height="3"><font size="2" face="Verdana"><textarea rows="2" name="bes" cols="20" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; font-weight: bold; border: 1 solid #000000"></textarea></font></td>
    </tr>
    <tr>
      <td width="303" height="1">
        <p align="center"><font size="2" face="Verdana"><br>
        Udfør</font></td>
      <td width="174" height="1"><font size="2" face="Verdana"><br>
        <input type="submit" name="update" value="Indsæt Linket" style="background-color: #FFFFFF; color: #000000; font-size: 13 px; font-family: Verdana; font-weight: bold; border: 1 solid #000000"></font></td>
    </tr>
  </table>
</form>
            <p><font color="red" size="2" face="verdana">&nbsp;</font></p>
        </td>
    </tr>
</table>
<p>&nbsp;</p>

Måske ved at lave en forespørgsel på om navnet eksisterer i tabellen:

if (mysql_result(mysql_query("select count(*) from links where navn='$navn'"),0) == 0) {

Indsat her:

if ($_POST[action] == "update"){
    $url = ($_POST[url]);
    $navn = ($_POST[navn]);
    $bes = ($_POST[bes]);
    $katekori = ($_POST[katekori]);
    $email = ($_POST[email]);
    if (mysql_result(mysql_query("select count(*) from links where navn='$navn'"),0) == 0) {
        mysql_query("INSERT INTO links SET navn = '$navn',url = '$url',bes = '$bes',email = '$email',katekori = '$katekori'");
    } else {
        // navn er der i forvejen
    }
}

Vi lukker og slukker

Ok, lidt brat måske?