|
|
Posted by Alex on 02/22/06 19:45
Erwin Moller wrote:
> 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.javascript.
>>>
>>> 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_fetch_object($dataresults} 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="mainselectbox" onChange="populateSecondairy();">
>
> 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","pineapple"),
> "books" => array("HitchHikersGuideToTheGalaxy","Programming
> Perl","Postgresql"),
> "animals" => array("dog","cat")
> );
>
> ?>
> <html>
> <head>
> <title>test</title>
> </head>
> <body>
>
> <form action="bla.php" Method="POST" name="testform">
> category: <SELECT name="category" onChange="populateSecondSelect();">
> <?
> 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 = "";
> $itemsWithQuotes = array();
> foreach ($items as $oneItem){
> $itemsWithQuotes[] = "\"$oneItem\"";
> }
>
> ?>
> category['<?= $cat ?>'] = new Array(<?= implode(",",$itemsWithQuotes) ?>);
> <?
> }
> ?>
>
> function populateSecondSelect(){
> // get selected category
> var selCat = document.forms["testform"].category.selectedIndex;
> var catName = document.forms["testform"].category[selCat].value;
>
> // now repopulate the second selectbox
> var refSecond = document.forms["testform"].item;
>
> // remove old options
> refSecond.length = 0;
>
> // add new options
> var theArr = category[catName];
> for (var i=0; i< theArr.length ; i++){
> refSecond.options[refSecond.options.length] = new
> Option(category[catName][i],"hai");
> }
>
> }
>
> </script>
>
> </body>
> </html>
> --------------------------------------
>
>
> Hope that helps.
>
> Good luck,
> Erwin Moller
Thanks Erwin for the code example, I will try it out and figure how to
make it work.
Ohh, and just to add some oil in the fire. Some people do ask questions
not because they want to solve something that there teacher gave them,
but because he knows that other people are specialists in the field and
hence he will find more easily his answer.
You can ask me anything on quantum communications if you like :) That is
one of the reasons why usenet even exists. To be a big community helping
each other.
Any way thank you a lot Erwin
[Back to original message]
|