请求帮忙！！(页 1) - P 语言 - E-DYN 异皇朝 - 马来西亚中文论坛 - 你我相遇的地方

wilsonlee1987 1-10-2007 01:04 AM

请求帮忙！！

问一下！！
如果我在一个界面，一直select一个值，而这个值不会变！L*|y.a5Q4JQ*vL
我要怎样去写？用php!!W'W@*pF]]
比如2X$K;CO;G4U3nJ&R"LT
我选择了第一个Medicine Big的值（注：listbox) U*G2k3w:KA
然后我按submit的按钮，

过后我下方会显示一个medicine Small的list box
当我选择好后，按select button(注：不是上面的submit buttton，是另外一个） j]D)O)M9r2|6^|(G$j
k'Oz1D/N2Q%y v
问题来了，就算我不挂南多少次，他都是要显示我之前所选择的Medicine Big的值在我德Medicine Big 的list box那边！
请问要怎样做?;P:gZ9N1?ZO:[

[[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 了之后，
上面的medicine big的值还是focus在我之前选的值！！
而且还可以抓到的那种！！/L*H Czh+H\&O

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

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

那为什么要那么麻烦选了 Medicine Big 之后要按 submit 才选择 Medicine small ？
把两个 listbox 都放在同一页不是更简单吗。。？
:ONI71: :ONI71:

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼神仙猫的帖子

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

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼神仙猫的帖子

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

像在目前为止，我想到一个方法，就是用session来存id,不懂这个行得通吗！！G9Y,D_.lyPBQ
问一下！

wilsonlee1987 1-10-2007 08:59 AM

回复 4楼神仙猫的帖子

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

像在目前为止，我想到一个方法，就是用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>
3_2V9ci4j&C8Xp_5Vx
<script language="JavaScript">
<!--
//==================== for zip code begin =========================K[ TFI
County = new Array("台北市","基隆市","台北縣","宜蘭縣","新竹市","新竹縣","桃園縣","苗栗縣","台中市","台中縣","彰化縣", "南投縣","嘉義市","嘉義縣","雲林縣","台南市","台南縣","高雄市","高雄縣","澎湖縣","屏東縣","台東縣","花蓮縣", "金門縣","連江縣","南海諸島","釣魚台列嶼","外國");//全省各縣市
Zone = new Array(28);
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("宜蘭市","頭城鎮","礁溪鄉","壯圍鄉","員山鄉","羅東鎮","三星鄉","大同鄉","五結鄉","冬山鄉","蘇澳鎮","南澳鄉");//宜蘭縣
Zone[4] = new Array("");//新竹市
Zone[5] = new Array("竹北市","湖口鄉","新豐鄉","新埔鄉","關西鎮","芎林鄉","寶山鄉","竹東鎮","五峰鄉","橫山鄉","尖石鄉","北埔鄉","峨嵋鄉");//新竹縣(_u;ue^9{ c [6}.k&\
Zone[6] = new Array("中壢市","平鎮","龍潭鄉","楊梅鎮","新屋鄉","觀音鄉","桃園市","龜山鄉","八德市","大溪鎮","復興鄉","大園鄉","蘆竹鄉");//桃園縣
Zone[7] = new Array("竹南鎮","頭份鎮","三灣鄉","南庄鄉","獅潭鄉","後龍鎮","通霄鎮","苑裡鎮","苗栗市","造橋鄉","頭屋鄉", "公館鄉","大湖鄉","泰安鄉","鉰鑼鄉","三義鄉","西湖鄉","卓蘭鄉");//苗栗縣5` rx w%q5`
Zone[8] = new Array("中區","東區","南區","西區","北區","北屯區","西屯區","南屯區");//台中市
Zone[9] = new Array("太平市","大里市","霧峰鄉","烏日鄉","豐原市","后里鄉","石岡鄉","東勢鎮","和平鄉","新社鄉","潭子鄉", "大雅鄉","神岡鄉","大肚鄉","沙鹿鎮","龍井鄉","梧棲鎮","清水鎮","大甲鎮","外圃鄉","大安鄉");//台中縣
Zone[10] = new Array("彰化市","芬園鄉","花壇鄉","秀水鄉","鹿港鎮","福興鄉","線西鄉","和美鎮","伸港鄉","員林鎮","社頭鄉", "永靖鄉","埔心鄉","溪湖鎮","大村鄉","埔鹽鄉","田中鎮","北斗鎮","田尾鄉","埤頭鄉","溪州鄉","竹塘鄉","二林鎮", "大城鄉","芳苑鄉","二水鄉");//彰化縣
Zone[11] = new Array("南投市","中寮鄉","草屯鎮","國姓鄉","埔里鎮","仁愛鄉","名間鄉","集集鄉","水里鄉","魚池鄉","信義鄉","竹山鎮","鹿谷鄉");//南投縣
Zone[12] = new Array("");//嘉義市
Zone[13] = new Array("番路鄉","梅山鄉","竹崎鄉","阿里山鄉","中埔鄉","大埔鄉","水上鄉","鹿草鄉","太保市","朴子市","東石鄉 ","六腳鄉","新港鄉","民雄鄉","大林鎮","漢口鄉","義竹鄉","布袋鎮");//嘉義縣\m4Um#u;AXr
Zone[14] = new Array("斗南市","大埤鄉","虎尾鎮","土庫鎮","褒忠鄉","東勢鄉","台西鄉","崙背鄉","麥寮鄉","斗六市","林內鄉", "古坑鄉","莿桐鄉","西螺鎮","二崙鄉","北港鎮","水林鄉","口湖鄉","四湖鄉","元長鄉");//雲林縣+R&bD#{"i\9z2RL
Zone[15] = new Array("中區","東區","南區","西區","北區","安平區","安南區");//台南市
Zone[16] = new Array("永康市","歸仁鄉","新化鎮","左鎮鄉","玉井鄉","楠西鄉","南化鄉","仁德鄉","關廟鄉","龍崎鄉","官田鄉", "麻豆鎮","佳里鎮","西港鄉","七股鄉","將軍鄉","學甲鎮","北門鄉","新營市","後壁鄉","白河鎮","東山鄉","六甲鄉", "下營鄉","柳營鄉","鹽水鎮","善化鎮","大內鄉","山上鄉","新市鄉","安定鄉");//台南縣
Zone[17] = new Array("新興區","前金區","苓雅區","鹽埕區","鼓山區","旗津區","前鎮區","三民區","楠梓區","小港區","左營區");//高雄市5I_;mp!~/e#}a
Zone[18] = new Array("仁武鄉","大社鄉","岡山鎮","路竹鄉","阿蓮鄉","田寮鄉","燕巢鄉","橋頭鄉","梓官鄉","彌陀鄉","永安鄉", "湖內鄉","鳳山市","大寮鄉","林園鄉","鳥松鄉","大樹鄉","旗山鎮","美濃鎮","六龜鄉","內門鄉","杉林鄉","甲仙鄉", "桃源鄉","三民鄉","茂林鄉","茄萣鄉");//高雄縣
Zone[19] = new Array("馬公市","西嶼鄉","望安鄉","七美鄉","白沙鄉","湖西鄉");//澎湖縣U&rey}9zw?.TJ
Zone[20] = new Array("屏東市","三地門鄉","霧台鄉","瑪家鄉","九如鄉","里港鄉","高樹鄉","鹽埔鄉","長治鄉","麟洛鄉","竹田鄉 ","內埔鄉","萬丹鄉","潮州鎮","泰武鄉","來義鄉","萬巒鄉","嵌頂鄉","新埤鄉","南州鄉","林邊鄉","東港鎮","琉球鄉 ","佳冬鄉","新園鄉","枋寮鄉", "枋山鄉","春日鄉","獅子鄉","車城鄉","牡丹鄉","恆春鎮","滿州鄉");//屏東縣
Zone[21] = new Array("台東市","綠島鄉","蘭嶼鄉","延平鄉","卑南鄉","鹿野鄉","關山鎮","海端鄉","池上鄉","東河鄉","成氐","長濱鄉","太麻里鄉","金峰鄉","大武鄉","達仁鄉");//台東縣
Zone[22] = new Array("花蓮市","新城鄉","秀林鄉","吉安鄉","壽豐鄉","鳳林鎮","光復鄉","豐濱鄉","瑞穗鄉","萬榮鄉","玉里鎮","卓溪鄉","富里鄉");//花蓮縣
Zone[23] = new Array("金沙鎮","金湖鎮","金寧鄉","金城鎮","烈嶼鄉","烏坵鄉");//金門縣~/d ~~"cl9@m
Zone[24] = new Array("南竿鄉","北竿鄉","莒光鄉","東引");//連江縣
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^Dw
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");//基隆市
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");//宜蘭縣
ZipCode[4] = new Array("300");//新竹市
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");//桃園縣
ZipCode[7] = new Array("350","351","352","353","354","356","357","358","360","361","362","363", "364","365","366","367","368","369");//苗栗縣
ZipCode[8] = new Array("400","401","402","403","404","406","407","408");//台中市
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");//台中縣
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");//嘉義市
ZipCode[13] = new Array("602","603","604","605","606","607","608","611","612","613","614","615", "616","621","622","623","624","625");//嘉義縣
ZipCode[14] = new Array("630","631","632","633","634","635","636","637","638","640","643","646", "647","648","649","651","652","653","654","655");//雲林縣
ZipCode[15] = new Array("700","701","702","703","704","708","709");//台南市
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");//高雄縣
ZipCode[19] = new Array("880","881","882","883","884","885");//澎湖縣0K2vns?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");//屏東縣
ZipCode[21] = new Array("950","951","952","953","954","955","956","957","958","959","961","962","963","964","965","966");
ZipCode[22] = new Array("970","971","972","973","974","975","976","977","978","979","981","982","983");//花蓮縣
ZipCode[23] = new Array("890","891","892","893","894","896");//金門縣
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(" ");//外國!vac9L6FJt/o

[/quote]Nd%~ d'x!Qrkp'v
*E2b^8J2_
显到暴多过一万你自己接下面的

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

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

[php]<script language="JavaScript" TYPE="text/javascript">9} j(pJ;aJe+@+\
VV/AB0un/|

</script>x*MR?o"{

<script language="JavaScript" TYPE="text/javascript">A5`%{D$my:p
function req(myField, myLabel)
{VD0hBs6Ac
var result = true;1rVX5YL
if (myField.value == "")
{
alert('Please enter a value for the "' + myLabel +'" field.');
myField.focus();
result = false;7C`Qo(BzEz
}
return result;Xeq PENG
}
7xj7?1Pb-f)dM3T s
function valform(myform)
{

if ( !req(myform.countyText, "Company Name")|| !req(myform.day0, "Day")||!req(myform.month0, "Month")||!req(myform.year0, "year")||!req(myform.sumtotal, "Total"))].Lc#?'hN0ij
{
return false;BX*V7?p$}
}L2d2B$bXVHu]
elseH rW7c!yF
{
return true;T*Sxcs^6Gv
}x5j.X(b@/\,a
}Z$kr3ep#Z`!X
9F;Q%P_#E.\
</script>[/php]

我自己改PHP:$ 不懂是不是你要的

wilsonlee1987 2-10-2007 03:35 PM

回复 8楼神仙猫的帖子

我的东西是有存在database 的！！
G/o'^1i%|
不实在array的！

wilsonlee1987 2-10-2007 03:55 PM

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

<?php
include ("session_judge.php");
include ("connect.php");)W/x U!C!e%dk

if (isset($_POST['assign']))$W)Vl-T5bhf
{&MZ/[4bF7P9D|D l
$getlastBigID=$_POST['lastbigId'];Vx6p"qR/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());
if(mysql_num_rows($updateBig)>0)
{
$upBig=mysql_fetch_array($updateBig); @ \o-Dt1`u4c0m

$selectBigQuantity=$upBig['Quantity'];
$selectBigWeight=$upBig['WeightBig'];
$selectBigIncomeDate=$upBig['Income_Date'];|8fc3UX/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());
if(mysql_num_rows($updateSmall)>0)
{
$upSmall=mysql_fetch_array($updateSmall);M|!B4x3?5fI/QLi.\
J\ E+n"L$Nt5? q
$selectSmallWeight=$upSmall['Weight_Small'];o.C"u:A,@C:o
$selectSmallQuantity=$upSmall['Quantity'];
echo $selectSmallWeight;
kAR8gpG'W5l6fi
$reQuantity=$selectBigQuantity-$getquantity;.qN&m Ulud
$calWeight=$getquantity*$selectBigWeight;
$calSmallQuantity=$calWeight/$selectSmallWeight;RS `e:i-U
$finalSmallQuantity=$calSmallQuantity+$selectSmallQuantity;
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());
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~4bh6fUyw |3Y&Mg
echo "<script>alert('Assign Medicine Successfully!')</script>";
echo "<script>window.location='AssignMedicine.php'</script>";(yr3V,Yqqad8}
}
(n DD,Lf7B%\E V+^
}
eqn3O }@ i
}]8YP0??K8G o_iu

?>,jCv3}+EY*n Gj
<html>;e${ NnG
<head>
<title>Pediatric Clinic System - Assign Medicine System</title>
<link rel="stylesheet" type="text/css" id="css" href="./css.css">
<script type="text/javascript" src="./menu.js"></script>
<SCRIPT LANGUAGE="JavaScript">*s ?L$[j:r^`}

</SCRIPT>{O2k2y%k%_J^%M
</head>
<body>U~ AIts
<hr>
<h1>Assign Medicine</h1>
<hr>
<?php@.G5U|o{!P V3J
include ("doctorlabel.html");
$medicine=$_POST['txtMedicineBig'];
$medicinesmall=$_POST['txtMedicineSmall'];K8ayHC
?>
<Form name="AssignMedicine" method="get" action="AssignMedicine.php?MedicineBig=<?php echo $_GET["txtMedicineBig"];?>">Zx9UyD E
<table border="1" align="center">
<tr>R@t&DQ
<th align="left">Assign Medicine Big Name:</th>
<td><SELECT NAME="txtMedicineBig">bmz)z[`9lM
<?phpI*I b!K"z
$define=$_GET["BIGID"];
$verify=$_GET["Check"];#yhP3m7nD!r%YH

$sql=mysql_query("SELECT * FROM medicinebig ORDER BY 'Medicine_Id'");,t?pl`Pc
if (mysql_num_rows($sql)>0)
{
while ($sqlmedicine=mysql_fetch_array($sql))
{
echo "<option value='".$sqlmedicine['Medicine_Id']."'";
if ($_GET["txtMedicineBig"] == $sqlmedicine['Medicine_Id'] || $define == $sqlmedicine['Medicine_Id'] || $verify==$sqlmedicine['Medicine_Id'])
{R2rv)s-B
echo "Selected=Selected ";/{y \HIS?
r7Y gS5hA
}
echo ">".$sqlmedicine['Medicine_Id']." - ".$sqlmedicine['Medicine_Name'];
}6Is&]W2Z{ l
}
?>
</SELECT></td>1o _-z%pfP~5KL!Q
<td><input type="submit" name="Searchbig" value="Search"></td>
</tr>
</table>Vf U'u T}r(h%l
</Form>(ow;qY!I ?4h+o
<BR>
<?phpNu+wL"B5L4}u
$medicinesmall=$_GET['txtMedicineSmall'];&sa.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">
<table border="1" align="center">
<tr>
<th align="left">Assign Medicine Big Name:</th>o+k-D8Zz x
<td><SELECT NAME="txtMedicineSmall">
<?php
$sqlfirst=mysql_query("SELECT * FROM medicinesmall WHERE Medicine_Id='$define' or Medicine_Id='$getID' or Medicine_Id = '$verify' ORDER BY 'Medicine_Id'");
if (mysql_num_rows($sql)>0)r"vAdy8s
{
while ($sqlmedicinesmall=mysql_fetch_array($sqlfirst))
{Ku |8K0O4w6s(j
echo "<option value='".$sqlmedicinesmall['S_Medicine_Id']."'";
if ($_GET["txtMedicineSmall"] == $sqlmedicinesmall['S_Medicine_Id'])k&g4N EBR
{$cia8eO%i,p
echo "Selected=Selected ";
}%VH,F SgA
echo ">".$sqlmedicinesmall['S_Medicine_Id']." - ".$sqlmedicinesmall['Medicine_Name'];

}
}m*usm#F$tjY
?>
</SELECT></td>m0B/P `H3eO
<input type="hidden" name="BIGID" value="<?php echo $getID;?>">
<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'];?>">
<td><input type="submit" name="SearchSmall" value="Search"></td>
</tr>{"U5m vL@d
</table> a2Dbd&a(@3s!M*i"]
</Form>
<BR>
<?php
}Kz0~%Y[5y#|6A
if(isset($_GET['Searchbig'])or isset($_GET['SearchSmall']))
{*_/LB/BUG7y
$getID=$_GET['txtMedicineBig'];
$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
{
?>
<Form name="assign" method="post">
<table align="center" border="1">B!{J+m:K K\;x#]5P!o
<tr><th colspan="4" bgcolor="#FF0000">Medicine Big</th></tr>
<tr>
<th>Medicine Name:</th>
<th>Quantity</th>Q1~EO1YR;J8j
<th>Weight</th>`2]:EsI.t*Y*JN
<th>Weight Type</th>
</tr>&K)yu'eE.k.ITJ
<?php
while($details=mysql_fetch_array($medicinefirst))
{.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>";
echo "<td>$details[WeightBig]</td>";d}ku3S%d1ad[\$q
echo "<td>$details[weight_Type]</td></tr>";WM+vh]5?
}a.i%zG1e
}
$getsmallID=$_GET['txtMedicineSmall'];#k8m,Ck{/o3uqIe4xe
$medicinesecond=mysql_query("SELECT * FROM medicinesmall WHERE S_Medicine_Id ='$getsmallID'");
if(mysql_num_rows($medicinesecond)>0)
{
?> <table>
<BR><BR>)A k1~/KG)A7VI
<table align="center" border="1">
<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>
<?php
while($seconddetails=mysql_fetch_array($medicinesecond))!Rn.@t)L5N
{5JVY,G+n @ v$hv8o
$resmallID=$seconddetails['S_Medicine_Id'];
echo "<tr><td>$seconddetails[Medicine_Name]</td>";wf&H2G2_M@c,^v
echo "<td>$seconddetails[Quantity]</td>";
echo "<td>$seconddetails[Weight_Small]</td>";
echo "<td>$seconddetails[weight_Type]</td></tr>";
}I+]{s-hQ
?>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>
<input type="hidden" name="lastbigId" value="<?php echo $reID?>">
<input type="hidden" name="lastsmallId" value="<?php echo $resmallID?>">&L k0vu4u(d(E
<td><input type="submit" name="assign" value="Assign"></td>
</tr>
</table>SZ|2ADw
</Form> wU'Yi1M|.\
<?php
}
}
?>$q ]3AS*} uPl-G
</body>M.C5yZ[iR`
</html>

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

如果有存 database，就不需要那么麻烦作什么 session 了。
medicine big 选择了之后用 onchange 更新 medicine small，就这么简单。

[hr]deeppink[/hr]
<script language="javascript">
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>

<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>
<td align="left"><select> [color=Blue]SQL Select 的 result（small）[/color] </select></td>
</tr>d}#LN p:qq'v
</table>
<center><input type="submit" value="Insert"></center>
</form>

[hr]deeppink[/hr]
RpDq7k(M(ih)I*k,c3q
其中，medicin.php 就是你的 php 执行程序，mid 是 medicine big pass 进去的 value，用它来 select medicine small。
之后把得到的 result 输出在 small 的 select。
红色字部分的 mid 是相对应，就这样。&N:Biwc-L1L
:ONI71: :ONI71:

wilsonlee1987 2-10-2007 10:52 PM

回复 14楼神仙猫的帖子

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

wilsonlee1987 3-10-2007 12:15 AM

他没有反应！！
4zx*a7?2rk!Vs
function OnChange()
(
document.write("HAHA!");gl9~'sN
var id = document.AssignMedicine.txtMedicineBig.options[document.AssignMedicine.txtMedicineBig.selectedIndex].value; window.location='AssignMedicine.php?txtMedicineBig='+id;
uS:?Z9jiP
}
//-->#m4m2aZ,sWvI
</SCRIPT>mH O~7q
</head>R3RC&L1L l&RIj+x&H:a
<body>
<hr>
<h1>Assign Medicine</h1>(Oz_z~1a6M)g
<hr>
<?php;yY2B[Q%JK/p
include ("doctorlabel.html");`7nZG:F4cs$Y'uO
$medicine=$_POST['txtMedicineBig'];
$medicinesmall=$_POST['txtMedicineSmall'];}a9T$N`f
?>*Ce+_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>
<td><SELECT NAME="txtMedicineBig">_k&q#EAp~
<?php
$define=$_GET["txtMedicineBig"]; %hf/L+]^%BD
$verify=$_GET["Check"];0qts|KL'K(G}"s

$sql=mysql_query("SELECT * FROM medicinebig ORDER BY 'Medicine_Id'");
if (mysql_num_rows($sql)>0)Mg)nc9Sya
{
while ($sqlmedicine=mysql_fetch_array($sql))I PjpSs%Uv
{*jP$@?h&T
echo "<option value='".$sqlmedicine['Medicine_Id']."'";
if ($_POST["txtMedicineBig"] == $sqlmedicine['Medicine_Id'] || $define == $sqlmedicine['Medicine_Id'])'Cdh0~/jtd)G_.G r
{K?H7c.A)nr:n$l~\
echo "Selected=Selected ";

}
echo ">".$sqlmedicine['Medicine_Id']." - ".$sqlmedicine['Medicine_Name'];
}
}vfI^u!{
?>D-k/f^aF*y S
</SELECT></td>8vdjB eqB
</tr>
</table> ]T5Oy D hQ1G.g
TrLUDi K

<?php
H'\4U9^"GeLK/U4B
$medicinesmall=$_GET['txtMedicineSmall'];"zq;_3PL

$getID=$_GET['txtMedicineBig'];
?>1S(M4w0YM
<table border="1" align="center">:TGJ F+y;U9V?
<tr>
<th align="left">Assign Medicine Big Name:</th>
<td><SELECT NAME="txtMedicineSmall">
<?php
$sqlfirst=mysql_query("SELECT * FROM medicinesmall WHERE Medicine_Id='$define' or Medicine_Id='$getID' or Medicine_Id = '$verify' ORDER BY 'Medicine_Id'");
if (mysql_num_rows($sql)>0)9W]}!u3E ~
{
while ($sqlmedicinesmall=mysql_fetch_array($sqlfirst))6yN-cs3B@
{
echo "<option value='".$sqlmedicinesmall['S_Medicine_Id']."'";
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'];

}
}
?>jvl ~Js
</SELECT></td>
<input type="hidden" name="BIGID" value="<?php echo $getID;?>"> W7w fk])yl
<input type="hidden" name="Check" value="<?php echo $define;?>">
;uK+NKF6Sw
<input type="hidden" name="smallID" value="<?php echo $_GET['txtMedicineSmall'];?>">9p~zRL ]:o
<td><input type="submit" name="Searchbig" value="Search"></td>
</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。
你把 onchange 放在 <form> tab ，就必须要按 submit button 之后才有动作了。{9x2g6odpQ)Bt(q
U-PS!hq_"^
这些和 php 无关。
html 标签和 dom 要搞清楚啊。。

wilsonlee1987 3-10-2007 02:24 PM

回复 17楼神仙猫的帖子

sorry上面那个是我比较早的！！-Rl2Q/V*v]
我后来有改了！
还是不行H@o]!F w9g!o7M

而且我发现到，我完全进不到onchange的code里面！！
w9iiqV#e{i
-----------------:ht*wv*S o/O
这是我用来test的!PD;n,t6@8v*s
可执行的codeCu|m@ZN
~&O_/?:X5U;I
<HTML>
<HEAD>"`,m-AR}/w
<TITLE> New Document </TITLE>o8\j.skCgv
<SCRIPT LANGUAGE="JavaScript">

l*f3EIN-W4S q
</SCRIPT>
</HEAD>$y CE$D1[_['l4^7_^
#byz6Re{ Uj'Hh
<BODY>g[xYQ
<Form name="form" >
first <INPUT TYPE="text" NAME="s1" value="Big Mac" onChange="handler()"><BR>
second <INPUT TYPE="text" NAME="s2" value="Coke">(GVSF S'LA
<INPUT TYPE="submit" name="submit" value="submit">
</Form>
</BODY>
</HTML>

-----+wB4DA dq'FyQ
执行不到的code!!N GY/~G.t
$n+r@n @-ZnAc
<script language="javascript">+h)?Dl#G'] }
{
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()
{]3\iK9['[$~{
yesno = confirm("Want to Change?");
if (!yesno) form.mid.value="Big Mac";
}*/

5`Q;q-P] j
O9M(UP4Z6d
</script>

<form name="form">+[c&i5D4D|i
<table><tr>
      <td align="right">Medicine Big :</td>UdID2x.L!k9[AG
<td align="left"><INPUT TYPE="text" NAME="mid" value="Big Mac" onchange="handler()">
</td>|by{ nFh'f;q
</tr>J5m*VP\W)Y
<tr>@]5oM&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>
</tr>&leC7l&h/x8x4V^,~
</table>7R)o"\ k3N&@.u#Q
<center><input type="submit" value="Insert"></center>
</form>
5\ M-s:PRd4zN
[[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 之后。
-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

[hr]deeppink[/hr]
<script language="javascript">
function Handler()}*@|3w!b
{
alert("Hahaa");
}
</script>r,|Ec7QR+I
<form>
<input type="text" onchange="Handler()">;r&a:M3@5?|L]/c
</form>

[hr]deeppink[/hr]
随便打东西，然后按 tab 看效果。

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

请求帮忙！！

回复 沙发 神仙猫 的帖子

回复 4楼 神仙猫 的帖子

回复 4楼 神仙猫 的帖子

回复 4楼 神仙猫 的帖子

回复 8楼 神仙猫 的帖子

回复 14楼 神仙猫 的帖子

回复 17楼 神仙猫 的帖子

回复 18楼 wilsonlee1987 的帖子

回复沙发神仙猫的帖子

回复 4楼神仙猫的帖子

回复 4楼神仙猫的帖子

回复 4楼神仙猫的帖子

回复 8楼神仙猫的帖子

回复 14楼神仙猫的帖子

回复 17楼神仙猫的帖子