Jump to content

beginnerprogrammer

New Members
 View Profile  See their activity

  • Posts

    3

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by beginnerprogrammer

    drop down date don't connect to database

    in PHP Coding Help

    Posted

    hello there.. i have a problem with my php coding where i want to keep date choose by user in the database.

     

     

    this is the drop down date 

    <select name="Date_Day">
<option> - Day - </option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</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="Date_Month">
<option> - Month - </option>
<option value="01">January</option>
<option value="02">Febuary</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>
<select name="Date_Year">
<option> - Year - </option>
    <option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
    <option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
    <option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>	
</select>
   

     

    the code to connect to the database

          $date_year= ($_POST['Date_Year']);
	$date_month=($_POST['Date_Month']);
	$date_day=($_POST['Date_Day']);
                $date=$date_year."-".$date_month."-".$date_day;

$query="INSERT INTO aduan (date) 
			VALUES ('date($date)')";
			$result=mysql_query($query);
				 if($result){
					echo 'Registration success.';
					?><script>window.location ='thanks.php'</script>
					<?php
					}
				else
					echo 'Registration failed';}

     

    when enter a value of date, the database will just show '0000-00-00'.. really hope for your help..  :confused:

    can't insert into the database

    in Javascript Help

    Posted

    I need to complete a nonline system.. The problem is I can't insert the module value into the database.. can someone help me??  :confused: The module will appear based on the system selected. Both module and system are from the database.

     

    This is the coding at the main page.

    <td>Sistem</td>
        <td>:</td>
        <td>
       <select name="system_name" size="1" id="system_name" onChange="showCustomer(this.value)">
          <option>- select -</option>
          <option value = "asis ">ASIS</option>
          <option value = "gais ">GAIS</option>
          <option value = "ifas ">IFAS</option>
          <option value = "sais ">SAIS</option>
          <option value = "persis ">PERSIS</option>
        </select>
       
        </td>
          </tr>
      
          <tr>
             <td>Modul</td>
            <td>:</td>
            <td>
           <?php 
        
          
          
          //$sql="SELECT module_name FROM system WHERE system_name='".$q."'";
          //$result1= mysql_query($sql);
          
                
                    echo"<select name=\"module_name\" id=\"module_name\">\n";
                    echo "<option value= \"none\"> - select - </option>\n";
                    /*do{
                        echo "<option value=\"";
                        echo $row_systemname['module_name'];
                        echo "\">"; echo $row_systemname['module_name']; 
                        echo "</option>\n";
                    }while ($row_systemname= mysql_fetch_assoc($result1));*/ 
                    echo "</select>";
                     
                    $_SESSION['module_name'] = $_POST['module_name'];
                    
            ?> *

     

    The AJAX used to connect to a page (out.php) to output the module menu.

     

    <script type="text/javascript">
function showCustomer(str)
{
var xmlhttp;    
if (str=="")
  {
  document.getElementById("module_name").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("module_name").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","out.php?q="+str,true);
xmlhttp.send();
}
</script>

     

    The coding to output the module (out.php)

    <?php 
    session_start();
    include('db_connect.php');
    //echo "<form action=\"borang0.php\" method=\"post\">";
      $q=$_GET["q"];
      //$system_name=$_POST['system_name'];
      $sql="SELECT module_name FROM system WHERE system_name='".$q."'";
      $result1= mysql_query($sql);
      //$option="";
            
                //echo"<select name=\"module_name\" id=\"module_name\">\n";
                echo "<option value= \"none\"> - select -</option>\n";
                do{
                    echo "<option value=\"";
                    echo $row_systemname['module_name'];
                    echo "\">"; echo $row_systemname['module_name'];
                    echo "</option>\n";
                }while ($row_systemname= mysql_fetch_assoc($result1)); 
                 echo "</select>";
                //$modul = $_POST['modul_name'];                
                //$_SESSION['modul']=$modul;
        //echo "</form>";
        ?>

     

    and here is the code to link to database

    <?php
session_start();
include ('db_connect.php');

      if(isset($_POST['submit']))
      {
        //$id=($_POST['id']);
        $choice=($_POST['choice']);
        $staff_no= $_SESSION['user_login']['staff_no']; 
        $tel=($_POST['tel']);
        $date= ($_POST['date']);;
        $time= ($_POST['time']);
        $system=($_POST['system_name']);
        $modul=$_SESSION['module_name'];
        $description=($_POST['description']);
        //$status=($_POST['status']);
        
            if ($choice == 0){
                $query="INSERT INTO aduan (staff_no,tel,date,time,system,modul,description) 
                VALUES ('$staff_no','$tel','$date','$time','$system','$modul','$description')";
                $result=mysql_query($query);
                     if($result){
                        echo 'Registration success.';
                        ?><script>window.location ='thanks.php'</script>
                        <?php
                        }
                    else
                        echo 'Registration failed';}
            else {
                $query="INSERT INTO permohonan (staff_no,tel,date,time,system,modul,description) 
                VALUES ('$staff_no','$tel','$date','$time','$system','$modul','$description')";
                $result=mysql_query($query);
                     if($result){
                        echo 'Registration success.';
                        ?><script>window.location ='thanks.php'</script>
                        <?php
                        }
                     else
                        echo 'Registration failed';}
                  }
?>

     

    really hope for someone's help..

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.