Forum Moderators: open
<?
$dbc = mysql_connect('example.com', 'user', 'pass');
if (!$dbc) {
echo ' Error ' ;
}
mysql_select_db('mydb', $dbc);
if (!mysql_select_db('mydb')) {
echo ' Error ';
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script language="javascript">
function showHint(hintStr){
var AdminRequest = window.ActiveXObject? new ActiveXObject("Microsoft.XMLHTTP") : new XMLHttpRequest();
AdminRequest.onreadystatechange = function()
{
if (AdminRequest.readyState == 4)
{
if (AdminRequest.status == 200)
{
document.getElementById('txtHint').innerHTML = AdminRequest.responseText;
}
else {
alert('Error get.php File '+ AdminRequest.statusText);
}
}
}
var infoStr = "?select="+hintStr;
AdminRequest.open("GET", "get.php"+infoStr, true);
AdminRequest.send(null);
}
</script>
<title>Untitled Document</title>
</head>
<body>
<form name="form1" method="post" action="">
<table width="778" border="0" align="center">
<tr>
<td width="245"><div align="right">Name Of Company : </div></td>
<td width="523"><select name="company" style="width:300px;margin:5px 0 5px 0;" onChange=" showHint(this.value);" >
<?
$query="SELECT * FROM listedcomp";
$result = mysql_query($query);
$num = mysql_numrows($result);
for ($i = 0; $i < $num;) {
$row = mysql_fetch_assoc($result);
?>
<option value="<?=$row['company'];?>"><? echo $row['company'];?></option>
<? $i++; }?>
</select></td>
</tr>
</table>
</form>
<p><div id="txtHint"></div></p>
</body>
</html>
[edited by: DrDoc at 6:37 pm (utc) on June 19, 2007]
[edit reason] Removed specifics [/edit]
><div id="txtHint">Please wait...Loading...</div>
That text will be replaced when the request completes.
