Member Avatar for jabeen123 
<SCRIPT language="javascript">
   function abc(){
   
 <?php 
 $search1=mysql_query("select Lab_credit_hr from courses where Course_Number='$_GET[course]'");
   if (mysql_num_rows($search1) == 0) 
{
?>
document.fm.lab.disabled=true;
<?php
 }?>
  </SCRIPT>

i want to check mysql table row that if column "lab credit hour"= 0 then lab text field disabled help me this code?
and this javascript function call in "course" option drop down menu

  • 5 Contributors
  • 8 Replies
  • 384 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by EvolutionFallen
Member Avatar for fobos

Try this:

<script type="text/javascript">
function abc() {
    <?php
    //Connection
    $search = mysql_query("SELECT lab_credit_hr FROM courses WHERE course_number = '$_GET['course']'");
    $row = mysql_fetch_array($search);
    if($row['lab_credit_hr'] == 0) {
        echo "document.getElementById('id').disabled = true;";
    } else {
        echo "document.getElemenbById('id').disabled = false;";
    }
    ?>
}
</script>

I hope this helps. This is untested

Edited by fobos because: n/a
Member Avatar for pritaeas

You need to create an ajax request, you cannot mix php and js like that, only if you need a static result (like fobos' example).

Edited by pritaeas because: n/a
Member Avatar for EvolutionFallen

Hi jabeen123,

First a couple of points on syntax:
a) You are missing a closing } . You open one on line 2 and one on line 7, but only close one on line 11.
b) You need quotation marks around the word course in $_GET[course] . You may want to change the whole statement to

$search1=mysql_query("select Lab_credit_hr from courses where Course_Number='" . $_GET['course'] . "'");

Now, can you explain your problem in a little more detail? I'm not certain I understand. When does abc() get called? Is it when you click on different <option>s in a <select> element, or is it when a link is clicked? I'm trying to clarify why you need to use JavaScript.

Member Avatar for diafol

I can't see anything really wrong with the code. You can echo out js from php based on php processing. That's not an issue.

However, using php via js once a page has loaded needs AJAX. You can't get around this.

So if you're running a js function in response to say, a change in a select dropdown - this can be run in JUST js, if all return values are known before hand. Otherwise, if you need server-side intervention, e.g. data from a database, you need to use AJAX.

Member Avatar for jabeen123

iam trying your code but it will disable all conditions if row lab 0 or 1 or 2.All conditions disable text field ? why
And i m trying also ajax code but also disabled all condtions??

<select name="course" id="course" onChange="getCourse(this.value);"/>
           <option>Select courses <?php echo $option2 ?></option>
         </select
function getCourse(str)
{
if (str=="")
  {
  document.getElementById("labdiv").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("labdiv").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","findcourse.php?course="+str,true);
xmlhttp.send("lab=" + document.getElementById("lab").value);
}
<head>

<link href="mystyle.css" rel="stylesheet" type="text/css">
</head>
<SCRIPT language="javascript">
   function abc(){
<?php
$name=$_GET['course'];

$link = mysql_connect("localhost","root",""); //changet the configuration in required
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
mysql_select_db("result_system_db",$link);
$query="select Lab_credit_hr from courses where Course_Number='$name'";

if($row=mysql_fetch_array($query)==0)
 
{

 echo "document.getElementById('lab').disabled = true";

    }
mysql_close($link); ?>}
</SCRIPT>
Member Avatar for EvolutionFallen 
if($row=mysql_fetch_array($query)==0)

You're comparing the returned array to 0. I believe you should be doing

$row=mysql_fetch_assoc($query);
if( $row['Lab_credit_hr'] == 0 ) {
     // disable field
}
Member Avatar for jabeen123

no work this code so far.
when i selected course option text field not disabled

<head>
<script type="text/javascript">
function abc() {
    <?php
    include_once("connect.php");
    $query = mysql_query("SELECT Lab_credit_hr FROM courses WHERE Course_Number = '$_GET[course]'");
	while($row = mysql_fetch_array($query))
	{
    
    if($row["Lab_credit_hr"] == 0) {
        echo "document.getElementById('lab').disabled = true;";
    } else {
        echo "document.getElemenbById('lab').disabled = false;";
    }
	}
    ?>
}
</script></head>
<body>
<?PHP
$option="";
include_once("connect.php");
$result = mysql_query("SELECT * FROM courses");
 
while($row = mysql_fetch_array($result))
{
$course2=$row["Course_Number"];
    $course3=$row["Course_Id"];
    $option2.="<OPTION VALUE=\"$course2\">".$course2.'</option>';
}
?>
      <div align="left"><strong>Course Number</strong>:      </div>
    
	</td>
	     <td><select name="course" id="course" onChange="javascript:abc()">
           <option>Select courses <?php echo $option2 ?></option>
         </select></td>
	   </tr>



</body>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.