Solved

help in jquery

Posted on 2009-04-02
1
294 Views
Last Modified: 2012-08-14
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.
<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>&nbsp;<b>Test Listing&nbsp;</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, ", "); ?>];

Open in new window

0
Comment
Question by:whspider
1 Comment
 
LVL 4

Accepted Solution

by:
davidsperling earned 500 total points
ID: 24049157
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article discusses four methods for overlaying images in a container on a web page
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now