<?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 (isset($_GET['act'])){
    if($_GET['act'] == "edit"){
        mysql_query('
            UPDATE `Links` SET
            `LinkText` = "'.$_POST['LinksText'].'",
            `SiteNum` = "'.$_POST['SiteNum'].'"
            WHERE `ID` = "'.$_POST['id'].'"'
            );

    }elseif($_GET['act'] != "edit"){
        mysql_query('
        INSERT INTO `Links`
        (`LinkText`, `SiteNum`)
        VALUES
        ("'.$_POST['LinksText'].'", "'.$_POST['SiteNum'].'")
        ');
    }
}
?>
<form method="POST" action="/wp-admin/admin.php?page=StoItemsPluginSub1&act=<?php echo $_GET['act']; ?>">
<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="submit" id="submit" value="submit"></td>
  </tr>
</table>
</form>