<?php
include('wpframe.php');
wpframe_stop_direct_call(__FILE__);

$dbuser="stodeckc";
$dbpass="m7625zsw";
$dbname="stodeckc_SEOweb";  //the name of the database
$mainsection="Links"; //The name of the table
$chandle = mysql_connect("localhost", $dbuser, $dbpass)
    or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found. " . $dbuser);


if($_POST['act'] == "edit"){
mysql_query('UPDATE `Links` SET
`LinkText` = "'.$_POST['LinksText'].'", `SiteNum` = "'.$_POST['SiteNum'].'" WHERE `ID` = "'.$_POST['id'].'"');
$_POST['act'] = "edit";
}
else
if(isset($_POST['act']) and ($_POST['act'] != "edit")){
mysql_query('
    INSERT INTO `Links`
    (`LinkText`, `SiteNum`)
    VALUES
    ("'.$_POST['LinksText'].'", "'.$_POST['SiteNum'].'")
    ');
}
?>
<form method="POST" action="/wp-admin/admin.php?page=StoItemsPluginSub1">
<table width="508" height="198" border="1">
  <tr>
    <td width="150">ID</td>
    <td width="153" align="right">ID</td>
    <td width="183"></td>
  </tr>
  <tr>
    <td>Links text</td>
    <td colspan="2" align="right"><label>
      <textarea name="LinksText" id="LinksText" cols="45" rows="5"></textarea>
    </label></td>
  </tr>
  <tr>
    <td>Insert into websites:</td>
    <td align="right"><select name="SiteNum" id="SiteNuml" style="width: 143px;">
<option value="1">HZFISH.COM - PR4 - Healthy life</option>
<option value="2">CARIBBEANCANDLES.com - PR4 - The modern pet</option>
<option value="3">PSYCHOMISHAP.COM - PR4 - furniture/house hold goods</option>
<option value="4">SABETIANS.COM - PR4 - constuction/renevations</option>
<option value="5">THELOVERSAUSTIN.COM - PR4 - Cosmetics</option>
<option value="6">ZYDECOTRAVEL.COM - PR4 - Truverl Anywhere</option>
<option value="7">bora-la.com - PR4 - Movies - </option>
<option value="8">hearinglosshouston.org - PR4 - Music</option>
<option value="9">jonastube.com - PR4 - Kids Toys</option>
<option value="10">instituto-virtual-abantos.com - PR5 - Games</option>
<option value="11">LECHICFROGFESTIVAL.COM - PR5 - food / restrants</option>
<option value="12">MALAIMALI.COM - PR5 - clothing</option>
<option value="13">SAMVRIDHI.COM - PR5 - sports/ athletics</option>
<option value="14">MATEMATIKAJEKAOSTVORENAZATEBE.COM - PR5 - vehicel</option>
<option value="15">SAMIAZARU.COM - PR5 - Business and Finance</option>
<option value="16">YOLKAYA.COM  - PR5 - Smartphones</option>

                </select></td>
    <td align="right"><input type="submit" name="<?php echo $_POST['act']; ?>" id="<?php echo $_POST['act']; ?>" value="Submit"></td>
  </tr>
</table>
</form>