Related Combo box not functioning

Feb 14 2013 12:12 PM

In the following code the section semester only show the semester value but related combo box for subject not working please guide the code in pink color not working

<?php
session_start();
if (!array_key_exists("user", $_SESSION)) {
header('Location: index.php');
exit;
}

function valid($instid,$title,$f_name,$e_mail,$mobile_numb,$designation,$sem, $area_exp,$year_exp,$course_id, $error)
{

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta charset="utf-8">
<title>SimpleAdmin - Full width page</title>


<link href='http://fonts.googleapis.com/css?family=Droid+Sans:400,700' rel='stylesheet'>
<link rel="stylesheet" href="css/design.css">


<meta name="viewport" content="width=device-width, initial-scale=1.0"/>


<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script src="js/script.js"></script>
<script language="javascript" type="text/javascript">

function showCompany(catid) {

document.create.submit();

}

</script>
         </head>
<body>



<?php

if ($error != '')
{
echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
}
?>
                                <div class="box">
<form action="" method="post" name="create" id="create">
    <fieldset>
<table>
    <thead><tr>
<th><b>Insert Records</b></th>
</tr>
<tr>
       <th><b><font color='white'>Institute ID<em>*</em></font></b></th>
       <th><b><font color='white'>Title<em>*</em></font></b></th>
       <th><b><font color='white'>Examiner Name<em>*</em></font></b></th>
       <th><b><font color='white'>Examiner Email Address<em>*</em></font></b></th>
       <th><b><font color='white'>Examiner Mobile Number<em>*</em></font></b></th>
       <th><b><font color='white'>Designation<em>*</em></font></b></th>
       <th><b><font color='white'>Semester<em>*</em></font></b></th>
       <th><b><font color='white'>Subject<em>*</em></font></b></th>
       <th><b><font color='white'>Experience in Year<em>*</em></font></b></th>
       <th><b><font color='white'>Course<em>*</em></font></b></th>
</tr>
</thead>
<tbody>
<tr>

<td><label>
<input type="text" readonly="readonly" name="instid" id="instid"
       value="<?php

require_once("Includes/db.php");

    $userID = userDB::getInstance()->get_hod_id_by_name($_SESSION['user']);
    $result = userDB::getInstance()->get_institute_by_user_id($userID);
while($instid = mysqli_fetch_array($result)):echo ($instid['instid']);?> <?php

                  endwhile;

            mysqli_free_result($result);
            ?> " />
</label></td>
<td><label>
<input type="text" name="title" id="title" value="<?php echo $title; ?>" />
</label></td>

<td width="371">

<select name="sem" id="sem" onChange="showCompany(this.value);">

<option value="">--Select--</option>

       <?php
        include('config.php');
        $sql1="select * from semester";

$sql_row1=mysql_query($sql1);

while($sql_res1=mysql_fetch_assoc($sql_row1))

{

<?php

}

</select>

</td>
<td id="td_subject">

<select name="area_exp" id="area_exp">
<option value="">--Select--</option>

       <?php
       include('config.php');
       $sql="select * from subject where sem_id='$sem1' and course='Computer Engineering'";

$sql_row=mysql_query($sql);

while($sql_res=mysql_fetch_assoc($sql_row))

{

<option value="<?php echo $sql_res["id"]; ?>"><?php echo $sql_res["sub_name"]; ?></option>

<?php

}

</select>

</td>

<td><label>
<input type="text" readonly="readonly" name="course_id" value="Computer Engineering" />
</label></td>
</tr>
<tr align="Right">
<td colspan="2"><label>
<input type="submit" name="submit" onClick="check()" value="Insert Records">
</label></td>
</tr>
</tbody>
</table>
          </fieldset>
</form>

                                </div>
<table>
<thead>
<th>Institute Code</th>
<th>Title</th>

<th>Examiner<br> Name</th>
<th>Email<br>Address</th>
<th>Mobile<br> Number</th>
<th>Designation</th>

<th>Area of<br> Expertise</th>
<th>Year of<br> Experience</th>
<th>Course</th>
<th>Edit</th>
<th>Delete</th>
        </thead>

        <tbody>

<?php
include('config.php');
$result1 = mysql_query("SELECT * FROM examinerinfo WHERE course_id='Computer Engineering' ORDER BY id DESC")
or die(mysql_error());
while($row = mysql_fetch_array( $result1 ))
{
?>

<td>
<a href="#" class="table-actions-button ic-table-edit"></a></td>
<td><a href="#" onclick="return confirm('Are you sure want to delete?');" class="table-actions-button ic-table-delete"></a>
</td>
</tr>
<?php

}
?>

            </tbody>
            <tfoot>
            <tr>

  <td colspan="5" class="table-footer">
   <label for="table-select-actions">With selected:</label>

   <select id="table-select-actions">
    <option value="option1">Delete</option>
    <option value="option2">Export</option>
    <option value="option3">Archive</option>
   </select>

   <a href="#" class="round button blue text-upper small-button">Apply to selected</a>

</td>
   </tr>
</tfoot>
</table>
  </div> 

   </div> 

  </div> 

</div> 
        <script language="JavaScript">
function check1()
{
document.create.submit()
}

function check()
{
     if(document.create.instid.value=="")
{
  alert("Please enter Institute ID")
  document.create.instid.focus()
}
    else if(document.create.title.value=="")
{
  alert("Please enter Title")
  document.create.title.focus()
}

    else if(document.create.f_name.value=="")
{
  alert("Please enter full name")
  document.create.f_name.focus()
}
    else if(document.create.e_mail.value=="")
{
  alert("please enter e-mail address")
  document.create.e_mail.focus()
}
else if(document.create.mobile_numb.value=="")
{
  alert("Please enter Mobile Number")
  document.create.mobile_numb.focus()
}
        else if(document.create.designation.value=="")
{
  alert("Please enter Examiner Designation")
  document.create.designation.focus()
}
    else if(document.create.sem.value=="")
{
  alert("Please enter Semester")
  document.create.sem.focus()
}
       else if(document.create.area_exp.value=="")
{
  alert("Please enter Examiner Area of Experience")
  document.create.area_exp.focus()
}

         else if(document.create.year_exp.value=="")
{
  alert("Please enter Examiner Teaching Experience")
  document.create.year_exp.focus()
}
    else if(document.create.course_id.value=="")
{
  alert("Please enter full name")
  document.create.course_id.focus()
}


else
{
getlength()
}

}

function getlength()
{
var val=document.create.eMail.value;
var loc=val.indexOf("@");

if(loc=="-1")
{
alert("Invalid Email address");
}
else
pos()
}

function pos()
{
var val=document.create.eMail.value;
var loc=val.indexOf("@");
if(loc==0)
{
alert("Invalid Email address");
return true;
}
else
dot()
}

function dot()
{
var val=document.create.eMail.value;
var locdot=val.indexOf(".");
var loc=val.indexOf("@");
var sub;

if(locdot=="-1")
{
alert("Invalid Email address");
}
else
posdot()

}

function posdot()
{
var val=document.create.eMail.value;
var locdot=val.indexOf(".");
if(locdot==0)
{
alert("Invalid Email address");
return true;
}
else
check1()
}
</script>

</body>

</html>
<?php
}

include('config.php');

if (isset($_POST['submit']))
{
$instid = mysql_real_escape_string(htmlspecialchars($_POST['instid']));
$title = mysql_real_escape_string(htmlspecialchars($_POST['title']));
$f_name = mysql_real_escape_string(htmlspecialchars($_POST['f_name']));
$e_mail = mysql_real_escape_string(htmlspecialchars($_POST['e_mail']));
$mobile_numb = mysql_real_escape_string(htmlspecialchars($_POST['mobile_numb']));
$designation = mysql_real_escape_string(htmlspecialchars($_POST['designation']));
$sem = mysql_real_escape_string(htmlspecialchars($_POST['sem']));
$area_exp = mysql_real_escape_string(htmlspecialchars($_POST['area_exp']));
$year_exp = mysql_real_escape_string(htmlspecialchars($_POST['year_exp']));
$course_id = mysql_real_escape_string(htmlspecialchars($_POST['course_id']));
if ($instid == '' || $title == '' || $f_name == '' ||
$e_mail == '' || $mobile_numb == ''|| $designation == '' ||
$sem== '' || $area_exp == '' || $year_exp == ''|| $course_id == '')
{

$error = 'Please enter the details!';

valid($instid,$title,$f_name,$e_mail,$mobile_numb,$designation,$sem, $area_exp, $year_exp,$course_id,$error);
}
else
{

mysql_query("INSERT examinerinfo SET instid='$instid',title='$title', f_name='$f_name',
e_mail='$e_mail',mobile_numb='$mobile_numb',designation='$designation',
sem='$sem',area_exp='$area_exp', year_exp='$year_exp', course_id='$course_id'")
or die(mysql_error());

header("Location: co.php");
}
}
else
{
valid('','','','','','','','','','','');
}
?>
v

e-commerce/add to cart

Calling Values from mysql table in TEXTBOXto instert in tabl

Akshay Homkar

Related Combo box not functioning

Answers (0)