CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Updating record fields after a listbox value change.

Print topic Send  topic

Author Message
aakici


Posts: 49
Posted: 12/05/2004, 3:07 PM

I have a record form. It contains several fields their values come from a MySql database. When i change listbox value other fields are blank. But i want to : when listbox value change all other fields must be updated automatically. An example : my fields are (id, name, surname, telefon number, address, etc). ıd is a listbox. When i change an id from listbox then all other fields must be automatically updated. For example; when i select 21 then name, surname, telefon number and address must be updated as alpaslan, akıcı, 13243546, main street no:29.
_________________
Regards,
M.Alpaslan AKICI
View profile  Send private message
Avenger_iSO
Posted: 12/05/2004, 5:11 PM

HTML code
<SELECT name="" onChange=this.form.submit()>
Damian Hupfeld
Posted: 12/06/2004, 3:36 AM

set the parameters of your grid to id=id
then make the name field required
then on the list box add an action to Client-OnChange of Submit
you will get an error because the name field is required, however it should
also submit the id back to the page which should then populate your fields


regards
Damian Hupfeld
http://www.nexthost.com.au/services.php





"aakici" <aakici@forum.codecharge> wrote in message
news:541b394c264abb@news.codecharge.com...
>I have a record form. It contains several fields their values come from a
>MySql
> database. When i change listbox value other fields are blank. But i want
> to :
> when listbox value change all other fields must be updated automatically.
> An
> example : my fields are (id, name, surname, telefon number, address, etc).
> ıd is a listbox. When i change an id from listbox then all other
> fields
> must be automatically updated. For example; when i select 21 then name,
> surname, telefon number and address must be updated as alpaslan,
> akıcı, 13243546, main street no:29.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

aakici


Posts: 49
Posted: 12/06/2004, 10:37 AM

Thanks. It is ok. Your code is working.
_________________
Regards,
M.Alpaslan AKICI
View profile  Send private message
klwillis


Posts: 428
Posted: 12/06/2004, 12:56 PM

You may find this helpfull. 8-)

http://forums.codecharge.com/posts.php?post_id=53454&s_keyword=Hidden+Field

Quote aakici:
I have a record form. It contains several fields their values come from a MySql database. When i change listbox value other fields are blank. But i want to : when listbox value change all other fields must be updated automatically. An example : my fields are (id, name, surname, telefon number, address, etc). ıd is a listbox. When i change an id from listbox then all other fields must be automatically updated. For example; when i select 21 then name, surname, telefon number and address must be updated as alpaslan, akıcı, 13243546, main street no:29.

_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"

Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006
View profile  Send private message
aakici


Posts: 49
Posted: 01/28/2005, 4:12 PM

answers here are all incomplete or wrong. i found that i have to use html code. like this :
window.location.href = "fatura.php?user_id=" + document.orders.user_id.value ;

and i have to use before show event to fill fields.
_________________
Regards,
M.Alpaslan AKICI
View profile  Send private message
peterr


Posts: 5971
Posted: 01/28/2005, 4:51 PM

Let me just point that similar example was included in the recently released CCS Example Pack 2.
The online version is at http://examples.codecharge.com/CCSExamplePack2/Retrievi...ieldsValues.php

Possibly it works little differently since it retrieves all related textbox values from the database, while I don't know where you were getting your values.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
aakici


Posts: 49
Posted: 01/30/2005, 2:10 PM

I don't see any difference between my and your solution. But, your code solved my another problem. Thanks peterr.
_________________
Regards,
M.Alpaslan AKICI
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.