查看完整版本: 请求帮忙！！

wilsonlee1987 1-10-2007 01:04 AM

请求帮忙！！

问一下！！
a? P:e&`-VP;U 如果我在一个界面，一直select一个值，而这个值不会变！
"lz'G8T~ 我要怎样去写？用php!!$RVt.VG.EBTt
比如
pZg ?z@ 我选择了第一个Medicine Big的值（注：listbox) u@0m#eYe
然后我按submit的按钮，
u@&HN6P|^8M/vR
9N;W cUi1m u-Fz 过后我下方会显示一个medicine Small的list box
W7_4Le9E q%S;nG*| 当我选择好后，按select button(注：不是上面的submit buttton，是另外一个）
.j1HaeG"ob`s3rBd eXbc1\8nf*E1@
问题来了，就算我不挂南多少次，他都是要显示我之前所选择的Medicine Big的值在我德Medicine Big 的list box那边！wlK\AV5a,h
请问要怎样做? x0FK%vA%AXl

Y'y|7f3M4O"B [[i] 本帖最后由 wilsonlee1987 于 2007-10-1 01:06 AM 编辑 [/i]]

极帝猫 1-10-2007 01:44 AM

老实说，我看不懂你的问题究竟要怎样。。4?7y F*R^Xza*A
可不可以在举个更具体的例子。。＝＝＋？L$u!z*?7lQI\R
Q%iaDN[)^
你选了 medicine big，按 submit 了之后会出现 medicine small。,IPm8{5n-|F"rw*`
你选了 medicine small，按 select 了之后是要得到什么？

wilsonlee1987 1-10-2007 02:00 AM

回复 沙发 神仙猫 的帖子

当我选了 medicine small，按 select 了之后，l} I9i*lh:moBN
上面的medicine big的值还是focus在我之前选的值！！g6I b;_ Aq:c
而且还可以抓到的那种！！N'hm6P4S

a |A:X9V_ 还有最重要是我不管按多少次medicine small的select，上面的medicine big的值还是focus在我之前选的值！！

极帝猫 1-10-2007 08:09 AM

那为什么要那么麻烦选了 Medicine Big 之后要按 submit 才选择 Medicine small ？Q5\%@6Q Gx
把两个 listbox 都放在同一页不是更简单吗。。？3H*a4NE,Ww U
:ONI71: :ONI71:

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼 神仙猫 的帖子

我也想啊！！j"U,ZSp O;C
但是我现在做的是分配药物的部分！！
PR;sum2{&a^ 所以我一定要先抓到大个容量的药物，才可以知道小个分量药物到底有没有存在再stock里面！
Q3V H]!z&sXr |8i 如果有，我才可以选择小个药物里面的东西！m!J4kg4Q0N*R

(C&H*D%sYv[ 像在目前为止，我想到一个方法，就是用session来存id,不懂这个行得通吗！！
Y@%j7~t^,Pmj 问一下！

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼 神仙猫 的帖子

我也想啊！！
^%@^7J#Dy8XWAOD 但是我现在做的是分配药物的部分！！
t)IQ4^vI(P"F;j 所以我一定要先抓到大个容量的药物，才可以知道小个分量药物到底有没有存在再stock里面！
sI.Fj"^X GIt#X 如果有，我才可以选择小个药物里面的东西！
(L}5y]6F9O4d;iR
/Jn(V^D1M^ Z!]} 像在目前为止，我想到一个方法，就是用session来存id,不懂这个行得通吗！！6Rm4_$w`j5m
问一下！

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼 神仙猫 的帖子

我也想啊！！
.YW1EL:p4mxu0F 但是我现在做的是分配药物的部分！！}+Z/xEc R4]d k
所以我一定要先抓到大个容量的药物，才可以知道小个分量药物到底有没有存在再stock里面！
"z#D8?-Ti UU$Zs y|B 如果有，我才可以选择小个药物里面的东西！5| HLV,_"A7J M

Ae|T0u6d 像在目前为止，我想到一个方法，就是用session来存id,不懂这个行得通吗！！rK@DJ5Uf`7z"K
问一下！

极帝猫 1-10-2007 09:50 AM

先问你，你的东西有存在 database 吗？

只對你說我愛你 1-10-2007 09:01 PM

[quote]<html>
L;NBB1x1Z!X P9xm <head>
`8y:l A5j DC/L -Pa'oP5dE5i4G
<script language="JavaScript">
a \)L]Ln[1u <!--5Z kO;F:f(Y${%S#E
//==================== for zip code begin =========================4mnJ_c.mU
County = new Array("台北市","基隆市","台北縣","宜蘭縣","新竹市","新竹縣","桃園縣","苗栗縣","台中市","台中縣","彰化縣", "南投縣","嘉義市","嘉義縣","雲林縣","台南市","台南縣","高雄市","高雄縣","澎湖縣","屏東縣","台東縣","花蓮縣", "金門縣","連江縣","南海諸島","釣魚台列嶼","外國");//全省各縣市
x,s.r-K9QJrK Zone = new Array(28);
0b-V'Ac9j w8L Zone[0] = new Array("中正區","大同區","中山區","松山區","大安區","萬華區","信義區","士林區","北投區","內湖區","南港區","文山區(木柵)","文山區(景美)");//台北市
z F~:ff6|dc Zone[1] = new Array("仁愛區","信義區","中正區","中山區","安樂區","暖暖區","七堵區");//基隆市
H1fR#d a]Z Zone[2] = new Array("萬里鄉","金山鄉","板橋市","汐止市","深坑鄉","石碇鄉","瑞芳鎮","平溪鄉","雙溪鄉","貢寮鄉","新店市", "坪林鄉","烏來鄉","永和市","中和市","土城市","三峽鎮","樹林市","鶯歌鎮","三重市","新莊市","泰山鄉","林口鄉", "蘆洲市","五股鄉","八里鄉","淡水鎮","三芝鄉","石門鄉");//台北縣
-N{ } [4o ~ Zone[3] = new Array("宜蘭市","頭城鎮","礁溪鄉","壯圍鄉","員山鄉","羅東鎮","三星鄉","大同鄉","五結鄉","冬山鄉","蘇澳鎮","南澳鄉");//宜蘭縣
t)Uo j%\8k r2E Zone[4] = new Array("");//新竹市`"k/U-\9V-~)Y5j?`(p
Zone[5] = new Array("竹北市","湖口鄉","新豐鄉","新埔鄉","關西鎮","芎林鄉","寶山鄉","竹東鎮","五峰鄉","橫山鄉","尖石鄉","北埔鄉","峨嵋鄉");//新竹縣
X o` Rd/[:j Zone[6] = new Array("中壢市","平鎮","龍潭鄉","楊梅鎮","新屋鄉","觀音鄉","桃園市","龜山鄉","八德市","大溪鎮","復興鄉","大園鄉","蘆竹鄉");//桃園縣_0]|\4[Z
Zone[7] = new Array("竹南鎮","頭份鎮","三灣鄉","南庄鄉","獅潭鄉","後龍鎮","通霄鎮","苑裡鎮","苗栗市","造橋鄉","頭屋鄉", "公館鄉","大湖鄉","泰安鄉","鉰鑼鄉","三義鄉","西湖鄉","卓蘭鄉");//苗栗縣z%O-w2T~Xa y
Zone[8] = new Array("中區","東區","南區","西區","北區","北屯區","西屯區","南屯區");//台中市
%p aI/g:o^!P Zone[9] = new Array("太平市","大里市","霧峰鄉","烏日鄉","豐原市","后里鄉","石岡鄉","東勢鎮","和平鄉","新社鄉","潭子鄉", "大雅鄉","神岡鄉","大肚鄉","沙鹿鎮","龍井鄉","梧棲鎮","清水鎮","大甲鎮","外圃鄉","大安鄉");//台中縣+qP3fU'D%o
Zone[10] = new Array("彰化市","芬園鄉","花壇鄉","秀水鄉","鹿港鎮","福興鄉","線西鄉","和美鎮","伸港鄉","員林鎮","社頭鄉", "永靖鄉","埔心鄉","溪湖鎮","大村鄉","埔鹽鄉","田中鎮","北斗鎮","田尾鄉","埤頭鄉","溪州鄉","竹塘鄉","二林鎮", "大城鄉","芳苑鄉","二水鄉");//彰化縣
x_N#Z-o!n P Zone[11] = new Array("南投市","中寮鄉","草屯鎮","國姓鄉","埔里鎮","仁愛鄉","名間鄉","集集鄉","水里鄉","魚池鄉","信義鄉","竹山鎮","鹿谷鄉");//南投縣4`3?Q b)FS]eA0g
Zone[12] = new Array("");//嘉義市]^y9M!w(]BR
Zone[13] = new Array("番路鄉","梅山鄉","竹崎鄉","阿里山鄉","中埔鄉","大埔鄉","水上鄉","鹿草鄉","太保市","朴子市","東石鄉 ","六腳鄉","新港鄉","民雄鄉","大林鎮","漢口鄉","義竹鄉","布袋鎮");//嘉義縣
%}sa)rY Zone[14] = new Array("斗南市","大埤鄉","虎尾鎮","土庫鎮","褒忠鄉","東勢鄉","台西鄉","崙背鄉","麥寮鄉","斗六市","林內鄉", "古坑鄉","莿桐鄉","西螺鎮","二崙鄉","北港鎮","水林鄉","口湖鄉","四湖鄉","元長鄉");//雲林縣$pf| [hG7DK"f
Zone[15] = new Array("中區","東區","南區","西區","北區","安平區","安南區");//台南市U(HBv$ia0g
Zone[16] = new Array("永康市","歸仁鄉","新化鎮","左鎮鄉","玉井鄉","楠西鄉","南化鄉","仁德鄉","關廟鄉","龍崎鄉","官田鄉", "麻豆鎮","佳里鎮","西港鄉","七股鄉","將軍鄉","學甲鎮","北門鄉","新營市","後壁鄉","白河鎮","東山鄉","六甲鄉", "下營鄉","柳營鄉","鹽水鎮","善化鎮","大內鄉","山上鄉","新市鄉","安定鄉");//台南縣
!UwNcf~W'X Zone[17] = new Array("新興區","前金區","苓雅區","鹽埕區","鼓山區","旗津區","前鎮區","三民區","楠梓區","小港區","左營區");//高雄市~O1q4]-y!\qi SD
Zone[18] = new Array("仁武鄉","大社鄉","岡山鎮","路竹鄉","阿蓮鄉","田寮鄉","燕巢鄉","橋頭鄉","梓官鄉","彌陀鄉","永安鄉", "湖內鄉","鳳山市","大寮鄉","林園鄉","鳥松鄉","大樹鄉","旗山鎮","美濃鎮","六龜鄉","內門鄉","杉林鄉","甲仙鄉", "桃源鄉","三民鄉","茂林鄉","茄萣鄉");//高雄縣6v {)wj7I p`Q
Zone[19] = new Array("馬公市","西嶼鄉","望安鄉","七美鄉","白沙鄉","湖西鄉");//澎湖縣
z;oPk3C#X2A*E Zone[20] = new Array("屏東市","三地門鄉","霧台鄉","瑪家鄉","九如鄉","里港鄉","高樹鄉","鹽埔鄉","長治鄉","麟洛鄉","竹田鄉 ","內埔鄉","萬丹鄉","潮州鎮","泰武鄉","來義鄉","萬巒鄉","嵌頂鄉","新埤鄉","南州鄉","林邊鄉","東港鎮","琉球鄉 ","佳冬鄉","新園鄉","枋寮鄉", "枋山鄉","春日鄉","獅子鄉","車城鄉","牡丹鄉","恆春鎮","滿州鄉");//屏東縣,B\D2u1P6S&F
Zone[21] = new Array("台東市","綠島鄉","蘭嶼鄉","延平鄉","卑南鄉","鹿野鄉","關山鎮","海端鄉","池上鄉","東河鄉","成氐","長濱鄉","太麻里鄉","金峰鄉","大武鄉","達仁鄉");//台東縣p0^ E t5g&I
Zone[22] = new Array("花蓮市","新城鄉","秀林鄉","吉安鄉","壽豐鄉","鳳林鎮","光復鄉","豐濱鄉","瑞穗鄉","萬榮鄉","玉里鎮","卓溪鄉","富里鄉");//花蓮縣
I9LA9~){ Zone[23] = new Array("金沙鎮","金湖鎮","金寧鄉","金城鎮","烈嶼鄉","烏坵鄉");//金門縣
F_"U1[s0WD(k3t Zone[24] = new Array("南竿鄉","北竿鄉","莒光鄉","東引");//連江縣
FC\$X"c,IC Q4z Zone[25] = new Array("東沙","西沙");//南海諸島8@+]3`vl'I/{4~:j
Zone[26] = new Array("");//釣魚台列嶼]Y8uU,Y P;m
Zone[27] = new Array("");//外國Qy9r%L(C!B v:AlQ
ZipCode = new Array(28);
Q&` nu!E:NE8~H ZipCode[0] = new Array("100","103","104","105","106","108","110","111","112","114","115","116","117");//台北市
\W;LT9^ ZipCode[1] = new Array("200","201","202","203","204","205","206");//基隆市U1Z/Pb0~2O2c MAN
ZipCode[2] = new Array("207","208","220","221","222","223","224","226","227","228","231","232", "233","234","235","236","237","238","239","241","242","243","244","247","248", "249","251","252","253");//台北縣
'N||lGYY$Bx ZipCode[3] = new Array("260","261","262","263","264","265","266","267","268","269","270","272");//宜蘭縣
%[{s^%TVr ZipCode[4] = new Array("300");//新竹市
C4LH"B/cj ZipCode[5] = new Array("302","303","304","305","306","307","308","310","311","312","313","314","315");//新竹縣!b/Qgu4B%g s
ZipCode[6] = new Array("320","324","325","326","327","328","330","333","334","335","336","337","338");//桃園縣q&uk*c*o)i[N"l
ZipCode[7] = new Array("350","351","352","353","354","356","357","358","360","361","362","363", "364","365","366","367","368","369");//苗栗縣*Glo4{R
ZipCode[8] = new Array("400","401","402","403","404","406","407","408");//台中市
)I Mp { [&pr ZipCode[9] = new Array("411","412","413","414","420","421","422","423","424","426","427","428", "429","432","433","434","435","436","437","438","439");//台中縣A,V Vl4q1\~(q@
ZipCode[10] = new Array("500","502","503","504","505","506","507","508","509","510","511","5112", "513","514","515","516","520","521","522","523","524","525","526","527","528", "530");//彰化縣
6~bs7o f(y,H%d[ ZipCode[11] = new Array("540","541","542","544","545","546","551","552","553","555","556","557","558");//南投縣
kI'c;}d'_9|)U ZipCode[12] = new Array("600");//嘉義市
M3Y&OWf:Hx*X} ZipCode[13] = new Array("602","603","604","605","606","607","608","611","612","613","614","615", "616","621","622","623","624","625");//嘉義縣
0lR"tE6U-z Z,pQ-F ZipCode[14] = new Array("630","631","632","633","634","635","636","637","638","640","643","646", "647","648","649","651","652","653","654","655");//雲林縣
%] z7{!i1}H ZipCode[15] = new Array("700","701","702","703","704","708","709");//台南市
m*{X)yt)SX ZipCode[16] = new Array("710","711","712","713","714","715","716","717","718","719","720","721", "722","723","724","725","726","727","730","731","732","733","734","735","736", "737","741","742","743","744","745");//台南縣 jxM\6S@%}V
ZipCode[17] = new Array("800","801","802","803","804","805","806","807","811","812","813");//高雄市[ J^hm#c d1B
ZipCode[18] = new Array("814","815","820","821","822","823","824","825","826","827","828","829", "830","831","832","833","840","842","843","844","845","846","847","848","849", "851","852");//高雄縣
WU$|0RfU*y9t ZipCode[19] = new Array("880","881","882","883","884","885");//澎湖縣
:S&XQ*DX#K&c ZipCode[20] = new Array("900","901","902","903","904","905","906","907","908","909","911","912", "913","920","921","922","923","924","925","926","927","928","929","931","932", "940","941","942","943","944","945","946","947");//屏東縣
$l)o(|a2FM ZipCode[21] = new Array("950","951","952","953","954","955","956","957","958","959","961","962","963","964","965","966");S8[1V u8W Se
ZipCode[22] = new Array("970","971","972","973","974","975","976","977","978","979","981","982","983");//花蓮縣9M g,ii7M/x
ZipCode[23] = new Array("890","891","892","893","894","896");//金門縣
*uQ/y{L ZipCode[24] = new Array("209","210","211","212");//連江縣
+|)h|0a.oR&J"q] ZipCode[25] = new Array("817","819","290");//南海諸島
AL3[8Jj:n`/u#Q4f ZipCode[26] = new Array("290");//釣魚台列嶼7c.]0c1eN:d2F,_|
ZipCode[27] = new Array(" ");//外國
(v2LEqc*g{(R(Q
%j,d y2`O vU [/quote]
P4\#F(B9a\"Mu aJc] {.[KH
显到暴 多过一万 你自己接下面的

只對你說我愛你 1-10-2007 09:01 PM

function initCounty(countyInput) {6iS!I9D*^geLj
countyInput.length = County.length;
lL;jSD;sg6Zt for (i = 0; i < County.length; i++) {
0[+md4c'Q0d&A countyInput.options[i].value = County[i];Qm\m[$b^'^&S3LC
countyInput.options[i].text = County[i]; fn*u;J#? D!^]
}#j i T{TJmv(@7?
countyInput.selectedIndex = 0;
z.GE/Y~oo!C }aDv+~/sX
+p_x({8{1K7zRWm Q;l
function initZone(countyInput, zoneInput, post){
K:O}U-P$dju changeZone(countyInput, zoneInput, post);
Ik `UD/U/yF } OP I,D&HKD)\-V d

$Wk}6ukA.l function changeZone(countyInput, zoneInput, post) {nIStQ$\V
selectedCountyIndex = countyInput.selectedIndex;
$^,z ] zs.D9@e8M 3uB"L,k;JS%l
zoneInput.length = Zone[selectedCountyIndex].length;
,E!l OX,FPY:{ for (i = 0; i < Zone[selectedCountyIndex].length; i++) {)o\/q,~#L#Qj8d w
zoneInput.options[i].value = Zone[selectedCountyIndex][i]; HOo:C`'F;Q*E
zoneInput.options[i].text = Zone[selectedCountyIndex][i];
\a | V6g!d"Wv3S+l@/C if (zoneInput.options[i].text == "松山區")2X4T*T2e0O
zoneInput.options[i].selected = true;
#PFa!k-sJ4A }
7y!r7ze v/EAb //zoneInput.selectedIndex = 0;
*a^D!u FB L
u4i2zRq"eD2U showZipCode(countyInput, zoneInput, post);y(h1jH;U9kY hz
}
)][1j(y/}'g G&{y&G~
function showZipCode(countyInput, zoneInput, post) {
,IKJ8["~0h5M2})Y post.value = ZipCode[countyInput.selectedIndex][zoneInput.selectedIndex]; S'ExQU&n
}
I$Xe5A:dEQ$E
5D4[ u!\b function showZone(countyInput,zoneInput,post){
];x"r-~w _ var k=0;l=0;
_1I5^6]X]q.n for (i=0; i < ZipCode.length; i++) {#dP7a+^'uh
for (j=0; j < ZipCode[i].length; j++) {(_"~%F%w o \k
if ( post == ZipCode[i][j] ) {G.zz%R&un%f
countyInput.length = County.length;8@ZN$U~ |+vy%~
for (k = 0; k < countyInput.length; k++) {
'O Z9W/\(r;H9`*y` countyInput.options[k].value = County[k];/~*~j-F-l,mdz
countyInput.options[k].text = County[k];
:q5H h{psn8k } Y if (County[k] == County[i]) {
9b+O)fE1v&t } M*V2{ S countyInput.options[k].selected = true;
@2T"opD F }
u[7U7}o/x] }]1Q,K ^jmDY
8{r8O0vMPM;M
zoneInput.length = Zone[i].length;G4v mVs9K
for (l = 0; l < zoneInput.length; l++) {}}j2O:i%J2Q&@
zoneInput.options[l].value = Zone[i][l];2g:Ctro$Nx
zoneInput.options[l].text = Zone[i][l];[c [/[s#]Rf
if (zoneInput.options[l].text == Zone[i][j]) {v.nP$vg*Z5~
zoneInput.options[l].selected = true;
9e.}4r(~3@ J:@ }}moH,g'XZV
}u'j$T#t@J~)x$ha+L
return;
#K1Q$CF:R'{^c{5n }8R dd[n9a1a
}
+E;?V-h;f!a }7G0t?(R:|bo;k
// alert(k+'無此郵遞區號'+l);post='105';ResetAll();return; mFKM2f WT3n&{
}
to@hCwYp(C
4[ g&y9A/J7dI$J W2S$x function showZone1(post){//郵遞區號 轉 地名UNmT T]&uY
for (i=0; i < ZipCode.length; i++) {
N8{7^4F E0V&i!gTK for (j=0; j < ZipCode[i].length; j++) {F;F"fczj/Y&f9|
if ( post == ZipCode[i][j] ) {
9|5nR(w5Qy^V(H document.write(County[i]+Zone[i][j]);return;#RuP&E|~P!@]C#`%J-P
}
V6?3k1I'x }
:w-U'eV+c}cr }
eb8JJ!\ x3pY2m X }(eIZ;WX/db"q#c
//==================== for zip code end =========================$S:L5Qw)kjK1a0d
-->F0{&P c2hd+C#tbz
</script> M.t&hr4zOsm
</head>
4u$Fmd'v <body bgcolor="#FFFFFF" topmargin="0" marginwidth="0" marginheight="0">
\:~Y)J D y7Z <form method="post" action="" name="mgr" >
z3C1hWxVi7` <table>
FC6u$zH'm8{ <tr>Mu8t%T!r{(y@6Sl_
<td nowrap colspan="4"><font color="#0000CC">地　　址

只對你說我愛你 1-10-2007 09:02 PM

[php]<script language="JavaScript" TYPE="text/javascript">
r qu'dFK9La <!--
&o.d1Q Nm3y 1u1Dx:W9DS
//==================== for zip code begin =========================
.h'kRs5dYw/o <?
Y]Ih4@n k1B s%\+lR0B[
        while($row4=mysql_fetch_row($result4))%S t*U%\1t)n {pq
        {
,VUB&f7y2m.a9qc;t                 $printOut = $printOut . $row4[1].'", "';       
9VdU)c k!H/|2f2L/IW         }
y;rh;v}5HG'd         mysql_free_result($result4);
Bqpp?\5l         $printOut2= "".'", "'.$printOut;
+Z1|T'g dVJ ?>
B0}Xa*o$De"k,x[ ] | County = new Array("<?=$printOut2?>");} by&jQ,j

3HR5jfgLK4~ <?7w#~p+zcw*~]
       
"E&O J8i `         while($row=mysql_fetch_row($result))
$XDW0^ ^*j6Y-d         {+I,?Tmj
                //print_r($row[1]);
/] S+s'E{IT-[         $count ++;'} Iw8kd$k ~Z
        }        N$m:n;\j5_ T ~
        mysql_free_result($result);
;v'|.H(bS {6?dhy         $count;8j] D? TPx8as2_BSZ
?>
2l(eZB] }Rf
_:Aver9Z'tq$e4d#T
3t2\w cMhA9X         Zone = new Array(<?=$count?>);
IfRV$a};]         Zone[0] = new Array("");
:^Jej ]        
S1M%t.P$L}A$R <?        [2Cu kF
        $i=1;
s1COj/O2X#Z         while($row2=mysql_fetch_row($result2))M[.h:e+y.sgW\M
        {        //print_r($row2);3X U@FRJ
                if($row2[7]!=null);|;CpEq
                {3i1f"B{:|!nP
?>               
aH]]JP}                 Zone[<?=$i?>] = new Array("<?=$row2[2]?>","<?=$row2[6]?>","<?=$row2[7]?>");0A5kb5o!X o$]&O
<?                1V&Kc4c.H
                }q,l0L'D0m_l%V
                else if($row2[6]!=null),xIr w0Ntf9H
                {
,VSJXP"RqF{"] ?>                b+Z2pE(H6?
                Zone[<?=$i?>] = new Array("<?=$row2[2]?>","<?=$row2[6]?>");
$h^-\!i"T3d:G\1_!X <?               
.DB)u'Ab e                 }
Mh2k5a)v:};@!}n:W                 else if($row2[6]==null)?l s0\X
                {
'OsCnIn^k+}O U ?>                0Qx(P#Rk
                Zone[<?=$i?>] = new Array("<?=$row2[2]?>");
*W nk @ Uu <?               
%O m~EPAb                 }                                        }7BL.O#j+gpmfpH
                else if($row2[7]==null)
&DI1[0f2Ek`9L                 {/l A:g.qNCS
?>               
N/}F%xF(J:x ~#]                 Zone[<?=$i?>] = new Array("<?=$row2[2]?>","<?=$row2[6]?>");
.^m(EDv(c \X\~6C <?                :d0X7I P%h?
                }                                        Ox^?!J
                $i++;|eL5Nz^2f KD
        }
Q|c"bBnK         mysql_free_result($result2);
wHAQ`i'g6N,T        
:WO'L0f._ \| ?>       
,r5HeJk0ce
:La dVDs:l!P
c`X b'}~         ZipCode = new Array(<?=$count?>);Vtp h6S
        ZipCode[0] = new Array("");
D IhZhG <?       
(D!r4o"MF         $j=1;mA4Q A6BH ~.V
        while($row3=mysql_fetch_row($result3))3G8|u2\4w/X{
        {)Ec l nA
                if($row3[9]!=null)^Y4VVT:OGM
                {Y'yc!{ T
?>                       
{5Nv]A5UK.O                 ZipCode[<?=$j?>] = new Array("<?=$row3[3]?>","<?=$row3[8]?>","<?=$row3[9]?>");.tR8G9R'|{`c
<?               
/{.Hf"}gGO0[                 }
zNF5Bj,?@'_                 else if($row3[8]!=null)
1D+X-}~(P^                 {
sZh!p/BY5q4C ?>                        0cV&c(f znn
                ZipCode[<?=$j?>] = new Array("<?=$row3[3]?>","<?=$row3[8]?>");
2l!Z/]pc-U0p <?                $fm2{t7Y${.G1u^Z~
                }               
g3y |D q:q@#K                 elseif($row3[8]==null)j{v| jW/u0a
                {
K Zkg_*i` ?>                       
.n i!@y _                 ZipCode[<?=$j?>] = new Array("<?=$row3[3]?>");
H^\#t"K1N"K <?               
6\c]y y{+xA#xC                 }P+NQ5cW d$o/O0H.ll c
                else if($row3[9]==null)
,k _y2E$}1Hg1vf                 {
HD&S*h\ ?>                       
*uC i#uV],@YV0I                 ZipCode[<?=$j?>] = new Array("<?=$row3[3]?>","<?=$row3[8]?>");
jA(Rox*e <?                EX8mO DTr
                }                                                                               
7Q BT/YHri!d?                 $j++;
/~*b"t0O(za6nL k`S         }cx3y$FT Q
        mysql_free_result($result3);hYwn7|O"Wk1y:`
bS!rYj g
        O"vM_`M5Q
?>c9V2lhg&x-x$R
function initCounty(countyInput){}-~#fOh;Y|
        countyInput.length = County.length;
[3@"Y`Z!QHrW         for (i = 0; i < County.length; i++) {%C+? ze Zj(kqpM
                countyInput.options[i].value = County[i]; zE0K]0a
                countyInput.options[i].text = County[i];
2HajT6\5{ R         }
.S @,XQJjD         countyInput.selectedIndex = 0;+JVA$B;F*g-kY4\3s-y
}
-m8huN,P!e -F4S:N _}z
function initZone(countyInput, zoneInput, post ,address, countyindex){
vh'WSbA         changeZone(countyInput, zoneInput, post , address, countyindex);T4R-?;S3@.|7N.G}
}{$I$q-?Qi0u-wA
2f Uy5[J ]\

'x8[]Y6G[Z7y !M#BhUo(oSa
function changeZone(countyInput, zoneInput, post ,address, countyindex) {xTJ6kD4r
        selectedCountyIndex = countyInput.selectedIndex;)?%H7B;j |4R9jA
U6c4v\9[(Z\ @
        zoneInput.length = Zone[selectedCountyIndex].length;*l!iUbc
        for (i = 0; i < Zone[selectedCountyIndex].length; i++) {2L&y/Ih(Dp"\
                zoneInput.options[i].value = Zone[selectedCountyIndex][i];(m0MC6nd+u
                zoneInput.options[i].text = Zone[selectedCountyIndex][i];
)w2Ks1O-HV                 if (zoneInput.options[i].text == "松山區")
M_)Hxwr7M ?5sS                         zoneInput.options[i].selected = true;
-Y&l%V"Y!W;]-j         }
e"}$v GY O         //zoneInput.selectedIndex = 0;       
[&I0u(jr@0jFu         showZipCode(countyInput, zoneInput, post ,address ,countyindex);
Yv6n9tq#^.H }Go$}/J6fh
;G@/[zP
function showZipCode(countyInput, zoneInput, post ,address, countyindex) {?Ap;m~:Tj6M\
        post.value = ZipCode[countyInput.selectedIndex][zoneInput.selectedIndex];
*h7y[.N0`N9k'o'A3V         updateaddress(countyInput, zoneInput, address, countyindex);
'KY zDE`}4y }
.\6zE6VUG3S'u D0^O X} 0D*yT}|%Ck%e
function updateaddress(countyInput, zoneInput, address, countyindex) {:}9i ei v;\/mX
        address.value = countyInput.options[countyInput.selectedIndex].text + zoneInput.options[zoneInput.selectedIndex].text ;Q o8fM ]#~
        countyindex.value = countyInput.selectedIndex+1 ;
M"y8U:Q-|!o#`fO2C)R }
7V*s/j w+OF *x |1g'zoha

$qp8?/bR p //==================== for zip code end =========================I;m r/ejkq
n]&cbF&h.u0D!k
        function ok(post)                {       
M z3e4^6I(A{;?                 window.opener.document.theForm.zipcode.value = post.value;SADWB!H
                alert("您的郵遞區號是"+post.value+"  已經幫您填好了");
Q,B0{S];lA&C%u //                window.close();'i-Qr_ S`%m
        }
,A b*@,E x:c!F        
? s0z-t@q#_         function ok2(post,address)                {        9hu.edC%s
                window.opener.document.forms[0].zipcode.value = post.value; b xF k-[5Ch]P
                window.opener.document.forms[0].address.value = address.value + window.opener.document.free2.address.value;xg-r:gZ#oQ
                alert("您的郵遞區號是"+post.value+"  已經幫您填好了");
(o3MftGop*tO                   window.close();#xe%mL R VR8f O4w^v
        }
9N,Q&?C Z%B         1`P^2u0YlIIL~
        function ResetAll()                {[ @*`/w5yBB
                initCounty(document.zipForm.countyText);.P)]-u'YGDy\ r
                initZone(document.zipForm.countyText, document.zipForm.area, document.zipForm.zipcode, document.zipForm.address, document.zipForm.county); U+C6`` u
        }N|JU&B
kug1S8_:XZ
        ResetAll();M4['Ne6sV^;p
hQC(`c,K
// -->7NQ_z%tc

A n,l3m0M9V,C/| </script>:Y2F&W|Z
-W r W[xn@iLK
<script language="JavaScript" TYPE="text/javascript">a"uN)v~zy'L
                function req(myField, myLabel) Aw![ jjQ`w
                {
9c*O4e{.Igy-?~|                         var result = true;
6|G:GM6}T_l                         if (myField.value == "")
Z3w/u uq)bQ.B4l                         {
m Y \4fr$^M ]                                 alert('Please enter a value for the "' + myLabel +'" field.');`9g2i'I'EO'gg
                                myField.focus();n&^ J'w@!G&X
                                result = false;|/q&n7t8o7U2FDc
                        }
X#k"g5Q A `WA                         return result;$sI7qN1G)G+i;Q
                }
W| L7yx3F#W1} e
&d H,d}uP                 function valform(myform)
tLf(D2n/c Y                 {RXz2fq8e I
.e1X#tv.CN8jcQ
                        if ( !req(myform.countyText, "Company Name")|| !req(myform.day0, "Day")||!req(myform.month0, "Month")||!req(myform.year0, "year")||!req(myform.sumtotal, "Total"))D3T'ePs
                        {
["sIRE$b+Ak#l                                 return false;
xoY(tW2h5QYgc0I                         }~r'aq#G0hY
                        else D']rAu5O~B"xR
                        {
Rg*] I0J!Q                                 return true;uX+L.H:_7rx
                        }dh~,fNM
                }4}(g S&l-j,?q2X~
               
b'kZA;`%K']$soX </script>[/php]
Xs/C5l$z Z @#Wn3l i P0Is})q)v
我自己改PHP:$ 不懂是不是你要的

wilsonlee1987 2-10-2007 03:35 PM

回复 8楼 神仙猫 的帖子

我的东西是有存在database 的！！
?yoYZ!f)L h
|#z:j!^$v3{@-H 不实在array的！

wilsonlee1987 2-10-2007 03:55 PM

我的code!!:St vXl7U

]0I?T.[ Rs3x <?php
coH [3v&[ AVB include ("session_judge.php");
Sg dG~ include ("connect.php");2m.s0BQ t}lG/a!l
o?1TE2uh"U2[$p
        if (isset($_POST['assign']))
6Dt]]W         {G~6hKg
                $getlastBigID=$_POST['lastbigId'];
5Z!N,E9S-YUkL3D                 $getlastSmallID=$_POST['lastsmallId'];
LYr1U%z\1H zi                 $getquantity=$_POST['bigquantity']; C2f)F4Jzw2Te&gbT

t:JJ+go3S                 $updateBig=mysql_query("SELECT * FROM medicinebig WHERE Medicine_Id = '$getlastBigID'")or die ("Can not Select MedicineBig!".mysql_error());
h ?ZQSJ&VU                 if(mysql_num_rows($updateBig)>0)-HG+C t Y]
                {
8t _/O [8[ D9o8Q|                         $upBig=mysql_fetch_array($updateBig);
{QfH4F-[+\                 2I]GR/\u I
                                $selectBigQuantity=$upBig['Quantity'];
~j#\/^_Co6LF                                 $selectBigWeight=$upBig['WeightBig'];
1yfv,n9G!By(To                                 $selectBigIncomeDate=$upBig['Income_Date'];
6|%oj,_#a!C                                 $selectBigExpiredDate=$upBig['Expired_Date'];
*n&V@y+w]/_J%?
X$V&r})m$ffa3k                         $updateSmall=mysql_query("SELECT * FROM medicinesmall WHERE S_Medicine_Id = '$getlastSmallID'") or die ("Can not Select Medicine Small!".mysql_error());
1w c` c;SoR%Ig4j,z                         if(mysql_num_rows($updateSmall)>0)m$Q/|:PB B!\Q
                        {n5Hq |^2I
                                $upSmall=mysql_fetch_array($updateSmall);
4Q5NV-@6l$T^ Nr4fa                                
Ga9vV+^,^Ub                                 $selectSmallWeight=$upSmall['Weight_Small']; O3L;oP8Fr*] P ir&^5d
                                $selectSmallQuantity=$upSmall['Quantity'];)\|y_b@Lrm
                                echo $selectSmallWeight; {y6L-Va1G R
~@c%u&z
                                $reQuantity=$selectBigQuantity-$getquantity;
-N6@,d'B-C j+\mx                                 $calWeight=$getquantity*$selectBigWeight;
Q4i#E.Whc;H                                 $calSmallQuantity=$calWeight/$selectSmallWeight;/B7e,{xY
                                $finalSmallQuantity=$calSmallQuantity+$selectSmallQuantity;'Ck"dP.M^*rOT

lr1J:|8h@                                 $updateMedicineBig=mysql_query("UPDATE medicinebig SET Quantity ='$reQuantity' WHERE Medicine_Id ='$getlastBigID'")or die ("Can not update Medicine Big Quantity!".mysql_error()); E [Wa @k#t
{o h h0w

S r%|vg g@ A5]                                 $updateMedicineSmall=mysql_query("UPDATE medicinesmall SET Quantity = '$finalSmallQuantity', Income_Date='$selectBigIncomeDate', Expired_Date='$selectBigExpiredDate' WHERE S_Medicine_Id = '$getlastSmallID'")or die ("Can not update Medicine Small Quantity!".mysql_error());
IMIz#LP SA:rsi
                                echo "<script>alert('Assign Medicine Successfully!')</script>";O4i pJX}h [
                                echo "<script>window.location='AssignMedicine.php'</script>";}/@.t&r,^z"R
                        }
]\#Cx)X7RB w4Z2TP$ZKS.k
                }J,g%leC b
RC|LY W!O+}M,F
        }2gJwG5o&tm~3h r

Wux1i[JH\-yu "nSr ]E~ r+dc
?>
2N P6e)O,v0D <html>
$ny#xB,x:k <head>
o!\j3o8R%\gSqo <title>Pediatric Clinic System - Assign Medicine System</title>,yX!H/m:N ~u Wx ng
<link rel="stylesheet" type="text/css" id="css" href="./css.css">e&PG(K-M*Y~ e5t
<script type="text/javascript" src="./menu.js"></script>
#D4HUX3Q'PW1r"l#s <SCRIPT LANGUAGE="JavaScript">
H;C&AoNWm:~9L <!--
-P'S_3n$J-N6o z function ValidatorForm(theForm)
?,Y?0@,Y1BSihi {/b4g'O7_[,k K!@
        if (theForm.bigquantity.value == "")C"L#aMb\
        {
|1X+|YF\*^                 alert('The Assign column can not be blank!');
JbX"wsy                 theForm.bigquantity.focus();
X"W-cU.ada;f4gEHC                 return(false);
N:gLjn         }
Q:?7n)W z'WA~ }VH%` T#N!V
//-->
T"k.[0GL'p$H </SCRIPT>;A6G5DV6wHz
</head>
N jY;j{ }Z <body>
qV z0N|1A <hr>-b6Xk+jCP:A&X
<h1>Assign Medicine</h1>A&y_A@N
<hr>X1j%OAnx/T9wE+Y
<?php/U d(CW Eh
include ("doctorlabel.html");
!m$B ^ Lv.\ $medicine=$_POST['txtMedicineBig'];;a j!eI XL:f
$medicinesmall=$_POST['txtMedicineSmall'];
zIwr q R6C ?>c?(UAP^j
<Form name="AssignMedicine" method="get" action="AssignMedicine.php?MedicineBig=<?php echo $_GET["txtMedicineBig"];?>">
9T*oUv${V @ <table border="1" align="center">
^)r0H*Y b?H         <tr>
C4r2]k6u,HlB                 <th align="left">Assign Medicine Big Name:</th>Oajtu8F+\
                <td><SELECT NAME="txtMedicineBig">*i HK}2n)pwif
                <?php
I$O{/H c-r,v.~%| ~8o                         $define=$_GET["BIGID"]; Oer0U.Jm y*f @
                        $verify=$_GET["Check"];9M[p(I/klBD[
                       
!nV-xA2I8L5L                         $sql=mysql_query("SELECT * FROM medicinebig ORDER BY 'Medicine_Id'");H;j4s%j}S;D n
                        if (mysql_num_rows($sql)>0)
o'@?7db                         {8Fk{%l#`
                                while ($sqlmedicine=mysql_fetch_array($sql))
Zs;c S)`$YY4Y                                 {
;n|D+g7c(p1} z&f                                         echo "<option value='".$sqlmedicine['Medicine_Id']."'";
]1e%_3mB e"Ot g                                         if ($_GET["txtMedicineBig"] == $sqlmedicine['Medicine_Id'] || $define == $sqlmedicine['Medicine_Id'] || $verify==$sqlmedicine['Medicine_Id'])
g5k!c)Jf+Qf                                         {
-F#U9l _ _(Q                                                 echo "Selected=Selected ";#w3`Ulb9}W
                                               
-i6`O#u8T_?1lm)?0a                                         }
b:ly-z5kf&nf                                         echo ">".$sqlmedicine['Medicine_Id']." - ".$sqlmedicine['Medicine_Name'];
1q,@2it z5?                                 }
/DcLr:Y `ehL                         }p7r&rus I;}M
                ?>9JM$rU7A4u#z V/lL`,s
                </SELECT></td>
Oi4e#v/[/L"W0Qb                 <td><input type="submit" name="Searchbig" value="Search"></td>
'C+i!HK,u W?         </tr>D:avB)_e
</table>
:~K/jK!II:s </Form>
i*{+aF^1r/X(B <BR>h'Vh/g6em#L"INO
<?php
n)[7Ve$_ $medicinesmall=$_GET['txtMedicineSmall'];
?$e0Hoz`aM;a         if(isset($_GET['Searchbig']) or isset($_GET['SearchSmall']))
kA)y2cs'Ry E         {*GkF"PS#hM+PM
                $getID=$_GET['txtMedicineBig'];+x Z2]UwN?
                ?>
:w#yl)_!H8r <Form name="AssignMedicineSmall" method="GET" action="AssignMedicine.php"> K+V0RV5u]\&`:J
<table border="1" align="center">
;hX([0c)Ie(i         <tr>1L'Hs(k+C
                <th align="left">Assign Medicine Big Name:</th>o)S G Xx%h2v0\.T
                <td><SELECT NAME="txtMedicineSmall">8UgQq$i'{Wn
                <?php $l$xq$c0oO
                $sqlfirst=mysql_query("SELECT * FROM medicinesmall WHERE Medicine_Id='$define' or Medicine_Id='$getID' or Medicine_Id = '$verify' ORDER BY 'Medicine_Id'");
a"Aa{q;k,S N6A                         if (mysql_num_rows($sql)>0)
I4}6}nN6f}                         {0k#RE`xP:}]i
                                while ($sqlmedicinesmall=mysql_fetch_array($sqlfirst)) l,],Tr&iDsclC
                                {RH5}[[;~9n&x(F
                                        echo "<option value='".$sqlmedicinesmall['S_Medicine_Id']."'";
#^)Q4I)Fb AfVV'K                                         if ($_GET["txtMedicineSmall"] == $sqlmedicinesmall['S_Medicine_Id'])
wd(}8Zt(pV-j5] xd                                         {:s,e$v.z oF m
                                                echo "Selected=Selected ";^X)l&Br,g:N ^1?(D
                                        }^)d"o x0z
                                        echo ">".$sqlmedicinesmall['S_Medicine_Id']." - ".$sqlmedicinesmall['Medicine_Name'];R2E!Sl6R1pfes3n2m
                                        Flr_)S3C3?
                                }
L)]a a%ONH;LtJ                         }v L/H;e(G/IL
                ?>2u#T@'`'@?.O:P2V
                </SELECT></td>
E,]$@+w hO                 <input type="hidden" name="BIGID" value="<?php echo $getID;?>">TV)zd2l @8F#B
                <input type="hidden" name="Check" value="<?php echo $define;?>">;ZSmT6xB%Sl`5A
                Q/V3X A}
                <input type="hidden" name="smallID" value="<?php echo $_GET['txtMedicineSmall'];?>">MZ*GR*H5CnaH
                <td><input type="submit" name="SearchSmall" value="Search"></td> \;wAG {%H C
        </tr>&Fj;e"Y9F l~xK6m
</table>
7ST%H h0l/`4S </Form>7U6}Ln5i
<BR>
^,C r,a}1B`0Vb9k <?php
y Cp| r n_         }/v.T'c~ tUX
                if(isset($_GET['Searchbig'])or isset($_GET['SearchSmall']))
G~8a]b                 {x @$q{8L(C4{2v
                        $getID=$_GET['txtMedicineBig'];
/j3r7a Tbk|                         $medicinefirst=mysql_query("SELECT * FROM medicinebig WHERE Medicine_Id ='$getID' or Medicine_Id='$define' or Medicine_Id ='$verify' or Medicine_Id='$reID'");
'~T9ur;bGGNp2^)Q                         if(mysql_num_rows($medicinefirst)>0)
M ya oF~C                         {+Fv3cGR~/F5F
?>
yP:PdH{5\#s:?t2s         <Form name="assign" method="post">$tK0q(t qLDk;m6~
                <table align="center" border="1">"u1UK~%d2P
                <tr><th colspan="4" bgcolor="#FF0000">Medicine Big</th></tr>p&N'y:FOE"l \
                <tr>0M9["w:GCj
                        <th>Medicine Name:</th>v(U*v7h!{B/U
                        <th>Quantity</th>
3n H-sgWW{c[u                         <th>Weight</th>
.xw7H9Q7H+mH                         <th>Weight Type</th>
ZxGj;FM4h8q                 </tr>
3C}W?UL/b                         <?phpj2D;a)BX8mfRf/us
                                while($details=mysql_fetch_array($medicinefirst))
)xS3q,MGs*Q                                 {0|E)\Qk{lM
                                        $reID=$details['Medicine_Id'];Bj@H B'N3j5[p
                                        echo "<tr><td>$details[Medicine_Name]</td>";&Qa5a)E?'UN
                                        echo "<td>$details[Quantity]</td>";Q2mf T3j:Hf
                                        echo "<td>$details[WeightBig]</td>";G#eW7zio
                                        echo "<td>$details[weight_Type]</td></tr>";
hGt8Q/I$@*ep KB                                 }
(W2w"A,E"M*|?                         }
x B,U-sdX;O0wBl                         $getsmallID=$_GET['txtMedicineSmall'];(q@b`8T MC
                        $medicinesecond=mysql_query("SELECT * FROM medicinesmall WHERE S_Medicine_Id ='$getsmallID'");
.P{k+Cg&K.nl                         if(mysql_num_rows($medicinesecond)>0)
7m2iF;R/W7A                         {:b}R/Y!o{%T
?>                <table>:Z2e#}%d;]7tl
                <BR><BR>
Pj9v\IG A                 <table align="center" border="1">7n&urmu4N&_-~.B
                <tr><th colspan="4" bgcolor="#FF0000">Medicine Small</th></tr>*E3f#Y4_e}
                <tr>
q[[*lUN                         <th>Medicine Name:</th>
cKl[ `g                         <th>Quantity</th>
/|}J k[ t|                         <th>Weight</th>
8T:a(uP:p w                         <th>Weight Type</th> V:R`;z0M{)y(]~"B
                </tr>W"O l6Uh,kBV
                <?phppdih8r a&jl
                                while($seconddetails=mysql_fetch_array($medicinesecond))WT,oJ E;@z{%AM
                                {
h2X M{|-T$S                                         $resmallID=$seconddetails['S_Medicine_Id'];HWtZ^G
                                        echo "<tr><td>$seconddetails[Medicine_Name]</td>";1BF;n2_&Lj d a!S4b!~h
                                        echo "<td>$seconddetails[Quantity]</td>";0Tk0h9R!}N
                                        echo "<td>$seconddetails[Weight_Small]</td>";
q&V"F@ B6j0H                                         echo "<td>$seconddetails[weight_Type]</td></tr>";.~'OEG(?C'C.X_
                                }
~n+TF{,R`"{                 ?>
;yl4{5}-O!R8P         </table>S su/X}L9f
</Form><BR>"J#l"Lva0X\
<Form name="assignfinal" onsubmit="return ValidatorForm(this)" method="post">
5w%W*G4Unv w j1Ox-P         <table align="center">
$_9[)lkK7\8qe                 <tr>
s7Y(`{w]                         <th>Assign Medicine Quantity From Medicine Big:</th>|7rp_ms Ss
                        <td><input type="text" name="bigquantity"></td>z{ Z-q ]
                        <input type="hidden" name="lastbigId" value="<?php echo $reID?>">B:_4Ckf5Nl1mi3H
                        <input type="hidden" name="lastsmallId" value="<?php echo $resmallID?>">`)MV}k)g
                        <td><input type="submit" name="assign" value="Assign"></td>Z8oq4XR!T`/S
                </tr>
#c|o!G{"kLA]         </table>
f8?9?h]y </Form> @Zt} w7Q*\
<?php
$W5tC*P{c"d)^y*~                         }P;Ac$Ib%iI9z
                }
Rk)R``5`1v ?>
"I b4DV,^8U8c </body>
vo9q A#Ui!E </html>

极帝猫 2-10-2007 05:14 PM

如果有存 database，就不需要那么麻烦作什么 session 了。
,fE._v4zn z_ medicine big 选择了之后用 onchange 更新 medicine small，就这么简单。
y,h3?@(g{J
c]6G tAI` [hr]deeppink[/hr]
1biK-INvr.N <script language="javascript">
6YV3{+L!q function [color=DarkOrange]OnChange()[/color]|$mI)^2j G4W
{
6nP n$}W         var id=document.[color=Green]form[/color].[color=Red]mid[/color].options[document.[color=Green]form[/color].[color=Red]mid[/color].selectedIndex].value;T)r&n2G OL(QX/]
        window.location.href="[color=Blue]medicine.php[/color]?[color=Red]mid[/color]="+id;
f:Z5@{5V }
LbUkighhG%|z T </script>-`lYao
4? O+UEOcx3qm#M
<form action="某些目标档案" method="post" name="[color=Green]form[/color]">2R,c@B.P`zf
<table><tr>u duB*e*aDUd
        <td align="right">Medicine Big :</td>
vA-xY SU         <td align="left"><select name="[color=Red]mid[/color]" onchange="[color=DarkOrange]OnChange()[/color]">[color=Blue]SQL Select 的 result（big）[/color]</select></td>
+gA(\/oK{ </tr>
#G?3W)V5}8xe`D <tr>"]GF_1k8eS#RE
        <td align="right">Medicine Small:</td>vWN*s3Kdy!r5H
        <td align="left"><select> [color=Blue]SQL Select 的 result（small）[/color] </select></td>pQ0?G7xC
</tr>I4W@,CX
</table>
c-Iz|5x*_-z <center><input type="submit" value="Insert"></center>}-O2K*V-g
</form>
z4ZS'D~(?y(qZ"D ,n0k'R9t)zD.A B
[hr]deeppink[/hr]
'e0dV.s2Rf` G T L ee.ick&F
其中，medicin.php 就是你的 php 执行程序，mid 是 medicine big pass 进去的 value，用它来 select medicine small。 ~8[ Gu9Hs`:D V
之后把得到的 result 输出在 small 的 select。 q/yd w6\1{-p
红色字部分的 mid 是相对应，就这样。
?n+N P'`9Ap :ONI71: :ONI71:

wilsonlee1987 2-10-2007 10:52 PM

回复 14楼 神仙猫 的帖子

我试试看！！
'p?7bE? 谢谢帮忙！
,hIR[ e`G 可能过后还有一些问题会问你们！

wilsonlee1987 3-10-2007 12:15 AM

他没有反应！！
j+I5N"O0d#Ny&O6W
{E2ms%X function OnChange()'u!F'OzB,}
( w#u@-g Q?l\
        document.write("HAHA!");
!`"sS-A M0F     var id = document.AssignMedicine.txtMedicineBig.options[document.AssignMedicine.txtMedicineBig.selectedIndex].value;  window.location='AssignMedicine.php?txtMedicineBig='+id;Z2N/Kj{]*B[(@
        0K%Ogw2B[I
}
P3]*|]r //-->f c&P `ii9ok|
</SCRIPT>
5?;tg"zo5Q7k1L1I </head>~v S3VI h8eU:X
<body>lu.H%d&e~qg
<hr>v r9cW:G hNc
<h1>Assign Medicine</h1>6Q%]0}#B,z2B
<hr>
$g"}4tP6p K <?php
KGgJBd@N?+{ include ("doctorlabel.html");s b+P+_2a
$medicine=$_POST['txtMedicineBig'];#T4|D+n8i-cK!]3t
$medicinesmall=$_POST['txtMedicineSmall'];"|u DG'??y
?>5g7{JkMjq ?
<Form name="AssignMedicine" method="post" OnChange="OnChange()" action="AssignMedicine.php">
6B D5XT&p$T <table border="1" align="center">
3o.a(e| n'S7K3pZP         <tr>
cg3G-Of6|                 <th align="left">Assign Medicine Big Name:</th>
tu7K F*`9KBim0a                 <td><SELECT NAME="txtMedicineBig">
:y{5XDmu/C                 <?phpt9d']%\ M
                        $define=$_GET["txtMedicineBig"];
1il5[ xL$Y1]                         $verify=$_GET["Check"]; B8QV PsVM
                        a,}(l'A sO#SxE
                        $sql=mysql_query("SELECT * FROM medicinebig ORDER BY 'Medicine_Id'");
(S L8P*Az@                         if (mysql_num_rows($sql)>0)
.t&qU7fh                         {
}SNd(z@                                 while ($sqlmedicine=mysql_fetch_array($sql))
XF2~Uf?W                                 {
Sj+MPJ                                         echo "<option value='".$sqlmedicine['Medicine_Id']."'";
^ET.k)Z$`4[ q D_                                         if ($_POST["txtMedicineBig"] == $sqlmedicine['Medicine_Id'] || $define == $sqlmedicine['Medicine_Id'])~-m-_Y'p tl
                                        {
,nwv2jU                                                 echo "Selected=Selected ";
M/A;GYs i                                                 i ]pGF;hvr
                                        }
u.Tp2d| Q,G                                         echo ">".$sqlmedicine['Medicine_Id']." - ".$sqlmedicine['Medicine_Name'];2i?o?_bwC8U"H
                                }
|T PA j@Vv                         },M2JG:[-cFEP
                ?>
p0[ue&UC,P                 </SELECT></td>
&R y q f-y(nI*oYp         </tr>
L/fd4q3OZJ </table>
*|7tX"o Mx:}
5l/f4JHs\ 5w D|1F:z K8_ h:_S$gx
<?php
w`-Gy{2ORv         -V)r.fz+_#GG3Z
$medicinesmall=$_GET['txtMedicineSmall'];D7T_ZgA

iL"l2l\3Tx t _5T                 $getID=$_GET['txtMedicineBig'];j)k/u4Su)N ])c4[h
                ?>
w3`8e1x0d!@u'B9Q <table border="1" align="center">,XS@X7Y5a0A
        <tr>
P1C }EBn([                 <th align="left">Assign Medicine Big Name:</th>
Qd[[ [                 <td><SELECT NAME="txtMedicineSmall">LR3Do s0Xi%K,G
                <?php
'@v;B3c tui6u5@                 $sqlfirst=mysql_query("SELECT * FROM medicinesmall WHERE Medicine_Id='$define' or Medicine_Id='$getID' or Medicine_Id = '$verify' ORDER BY 'Medicine_Id'");(i;xik;^Dv&se k
                        if (mysql_num_rows($sql)>0)
s"ax ~a+} L                         {
9K~)}/@A Z7~;e/I'xQ                                 while ($sqlmedicinesmall=mysql_fetch_array($sqlfirst)):mZL_6|f+J4U
                                {y| Y.lTk-d0vK r
                                        echo "<option value='".$sqlmedicinesmall['S_Medicine_Id']."'";
o E3fw,fm*y1]P                                         if ($_GET["txtMedicineSmall"] == $sqlmedicinesmall['S_Medicine_Id'])
1r:FTV&_'x9B                                         {
$JdI!|L*Pf                                                 echo "Selected=Selected ";
Q4\QukcA                                         }*n8} w:vd
                                        echo ">".$sqlmedicinesmall['S_Medicine_Id']." - ".$sqlmedicinesmall['Medicine_Name'];S S_3mdo
                                       
s/G*H_Szoz-CTP                                 }
4{CeV@x DZ                         } QC JT$F
                ?>
o m5Y2B-aE&oB;T&W                 </SELECT></td>
&D$^V-O-SS                 <input type="hidden" name="BIGID" value="<?php echo $getID;?>">
cX:W8@b[DB                 <input type="hidden" name="Check" value="<?php echo $define;?>">
^%nky^                
(u-q;_t)TT H$b                 <input type="hidden" name="smallID" value="<?php echo $_GET['txtMedicineSmall'];?>">
G,i6qsr%]6b                 <td><input type="submit" name="Searchbig" value="Search"></td>
n)X$ZP6yE'rl3y         </tr>
o~ a ye` </table>
p&h!z.Y,u!r2U </Form>

极帝猫 3-10-2007 01:43 PM

你完全理解错误。。。
a|m6Zr7VOi onchange  是必须放在 <select> 这个 HTML tab 里的。
#uq8s:F:n^!J7i'K_ 当你 select medicine big 这个 tab 之后，onchange 执行 javascript pass medicine big value 去 php，用它来找出 medicne small，在 show 回去 medicine small 的 <select> tab。!s:g~$Y{)p+Y

'?7_;}o V 放在 <select> tab 里面最大的作用就是，OXQ'sY8C
当你选择了 medicine big 之后，就执行 onchange。
\ p+sr7Vq2F 你把 onchange 放在 <form> tab ，就必须要按 submit button 之后才有动作了。
Xa3pb6p X?m
-ed8P2RC!}+R1qhtZ 这些和 php 无关。
UG8^.{a1E t f? html 标签和 dom 要搞清楚啊。。

wilsonlee1987 3-10-2007 02:24 PM

回复 17楼 神仙猫 的帖子

sorry上面那个是我比较早的！！
Zbxa*]/i} 我后来有改了！
)V0^r?0\jjYJ"B 还是不行 }`lIVj{5T c
L Ji4| \ [.wK
而且我发现到，我完全进不到onchange的code里面！！
+h^3{Ax Kdi2UV Q)B
-----------------I+e { A%`"Cm,on
这是我用来test的1Q D9x o+u dM
可执行的code
#hTho1aw!g ~1c;a#x9Zg8Am
<HTML>
W.S v(Z? <HEAD>mW-^AUo$fF
<TITLE> New Document </TITLE>#se,P7f-S)tB
<SCRIPT LANGUAGE="JavaScript">
m1z}e;|'Sut} <!--
c)k S6\ no;h function handler();YnM8B@'aE
{8k7q;hb6SII
        yesno = confirm("Want to Change?");
L6dc)YN\ NKQ&h         if (!yesno) form.s1.value="Big Mac";
q8Y ^rr/h7d }F1tBHQ%\yajUz
//-->
IG]l Z-L9p `.P
#W8}:O!p(V:W </SCRIPT>)f4A/q(I`^3bU#E7e
</HEAD>
/Q$s:k1Uh|6r%o
U.PBN9HlD9j <BODY>
{ BEk%TX <Form name="form" >-kMN g2a^%B8a je5A
first        <INPUT TYPE="text" NAME="s1" value="Big Mac" onChange="handler()"><BR>
n'i9h ?C second        <INPUT TYPE="text" NAME="s2" value="Coke">t)S5J3c#U4l.l
<INPUT TYPE="submit" name="submit" value="submit">
U;Ws@ |WYN </Form>
g,\*_n-R X </BODY>
l.t~q }h </HTML>(w)N4S4\|K
~7kH/g1}P3@;T
-----
gNBL(Dl(b 执行不到的code!!"Zx9MW+E

8}$C$Y#}[T&D <script language="javascript">
+ZMp/d RK'km,q {5I8R"Jp6\Z8t
function handler()oHQ\,A,Q#ka
(
l(cjOpR^$\ alert('haha');
'X8n/z9P%\M't     vi=document.form.mid.options[document.form.mid.selectedIndex].value;  window.location.href="medicine.php?mid="+vi;A Q)[pV WP5vg _
^I:aR u*v
}}N0Sg'vD*p
/*function handler()
*i&Q+joe*? {HQlU#] U(?eEn6u
        yesno = confirm("Want to Change?");`wuk*hX
        if (!yesno) form.mid.value="Big Mac";
|a;Eb-a }*/0E7k$|\ Z ]Z U,O@

T*K0eQz h X8NI
o&Bw}0E/l&pB
.p+{:E%RL+q By </script>
wt|+u U6k.Q
XsHU pI0n <form name="form">I`.s.uLl+W"J}x
<table><tr>
-D Vz%G7L~         <td align="right">Medicine Big :</td>C | o{bB
                <td align="left"><INPUT TYPE="text" NAME="mid" value="Big Mac" onchange="handler()">2Qy'QLXh)i4}+xEs
        </td>
{#Pit+C E2` </tr>*X+|[2jK B*R2pM
<tr>4a5D"N:H}P3V
        <td align="right">Medicine Small:</td>$]S"eCo7^ H a
        <td align="left"><INPUT TYPE="text" NAME="mi" >
8C-HK-jl                 </td>}gI6FK0|c1X
                </tr>+h)a}kjf5o8YT!|
</table>
-_pKWhTv <center><input type="submit" value="Insert"></center>
)o*g6t.t}&@V </form>xm5U(T,e6T ]J
}5H5X5B9v o \t;r o
[[i] 本帖最后由 wilsonlee1987 于 2007-10-3 02:35 PM 编辑 [/i]]

极帝猫 4-10-2007 12:56 AM

回复 18楼 wilsonlee1987 的帖子

老板，onchange 的 event handler 必须是当前值有改变才会产生 event。。
,fE3w XcA)P[ event 产生在 onblur 之后。m}Hp \?#^)^
ne#Tp][#u
[url]http://www.w3schools.com/jsref/jsref_onchange.asp[/url]
0THg)Y{ [url]http://msdn2.microsoft.com/en-us/library/ms536912.aspx[/url]
AuI X.?$V
$i/u ^m!]ic [hr]deeppink[/hr]
S4BjF,T$xE <script language="javascript">
!y)[rnfp,kU1@'s function Handler()
;]1XNr+k4b3C \*K {
.T*g(NC6}Lb8a+b         alert("Hahaa");
(nU pCv2J3|;rc }fXe)s:z;N `&]7D;}.B
</script>Qw4?Z.v8c9ad
<form>
_Y,BDBfK <input type="text" onchange="Handler()">NXUr5O'V/?
</form>:G2L7T3l-n

k7a?Pbw W,^ h [hr]deeppink[/hr]*BvBH-m.Tj
随便打东西，然后按 tab 看效果。
页: [1]
查看完整版本: 请求帮忙！！