Hi,

I need some help in PHP. i have a page named test.php which contain a list box. The list box have id. Whenever i choose a id i have to show the info belongs to the id in the same page that is in the test.php. The info are in the database with the id. I m using php and javascript

I think u understand the prob, if not, inform me.

Thanks

You can do this in two ways.

1) Using XML. Please have a look at the sample XML code given at

http://p2p.wrox.com/topic.asp?TOPIC_ID=25686

This is in ASP. But PHP provides the same technology.

2) using Javascript.

Fetch the texts associated with ids and store them in hidden fields. Let the names of hidden fields be created as hid_<id>. Let the name of form be frm_dynamic

Create a place holder for text. This can be a table cell or a div. You need to give an id for this. Let this id be id_place_holder.

Then, in the onchange event of the combo, you can write a javascript. Get the value of the chosen id. Get the corresponding text from hidden field. Display it in the place holder. Following code will do this.

var i_current_id=document.frm_dynamic.cbo_id.options[document.frm_dynamic. cbo_id.selectedIndex].value;
var str_text=eval('document.frm_dynamic.hid_'+i_curren t_id+'.value');
var obj_place_holder=document.getElementById("id_place _holder");
obj_place_holder.innerHTML=str_text;

Thanks madhukp for the quick reply. But the main problem is (i think) i have to get the id and then i have query to the database. And then show the info in the same page. That is first i have to get the id by JavaScript then with that id i have to query by php in the db. And i think this is the hard part. I think i may clear the prob

ok, that is what I have said in the earlier part. The db query you can do in the beginning and fetch all the values corresponding to each id and store them in hidden fields. Suppose you have ids going from 1 to 10, you will have 10 hidden fields in the form. Each of these contain the value corresponding to one id. Then show the appropriate value from them as the selection changes.

This will cause problem when number of elements in the select box increases. Then you will have to use either refresh method or XML method.

In the refresh method, you will simply submit the form containing select box and in the page, you will fetch and display the corresponding value when there is submitted value of id. That is, in the onchange event of select box submit the form to the same page. In the page, check whether the submitted value of id is null. If it is not null, you can query the database and display relevant value corresponding to the submitted id. Hope you understood.

sorry that i do not understant you...and thanks for explain the solution beautifully..and again sorry for the late reply..

Thanks