Въпрос за база данни

D

DirectX

Registered
имам си полета за избиране на дата, месец, час и т.н. Тъй като са падащи менюта
Код: 
 <select name="day_start" style="width: 100px">
            <option value="">---</option>
            <option value="01">01</option>
            <option value="02">02</option>
трябва ли day_start да се добави към php скрипта, за вписване в базата данни?

т.е. да стане така $sql = "INSERT INTO `blanka` (`id`, `day_start`) и т.н. ?

И другото което е после как ще изкарам резултата:
Код: 
$day_start = $row['day_start'];
[code] 

така ли ще стане ? :)
 
Код: 
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>Untitled Document</title>

<?php
include ("config.php");
?>

<form method="post" action="">
  <table align="center" cellpadding="1" cellspacing="1">
  <tr>
    <td align="left"><table align="center" cellpadding="1" cellspacing="1">
      <tr>
        <td align="left"><p class="margin">Име на задачата</p></td>
        <td align="left"><input name="name" type="text" id="name" maxlength="35" size="25" /></td>
      </tr>
      <tr>
        <td align="left"><p class="margin">Започва в: </p></td>
        <td align="left"><div align="left">
          Дата
          <select name="day_start" style="width: 100px">
            <option value="">---</option>
            <option value="01">01</option>
            <option value="02">02</option>
            <option value="03">03</option>
            <option value="04">04</option>
            <option value="05">05</option>
            <option value="06">06</option>
            <option value="07">07</option>
            <option value="08">08</option>
            <option value="09">09</option>
            <option value="10">10</option>
            <option value="11">11</option>
            <option value="12">12</option>
            <option value="13">13</option>
            <option value="14">14</option>
            <option value="15">15</option>
            <option value="16">16</option>
            <option value="17">17</option>
            <option value="18">18</option>
            <option value="19">19</option>
            <option value="20">20</option>
            <option value="21">21</option>
            <option value="22">22</option>
            <option value="23">23</option>
            <option value="24">24</option>
            <option value="25">25</option>
            <option value="26">26</option>
            <option value="27">27</option>
            <option value="28">28</option>
            <option value="29">29</option>
            <option value="30">30</option>
            <option value="31">31</option>
          </select>
          Месец
          <select name="month_start" style="width: 100px">
            <option value="">---</option>
            <option value='1'>Януари</option>
            <option value='2'>Февруари</option>
            <option value='3'>Март</option>
            <option value='4'>Март</option>
            <option value='5'>Април</option>
            <option value='6'>Май</option>
            <option value='7'>Юни</option>
            <option value='8'>Юли</option>
            <option value='9'>Август</option>
            <option value='10'>Септември</option>
            <option value='11'>Октомрви</option>
            <option value='12'>Ноември</option>
            <option value='13'>Декември</option>
            
          </select>
          Час
          <select name="hour_start" style="width: 100px">
            <option value="">---</option>
            <option value="01">01</option>
            <option value="02">02</option>
            <option value="03">03</option>
            <option value="04">04</option>
            <option value="05">05</option>
            <option value="06">06</option>
            <option value="07">07</option>
            <option value="08">08</option>
            <option value="09">09</option>
            <option value="10">10</option>
            <option value="11">11</option>
            <option value="12">12</option>
            <option value="13">13</option>
            <option value="14">14</option>
            <option value="15">15</option>
            <option value="16">16</option>
            <option value="17">17</option>
            <option value="18">18</option>
            <option value="19">19</option>
            <option value="20">20</option>
            <option value="21">21</option>
            <option value="22">22</option>
            <option value="23">23</option>
            <option value="24">24</option>
              </select>
          Минути
          <select name="minute_start" style="width: 100px">
            <option value="">---</option>
            <option value="00">00</option>
            <option value="01">01</option>
            <option value="02">02</option>
            <option value="03">03</option>
            <option value="04">04</option>
            <option value="05">05</option>
            <option value="06">06</option>
            <option value="07">07</option>
            <option value="08">08</option>
            <option value="09">09</option>
            <option value="10">10</option>
            <option value="11">11</option>
            <option value="12">12</option>
            <option value="13">13</option>
            <option value="14">14</option>
            <option value="15">15</option>
            <option value="16">16</option>
            <option value="17">17</option>
            <option value="18">18</option>
            <option value="19">19</option>
            <option value="20">20</option>
            <option value="21">21</option>
            <option value="22">22</option>
            <option value="23">23</option>
            <option value="24">24</option>
            <option value="25">25</option>
            <option value="26">26</option>
            <option value="27">27</option>
            <option value="28">28</option>
            <option value="29">29</option>
            <option value="30">30</option>
            <option value="31">31</option>
            <option value="32">32</option>
            <option value="33">33</option>
            <option value="34">34</option>
            <option value="35">35</option>
            <option value="36">36</option>
            <option value="37">37</option>
            <option value="38">38</option>
            <option value="39">39</option>
            <option value="40">40</option>
            <option value="42">42</option>
            <option value="43">43</option>
            <option value="44">44</option>
            <option value="45">45</option>
            <option value="46">46</option>
            <option value="47">47</option>
            <option value="48">48</option>
            <option value="49">49</option>
            <option value="50">50</option>
            <option value="51">51</option>
            <option value="52">52</option>
            <option value="53">53</option>
            <option value="54">54</option>
            <option value="55">55</option>
            <option value="56">56</option>
            <option value="57">57</option>
            <option value="58">58</option>
            <option value="59">59</option>
          </select>
          <br> 
          </select>
        </div></td>
      </tr>
      <tr>
        <td align="left"><p class="margin">Свърша в:</p></td>
        <td align="left">Дата
          <select name="day_end" style="width: 100px">
            <option value="">---</option>
            <option value="01">01</option>
            <option value="02">02</option>
            <option value="03">03</option>
            <option value="04">04</option>
            <option value="05">05</option>
            <option value="06">06</option>
            <option value="07">07</option>
            <option value="08">08</option>
            <option value="09">09</option>
            <option value="10">10</option>
            <option value="11">11</option>
            <option value="12">12</option>
            <option value="13">13</option>
            <option value="14">14</option>
            <option value="15">15</option>
            <option value="16">16</option>
            <option value="17">17</option>
            <option value="18">18</option>
            <option value="19">19</option>
            <option value="20">20</option>
            <option value="21">21</option>
            <option value="22">22</option>
            <option value="23">23</option>
            <option value="24">24</option>
            <option value="25">25</option>
            <option value="26">26</option>
            <option value="27">27</option>
            <option value="28">28</option>
            <option value="29">29</option>
            <option value="30">30</option>
            <option value="31">31</option>
          </select>
Месец
<select name="month_end" style="width: 100px">
  <option value="">---</option>
  <option value='1'>Януари</option>
  <option value='2'>Февруари</option>
  <option value='3'>Март</option>
  <option value='4'>Март</option>
  <option value='5'>Април</option>
  <option value='6'>Май</option>
  <option value='7'>Юни</option>
  <option value='8'>Юли</option>
  <option value='9'>Август</option>
  <option value='10'>Септември</option>
  <option value='11'>Октомрви</option>
  <option value='12'>Ноември</option>
  <option value='13'>Декември</option>
</select>
Час
<select name="hour_end" style="width: 100px">
  <option value="">---</option>
  <option value="01">01</option>
  <option value="02">02</option>
  <option value="03">03</option>
  <option value="04">04</option>
  <option value="05">05</option>
  <option value="06">06</option>
  <option value="07">07</option>
  <option value="08">08</option>
  <option value="09">09</option>
  <option value="10">10</option>
  <option value="11">11</option>
  <option value="12">12</option>
  <option value="13">13</option>
  <option value="14">14</option>
  <option value="15">15</option>
  <option value="16">16</option>
  <option value="17">17</option>
  <option value="18">18</option>
  <option value="19">19</option>
  <option value="20">20</option>
  <option value="21">21</option>
  <option value="22">22</option>
  <option value="23">23</option>
  <option value="24">24</option>
</select>
Минути
<select name="minute_end" style="width: 100px">
  <option value="">---</option>
  <option value="00">00</option>
  <option value="01">01</option>
  <option value="02">02</option>
  <option value="03">03</option>
  <option value="04">04</option>
  <option value="05">05</option>
  <option value="06">06</option>
  <option value="07">07</option>
  <option value="08">08</option>
  <option value="09">09</option>
  <option value="10">10</option>
  <option value="11">11</option>
  <option value="12">12</option>
  <option value="13">13</option>
  <option value="14">14</option>
  <option value="15">15</option>
  <option value="16">16</option>
  <option value="17">17</option>
  <option value="18">18</option>
  <option value="19">19</option>
  <option value="20">20</option>
  <option value="21">21</option>
  <option value="22">22</option>
  <option value="23">23</option>
  <option value="24">24</option>
  <option value="25">25</option>
  <option value="26">26</option>
  <option value="27">27</option>
  <option value="28">28</option>
  <option value="29">29</option>
  <option value="30">30</option>
  <option value="31">31</option>
  <option value="32">32</option>
  <option value="33">33</option>
  <option value="34">34</option>
  <option value="35">35</option>
  <option value="36">36</option>
  <option value="37">37</option>
  <option value="38">38</option>
  <option value="39">39</option>
  <option value="40">40</option>
  <option value="42">42</option>
  <option value="43">43</option>
  <option value="44">44</option>
  <option value="45">45</option>
  <option value="46">46</option>
  <option value="47">47</option>
  <option value="48">48</option>
  <option value="49">49</option>
  <option value="50">50</option>
  <option value="51">51</option>
  <option value="52">52</option>
  <option value="53">53</option>
  <option value="54">54</option>
  <option value="55">55</option>
  <option value="56">56</option>
  <option value="57">57</option>
  <option value="58">58</option>
  <option value="59">59</option>
</select></td>
      </tr>
      <tr>
        <td align="left"><p class="margin">:</p></td>
        <td align="left"> </td>
      </tr>
      <tr>
        <td align="left"><p class="margin">Бележка:</p></td>
        <td align="left"><textarea name="desc" id="desc" rows="7" cols="30" wrap="virtual"></textarea></td>
      </tr>
      <tr>
        <td colspan="3" align="left"><input name="submit" type="submit" id="button" value="Добави задача" />
           
          <input name="reset" type="reset" id="button" value="Изчисти"></td>
      </tr>
    </table>      <p class="margin"> </p></td>
  </tr>
  </table>
</form>


<?php
if(isset($_POST['submit'])){
if($_POST['name'] == ""){
echo "<script type=\"text/javascript\">alert('Не сте въвели име на задачата!');</script>"; //при не попълнено поле т.е. name вади грешка..
}
else
if($_POST['desc'] == "") {
echo "<script type=\"text/javascript\">alert('Не сте въвели Вашето мнение!');</script>"; //при не попълнено поле т.е. desc вади грешка.. iiaeiaoa!
}
else {
$task = trim(strip_tags(addslashes($_POST['task']))); // imeto na zada4ata
$day_start = trim(strip_tags(addslashes($_POST['day_start']))); // 
$month_start = trim(strip_tags(addslashes($_POST['month_start'])));
$hour_start = trim(strip_tags(addslashes($_POST['hour_start'])));
$minute_start = trim(strip_tags(addslashes($_POST['minute_start'])));
$day_end = trim(strip_tags(addslashes($_POST['day_end']))); // 
$month_end = trim(strip_tags(addslashes($_POST['month_end'])));
$hour_end = trim(strip_tags(addslashes($_POST['hour_end'])));
$minute_end = trim(strip_tags(addslashes($_POST['minute_end'])));
$desc = nl2br(strip_tags(addslashes($_POST['desc']))); // 
$ip = $_SERVER['REMOTE_ADDR'];
$ip = ip2long($ip);
$added = trim(strip_tags(addslashes($_POST['added'])));
$
$sql = "INSERT INTO `blanka` (`id`,`task`, `start`, `end`, `desc`, `added`,`ip`, `day_start`, `month_start`, `hour_start`, `minute_start`, `day_end`, `month_end`, `hour_end`, `minute_end`)
VALUES (NULL, '$task', '$day_start', '$month_start', '$hour_start', '$minute_start' '$day_end', '$month_end', '$hour_end', '$minute_end', '$desc', NOW(), '$ip');";
$result = mysql_query($sql)or die(mysql_error()."<br />Грешка: ".__LINE__);
if($result == true){
echo '<meta http-equiv="refresh" content="1;url=index.php">';
echo "Моля почакайте страницата да презареди...";
}
else {
echo "възникна грешка..";
}}}
?>

Код: 
CREATE TABLE `blanka` (
  `id` int(11) NOT NULL auto_increment,
  `task` varchar(35) NOT NULL,
  `day_start`  varchar(25) NOT NULL,
  `month_start`  varchar(25) NOT NULL,
  `hour_start`  varchar(25) NOT NULL,
  `minute_start`  varchar(25) NOT NULL,
  `day_end` varchar(25) NOT NULL ,
  `month_end` varchar(25) NOT NULL ,
  `hour_end` varchar(25) NOT NULL ,
  `minute_end` varchar(25) NOT NULL ,
  `desc` TEXT NOT NULL,
  `added` int(5) NOT NULL,
  `ip` int(25) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM

грешката е :

Query was empty
Грешка: 360
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе