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

wilsonlee1987 1-10-2007 01:04 AM

请求帮忙!!

问一下!!
y~y5G3a*G 如果我在一个界面,一直select一个值,而这个值不会变!L*|y.a5Q4JQ*vL
我要怎样去写?用php!!W'W@*pF]]
比如2X$K;CO;G4U3nJ&R"LT
我选择了第一个Medicine Big的值(注:listbox) U*G2k3w:KA
然后我按submit的按钮,
#Rs JzVs
.k@(aLTKk"})m"H 过后我下方会显示一个medicine Small的list box
q&{H(vl~J{#~Q 当我选择好后,按select button(注:不是上面的submit buttton,是另外一个) j]D)O)M9r2|6^|(G$j
k'Oz1D/N2Q%y v
问题来了,就算我不挂南多少次,他都是要显示我之前所选择的Medicine Big的值在我德Medicine Big 的list box那边!
:dN)^;S;bqm@ 请问要怎样做?;P:gZ9N1?ZO:[

8kY/nw q-}g,K2F%A3w [[i] 本帖最后由 wilsonlee1987 于 2007-10-1 01:06 AM 编辑 [/i]]

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

老实说,我看不懂你的问题究竟要怎样。。$u2JR W9ML h'?s-N Ho
可不可以在举个更具体的例子。。==+?-g[.M'ci`z
2s)A DCy'd
你选了 medicine big,按 submit 了之后会出现 medicine small。WLf@"a MG
你选了 medicine small,按 select 了之后是要得到什么?

wilsonlee1987 1-10-2007 02:00 AM

回复 沙发 神仙猫 的帖子

当我选了 medicine small,按 select 了之后,
%RE)Z;V]zCt 上面的medicine big的值还是focus在我之前选的值!!
(^ sY6P|]n1O 而且还可以抓到的那种!!/L*H Czh+H\&O

&@0vu'u+`mNE 还有最重要是我不管按多少次medicine small的select,上面的medicine big的值还是focus在我之前选的值!!

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

那为什么要那么麻烦选了 Medicine Big 之后要按 submit 才选择 Medicine small ?
"B/e z;pP{!NN 把两个 listbox 都放在同一页不是更简单吗。。?
%R@I*o1G InQ3B :ONI71: :ONI71:

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼 神仙猫 的帖子

我也想啊!!
wn;|` \ 但是我现在做的是分配药物的部分!!
.qN5}wnD ^ z7K7t 所以我一定要先抓到大个容量的药物,才可以知道小个分量药物到底有没有存在再stock里面!
4|/`J%GW E 如果有,我才可以选择小个药物里面的东西!
0AqU$SV /m'`a.\_ ~jv
像在目前为止,我想到一个方法,就是用session来存id,不懂这个行得通吗!!&pFo L%k6|*c*o+{
问一下!

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼 神仙猫 的帖子

我也想啊!!
l[/?p6]mQtG 但是我现在做的是分配药物的部分!!?/N'l.w0CO[6D?
所以我一定要先抓到大个容量的药物,才可以知道小个分量药物到底有没有存在再stock里面!:i6@zx^.K cD
如果有,我才可以选择小个药物里面的东西!1Mc*| \(g

0c*b3]VsO ?1P 像在目前为止,我想到一个方法,就是用session来存id,不懂这个行得通吗!!G9Y,D_.lyPBQ
问一下!

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼 神仙猫 的帖子

我也想啊!!
n!Z\&Es*{ 但是我现在做的是分配药物的部分!!
.D]5\D"e9k,N6B9@ 所以我一定要先抓到大个容量的药物,才可以知道小个分量药物到底有没有存在再stock里面!9h.H6wx)\VC4vZ)b
如果有,我才可以选择小个药物里面的东西!r-b!cc"qlG9r

!e O%O#l+fE/D"Z/v 像在目前为止,我想到一个方法,就是用session来存id,不懂这个行得通吗!!Z(ShF XVU7Bm0I
问一下!

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

先问你,你的东西有存在 database 吗?

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

[quote]<html>b0\gy;ZJb)N
<head>
We Up b8P/byhX 3_2V9ci4j&C8Xp_5Vx
<script language="JavaScript">
pB6wR?Ax z W wV0zl <!--
{1i0U-Tbj6}H8u*p&C //==================== for zip code begin =========================K[ TFI
County = new Array("台北市","基隆市","台北縣","宜蘭縣","新竹市","新竹縣","桃園縣","苗栗縣","台中市","台中縣","彰化縣", "南投縣","嘉義市","嘉義縣","雲林縣","台南市","台南縣","高雄市","高雄縣","澎湖縣","屏東縣","台東縣","花蓮縣", "金門縣","連江縣","南海諸島","釣魚台列嶼","外國");//全省各縣市
!X/ND O S0fO Zone = new Array(28);
QA l!A;Z0A W8YH Zone[0] = new Array("中正區","大同區","中山區","松山區","大安區","萬華區","信義區","士林區","北投區","內湖區","南港區","文山區(木柵)","文山區(景美)");//台北市3QC%J(k1q'? G
Zone[1] = new Array("仁愛區","信義區","中正區","中山區","安樂區","暖暖區","七堵區");//基隆市(Ee2B7|N9A$J
Zone[2] = new Array("萬里鄉","金山鄉","板橋市","汐止市","深坑鄉","石碇鄉","瑞芳鎮","平溪鄉","雙溪鄉","貢寮鄉","新店市", "坪林鄉","烏來鄉","永和市","中和市","土城市","三峽鎮","樹林市","鶯歌鎮","三重市","新莊市","泰山鄉","林口鄉", "蘆洲市","五股鄉","八里鄉","淡水鎮","三芝鄉","石門鄉");//台北縣l-SM"djw}@ i1L5n
Zone[3] = new Array("宜蘭市","頭城鎮","礁溪鄉","壯圍鄉","員山鄉","羅東鎮","三星鄉","大同鄉","五結鄉","冬山鄉","蘇澳鎮","南澳鄉");//宜蘭縣
Q*ytf} Zone[4] = new Array("");//新竹市
3g#rX zc;|5o8R Zone[5] = new Array("竹北市","湖口鄉","新豐鄉","新埔鄉","關西鎮","芎林鄉","寶山鄉","竹東鎮","五峰鄉","橫山鄉","尖石鄉","北埔鄉","峨嵋鄉");//新竹縣(_u;ue^9{ c [6}.k&\
Zone[6] = new Array("中壢市","平鎮","龍潭鄉","楊梅鎮","新屋鄉","觀音鄉","桃園市","龜山鄉","八德市","大溪鎮","復興鄉","大園鄉","蘆竹鄉");//桃園縣
4t]!bqv4g2o%k l Zone[7] = new Array("竹南鎮","頭份鎮","三灣鄉","南庄鄉","獅潭鄉","後龍鎮","通霄鎮","苑裡鎮","苗栗市","造橋鄉","頭屋鄉", "公館鄉","大湖鄉","泰安鄉","鉰鑼鄉","三義鄉","西湖鄉","卓蘭鄉");//苗栗縣5` rx w%q5`
Zone[8] = new Array("中區","東區","南區","西區","北區","北屯區","西屯區","南屯區");//台中市
Q^+p h/I(QGC(M(v Zone[9] = new Array("太平市","大里市","霧峰鄉","烏日鄉","豐原市","后里鄉","石岡鄉","東勢鎮","和平鄉","新社鄉","潭子鄉", "大雅鄉","神岡鄉","大肚鄉","沙鹿鎮","龍井鄉","梧棲鎮","清水鎮","大甲鎮","外圃鄉","大安鄉");//台中縣
]f \ UI)a,I6E Zone[10] = new Array("彰化市","芬園鄉","花壇鄉","秀水鄉","鹿港鎮","福興鄉","線西鄉","和美鎮","伸港鄉","員林鎮","社頭鄉", "永靖鄉","埔心鄉","溪湖鎮","大村鄉","埔鹽鄉","田中鎮","北斗鎮","田尾鄉","埤頭鄉","溪州鄉","竹塘鄉","二林鎮", "大城鄉","芳苑鄉","二水鄉");//彰化縣
#f6c1ee,u;_c7V Zone[11] = new Array("南投市","中寮鄉","草屯鎮","國姓鄉","埔里鎮","仁愛鄉","名間鄉","集集鄉","水里鄉","魚池鄉","信義鄉","竹山鎮","鹿谷鄉");//南投縣
&s"X1dS,~3M Zone[12] = new Array("");//嘉義市
pX6yyC-?hj Zone[13] = new Array("番路鄉","梅山鄉","竹崎鄉","阿里山鄉","中埔鄉","大埔鄉","水上鄉","鹿草鄉","太保市","朴子市","東石鄉 ","六腳鄉","新港鄉","民雄鄉","大林鎮","漢口鄉","義竹鄉","布袋鎮");//嘉義縣\m4Um#u;AXr
Zone[14] = new Array("斗南市","大埤鄉","虎尾鎮","土庫鎮","褒忠鄉","東勢鄉","台西鄉","崙背鄉","麥寮鄉","斗六市","林內鄉", "古坑鄉","莿桐鄉","西螺鎮","二崙鄉","北港鎮","水林鄉","口湖鄉","四湖鄉","元長鄉");//雲林縣+R&bD#{"i\9z2RL
Zone[15] = new Array("中區","東區","南區","西區","北區","安平區","安南區");//台南市
zOKzs[}ur Zone[16] = new Array("永康市","歸仁鄉","新化鎮","左鎮鄉","玉井鄉","楠西鄉","南化鄉","仁德鄉","關廟鄉","龍崎鄉","官田鄉", "麻豆鎮","佳里鎮","西港鄉","七股鄉","將軍鄉","學甲鎮","北門鄉","新營市","後壁鄉","白河鎮","東山鄉","六甲鄉", "下營鄉","柳營鄉","鹽水鎮","善化鎮","大內鄉","山上鄉","新市鄉","安定鄉");//台南縣
t E/VM$b]#VR|*^ Zone[17] = new Array("新興區","前金區","苓雅區","鹽埕區","鼓山區","旗津區","前鎮區","三民區","楠梓區","小港區","左營區");//高雄市5I_;mp!~/e#}a
Zone[18] = new Array("仁武鄉","大社鄉","岡山鎮","路竹鄉","阿蓮鄉","田寮鄉","燕巢鄉","橋頭鄉","梓官鄉","彌陀鄉","永安鄉", "湖內鄉","鳳山市","大寮鄉","林園鄉","鳥松鄉","大樹鄉","旗山鎮","美濃鎮","六龜鄉","內門鄉","杉林鄉","甲仙鄉", "桃源鄉","三民鄉","茂林鄉","茄萣鄉");//高雄縣
6@^8q$}q Zone[19] = new Array("馬公市","西嶼鄉","望安鄉","七美鄉","白沙鄉","湖西鄉");//澎湖縣U&rey}9zw?.TJ
Zone[20] = new Array("屏東市","三地門鄉","霧台鄉","瑪家鄉","九如鄉","里港鄉","高樹鄉","鹽埔鄉","長治鄉","麟洛鄉","竹田鄉 ","內埔鄉","萬丹鄉","潮州鎮","泰武鄉","來義鄉","萬巒鄉","嵌頂鄉","新埤鄉","南州鄉","林邊鄉","東港鎮","琉球鄉 ","佳冬鄉","新園鄉","枋寮鄉", "枋山鄉","春日鄉","獅子鄉","車城鄉","牡丹鄉","恆春鎮","滿州鄉");//屏東縣
&b;t0n?&Fc~9g Zone[21] = new Array("台東市","綠島鄉","蘭嶼鄉","延平鄉","卑南鄉","鹿野鄉","關山鎮","海端鄉","池上鄉","東河鄉","成氐","長濱鄉","太麻里鄉","金峰鄉","大武鄉","達仁鄉");//台東縣
R]1@$u}X Zone[22] = new Array("花蓮市","新城鄉","秀林鄉","吉安鄉","壽豐鄉","鳳林鎮","光復鄉","豐濱鄉","瑞穗鄉","萬榮鄉","玉里鎮","卓溪鄉","富里鄉");//花蓮縣
`_%r]-m4J Zone[23] = new Array("金沙鎮","金湖鎮","金寧鄉","金城鎮","烈嶼鄉","烏坵鄉");//金門縣~/d ~~"cl9@m
Zone[24] = new Array("南竿鄉","北竿鄉","莒光鄉","東引");//連江縣
6a U:{~;W Zone[25] = new Array("東沙","西沙");//南海諸島1Dq/hc8q^C0Hot
Zone[26] = new Array("");//釣魚台列嶼.R:emtFf
Zone[27] = new Array("");//外國7~9t%X3ivaz6Qs-N C
ZipCode = new Array(28);-c){V+r^D w
ZipCode[0] = new Array("100","103","104","105","106","108","110","111","112","114","115","116","117");//台北市9pGm P0^b*W9M.\
ZipCode[1] = new Array("200","201","202","203","204","205","206");//基隆市
&rqAg8|F%Ok\ 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");//台北縣-Q }.fUC|o
ZipCode[3] = new Array("260","261","262","263","264","265","266","267","268","269","270","272");//宜蘭縣
-I|&~C~j ZipCode[4] = new Array("300");//新竹市
aQEr'f/KoIH ZipCode[5] = new Array("302","303","304","305","306","307","308","310","311","312","313","314","315");//新竹縣7t(fEza8\W7UZ z1_
ZipCode[6] = new Array("320","324","325","326","327","328","330","333","334","335","336","337","338");//桃園縣
9LxP[$N ZipCode[7] = new Array("350","351","352","353","354","356","357","358","360","361","362","363", "364","365","366","367","368","369");//苗栗縣
1wnq6c!KslF ZipCode[8] = new Array("400","401","402","403","404","406","407","408");//台中市
i r$L}3Of^'u/d 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");//台中縣
BVDA7L7C.NG 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");//彰化縣j)sR%cA!_\B
ZipCode[11] = new Array("540","541","542","544","545","546","551","552","553","555","556","557","558");//南投縣 Zz2a g*y
ZipCode[12] = new Array("600");//嘉義市
*ZY_{7jx ZipCode[13] = new Array("602","603","604","605","606","607","608","611","612","613","614","615", "616","621","622","623","624","625");//嘉義縣
%LL:^S xe^ ZipCode[14] = new Array("630","631","632","633","634","635","636","637","638","640","643","646", "647","648","649","651","652","653","654","655");//雲林縣
-e(@ N(Eb/y5DL ZipCode[15] = new Array("700","701","702","703","704","708","709");//台南市
Ii6c U'vJA$u%Mp 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");//台南縣0KC;ecPg
ZipCode[17] = new Array("800","801","802","803","804","805","806","807","811","812","813");//高雄市fUqz1m K
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");//高雄縣
7o2z/v }#c j ZipCode[19] = new Array("880","881","882","883","884","885");//澎湖縣0K2vn s ?ASy{
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");//屏東縣
K$Y!hz;[+x ZipCode[21] = new Array("950","951","952","953","954","955","956","957","958","959","961","962","963","964","965","966");
#a @pFHY ZipCode[22] = new Array("970","971","972","973","974","975","976","977","978","979","981","982","983");//花蓮縣
-dj0B Y-w!HN&E ZipCode[23] = new Array("890","891","892","893","894","896");//金門縣
h1P9B| EV0e ZipCode[24] = new Array("209","210","211","212");//連江縣0Z@oI-F2u*MS
ZipCode[25] = new Array("817","819","290");//南海諸島7mr`0r#jv#La
ZipCode[26] = new Array("290");//釣魚台列嶼_N6k)gzr!YY
ZipCode[27] = new Array(" ");//外國!vac9L6FJ t/o

u)N r7{!~ ` V En0}o [/quote]Nd%~ d'x!Qrkp'v
*E2b^8J2_
显到暴 多过一万 你自己接下面的

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

function initCounty(countyInput) {
},E(CKM!Z countyInput.length = County.length;
\:L.Aac/aXB2M for (i = 0; i < County.length; i++) {*g$y2N)xE)u ST&Zp
countyInput.options[i].value = County[i];LE&u:_-e:Trm/m T
countyInput.options[i].text = County[i];
r~6p:LO,? }
g%N2p&LI%E gJ countyInput.selectedIndex = 0;N#ga1QAy
}
nKm I Z\ O]oA1p'iYv
function initZone(countyInput, zoneInput, post){
)y!]7A2XjT changeZone(countyInput, zoneInput, post);n(n8e%R~ b0s E&Y
}EY"wb6SY
nO |3G)b9_%M
function changeZone(countyInput, zoneInput, post) {
+Y@0g/X"C)L6_rP selectedCountyIndex = countyInput.selectedIndex;x s^,Q;oCa(Ll&V

3d;d9g yk'b&x zoneInput.length = Zone[selectedCountyIndex].length;
{:^]zOd-qJ for (i = 0; i < Zone[selectedCountyIndex].length; i++) {i/Eq]]8w"m u
zoneInput.options[i].value = Zone[selectedCountyIndex][i];
{|4NG;g'D S&z@ O zoneInput.options[i].text = Zone[selectedCountyIndex][i];fUa)Z*_6qj
if (zoneInput.options[i].text == "松山區")
gBvfIF/p/S9CB[ zoneInput.options[i].selected = true;Q5ns+}/@@2Q
}3n%{lN`:zq
//zoneInput.selectedIndex = 0;YDu)|0b
W.BI:m:N'\:y
showZipCode(countyInput, zoneInput, post);;d-D;K!_"x*c)boH
}
KCixlW.j$G)c,| YZD4[+xiW
function showZipCode(countyInput, zoneInput, post) {1y1}AKw r/[L8L
post.value = ZipCode[countyInput.selectedIndex][zoneInput.selectedIndex];
$b1C?A_W,R P#Sja }+gd5rZ!s
kZSb;f9x.v
function showZone(countyInput,zoneInput,post){+|;z8?P a6vL a d
var k=0;l=0;f3s3kiJ-}-J(]V1{ S)n
for (i=0; i < ZipCode.length; i++) {
:ZB\\C]'H/|%^z for (j=0; j < ZipCode[i].length; j++) {+X_E!vo N)z
if ( post == ZipCode[i][j] ) {9N+wo+aR&jaG
countyInput.length = County.length;
,J2e9F{ZC,XFZ for (k = 0; k < countyInput.length; k++) {
bc/JD?V.O countyInput.options[k].value = County[k];-eB u:V*ku
countyInput.options[k].text = County[k];
2\Y+F.h%t;Y"Z \#] if (County[k] == County[i]) {E/N9yg)T
countyInput.options[k].selected = true;cn]x8K
}
lDf3vo#z$^,y/K&Oc/P&N }
$k5t*[!K,xZ k2w x;I3?$_!p m Q
zoneInput.length = Zone[i].length;
DKv m,r'J for (l = 0; l < zoneInput.length; l++) {t.@^6M(y
zoneInput.options[l].value = Zone[i][l];%?9V0_+eF)iK-k)X
zoneInput.options[l].text = Zone[i][l];
-^ z^:z(K-w!Nm2v#u if (zoneInput.options[l].text == Zone[i][j]) {
'C"N5{(m)u[2q/V zoneInput.options[l].selected = true;.e CC1i,DZ
}
M:SpOD~y0`$i { }2tWl ZP%dEa
return; l-wO&lL%i
}
j2?$d De}5e }6OO}#PJ:Q]g;O/Y `
}
2r1D$L:_4l ~5f!Q // alert(k+'無此郵遞區號'+l);post='105';ResetAll();return;&`:l5zY:N_*M
}
"C^)lm+mTZ4a
1qrk+PSb function showZone1(post){//郵遞區號 轉 地名
-X1AWCT Y`Ck for (i=0; i < ZipCode.length; i++) {;BQ H&KN;pQ)l/kO
for (j=0; j < ZipCode[i].length; j++) {
5I.gM#hkSe~ if ( post == ZipCode[i][j] ) {Q-o~d,_d
document.write(County[i]+Zone[i][j]);return;
sos O!n*z }:gw"T-F-K0m
} d7Ypj1J&cq
}
a@&r}Y9K~3UdY }
e%q[{@;u3mm //==================== for zip code end =========================+mj~!`@&B&l
-->'D oor-R
</script>
}*hm'cs|#TG </head>RCL@,E1\0pp1T
<body bgcolor="#FFFFFF" topmargin="0" marginwidth="0" marginheight="0">
+_\7P]8|u'v <form method="post" action="" name="mgr" >
9O!JS$h@2B\ <table>Ve G*Jd"L:V_-h
<tr>
8zxa)T'[+O <td nowrap colspan="4"><font color="#0000CC">地  址

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

[php]<script language="JavaScript" TYPE="text/javascript">9} j(pJ;aJe+@+\
<!--eV O/P$~^y
?~Z F1Yix u+x
//==================== for zip code begin =========================
e{ VuAb6om[v <?V&MA;_9w

4`/Q#rt J'r         while($row4=mysql_fetch_row($result4))I#H5u8dB OC#mH
        {
-?M6Dxv                 $printOut = $printOut . $row4[1].'", "';        lP$g#EbS
        }U.Og`4I9?3z-k
        mysql_free_result($result4);
[8Y4Q]H         $printOut2= "".'", "'.$printOut;
$UK w(Z!^Bq5g ?> N+p[.A XN
County = new Array("<?=$printOut2?>");
\ n:B/iO[i5s `W {~m3b)Z@
<?4IZ `!kH-X.qd
        bl@ gF1ejV8]
        while($row=mysql_fetch_row($result))
PJ.B+h4X2qO         {g8Bd2E v3|l
                //print_r($row[1]);
APGp!](]Z,H         $count ++;
Y9^j+d H~D/y         }        "G[O:m.@,}*N
        mysql_free_result($result);
'R8uZa SJ4d         $count;+B3K0VOc
?>/a$oZ`k;u!g

:|]h-vH,l FL'u vXy
.Fs(s}_"W+U0PF         Zone = new Array(<?=$count?>);
7LU ~ofF7y3mN'I}         Zone[0] = new Array("");%q,]GJ!B`.y\
        F6N PDY
<?       
:s-Aqa+jYX%e         $i=1;
4b2|@2f0fX.b)Z?X1x         while($row2=mysql_fetch_row($result2)) AN#A/xX }\S&H0X
        {        //print_r($row2);Xj ok$|] F
                if($row2[7]!=null)K7@G(`8wL_
                { f;r"B"CV-b
?>               
,a:[&~!Kp Jx                 Zone[<?=$i?>] = new Array("<?=$row2[2]?>","<?=$row2[6]?>","<?=$row2[7]?>");
VpR]RSt <?                !]eu,P*fQ a{
                }
z1zX0W$dz{U b                 else if($row2[6]!=null)
*I4U] MO P6\[+t3d                 {
Rxv(B,Gr&Xb;V ?>               
p1V Y qD8P0V4w J                 Zone[<?=$i?>] = new Array("<?=$row2[2]?>","<?=$row2[6]?>");R%t|[iw^I
<?               
7{cd7e9L                 }
;GQQ+JQ5C+H'_                 else if($row2[6]==null)
:Z gy\t7Ob                 {
cBQ^Gy9C6j ?>               
7hX w"?!LbC9G,n.y5j-p                 Zone[<?=$i?>] = new Array("<?=$row2[2]?>");
f u;eJPt j7s <?                .t'h CR7K ll |
                }                                       
"a1S o*\/l;?X6X                 else if($row2[7]==null)
sXe:l6YJ|(m~W                 {!z0i2[_,A,K-` h
?>                tqxF] `7~S
                Zone[<?=$i?>] = new Array("<?=$row2[2]?>","<?=$row2[6]?>");
gdtVD{8MN G <?               
+r@?6x'u                 }                                       
)|,Sd[\&Pf7m                 $i++;
Gak,L n1d+V|4L         }
1?1Gq*X)OQ?g         mysql_free_result($result2);
c:H6M;b OW4CS g         %]+h7sSJH,W7N
?>        /Hd3Yyl(q&q9F[

*Ba5[3|!?z Gw3x
+[7o/o8w.J_)[4^?'E#~d         ZipCode = new Array(<?=$count?>);
b+jv-gSQJ         ZipCode[0] = new Array("");
0Fjo'A&k)@h(g0p <?       
-x'{N*Q^ [*K[(r         $j=1;.yQ#gjU
        while($row3=mysql_fetch_row($result3)) P0``JASF$\A
        {
9GKl.P:BFWL_                 if($row3[9]!=null)P5[~@$^TQM9]c
                {V~N:TMq
?>                       
6E!]`5o lA                 ZipCode[<?=$j?>] = new Array("<?=$row3[3]?>","<?=$row3[8]?>","<?=$row3[9]?>");`N q`B0o
<?                @gP9\A
                }
e2u7p \ k`8I,y                 else if($row3[8]!=null)D5j)[{&f f
                {
\Y~ {QM$Q0Z7x%n ?>                        .L$yO7Xm8l&h
                ZipCode[<?=$j?>] = new Array("<?=$row3[3]?>","<?=$row3[8]?>"); I-C!?%fW%c5LCmm`u
<?               
,e'V%uHX                 }               
C&}R2[&{#E O u                 elseif($row3[8]==null)i:JU-I3mj1Uj'b(L
                { D.ubJ(HZ
?>                        \ lr3Y!`(z
                ZipCode[<?=$j?>] = new Array("<?=$row3[3]?>");Y,J0^I:H?+q*U3a
<?                Z^ `A eZ2Y-dzLN
                }9L e@ Hp%siS
                else if($row3[9]==null)?3Uto]S"O
                {
"OI R k R VD ?>                       
;M[5\'m5i                 ZipCode[<?=$j?>] = new Array("<?=$row3[3]?>","<?=$row3[8]?>");4I kd(B)F#_ ~
<?                ye9\q4~
                }                                                                               
;Vdd Kt-^ d                 $j++;
R+b^P?5Z         }.O {7X,F5u$B~u(m
        mysql_free_result($result3);
Cy2Jp7pTp
6W1R ~p l }c(X        
xb;H_ o { ?>
,ac"G ?wRC$L function initCounty(countyInput){
f4R-r[3\LoXM         countyInput.length = County.length;@p? j@L(S
        for (i = 0; i < County.length; i++) {(CJ5m$p(xhhHX)S
                countyInput.options[i].value = County[i];*M;]-C:P {!e\y.J.E
                countyInput.options[i].text = County[i];
_%\w/eq8Y D9x1Bk9b:\p a         }Gw2Y_8]m5q6[
        countyInput.selectedIndex = 0;~2N_!s}@S0CFtB W
}
\ W$bLJ
IYC ]+i `I function initZone(countyInput, zoneInput, post ,address, countyindex){
.{}+fNST^;R         changeZone(countyInput, zoneInput, post , address, countyindex);
1Q%Z/_;HT^*a'p/s }%K;A*LAk/o2f}
g @Q&}8rc?:y&J:i
V6QO3A!Gz0M P
!Ru*wM7aQ2J
function changeZone(countyInput, zoneInput, post ,address, countyindex) {T5r3],j Yw
        selectedCountyIndex = countyInput.selectedIndex;5`Zl9DM.`
?:D%|+uhR
        zoneInput.length = Zone[selectedCountyIndex].length;
*nO GP.l R A4xI         for (i = 0; i < Zone[selectedCountyIndex].length; i++) {
5ZPp(@'eQ:H/fW"@                 zoneInput.options[i].value = Zone[selectedCountyIndex][i];
j3|)h'c!ZnU!i                 zoneInput.options[i].text = Zone[selectedCountyIndex][i];-LhV n3t ~/\
                if (zoneInput.options[i].text == "松山區")
9Ipqo9Fi                         zoneInput.options[i].selected = true;
C R.n9p'L         }
-lA4?dH1~:h(L         //zoneInput.selectedIndex = 0;       
w'v1bt;d?yP A         showZipCode(countyInput, zoneInput, post ,address ,countyindex);
4u0R+waA(^j.J]Y }
#N-^;Uw!a&_T *K+N9D{ p
function showZipCode(countyInput, zoneInput, post ,address, countyindex) {#th8f_x8u
        post.value = ZipCode[countyInput.selectedIndex][zoneInput.selectedIndex];
J%w;j(K3eX%q9Ha F~         updateaddress(countyInput, zoneInput, address, countyindex);
;r C;U.I"tHn }
M*b/Z gJ!|| #w(_*H C{.l
function updateaddress(countyInput, zoneInput, address, countyindex) {
"v+fz"f~&q.U7@t         address.value = countyInput.options[countyInput.selectedIndex].text + zoneInput.options[zoneInput.selectedIndex].text ;#ETh"[ o&z
        countyindex.value = countyInput.selectedIndex+1 ; G)@S`/m
}
'Y7mc7F\~k
?Q7f0IN+N(eQ o4C C!}[6V:G.n_n G
//==================== for zip code end =========================\S(U:UDn*tjd

*y"e'v6Py'_-o lQ         function ok(post)                {       
*n'l S:a)c:{y7^0ek                 window.opener.document.theForm.zipcode.value = post.value;
0BT9pc}D^MHF                 alert("您的郵遞區號是"+post.value+"  已經幫您填好了");
*E Pj Of\/J //                window.close(); x'l)otGI0m;hL
        }-q9i.]s"G0H a
       
p1qR-B7Zz%x         function ok2(post,address)                {        'DV0}qNCI.o_N B
                window.opener.document.forms[0].zipcode.value = post.value;
n)y#OZtt:~%Z$w                 window.opener.document.forms[0].address.value = address.value + window.opener.document.free2.address.value;
%uP0C]g                 alert("您的郵遞區號是"+post.value+"  已經幫您填好了");
gxoe S                   window.close();6b,e"GT [9`(I4~fLo
        }w&n3CLZ9V'A Y%c!Bx
        1I0ou:y'];K.Ka
        function ResetAll()                {7E|*d_0M
                initCounty(document.zipForm.countyText);
}5@1`H'k)n                 initZone(document.zipForm.countyText, document.zipForm.area, document.zipForm.zipcode, document.zipForm.address, document.zipForm.county);\w}'w(o3K)_5h
        }|R Vy o2Q

0Q\;d"jvd+CE         ResetAll();I{/UU-R o8s5j+O
q)wg/u5a6vT
// -->VV/AB0un/|

)F+M1yM0E~Gt:\ </script>x*MR?o"{

t:` wM2x W MM"~%^#g <script language="JavaScript" TYPE="text/javascript">A5`%{D$my:p
                function req(myField, myLabel)
fd(P%_(Ya                 {VD0hBs6Ac
                        var result = true;1rVX5YL
                        if (myField.value == "")
6SAN+V*p`p,u1[                         {
/z B,@`E&E T/n                                 alert('Please enter a value for the "' + myLabel +'" field.');
I9psm6I&X                                 myField.focus();
6?W3\K$`+h.Pb                                 result = false;7C`Qo(BzEz
                        }
4z b-ytE\                         return result;Xeq P ENG
                }
0c7}'V q)Jj#W$MW 7xj7?1Pb-f)d M3T s
                function valform(myform)
V"DhwT!V/G:z&y.N                 {
3[&cB:n-W pN W
#ly YX$I D6J(J.V                         if ( !req(myform.countyText, "Company Name")|| !req(myform.day0, "Day")||!req(myform.month0, "Month")||!req(myform.year0, "year")||!req(myform.sumtotal, "Total"))].Lc#?'hN0ij
                        {
Tb v1Q6\8t'D:J                                 return false;BX*V7?p$}
                        }L2d2B$bXVHu]
                        elseH rW7c!yF
                        {
\d%fJD"L Z                                 return true;T*Sxcs^6Gv
                        }x5j.X(b@/\,a
                }Z$kr3ep#Z`!X
                9F;Q%P_#E.\
</script>[/php]
)F.P8`[$K
OUk#ioTE.S 我自己改PHP:$ 不懂是不是你要的

wilsonlee1987 2-10-2007 03:35 PM

回复 8楼 神仙猫 的帖子

我的东西是有存在database 的!!
y}{yD!f(QE9^$x3S G/o'^1i%|
不实在array的!

wilsonlee1987 2-10-2007 03:55 PM

我的code!!#v\9Fe/n"s4Q}!|3dg

XgD6M5u3ZoE <?php
&\\;ei2] o@[ include ("session_judge.php");
2}!h6e(]j![(u2~L:Z include ("connect.php");)W/x U!C!e%dk

m7P0aP;N Y-xPE         if (isset($_POST['assign']))$W)Vl-T5bhf
        {&MZ/[4bF7P9D|D l
                $getlastBigID=$_POST['lastbigId'];Vx6p"q R/U#@
                $getlastSmallID=$_POST['lastsmallId'];ZL5u4yl5{
                $getquantity=$_POST['bigquantity'];2H8gnWz6x3t
#f5D+S7g*G
                $updateBig=mysql_query("SELECT * FROM medicinebig WHERE Medicine_Id = '$getlastBigID'")or die ("Can not Select MedicineBig!".mysql_error());
"n&ycW5I `w                 if(mysql_num_rows($updateBig)>0)
P2~](ax5U(Cl&\3}1xp                 {
Y$bN3{1O\                         $upBig=mysql_fetch_array($updateBig); @ \o-Dt1`u4c0m
               
ia/o9Y3tf5e4r(Ynf                                 $selectBigQuantity=$upBig['Quantity'];
)w/T|4W |+}*G                                 $selectBigWeight=$upBig['WeightBig'];
B{n\u-V&U                                 $selectBigIncomeDate=$upBig['Income_Date'];|8fc3U X/P1A B
                                $selectBigExpiredDate=$upBig['Expired_Date'];p"Z/]X0{+J2W3\ [
!Gi,|6X%fxipjW4e
                        $updateSmall=mysql_query("SELECT * FROM medicinesmall WHERE S_Medicine_Id = '$getlastSmallID'") or die ("Can not Select Medicine Small!".mysql_error());
T6[N0@#@6V8{0R,C                         if(mysql_num_rows($updateSmall)>0)
ljg8G4X"m9Ae                         {
#EH!d vz9W4h                                 $upSmall=mysql_fetch_array($updateSmall);M|!B4x3?5fI/QL i.\
                                J\ E+n"L$Nt5? q
                                $selectSmallWeight=$upSmall['Weight_Small'];o.C"u:A,@C:o
                                $selectSmallQuantity=$upSmall['Quantity'];
9QWk!R0wY b6r                                 echo $selectSmallWeight;
w;y?~8y-SU kAR8gpG'W5l6fi
                                $reQuantity=$selectBigQuantity-$getquantity;.qN&m Ulud
                                $calWeight=$getquantity*$selectBigWeight;
EINM?8} F                                 $calSmallQuantity=$calWeight/$selectSmallWeight;RS `e:i-U
                                $finalSmallQuantity=$calSmallQuantity+$selectSmallQuantity;
&yf|-pg F"g8C.?'uW b&qdF,KX;?8JF
                                $updateMedicineBig=mysql_query("UPDATE medicinebig SET Quantity ='$reQuantity' WHERE Medicine_Id ='$getlastBigID'")or die ("Can not update Medicine Big Quantity!".mysql_error());
"d;Zv$L1XwJ Y-L9ENnR 7l)J:nR SJ/Y0e
` x9r l B9}6D(a
                                $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());o&J(z)s8Z+R*\Y.o
8Km~4bh6f Uy w |3Y&Mg
                                echo "<script>alert('Assign Medicine Successfully!')</script>";
L{+x^9{+e1TWl                                 echo "<script>window.location='AssignMedicine.php'</script>";(y r3V,Yqqad8}
                        }
p6q2P#K3d8t"n (n DD,Lf7B%\E V+^
                }
}|x-jt GTjb1u eqn3O }@ i
        }]8YP0??K8G o_iu

/a0x0VIu;gi*{S[a
,s| Py.ZLo ?>,jCv3}+EY*n Gj
<html>;e${ NnG
<head>
:R HlYy9v1H2Y1a/J <title>Pediatric Clinic System - Assign Medicine System</title>
*uV5g|5W.H L <link rel="stylesheet" type="text/css" id="css" href="./css.css">
&|3L,}M:wE~ KG L <script type="text/javascript" src="./menu.js"></script>
Yv'B])I]7@({ I.Q <SCRIPT LANGUAGE="JavaScript">*s ?L$[j:r^`}
<!--
e6EC3i|C:G8IH~%P function ValidatorForm(theForm)
:]V ?4Yl {
k7@:XtT:K+v~6H         if (theForm.bigquantity.value == "")/UO0K)H @z_ n
        {1PO-j m I};OMi
                alert('The Assign column can not be blank!'); Z AD5\9K'[ N(M
                theForm.bigquantity.focus();
,m"]t L H3W8m                 return(false);
+vSE-O^2DR         }o ~%w.Db6K^&Y]'` j
}#y-y)Bw lU'wj s9i
//-->
*[5K'`Pv'hJ </SCRIPT>{O2k2y%k%_J^%M
</head>
*|j+EU `5V8NK[u <body>U~ AIts
<hr>
WS1I"_w <h1>Assign Medicine</h1>
h@~mp(St[ <hr>
Tc$T ? tL3C#y <?php@.G5U|o{!P V3J
include ("doctorlabel.html");
P%X\#j^E@.s C $medicine=$_POST['txtMedicineBig'];
K"F@6Y ^'c] $medicinesmall=$_POST['txtMedicineSmall'];K8ayHC
?>
4?"j3jb/zX P;o$Akw <Form name="AssignMedicine" method="get" action="AssignMedicine.php?MedicineBig=<?php echo $_GET["txtMedicineBig"];?>">Zx9UyD E
<table border="1" align="center">
*Pjssi         <tr>R @t&DQ
                <th align="left">Assign Medicine Big Name:</th>
lh.k&CU9q3K                 <td><SELECT NAME="txtMedicineBig">bmz)z[`9lM
                <?phpI*I b!K"z
                        $define=$_GET["BIGID"];
O2x]w)U9A6h h                         $verify=$_GET["Check"];#yhP3m7nD!r%YH
                       
9P;{$n+Vy SvH                         $sql=mysql_query("SELECT * FROM medicinebig ORDER BY 'Medicine_Id'");,t?pl`Pc
                        if (mysql_num_rows($sql)>0)
s)TM W,D7Y+z"g                         {
&g,`9kw[["_                                 while ($sqlmedicine=mysql_fetch_array($sql))
c.zqr7P:U}({                                 {
){1J"?*})D N                                         echo "<option value='".$sqlmedicine['Medicine_Id']."'";
0Q%VI9R9p)lGs                                         if ($_GET["txtMedicineBig"] == $sqlmedicine['Medicine_Id'] || $define == $sqlmedicine['Medicine_Id'] || $verify==$sqlmedicine['Medicine_Id'])
6sf-h:x/rm3Uw E                                         {R2rv)s-B
                                                echo "Selected=Selected ";/{y \HIS?
                                                r7Y gS5hA
                                        }
$W3]e"Xm zU8U)U!`                                         echo ">".$sqlmedicine['Medicine_Id']." - ".$sqlmedicine['Medicine_Name'];
0Af)MPFhv.T3{V W7@                                 }6I s&]W2Z{ l
                        }
`(g"w4i5gS Jq                 ?>
TR1Su0|_6^W                 </SELECT></td>1o _-z%pfP ~5KL!Q
                <td><input type="submit" name="Searchbig" value="Search"></td>
uP\"wGl,d         </tr>
5~+t@T%Rx7j </table>Vf U'u T }r(h%l
</Form>(ow;qY!I ?4h+o
<BR>
'S6dx|OA-` <?php Nu+wL"B5L4}u
$medicinesmall=$_GET['txtMedicineSmall'];&s a.tVFw G
        if(isset($_GET['Searchbig']) or isset($_GET['SearchSmall'])):Z\a'L0g3J0Zc N9\&l
        {i0V7H(O7CSR
                $getID=$_GET['txtMedicineBig'];2gV7Q"l$B
                ?>o&[*jpd
<Form name="AssignMedicineSmall" method="GET" action="AssignMedicine.php">
B ~#T_ ?/j5D <table border="1" align="center">
;P)@-{$C'YK xn o         <tr>
#qv5I sVQ`%uE.Y                 <th align="left">Assign Medicine Big Name:</th>o+k-D8Zz x
                <td><SELECT NAME="txtMedicineSmall">
O:O t"l#b&V5JC                 <?php
B7BrCY)q(x                 $sqlfirst=mysql_query("SELECT * FROM medicinesmall WHERE Medicine_Id='$define' or Medicine_Id='$getID' or Medicine_Id = '$verify' ORDER BY 'Medicine_Id'");
~.NE)m r)S@*?                         if (mysql_num_rows($sql)>0)r"vA dy8s
                        {
:K%?.N1Df8Miy6b                                 while ($sqlmedicinesmall=mysql_fetch_array($sqlfirst))
bK8R&q)lFN/U                                 {Ku |8K0O4w6s(j
                                        echo "<option value='".$sqlmedicinesmall['S_Medicine_Id']."'";
q'oG ]O                                         if ($_GET["txtMedicineSmall"] == $sqlmedicinesmall['S_Medicine_Id'])k&g4N EBR
                                        {$cia8eO%i,p
                                                echo "Selected=Selected ";
cBJ O5Z                                         }%VH,F SgA
                                        echo ">".$sqlmedicinesmall['S_Medicine_Id']." - ".$sqlmedicinesmall['Medicine_Name'];
5{6}S)s2]4qM`                                        
]:K T_E m5vK9e                                 }
{E(g/r!HV                         }m*usm#F$tjY
                ?>
im G k(C+j5l2w1d                 </SELECT></td>m0B/P `H3eO
                <input type="hidden" name="BIGID" value="<?php echo $getID;?>">
ME {-NrPJ}                 <input type="hidden" name="Check" value="<?php echo $define;?>">3Ei5C&B#^H#Z k
                p5L ~:P3u W/kdt?
                <input type="hidden" name="smallID" value="<?php echo $_GET['txtMedicineSmall'];?>">
z _8Ghy B                 <td><input type="submit" name="SearchSmall" value="Search"></td>
/Vt'h d T         </tr>{"U5m vL@d
</table> a2Dbd&a(@3s!M*i"]
</Form>
t ~B d |l?Mb? <BR>
}N@I)N-\0g <?php
H'i |NT:L         }Kz0~%Y[5y#|6A
                if(isset($_GET['Searchbig'])or isset($_GET['SearchSmall']))
cDnY(l/o'pUH;G                 {*_/LB/BUG7y
                        $getID=$_GET['txtMedicineBig'];
6@:x.d+[%WL RW;_                         $medicinefirst=mysql_query("SELECT * FROM medicinebig WHERE Medicine_Id ='$getID' or Medicine_Id='$define' or Medicine_Id ='$verify' or Medicine_Id='$reID'");1z3Y&U$d8IE
                        if(mysql_num_rows($medicinefirst)>0)l ETX1w)Qw/d
                        {
(L,jn5F3p C ?>
AQT}j![!F R Z1w v9t         <Form name="assign" method="post">
V{S'| B*zW                 <table align="center" border="1">B!{J+m:K K\;x#]5P!o
                <tr><th colspan="4" bgcolor="#FF0000">Medicine Big</th></tr>
{x,JN~0h1bzi2PTz                 <tr>
L7WI?5C0F"h&X                         <th>Medicine Name:</th>
1`0US'W9L!J{Ku                         <th>Quantity</th>Q1~EO1YR;J8j
                        <th>Weight</th>`2]:EsI.t*Y*JN
                        <th>Weight Type</th>
b x!i7DH5r                 </tr>&K)yu'eE.k.ITJ
                        <?php
2f/bW{[zV                                 while($details=mysql_fetch_array($medicinefirst))
o~vx)F                                 {.s2sV|C:Bj#p8A
                                        $reID=$details['Medicine_Id']; y%['[h*zsK
                                        echo "<tr><td>$details[Medicine_Name]</td>";SdP/\Vz
                                        echo "<td>$details[Quantity]</td>";
{-to~o$t                                         echo "<td>$details[WeightBig]</td>";d}ku3S%d1ad[\$q
                                        echo "<td>$details[weight_Type]</td></tr>"; WM+vh]5?
                                }a.i%zG1e
                        }
*Y h6A Z/xTYCdp                         $getsmallID=$_GET['txtMedicineSmall'];#k8m,Ck{/o3uqIe4xe
                        $medicinesecond=mysql_query("SELECT * FROM medicinesmall WHERE S_Medicine_Id ='$getsmallID'");
'{'C qfk                         if(mysql_num_rows($medicinesecond)>0)
!Z0f0r6X\z ?                         {
M3h/~:Tq3mOGO*R ?>                <table>
({K,lj;YJ^y[                 <BR><BR>)A k1~/KG)A7VI
                <table align="center" border="1">
z-H xN0c4D |                 <tr><th colspan="4" bgcolor="#FF0000">Medicine Small</th></tr>n!X d7OLwY
                <tr>7g2G7I;fq)d5X
                        <th>Medicine Name:</th> i'H$?,@|%v3q
                        <th>Quantity</th>tyOc4Z1vu/q
                        <th>Weight</th>`,x"Aa2s Y:c*a
                        <th>Weight Type</th>@o%h_Xd0{2Q+Y-V } Y'V
                </tr>
BD(x$d T5Yn[#qE                 <?php
&K qL|*G U5a9B                                 while($seconddetails=mysql_fetch_array($medicinesecond))!Rn.@t)L5N
                                {5JVY,G+n @ v$hv8o
                                        $resmallID=$seconddetails['S_Medicine_Id'];
X8Ii5G jC^ uC,b)u"Y                                         echo "<tr><td>$seconddetails[Medicine_Name]</td>";wf&H2G2_M@c,^v
                                        echo "<td>$seconddetails[Quantity]</td>";
ZSMF\I]                                         echo "<td>$seconddetails[Weight_Small]</td>";
N(v]t1g+|,nVW6Z,D                                         echo "<td>$seconddetails[weight_Type]</td></tr>";
]M3r2^.A/a                                 }I+]{s-h Q
                ?>6PA&A2b!h/a)B
        </table>Y)K^)tN%A8LX&g
</Form><BR>8]7Xy`F \
<Form name="assignfinal" onsubmit="return ValidatorForm(this)" method="post">5KD9ZO%a
        <table align="center">!QZ9V S [] g)}0F
                <tr>E*T NW` O8Q1Sj`
                        <th>Assign Medicine Quantity From Medicine Big:</th>4l7M"[KJ2kC`,}
                        <td><input type="text" name="bigquantity"></td>
+nF8wCm z                         <input type="hidden" name="lastbigId" value="<?php echo $reID?>">
G%pj)u'T'PW                         <input type="hidden" name="lastsmallId" value="<?php echo $resmallID?>">&L k0v u4u(d(E
                        <td><input type="submit" name="assign" value="Assign"></td>
H!eKw?K                 </tr>
"L&B{ iF         </table>SZ|2ADw
</Form> w U'Yi1M|.\
<?php
F4D!DX8otB-Xd#H                         }
-y @}`f)T8[Z5@'M                 }
$A5[`8C5ATGn;n ?>$q ]3A S*} uPl-G
</body>M.C5yZ[iR`
</html>

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

如果有存 database,就不需要那么麻烦作什么 session 了。
}X)S _t[ medicine big 选择了之后用 onchange 更新 medicine small,就这么简单。
bX#[!C)_U
/xk.P r _;P0^[)S [hr]deeppink[/hr]
6x;E q)Q(f*Ql <script language="javascript">
1Y3QKn7m function [color=DarkOrange]OnChange()[/color]_#W^D-h,y.m`
{4F+[EQ^.v;lA
        var id=document.[color=Green]form[/color].[color=Red]mid[/color].options[document.[color=Green]form[/color].[color=Red]mid[/color].selectedIndex].value;*{ M-c0?iJ2I
        window.location.href="[color=Blue]medicine.php[/color]?[color=Red]mid[/color]="+id;5h*[Z.sxc
}(h7jc1~j1GC _$nOw?
</script>
-PRDRQjcJ"|
I!cH$n_ tf <form action="某些目标档案" method="post" name="[color=Green]form[/color]">jbey/O2_K
<table><tr> e&hu5rh-vxhh
        <td align="right">Medicine Big :</td>.a-V!G C{
        <td align="left"><select name="[color=Red]mid[/color]" onchange="[color=DarkOrange]OnChange()[/color]">[color=Blue]SQL Select 的 result(big)[/color]</select></td>*?]wBjP
</tr>XS,j!V?f;t
<tr>SO^W,vr5_P#z
        <td align="right">Medicine Small:</td>
cDhw-z'oT[{`         <td align="left"><select> [color=Blue]SQL Select 的 result(small)[/color] </select></td>
%nJi)Oct1B </tr>d}#LN p:qq'v
</table>
6FQ]ivK <center><input type="submit" value="Insert"></center>
`B F;@/cX6? </form>
-h8a,Zq|;Z
ajUB;I'J [hr]deeppink[/hr]
$|0U6mwJ`(D e@ RpDq7k(M(ih)I*k,c3q
其中,medicin.php 就是你的 php 执行程序,mid 是 medicine big pass 进去的 value,用它来 select medicine small。
*bh?V`;CK} 之后把得到的 result 输出在 small 的 select。
e { BdTrm 红色字部分的 mid 是相对应,就这样。&N:Biwc-L1L
:ONI71: :ONI71:

wilsonlee1987 2-10-2007 10:52 PM

回复 14楼 神仙猫 的帖子

我试试看!!
yHu;fCS 谢谢帮忙!w!b7dI,l6f1@ Y]
可能过后还有一些问题会问你们!

wilsonlee1987 3-10-2007 12:15 AM

他没有反应!!
(?g0r(id+W 4zx*a7?2rk!Vs
function OnChange()
B#TxR DIg9QZ (
1o3Fzzr,}$G0Qr         document.write("HAHA!");gl9~'sN
    var id = document.AssignMedicine.txtMedicineBig.options[document.AssignMedicine.txtMedicineBig.selectedIndex].value;  window.location='AssignMedicine.php?txtMedicineBig='+id;
7z6a%E/sGv)Z6h7R         u S:?Z9jiP
}
!L!tq5b*\P5o:G //-->#m4m2aZ,sWvI
</SCRIPT>mH O~7q
</head>R3RC&L1L l&RIj+x&H:a
<body>
"p%E-j!q)x <hr>
3x wN3cJe*O,{ <h1>Assign Medicine</h1>(Oz _z~1a6M)g
<hr>
r2N2g-s X <?php;yY2B[Q%JK/p
include ("doctorlabel.html");`7nZG:F4cs$Y'uO
$medicine=$_POST['txtMedicineBig'];
cXZxr.`9H[n $medicinesmall=$_POST['txtMedicineSmall'];}a9T$N`f
?>*C e+_R:z{D!h{ _
<Form name="AssignMedicine" method="post" OnChange="OnChange()" action="AssignMedicine.php">V7[:U!uBC*v0J5?
<table border="1" align="center">;rG@];oI5T
        <tr>py*B1o&e0EU;r6~
                <th align="left">Assign Medicine Big Name:</th>
J[_y:kBG%ns E&z                 <td><SELECT NAME="txtMedicineBig">_k&q#EAp~
                <?php
Z6JI'{|`s)j&s*W                         $define=$_GET["txtMedicineBig"]; %hf/L+]^%BD
                        $verify=$_GET["Check"];0qts|KL'K(G}"s
                       
s&@d5D$poh                         $sql=mysql_query("SELECT * FROM medicinebig ORDER BY 'Medicine_Id'");
Sk};O)Pz!_                         if (mysql_num_rows($sql)>0)Mg)nc9Sya
                        {
1vLz!x*^*l m\                                 while ($sqlmedicine=mysql_fetch_array($sql))I Pj pSs%Uv
                                {*jP$@?h&T
                                        echo "<option value='".$sqlmedicine['Medicine_Id']."'";
h3w*H^IU kj                                         if ($_POST["txtMedicineBig"] == $sqlmedicine['Medicine_Id'] || $define == $sqlmedicine['Medicine_Id'])'Cdh0~/jtd)G_.G r
                                        {K?H7c.A)n r:n$l~\
                                                echo "Selected=Selected ";
} S }7]G+~ U'Mw                                                
pU;N&V So                                         }
,d6Nk7g1h                                         echo ">".$sqlmedicine['Medicine_Id']." - ".$sqlmedicine['Medicine_Name'];
AW` u_*ozT,i                                 }
2K{x^!K:UL                         }vfI ^u!{
                ?>D-k/f^aF*y S
                </SELECT></td>8vdjB eqB
        </tr>
7{,Diku-_2[7~ </table> ]T5Oy D hQ1G.g
TrLUD i K

-kgyl*L!L{8J"F X <?php
~v\6V8z6ss|9@         H'\4U9^"Ge LK/U4B
$medicinesmall=$_GET['txtMedicineSmall'];"zq;_3PL

*K1QP8S m*XX                 $getID=$_GET['txtMedicineBig'];
%Z-`gxc4gH+VD                 ?>1S(M4w0YM
<table border="1" align="center">:TGJ F+y;U9V?
        <tr>
uIcG.{m ^j                 <th align="left">Assign Medicine Big Name:</th>
2D*}3_ev_                 <td><SELECT NAME="txtMedicineSmall">
0] E~#yU"^                 <?php
Kifd y+mG$k                 $sqlfirst=mysql_query("SELECT * FROM medicinesmall WHERE Medicine_Id='$define' or Medicine_Id='$getID' or Medicine_Id = '$verify' ORDER BY 'Medicine_Id'");
MNZl K|%t/]                         if (mysql_num_rows($sql)>0)9W]}!u3E ~
                        {
X*Q"xv/[cE7K6\                                 while ($sqlmedicinesmall=mysql_fetch_array($sqlfirst))6yN-cs3B@
                                {
EY4RF A~7i*_z p w                                         echo "<option value='".$sqlmedicinesmall['S_Medicine_Id']."'";
6v{ utE x                                         if ($_GET["txtMedicineSmall"] == $sqlmedicinesmall['S_Medicine_Id'])I/\.p!B_.Z
                                        {&Qo8S:N+l s4L/{5S
                                                echo "Selected=Selected ";_J*v8g9Q??
                                        }'^qMpD_K
                                        echo ">".$sqlmedicinesmall['S_Medicine_Id']." - ".$sqlmedicinesmall['Medicine_Name'];
Dx D^$H0j omj                                        
p0suJ(fG                                 }
fC-d6N-]4?,y.U                         }
"Q;{*f cx7O"F d^                 ?>jvl ~Js
                </SELECT></td>
,g-I*t$r%h Ylm&JmK                 <input type="hidden" name="BIGID" value="<?php echo $getID;?>"> W7w fk])yl
                <input type="hidden" name="Check" value="<?php echo $define;?>">
T,F~4oE1c;z                 ;uK+NKF6Sw
                <input type="hidden" name="smallID" value="<?php echo $_GET['txtMedicineSmall'];?>">9p~zRL ]:o
                <td><input type="submit" name="Searchbig" value="Search"></td>
^$a})q5o4g%ti*}         </tr>.{%L.n}YB
</table>0u#f:L!f$T2PaD6W
</Form>

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

你完全理解错误。。。5? C,Z.o#EC
onchange  是必须放在 <select> 这个 HTML tab 里的。4WM4]8k5Y7V?
当你 select medicine big 这个 tab 之后,onchange 执行 javascript pass medicine big value 去 php,用它来找出 medicne small,在 show 回去 medicine small 的 <select> tab。!`@8{-Rp0Q#u.R*DU
*w&jJ-X.d#{ F
放在 <select> tab 里面最大的作用就是,RT*]-a*~ Po9O @
当你选择了 medicine big 之后,就执行 onchange。
"q;K&b7C7E+TD6B 你把 onchange 放在 <form> tab ,就必须要按 submit button 之后才有动作了。 {9x2g6odpQ)Bt(q
U-PS!hq_"^
这些和 php 无关。
bgv|B A html 标签和 dom 要搞清楚啊。。

wilsonlee1987 3-10-2007 02:24 PM

回复 17楼 神仙猫 的帖子

sorry上面那个是我比较早的!!-R l2Q/V*v]
我后来有改了!
O`}"^(Q4|4e 还是不行 H@o]!F w9g!o7M

]#oW#L"Z%T6Y;xO 而且我发现到,我完全进不到onchange的code里面!!
!^0ERE&IqX w9iiqV#e{i
-----------------:ht*wv*S o/O
这是我用来test的!PD;n,t6@8v*s
可执行的codeCu|m@ZN
~&O_/?:X5U;I
<HTML>
P?/O ZT0C <HEAD>"`,m-AR}/w
<TITLE> New Document </TITLE>o8\j.skCgv
<SCRIPT LANGUAGE="JavaScript">
D i{V2LA7sLP` <!--@ S0^u3D bt8C
function handler()a5LDT1WD
{.[s;sVW#y&H$xvm'G
        yesno = confirm("Want to Change?");pI+fg&u4yO2O
        if (!yesno) form.s1.value="Big Mac";9`+bfe0tb
}#~&h9c@&@5Q S.}x\
//-->
\8Vu6N/t3bm$?)N0@ l*f3EIN-W4S q
</SCRIPT>
\ub G6^;h N </HEAD>$y CE$D1[_ ['l4^7_^
#b yz6Re{ Uj'Hh
<BODY> g[xYQ
<Form name="form" >
tR J_ d5K first        <INPUT TYPE="text" NAME="s1" value="Big Mac" onChange="handler()"><BR>
(^rPl Il second        <INPUT TYPE="text" NAME="s2" value="Coke">(GVSF S'LA
<INPUT TYPE="submit" name="submit" value="submit">
AcV R/d0Pv </Form>
e!?*L `$Y9B,Z'v6?] </BODY>
A-zr@weO,d </HTML>
;H.[Yt2gF+?
@q'i7J,|`]:] -----+wB4D A dq'F yQ
执行不到的code!!N GY/~G.t
$n+r@n @-Zn Ac
<script language="javascript">+h)?Dl#G'] }
{
G;l3T8b(L~ function handler()6tgW U'anOw0CC
( 5G1^n4SsgQ:WL6b
alert('haha');@r0{8v tQ
    vi=document.form.mid.options[document.form.mid.selectedIndex].value;  window.location.href="medicine.php?mid="+vi;.i#L5t.D+A/B pk)]_k
jJ_ K,\C
}drsyKT s
/*function handler()
:h,hOL:jf4P"r^,Y K {]3\iK9['[$~{
        yesno = confirm("Want to Change?");
}}1a IvN4xS E         if (!yesno) form.mid.value="Big Mac";
]8t1B#^Ms }*/
ku_)L[K s
-~ PeoC 5`Q;q-P] j
O9M(UP4Z6d
</script>
#B`V8z$`.rc7E
*UOI!f9CS8e*f <form name="form">+[c&i5D4D|i
<table><tr>
$f$C#M$@5g         <td align="right">Medicine Big :</td>UdID2x.L!k9[A G
                <td align="left"><INPUT TYPE="text" NAME="mid" value="Big Mac" onchange="handler()">
4W?a&}/ne%V0W eu         </td>|by{ nFh'f;q
</tr>J5m*VP\W)Y
<tr>@]5o M&Q&Rm
        <td align="right">Medicine Small:</td>!xOdCh^"V^
        <td align="left"><INPUT TYPE="text" NAME="mi" >F0UCz+M*p$fU/r(G-p
                </td>
X)}Q)e3r                 </tr>&leC7l&h/x8x4V^,~
</table>7R)o"\ k3N&@.u#Q
<center><input type="submit" value="Insert"></center>
2lo0tP\'@ E W3oJ,{ </form>
3s$T2eo:|!@*KS 5\ M-s:PR d4zN
[[i] 本帖最后由 wilsonlee1987 于 2007-10-3 02:35 PM 编辑 [/i]]

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

回复 18楼 wilsonlee1987 的帖子

老板,onchange 的 event handler 必须是当前值有改变才会产生 event。。's2gkV%W ?9~
event 产生在 onblur 之后。
&{z&x0`2`:xA9l -th%Ij-m/tT~
[url]http://www.w3schools.com/jsref/jsref_onchange.asp[/url] `(WTi%@IjBv N
[url]http://msdn2.microsoft.com/en-us/library/ms536912.aspx[/url]2h3ld&@4K jP

T;e`$F? [hr]deeppink[/hr]
%yelTvO-H$| <script language="javascript">
y8SV c;fw,? dU/Q function Handler()}*@|3w!b
{
|DM(BNwq_;p         alert("Hahaa");
RN$K@I4e`3{E }
9k!m(bEpU.Vd </script>r,|Ec7Q R+I
<form>
K]:w9Cy&^FoC7e2~T <input type="text" onchange="Handler()">;r&a:M3@5?|L]/c
</form>
q1V B M-Lr~x
E)E2d1MNE [hr]deeppink[/hr]
"chP%?^P_1M 随便打东西,然后按 tab 看效果。
页: [1]
查看完整版本: 请求帮忙!!