showuser not defined???

Greaser9780 · March 2, 2007

Here is my select box that calls the js:

<html>

<head>

</head>

<body>

<form>

</select>

</FORM>

</BODY>

</html>

Here is the java:

var xmlHttpfunction ;showUser(str)

{

xmlHttp=GetXmlHttpObject()

if (xmlHttp==null)

{

alert ("Browser does not support HTTP Request")

}

var url="getuser.php"

url=url+"?q="+str

url=url+"&sid="+Math.random()

xmlHttp.onreadystatechange=stateChanged

xmlHttp.open("GET",url,true)

xmlHttp.send(null)

}

function stateChanged()

{

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")

{

document.getElementById("txtHint").innerHTML=xmlHttp.responseText

}

}function GetXmlHttpObject()

{

var xmlHttp=null;

try

{

// Firefox, Opera 8.0+, Safari

xmlHttp=new XMLHttpRequest();

}

catch (e)

{

//Internet Explorer

try

{

xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");

}

catch (e)

{

xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

}

return xmlHttp;

}

Here is what it is supposed to show:

<?php

$q=$_GET["q"];

require("db.php");

$sql="SELECT * FROM players WHERE position = '".$q."'";

$result = mysql_query($sql);

?>

<html>

<head>

</head>

<body>

Team name:<input type='text' name='name'>

Password:<input type='password' name='pass'>

Comment:<input type='text' name='com' maxlength='80'>

<?php

while($row = mysql_fetch_array($result))

{

echo "<option value='" . $row['name'] . "'>" . $row['name'] . "</option>";

}

?>

</select>

</form>

</body>

</html>

Any clues why I keep getting these errors

ScotDiddle · March 2, 2007

Greaser9780,

I got it to work with the following files...

Try them out and let us know.

Scot L. Diddle, Richmond VA

test2.php


<html>
<head>
<style>

div#txtHint {
font-weight:bold;
}
</style>

<script src="/javascript/showUser.js"></script>
</head>
<body>
<form>
<select name="users" onchange="showUser(this.value)">
<option>QB</option>
<option>WR</option>
<option>RB</option>
<option>TE</option>
<option>PK</option>
<option>DF</option>
</select>
</FORM>
<div id="txtHint"> </div>
</BODY>
</html>

showUser.js ( Called from test2.php, it lives in a folder called javascript/ )


var xmlHttp

function showUser(str)
{ 
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
} 
var url="showUser.php"
url=url+"?"+str
url=url+"&sid="+Math.random()
xmlHttp.onreadystatechange=stateChanged 
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}

function stateChanged() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{ 
document.getElementById("txtHint").innerHTML=xmlHttp.responseText 
} 
}

function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
  {
  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  }
catch (e)
  {
  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
}
return xmlHttp;
}

showUser.php ( Called form showUser.js ... modified, because I don't have your DB definitions... )


<?php
$q=$_GET["q"];

// echo "\$q : " . $q;	

$con = mysql_connect('localhost', 'root', '');
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }

mysql_select_db("MySQL", $con);

$sql="SELECT * FROM user ";

$result = mysql_query($sql);

?>
<html>
<head>
</head>
<body>
<form action="select.php" method="post">
Team name:<input type='text' name='name'>

Password:<input type='password' name='pass'>

Comment:<input type='text' name='com' maxlength='80'>

<select name="playername">
<?php
while($row = mysql_fetch_array($result))
{
  echo "<option value='" . $row['0'] . "'>" . $row['1'] . "</option>";

  }
?>
</select>
<input type="submit" name="submit" value="select">
</form>
</body>
</html>

Greaser9780 · March 3, 2007

showUser.php is not getting the variable $q. Any clue how to force showUser to get Q. I need showUser.php to know which position was selected so it can send the proper query to show.

Sign In

showuser not defined???

Recommended Posts

Greaser9780

Link to comment

Share on other sites

ScotDiddle

Link to comment

Share on other sites

Greaser9780

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information