Loogin එකේ ප්‍රශ්නයක්.

[Gagapura Sira]

Loogin එකේ ප්‍රශ්නයක්.

මගේ ලොගින් system එකේ code එක,

<?php
if(isset($_POST['sub'])){
$fname = $_POST['name'];
$lname = $_POST['name2'];
$nic = $_POST['nic'];
$radio = $_POST['radio'];
$address = $_POST['add'];
$date = $_POST['day, month, year'];
$mail = $_POST['mail'];
$country = $_POST['con'];

$con = mysql_connect("localhost","root","789") or die ("Connection error".mysql_error());
mysql_select_db("student",$con) or die("database arror". mysql_error());


$sql = "INSERT INTO loging VALUES('$fname','$lname','$nic','$radio','$address','$date','$mail','$country')";
$que = mysql_query($sql) or die("SQL Error".mysql_error());

}
?>
<div id="outer">
<center>
  <form id="form1" name="form1" method="post" action="">
    <table width="540" height="618" border="0">
      <tr>
        <th scope="row"><div align="left">First Name:</div></th>
        <td><label>
          <input type="text" name="name" id="name" />
        </label></td>
      </tr>
      <tr>
        <th scope="row"><div align="left">Last Name:</div></th>
        <td><label>
          <input type="text" name="name2" id="name2" />
        </label></td>
      </tr>
      <tr>
        <th scope="row"><div align="left">NIC Number:</div></th>
        <td><label>
          <input type="text" name="nic" id="nic" />
        </label></td>
      </tr>
      <tr>
        <th scope="row"><div align="left">Gender:</div></th>
        <td><label>
    <input type="radio" name="radio" id="male" value="male" />
    Male</label>
    <label>
    <input type="radio" name="radio" id="female" value="female" />
    Female</label></td>
      </tr>
      <tr>
        <th scope="row"><div align="left">Address:</div></th>
        <td><label>
          <textarea name="add" id="add" cols="30" rows="2"></textarea>
        </label></td>
      </tr>
      <tr>
        <th scope="row"><div align="left">Date of birth:</div></th>
        <td><label>Day
    <select name="day" id="day">
      <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>
    </label>
    <label>Month
    <select name="month" id="month">
      <option value="01">January</option>
      <option value="02">February</option>
      <option value="03">March</option>
      <option value="04">April</option>
      <option value="05">May</option>
      <option value="06">June</option>
      <option value="07">July</option>
      <option value="08">August</option>
      <option value="09">September</option>
      <option value="10">October</option>
      <option value="11">November</option>
      <option value="12">December</option>
    </select>
    </label>
    
    <label>Year
    <select name="year" id="year">
      <option value="1970">1970</option>
      <option value="1971">1971</option>
      <option value="1972">1972</option>
      <option value="1973">1973</option>
      <option value="1974">1974</option>
      <option value="1975">1975</option>
      <option value="1976">1976</option>
      <option value="1977">1977</option>
      <option value="1978">1978</option>
      <option value="1979">1979</option>
      <option value="1980">1980</option>
      <option value="1981">1981</option>
      <option value="1982">1982</option>
      <option value="1983">1983</option>
      <option value="1984">1984</option>
      <option value="1985">1985</option>
      <option value="1986">1986</option>
      <option value="1987">1987</option>
      <option value="1988">1988</option>
      <option value="1989">1989</option>
      <option value="1990">1990</option>
      <option value="1991">1991</option>
      <option value="1992">1992</option>
      <option value="1993">1993</option>
      <option value="1994">1994</option>
      <option value="1995">1995</option>
      <option value="1996">1996</option>
      <option value="1997">1997</option>
      <option value="1998">1998</option>
      <option value="1999">1999</option>
      <option value="2000">2000</option>
        </select>
    </label></td>
      </tr>
      <tr>
        <th scope="row"><div align="left">E-mail Address:</div></th>
        <td><label>
          <input type="text" name="mail" id="mail" />
        </label></td>
      </tr>
      <tr>
        <th scope="row"><div align="left">Country:</div></th>
        <td><label>
          <input type="text" name="con" id="con" />
        </label></td>
      </tr>
      <tr>
        <th scope="row"> </th>
        <td> </td>
      </tr>
      <tr>
        <th scope="row"><label>
          <input type="submit" name="sub" id="sub" value="Login" />
        </label></th>
        <td> </td>
      </tr>
    </table>
  </form>
</center>
</div>

මේකේ date, month, year එක දීලා submit කරනකොට database එකට යන්ඩ ඕනේ,
අර date, month, year එක combind වෙලා එක ෆීල්ඩ් එකකට. අනේ එක කියා දෙනවකෝ කොහොමද කරන්නේ කියලා. මම අහපු ප්‍රශ්නේ තේරුනාද දන්නේ නැහැ. තේරුන අය කියලා දියල්ල මයේ අප්පලා ටික.