whspider
asked on
help in jquery
Hi am using autocomplete....
what i want is to populate 2 diferent sets of auto values based on the option button selection
what happens is when i choose the first option values are loaded properly but when i switch to 2 option values corresponding to 2 option are not loaded...values relating to first option only pops up...only when i refresh the page the other option value gets loaded....
values does not change based on option button change..but they change each time the page is refreshed.
what i want is to populate 2 diferent sets of auto values based on the option button selection
what happens is when i choose the first option values are loaded properly but when i switch to 2 option values corresponding to 2 option are not loaded...values relating to first option only pops up...only when i refresh the page the other option value gets loaded....
values does not change based on option button change..but they change each time the page is refreshed.
<head>
<script type="text/javascript" src="jquery-autocomplete/lib/jquery.js"></script>
<script type="text/javascript" src="jquery-autocomplete/jquery.autocomplete.js"></script>
<script type="text/javascript" src="jquery-autocomplete/searchdata.php"></script>
<link rel="stylesheet" type="text/css" href="jquery-autocomplete/jquery.autocomplete.css" />
<script type="text/javascript">
$(document).ready(function() {
if(document.test.test1[0].checked)
{
$("#cse_search").autocomplete(searchdata2);
}
if(document.test.test1[1].checked)
{
$("#cse_search").autocomplete(searchdata1);
}
});
</script>
</head>
<center>
<body onLoad="showClock()">
<form name='test' method='POST' action='<? $_SERVER['PHP_SELF'] ?>'>
<!-- start here Test Listing table -->
<div class="b2">
<fieldset>
<legend> <b>Test Listing </b></legend>
<table cellspacing="2" cellpadding="2" border="0">
<tr>
<!-- start here Radio button table -->
<td>
<table width="350" height="55" border="0 " cellpadding="0" cellspacing="1" align="center" >
<tr>
<td><input type="radio" name="test1"></td><td>Testing</td>
<td><input type="radio" name="test1"></td><td>Profile</td>
<td><input type="radio" name="testing"></td><td>Master Profile</td>
</tr>
<tr>
<td colspan="9"><input type="text" id="cse_search" name="q" size="31" /></td>
</tr>
</table>
...........................
searchdata.php
.............................
<?php
/* This script parses the Popular Queries feed from Google's CSE product and outputs
the recent queries in a JavaScript array for use with the jQuery Autocomplete plugin. */
// There may be some search queries you want to include in the autocomplete box
// that aren't necessarily popular searches and therefore don't show up in your
// Google CSE feed. You can add those terms to this array to ensure they show up.
// You will want to make sure you enter the terms in lowercase.
$server="localhost";
$user="root";
$password="";
$database="lab";
mysql_connect($server,$user,$password) or
die("Unable to connect to the localhost");
mysql_select_db($database) or
die("Database 'Products' doesn't exist!");
$table="doctor";
$query="select d_name from $table";
$result=mysql_query($query);
//$data=mysql_fetch_array($result);
$num_rows = mysql_num_rows($result);
// Load the Popular Queries RSS Feed from Google's CSE using SimpleXML
// The URL is available by clicking "Statistics" from inside your CSE control panel.
while($data1=mysql_fetch_array($result))
{
$data[]=$data1['d_name'];
}
// Format the data for JavaScript output.
sort($data); //alphabetize the array
foreach($data as $search_term)
{
$js_data[] ="\"" . $search_term . "\"";
}
// Let's inform the browser that we're sending JavaScript.
//header("Content-type: text/javascript\n\n");
// Next we'll escape from PHP and create a JavaScript array. Inside the array, we'll return t
// PHP and use implode() to return a comma-separated string of all the data inside $js_data.
?>
var searchdata1 = [<?php echo implode($js_data, ", "); ?>];
<?
$table1="test_list";
$query1="select tst_code from $table1";
$result1=mysql_query($query1);
//$data=mysql_fetch_array($result);
$num_rows1 = mysql_num_rows($result1);
// Load the Popular Queries RSS Feed from Google's CSE using SimpleXML
// The URL is available by clicking "Statistics" from inside your CSE control panel.
while($data2=mysql_fetch_array($result1))
{
$dat[]=$data2['tst_code'];
}
// Format the data for JavaScript output.
sort($dat); //alphabetize the array
foreach($dat as $search_trm)
{
$js_dat[] ="\"" . $search_trm . "\"";
}
// Let's inform the browser that we're sending JavaScript.
//header("Content-type: text/javascript\n\n");
// Next we'll escape from PHP and create a JavaScript array. Inside the array, we'll return t
// PHP and use implode() to return a comma-separated string of all the data inside $js_data.
?>
var searchdata2 = [<?php echo implode($js_dat, ", "); ?>];
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.