Page not reloading after jsp query

Javascript coding ..

Moderators: macek, egami, gesf

Nikita06
New php-forum User
New php-forum User
Posts: 4
Joined: Wed Feb 29, 2012 9:08 pm

Page not reloading after jsp query

Postby Nikita06 » Wed Feb 29, 2012 9:47 pm

In my code, what i'm doing is picking a value from a dropdown-searching it in mySQL-and then printing the details in a file. However i have 2 forms one a single php page and each form connects to a different database to get values.
the problem i'm facing is when my jsp query is executed, the query results into the same page with information however this page loads underneath the dropdown from which the value was selected. How can i make the page lod itself over the original page??
heres my code:

Code: Select all

<html>
<head>

<?php
   error_reporting(E_ERROR | E_PARSE);

   echo "<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Strict//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd'>";
   echo "\n<html xmlns='http://www.w3.org/1999/xhtml' xml:lang='en' lang='en'>";
   echo "\n<div id='header'>";
   echo "\n<img src='nucleosome.png' style= 'float:left; margin: 1px 1px 1px 1px;' height='98px' title ='nucleosome' alt='nucleosome' />";
   echo "\n<img src='vman.png' style= 'float:right; margin: 1px 1px 1px 1px;' height='98px' title ='Mouse' alt='Mouse' />";
   echo "\n<h1> <center><i>HI</i>stome: The <i>H</i>istone <i>I</i>nfobase </center></h1>";
   echo "\n<h4> <center>A database of mouse histones, their post-translational modifications and modifying enzymes </center></h4>";
   echo "</div>";
   echo "<script type='text/javascript' src='slide_down_menu_javascript.js'></script>";
?>

</head>

<body>
</br>
</br>
<table width = "1000" cellpadding = "5" border = "0">
<tr>
<th>MOUSE</th>
<th>HUMAN</th>
</tr>
<tr>
<td>
<form align="center">

<?php
        $con = mysql_connect("localhost","root","1234");
      if (!$con)
      die('Could not connect: ' . mysql_error());
   $db = mysql_select_db("mus_histone");
      if (!$db)
   die('Could not select the database: ' . mysql_error());

   $sql = "Select protein_name from main where main = 'histone' order by protein_name";
   $res = mysql_query($sql);
   $dropdown = "<select name='protein_name' onchange='getSequence(this.value)'>";
   while($row = mysql_fetch_assoc($res))
   {
      $dropdown .= "\r\n<option value='{$row['protein_name']}'>{$row['protein_name']}</option>";
   }
   $dropdown .= "\r\n</select>";
   echo $dropdown;
   echo "<script type = 'text/javascript' src = 'getSeq.js'></script>";
   $q= $_REQUEST["q"];
   //echo $q;
   $result = mysql_query("Select sequence from main where protein_name = '".$q."'");
      if (!$result)
      die('Could not query the database: ' . mysql_error());
   $row = mysql_fetch_array($result);

   if($q != "")
   {
      $seq = $row['sequence'];
      $sequence_mus = wordwrap($seq, 50, "\n", true);
      $myFile = "seq.txt";
      $fh = fopen($myFile, 'a');
      fwrite($fh, ">".str_replace(" ", "_", $q)."_mouse"."\n".$sequence_mus."\n");
      fclose($fh);
   }
?>
</form>
<div id="txtHint"></div>
</td>
<td>
<form align = "center">
<?php

   $con = mysql_connect("localhost","root","1234");
      if (!$con)
      die('Could not connect: ' . mysql_error());
   $db = mysql_select_db("coee");
      if (!$db)
   die('Could not select the database: ' . mysql_error());

   $sql = "Select protein_name from main where main = 'histone' order by protein_name";
   $res = mysql_query($sql);
   $dropdown = "<select name='protein_name' onchange='getSequenceHuman(this.value)'>";
   while($row = mysql_fetch_assoc($res))
   {
      $dropdown .= "\r\n<option value='{$row['protein_name']}'>{$row['protein_name']}</option>";
   }
   $dropdown .= "\r\n</select>";
   //echo "Human: ";
   echo $dropdown;
   echo "<script type = 'text/javascript' src = 'getSeq.js'></script>";
   $qHuman= $_REQUEST["qHuman"];
   $resultHuman = mysql_query("Select sequence from main where protein_name = '".$qHuman."'");
      if (!$resultHuman)
      die('Could not query the database: ' . mysql_error());
   $rowHuman = mysql_fetch_array($resultHuman);

   if($qHuman != "")
   {
      $seqHuman = $rowHuman['sequence'];
      $sequence_human = wordwrap($seqHuman, 50, "\n", true);
      $myFile = "seq.txt";
      $fh = fopen($myFile, 'a');
      fwrite($fh, ">".str_replace(" ", "_", $qHuman)."_human"."\n".$sequence_human."\n" );
      fclose($fh);
   }
?>
</form>
<div id="txtHintH"></div>
</td>
</tr>
</table>
</body>
</html>



And heres my java script:

Code: Select all

function getSequence(str)
{
//document.write(str);
if (str=="")
  {
  document.getElementById("txtHint").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("txtHint").innerHTML=xmlhttp.responseText;
    }
  }

xmlhttp.open("GET","sample1.php?q="+str,true);
xmlhttp.send();
}

function getSequenceHuman(str)
{
//document.write(str);
if (str=="")
  {
  document.getElementById("txtHintH").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("txtHintH").innerHTML=xmlhttp.responseText;
    }
  }

xmlhttp.open("GET","sample1.php?qHuman="+str,true);
xmlhttp.send();
}

Also i'm completely new to php. Any help will be appreciated! :)

Return to “JavaScript”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest