Solved

how to load values from form to jquery

Posted on 2009-04-04
3
346 Views
Last Modified: 2012-06-27
am having 2 a select box with 2 options....

when i i select an option1 and click submit, i get values relating to the first option in the grid. But when i change to option2  the values does not change.

i need to refresh again and when i choose option2 this time i get the corresponding values and again when i try to change to option1 same prob as above.....pls help
<?

mysql_connect("localhost","root","");

mysql_select_db("lab")or die("CANNOT CONNECT To DATABASE".mysql_error());

?>
 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

	<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />

<title>Flexigrid</title>

<link rel="stylesheet" type="text/css" href="css/flexigrid.css" />

<script type="text/javascript" src="jquery-1.2.3.pack.js"></script>

<script type="text/javascript" src="flexigrid.js"></script>
 

<script type="text/javascript">
 

function getXMLHTTP() { //fuction to return the xml http object

		var xmlhttp=false;	

		try{

			xmlhttp=new XMLHttpRequest();

		}

		catch(e)	{		

			try{			

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

			}

			catch(e){

				try{

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

				}

				catch(e1){

					xmlhttp=false;

				}

			}

		}

		 	

		return xmlhttp;

    } 
 
 

$(document).ready(function(){
 

$('form').submit(function() {
 

  var fname=$('#test_n').val();

	

	$("#flex1").flexigrid

			(

			{

			

			url: 'post2.php?type='+fname,

			dataType: 'json',

			colModel : [

			

				{display: 'Test ID', name : 'test_id', width : 40, sortable : true, align: 'center'},

				{display: 'Test Code', name : 'tst_code', width : 80, sortable : true, align: 'left'},

				{display: 'Test Name', name : 'test_name', width : 180, sortable : true, align: 'left'},

				{display: 'Test Dept ID', name : 'tst_dep_id', width : 70, sortable : true, align: 'center'},

				{display: 'Test Sample ID', name : 'tst_sample_id', width : 70, sortable : true, align: 'center' },//hide: true},

				{display: 'Normal Value', name : 'normal_val', width : 80, sortable : true, align: 'left',hide:true}

				//{display: 'Number', name : 'num', width : 80, sortable : true, align: 'right'}

				],

			

			searchitems : [

				{display: 'Test Code', name : 'tst_code'},

				{display: 'Test Name', name : 'test_name', isdefault: true}

				],

			sortname: "test_id",

			sortorder: "asc",

			usepager: true,

			title: 'TEST LIST	',

			useRp: true,

			rp: 10,

			showTableToggleBtn: true,

			width: 700,

			height: 255

			}

			);   

	

return false;

});

});
 

</script>

</head>

<br /><br />
 

<body align="center" bgcolor="#ffffff">

<form method='post' action='<? $_SERVER['PHP_SELF'] ?>' onsubmit='return validate_form();'>
 

<div id="statediv">Test Name:&nbsp;&nbsp;&nbsp;<select id="test_n" name="test_name"  >

	<option value="test" >All</option>

    <option value="test1" >All2</option>

    

        </select>

		<input type="submit" value="submit"></div>

<?

//echo $_REQUEST['sortname'];

echo "<table id='flex1' style='display:none' ></table>"

?>
 

</form>

<br /><br />
 

</body>

</html>

Open in new window

0
Comment
Question by:whspider
  • 2
3 Comments
 
LVL 5

Expert Comment

by:prokvk
ID: 24067589
How about posting your validate_form() function ?
0
 

Author Comment

by:whspider
ID: 24067664
am not using validation....

i just want the grid the have values based on the selected options
0
 

Accepted Solution

by:
whspider earned 0 total points
ID: 24144922
thanks i found it myself.i included the following and it worked

var fname=$('#test_n option:selected').val();
var fname1=
jQuery('#flex1').flexOptions({newp:1, params:[{name:'type', value: fname},{name:'sal',value:fname1}]});
jQuery("#flex1").flexReload();
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction A frequently asked question goes something like this:  "I am running a long process in the background and I want to alert my client when the process finishes.  How can I send a message to the browser?"  Unfortunately, the short answer …
Introduction JSON is an acronym for JavaScript Object Notation.  It is a text-string data transport mechanism, capable of representing simple or complex data structures in a consistent and easy-to-read manner.  Similar in concept to XML, but more e…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

919 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

16 Experts available now in Live!

Get 1:1 Help Now