PHP display data in textbox onchange of selectbox value

-1

Hi i am new for PHP. I want help, I added one selection box in my form and some text box and one Save button.When page load Selection box fills with some data form MySQL table,i know this much only now i want when i select other value from selection box then in text box will fill related data from MySQL table and when i press Save button all data(which is in text box) will save in other table. please give me code for this. send to ujrnayak@gmail.com

php

Contributors

Replies

Views

6 Years

Discussion Span

6 Years Ago

Last Post by saadsaidi

This is a ajax(JQuery)/php matter giving you code just like this will not solve your problem.
never the less here is some a sample and taking in consideration that you already know how to deal with data retrieval via mysql
include the jquery library in the page header
include this the following code in javascript tags and remember to give ids for your html textbox and selectbox

$("#selectBox").live('change', function(e){
	var value = $("#selectBox").val();
	$.ajax({
		beforeSend: function(){
			$('#textbox').empty();
		},
		url: "where/php/script/is/script.php", 
		type: "POST",
		data: 'recordID='+$value,
		dataType: "html",
		cache: false,
		success: function (html) {
			$("#textbox").val(html);
		}
	});	
	return;
});

I hope this gives you a glimpse

$("#selectBox").live('change', function(e){
	var value = $("#selectBox").val();
	$.ajax({
		beforeSend: function(){
			$('#textbox').empty();
		},
		url: "where/php/script/is/script.php", 
		type: "POST",
		data: 'recordID='+$value,
		dataType: "html",
		cache: false,
		success: function (html) {
			$("#textbox").val(html);
		}
	});	
	return;
});

I hope this gives you a glimpse

php