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

        }
}elseif(isset($_POST['submit'])and ($_GET['act'] != "edit")){
print_r($_POST['SiteNum']);
foreach($_POST['SiteNum'] as  $value){
        mysql_query('
        INSERT INTO `Links`
        (`LinkText`, `SiteNum`)
        VALUES
        ("'.$_POST['LinkText'].'", "'.$value.'")
        ');
        }
    }

$sitesa = array(
1 => "HZFISH.COM PR4",
2 => "CARIBBEANCANDLES.com PR4",
3 => "PSYCHOMISHAP.COM PR4",
4 => "SABETIANS.COM PR4",
5 => "THELOVERSAUSTIN.COM PR4",
6 => "ZYDECOTRAVEL.COM PR4",
7 => "bora-la.com PR4",
8 => "hearinglosshouston.org PR4",
9 => "jonastube.com PR4",
10 => "instituto-virtual-abantos.com PR5",
11 => "LECHICFROGFESTIVAL.COM PR5",
12 => "MALAIMALI.COM PR5",
13 => "SAMVRIDHI.COM PR5",
14 => "MATEMATIKAJEKAOSTVORENAZATEBE.COM PR5",
15 => "SAMIAZARU.COM PR5",
16 => "YOLKAYA.COM PR5");

?>
<form method="POST" action="/wp-admin/admin.php?page=StoItemsPluginSub1&act=<?php echo $_GET['act'].'&id='.$_GET['id']; ?>">
<table width="700" height="198" border="1">
  <tr>
    <td width="150">ID</td>
    <td colspan="2" width="153" align="center"><?php if(isset($sitesa[$_GET['id']])){ echo $sitesa[$_GET['id']];}else echo 'Please enter new entery'; ?></td>

  </tr>
  <tr>
    <td>Links text</td>
    <td colspan="2" align="right"><label>
      <textarea name="LinkText" id="LinkText" cols="45" rows="5"></textarea>
    </label></td>
  </tr>
  <tr>
    <td>Insert into websites:</td>
    <td align="right">
<select multiple="multiple" name="SiteNum[]" id="SiteNum" style="width: 400px; height: 280px;">
<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>