Dynamic fill form fields depending on dropdown box

[Alex]

Hello list

This question has probably already been asked, but let me ask again

I have a mysql database to which I connect with my php scripts. The
database contains articles. Name, Unit_Price and Reference

Now my client needs to order 5 items, click a button and a table with 5
lines and 3 columns appears (until now easy)

In the first column is a drop down box with a <select > and <options> in
which I store all possible names.

I would like than whenever the client changes one of the boxes (in my
case there are 5) the Unite_Price column and Reference column in the
line he just choose get automatically updated
I search all over the web but I could not find it.

Thank you for your help

Alex

[Erwin Moller]

Alex wrote:

Hello list

This question has probably already been asked, but let me ask again

I have a mysql database to which I connect with my php scripts. The
database contains articles. Name, Unit_Price and Reference

Now my client needs to order 5 items, click a button and a table with 5
lines and 3 columns appears (until now easy)

In the first column is a drop down box with a <select > and <options> in
which I store all possible names.

I would like than whenever the client changes one of the boxes (in my
case there are 5) the Unite_Price column and Reference column in the
line he just choose get automatically updated

Are you talking about Javascript here?
Do you want the user to do a select on your page and the page will fill the
appropriate fields? Then go Javascript.

Or do you want to go back to the server if somebody touches the selectbox?
Then it is PHP.
I think you better do this with Javascript.
Try comp.lang.javas cript.

If you want to do it in PHP, well... where to start?
Do you know how to receive a form in PHP? ($_POST[] and the like)
Do you know how to put dynamical data into your html-page with PHP?

If you want to do this in PHP, please be more specific and ask a question
that is answerable instead of the complete solution to a problem nobody in
here knows except you. :-)


I search all over the web but I could not find it.
Really?
This is quite basic stuff (both in Javascript and PHP) so I wonder why you
didn't find any code that does similar things.
(No punch intended)

Good luck.

Regards,
Erwin Moller

Thank you for your help

Alex

[Alex]

Erwin Moller wrote:

Alex wrote:

Hello list

This question has probably already been asked, but let me ask again

I have a mysql database to which I connect with my php scripts. The
database contains articles. Name, Unit_Price and Reference

Now my client needs to order 5 items, click a button and a table with 5
lines and 3 columns appears (until now easy)

In the first column is a drop down box with a <select > and <options> in
which I store all possible names.

I would like than whenever the client changes one of the boxes (in my
case there are 5) the Unite_Price column and Reference column in the
line he just choose get automatically updated

Are you talking about Javascript here?
Do you want the user to do a select on your page and the page will fill the
appropriate fields? Then go Javascript.

Or do you want to go back to the server if somebody touches the selectbox?
Then it is PHP.
I think you better do this with Javascript.
Try comp.lang.javas cript.

If you want to do it in PHP, well... where to start?
Do you know how to receive a form in PHP? ($_POST[] and the like)
Do you know how to put dynamical data into your html-page with PHP?

If you want to do this in PHP, please be more specific and ask a question
that is answerable instead of the complete solution to a problem nobody in
here knows except you. :-)

I search all over the web but I could not find it.

Really?
This is quite basic stuff (both in Javascript and PHP) so I wonder why you
didn't find any code that does similar things.
(No punch intended)

Good luck.

Regards,
Erwin Moller

Thank you for your help

Alex

Well you are almost right, this is not only php it is also a bit of
Javascript, I need in fact to be able to pass the
$fields=mysql_f etch_object($da taresults} to a javascript, but I do not
see how I can implement that since I do not know how to pass the result
using php, so in that sens it is also php relevant

as for the punch, I searched the net but I only get either trivial
results or things that populate a drop down menu (which I already know
how to do) That's why I ask it here

Thanks

[Erwin Moller]

Krustov wrote:

<comp.lang.ph p , Erwin Moller ,
si************* *************** **...yourself.co m>
<43************ ***********@new s.xs4all.nl>
<Wed, 22 Feb 2006 16:46:51 +0100>

> I search all over the web but I could not find it.

Really?
This is quite basic stuff (both in Javascript and PHP) so I wonder why
you didn't find any code that does similar things.
(No punch intended)

Do you ever actually help anybody on here who asks a question .

You only ever seem to comment and give your opinion on 'what' they ask
rather than helping them .

Bull. Look around more.
I do actually help people, even this OP, as you could see in the part you
cutted away. Please go insult somebody else, thanks.

Erwin Moller

[noone]

Alex wrote:

Erwin Moller wrote:

Alex wrote:

Hello list

This question has probably already been asked, but let me ask again

I have a mysql database to which I connect with my php scripts. The
database contains articles. Name, Unit_Price and Reference

Now my client needs to order 5 items, click a button and a table with 5
lines and 3 columns appears (until now easy)

In the first column is a drop down box with a <select > and <options> in
which I store all possible names.

I would like than whenever the client changes one of the boxes (in my
case there are 5) the Unite_Price column and Reference column in the
line he just choose get automatically updated

Are you talking about Javascript here?
Do you want the user to do a select on your page and the page will fill the
appropriate fields? Then go Javascript.

Or do you want to go back to the server if somebody touches the selectbox?
Then it is PHP.
I think you better do this with Javascript.
Try comp.lang.javas cript.

If you want to do it in PHP, well... where to start?
Do you know how to receive a form in PHP? ($_POST[] and the like)
Do you know how to put dynamical data into your html-page with PHP?

If you want to do this in PHP, please be more specific and ask a question
that is answerable instead of the complete solution to a problem nobody in
here knows except you. :-)

I search all over the web but I could not find it.

Really?
This is quite basic stuff (both in Javascript and PHP) so I wonder why you
didn't find any code that does similar things.
(No punch intended)

Good luck.

Regards,
Erwin Moller

Thank you for your help

Alex

Well you are almost right, this is not only php it is also a bit of
Javascript, I need in fact to be able to pass the
$fields=mysql_f etch_object($da taresults} to a javascript, but I do not
see how I can implement that since I do not know how to pass the result
using php, so in that sens it is also php relevant

creating a javascript portion of a page and populating it with the data
from $fields is no different than creating the select/options from a
resultset.

Spend some time to map out your data flow. where does it come from
(server-side database, client-side selection/entry), where does it go
browser/client,server into database or other processing.

as for the punch, I searched the net but I only get either trivial
results or things that populate a drop down menu (which I already know
how to do) That's why I ask it here

Understanding the data flow above allows you to be a good programmer not
just a copy/paster (while that is not bad, you should not rely on it).
One should also understand the technologies they are using and why they
are using them - there may be other solutions to your problem you/we
have not thought of...
Thanks

[noone]

Krustov wrote:

<comp.lang.ph p , Erwin Moller ,
si************* *************** **...yourself.co m>
<43************ ***********@new s.xs4all.nl>
<Wed, 22 Feb 2006 16:46:51 +0100>

I search all over the web but I could not find it.

Really?
This is quite basic stuff (both in Javascript and PHP) so I wonder why you
didn't find any code that does similar things.
(No punch intended)

Do you ever actually help anybody on here who asks a question .

You only ever seem to comment and give your opinion on 'what' they ask
rather than helping them .

Krustov,

did you ever think that by forcing someone back to the docs or other
research DOES help them to better understand what it is they are trying
to accomplish and maybe - just maybe - learn a lot more than they would
if we just gave some code snippet? (BTW I have seen WAY TOO MANY
questions in some forums that are trying to solve almost an identical
problem - and some in those forums refuse to answer because it is common
knowledge they are trying to solve an assignment from their CIS/IT
professor in school. Solving the problem with a code snippet gains
nothing - understanding the technology gains much knowledge enabling
them to solve more and more complex isssues. Most programmers/IT
professionals are neither programmers or professional... )

I could go on a rant that describes how some generations feel they
"deserve" to be spoon-fed their entire life - but I do not believe this
situation warrants that much effort.

[Erwin Moller]

noone wrote:

Krustov wrote:

<comp.lang.ph p , Erwin Moller ,
si************* *************** **...yourself.co m>
<43************ ***********@new s.xs4all.nl>
<Wed, 22 Feb 2006 16:46:51 +0100>

I search all over the web but I could not find it.

Really?
This is quite basic stuff (both in Javascript and PHP) so I wonder why
you didn't find any code that does similar things.
(No punch intended)

Do you ever actually help anybody on here who asks a question .

You only ever seem to comment and give your opinion on 'what' they ask
rather than helping them .

Krustov,

did you ever think that by forcing someone back to the docs or other
research DOES help them to better understand what it is they are trying
to accomplish and maybe - just maybe - learn a lot more than they would
if we just gave some code snippet? (BTW I have seen WAY TOO MANY
questions in some forums that are trying to solve almost an identical
problem - and some in those forums refuse to answer because it is common
knowledge they are trying to solve an assignment from their CIS/IT
professor in school. Solving the problem with a code snippet gains
nothing - understanding the technology gains much knowledge enabling
them to solve more and more complex isssues. Most programmers/IT
professionals are neither programmers or professional... )

I could go on a rant that describes how some generations feel they
"deserve" to be spoon-fed their entire life - but I do not believe this
situation warrants that much effort.

thx mate. :-)

Erwin

[Erwin Moller]

Alex wrote:

Erwin Moller wrote:

Alex wrote:

Hello list

This question has probably already been asked, but let me ask again

I have a mysql database to which I connect with my php scripts. The
database contains articles. Name, Unit_Price and Reference

Now my client needs to order 5 items, click a button and a table with 5
lines and 3 columns appears (until now easy)

In the first column is a drop down box with a <select > and <options> in
which I store all possible names.

I would like than whenever the client changes one of the boxes (in my
case there are 5) the Unite_Price column and Reference column in the
line he just choose get automatically updated

Are you talking about Javascript here?
Do you want the user to do a select on your page and the page will fill
the appropriate fields? Then go Javascript.

Or do you want to go back to the server if somebody touches the
selectbox? Then it is PHP.
I think you better do this with Javascript.
Try comp.lang.javas cript.

If you want to do it in PHP, well... where to start?
Do you know how to receive a form in PHP? ($_POST[] and the like)
Do you know how to put dynamical data into your html-page with PHP?

If you want to do this in PHP, please be more specific and ask a question
that is answerable instead of the complete solution to a problem nobody
in here knows except you. :-)

I search all over the web but I could not find it.

Really?
This is quite basic stuff (both in Javascript and PHP) so I wonder why
you didn't find any code that does similar things.
(No punch intended)

Good luck.

Regards,
Erwin Moller

Thank you for your help

Alex

Well you are almost right, this is not only php it is also a bit of
Javascript, I need in fact to be able to pass the
$fields=mysql_f etch_object($da taresults} to a javascript, but I do not
see how I can implement that since I do not know how to pass the result
using php, so in that sens it is also php relevant

as for the punch, I searched the net but I only get either trivial
results or things that populate a drop down menu (which I already know
how to do) That's why I ask it here

Thanks

Hi alex, just hang on.
I made something similar (databasemappin g to JS) just one week back, and am
fitting it into an example that I will post soon.

Erwin

[Erwin Moller]

Alex wrote:

Erwin Moller wrote:

Alex wrote:

Hello list

This question has probably already been asked, but let me ask again

I have a mysql database to which I connect with my php scripts. The
database contains articles. Name, Unit_Price and Reference

Now my client needs to order 5 items, click a button and a table with 5
lines and 3 columns appears (until now easy)

In the first column is a drop down box with a <select > and <options> in
which I store all possible names.

I would like than whenever the client changes one of the boxes (in my
case there are 5) the Unite_Price column and Reference column in the
line he just choose get automatically updated

Are you talking about Javascript here?
Do you want the user to do a select on your page and the page will fill
the appropriate fields? Then go Javascript.

Or do you want to go back to the server if somebody touches the
selectbox? Then it is PHP.
I think you better do this with Javascript.
Try comp.lang.javas cript.

If you want to do it in PHP, well... where to start?
Do you know how to receive a form in PHP? ($_POST[] and the like)
Do you know how to put dynamical data into your html-page with PHP?

If you want to do this in PHP, please be more specific and ask a question
that is answerable instead of the complete solution to a problem nobody
in here knows except you. :-)

I search all over the web but I could not find it.

Really?
This is quite basic stuff (both in Javascript and PHP) so I wonder why
you didn't find any code that does similar things.
(No punch intended)

Good luck.

Regards,
Erwin Moller

Thank you for your help

Alex

Well you are almost right, this is not only php it is also a bit of
Javascript, I need in fact to be able to pass the
$fields=mysql_f etch_object($da taresults} to a javascript, but I do not
see how I can implement that since I do not know how to pass the result
using php, so in that sens it is also php relevant

Ok, clear.
So you need data from the database ready-at-hand in a webpage, usable for
javascript? Right?

Here follows a simple example, maybe enough to get you going in your own
situation.

Suppose you have 1 selectbox, and depending on the value the visitor selects
you need to populate a second selectbox.
eg:
[mainselectbox] category
[secondary selectbox] item

You can now simply fill the first selectbox with appropriate options. (You
said you already know how, so I skip that part)

Just add an eventhandler to the select, you'll end up with something like
this (just the html)
<select name="mainselec tbox" onChange="popul ateSecondairy() ;">

Here follows a comple example.
I faked the queryresults to keep things shorter, but if you understand the
used Javascript, you are able to modify it for your own uses.

------------------------------
<?

// fakeresult from databasequery that returned category and items
$rs = array(
"fruit" => array("apple"," banana","pineap ple"),
"books" => array("HitchHik ersGuideToTheGa laxy","Programm ing
Perl","Postgres ql"),
"animals" => array("dog","ca t")
);

?>
<html>
<head>
<title>test</title>
</head>
<body>

<form action="bla.php " Method="POST" name="testform" >
category: <SELECT name="category" onChange="popul ateSecondSelect ();">
<?
foreach($rs as $cat => $items){
?>
<OPTION value="<?= $cat ?>"><?= $cat ?>
<?
}
?>
</SELECT>
<hr>
Item: <SELECT name="item">
<OPTION value="-1">pick category first
</SELECT>
</form>

<script type="text/javascript">
// drop all possible item-values in Object
var category = new Object();

<?
// Create all js-object with their items
foreach($rs as $cat => $items){
// put all $items in JS-readable format.
$JSitems = "";
$itemsWithQuote s = array();
foreach ($items as $oneItem){
$itemsWithQuote s[] = "\"$oneItem \"";
}

?>
category['<?= $cat ?>'] = new Array(<?= implode(",",$it emsWithQuotes) ?>);
<?
}
?>

function populateSecondS elect(){
// get selected category
var selCat = document.forms["testform"].category.selec tedIndex;
var catName = document.forms["testform"].category[selCat].value;

// now repopulate the second selectbox
var refSecond = document.forms["testform"].item;

// remove old options
refSecond.lengt h = 0;

// add new options
var theArr = category[catName];
for (var i=0; i< theArr.length ; i++){
refSecond.optio ns[refSecond.optio ns.length] = new
Option(category[catName][i],"hai");
}

}

</script>

</body>
</html>
--------------------------------------
Hope that helps.

Good luck,
Erwin Moller

[Erwin Moller]

Krustov wrote:

<comp.lang.ph p , Erwin Moller ,
si************* *************** **...yourself.co m>
<43************ ***********@new s.xs4all.nl>
<Wed, 22 Feb 2006 17:35:57 +0100>

> Do you ever actually help anybody on here who asks a question .
>
> You only ever seem to comment and give your opinion on 'what' they ask
> rather than helping them .
Bull. Look around more.
I do actually help people, even this OP, as you could see in the part you
cutted away. Please go insult somebody else, thanks.

Yes i'd say you do help some people .

But would you say that grants you the right to spout drivel at others .

drivel?
Well thanks.

If you don't care for my postings, I suggest you put me on your blocklist. I
couldn't care less.
Most posters I answer appreciate my effort. If you don't: fine with me.

If, however, you don't like my tone, and want to educate me on that: fine
too, really, point taken.

I am here to help people and get help, not to socialize.


No big thing and not the end of the world - but perhaps your forgetting
its not just the person you are replying too that sees it .

So what?
Do you think I am not aware of that?

Seriously: If you think that I for some invalid reason was rude: Sorry for
that. But I don't think I was out of line somewhere.

I am trying to help people in here, and when I see bad questions (which I
see a lot lately) I get irritated.
It seems less and less people know how to post in usenet these days.

Regards,
Erwin Moller