Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

how to load values from form to jquery

Posted on 2009-04-04
3
Medium Priority
?
359 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

The most up-to-date version of this article is on my Blog https://iconoun.com/blog/
Requirements JQuery 1.6+ HTML CSS Introduction This article was inspired by an EE question (http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28372511.html) on how to make a page show some balloons animate up a page…
The viewer will learn how to dynamically set the form action using jQuery.
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…
Suggested Courses

604 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