ขอถามหน้าแก้ไขข้อมูลครับ (..ที่เป็นแบบลิสเมนูย่อย แปลผันตามลิสเมนูหลัก ครับ)
Code (PHP) <?php
/*** By Weerachai Nukitram ***/
/*** http://www.ThaiCreate.Com ***/
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("thailand");
@mysql_query("SET NAMES UTF8");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>ThaiCreate.Com ListMenu</title>
<script language = "JavaScript">
//**** List Province (Start) ***//
function ListProvince(SelectValue)
{
frmMain.ddlProvince.length = 0
frmMain.ddlAmphur.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.ddlProvince.options[frmMain.ddlProvince.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM province ORDER BY PROVINCE_ID ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = <?=$intRows;?>;
mySubList = new Array();
strGroup = <?=$objResult["GEO_ID"];?>;
strValue = "<?=$objResult["PROVINCE_ID"];?>";
strItem = "<?=$objResult["PROVINCE_NAME"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.ddlProvince.options[frmMain.ddlProvince.length]= myOption
}
<?
}
?>
}
//**** List Province (End) ***//
//**** List Amphur (Start) ***//
function ListAmphur(SelectValue)
{
frmMain.ddlAmphur.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.ddlAmphur.options[frmMain.ddlAmphur.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM amphur ORDER BY AMPHUR_ID ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = <?=$intRows;?>;
mySubList = new Array();
strGroup = <?=$objResult["PROVINCE_ID"];?>;
strValue = "<?=$objResult["AMPHUR_ID"];?>";
strItem = "<?=$objResult["AMPHUR_NAME"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.ddlAmphur.options[frmMain.ddlAmphur.length]= myOption
}
<?
}
?>
}
//**** List Amphur (End) ***//
</script>
</head>
<form name="frmMain" action="" method="post">
Geography
<select id="ddlGeo" name="ddlGeo" onChange = "ListProvince(this.value)">
<option selected value=""></option>
<?
$strSQL = "SELECT * FROM geography ORDER BY GEO_ID ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery))
{
?>
<option value="<?=$objResult["GEO_ID"];?>"><?=$objResult["GEO_NAME"];?></option>
<?
}
?>
</select>
Province
<select id="ddlProvince" name="ddlProvince" style="width:120px" onChange = "ListAmphur(this.value)"></select>
Amphur
<select id="ddlAmphur" name="ddlAmphur" style="width:200px"></select>
</form>
</body>
</html>
<?
mysql_close($objConnect);
?>
สร้าง Dependent ListMenu เลือกข้อมูลหลักและข้อมูลย่อยเปลี่ยนตามหัวข้อหลัก
Date :
2009-10-20 23:19:10By :
webmaster
Error ว่าอะไรครับ ??
Date :
2009-10-21 11:58:11By :
webmaster
ขอบคุณพี่ win มากเลยครับพอดีผมกำลังแก้ไขโค้ดตามที่พี่ win แนะนำอ่ะครับมันมาติดตรงที่ต้องแก้โค้ดให้เข้ากับ<?php
session_start();
if ($sess_adminid<>session_id()) {
header( "Location: admin.php"); exit();
}
$id_edit=$_GET[id_edit];
include "connect.php";
$strSQL="select * from tb_product where id_prd='$id_edit' ";
$objQuery=mysql_db_query($dbname,$strSQL);
$rs=mysql_fetch_array($objQuery);
$id_prd=$rs[id_prd];
$code=sprintf("%05d",$id_prd);
$name_prd=$rs[name_prd];
$detail_prd=$rs[detail_prd];
$ref_id_type=$rs[ref_id_type];
$ref_id_sub_type=$rs[ref_id_sub_type];
$price_prd=$rs[price_prd];
$photo_prd=$rs[photo_prd];
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>ร้านค้าออนไลน์สำหรับผู้ดูแลระบบ</title>
<script language = "JavaScript">
//**** List Province (Start) ***//
function ListProvince(SelectValue)
{
frmMain.ddlProvince.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
frmMain.ddlProvince.options[frmMain.ddlProvince.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM tb_sub_type ORDER BY id_sub_type ASC ";
$objQuery=mysql_db_query($dbname,$strSQL);
$intRows = 0;
while($objResult=mysql_fetch_array($objQuery)) {
$intRows++;
?>
x = <?=$intRows;?>;
mySubList = new Array();
strGroup = <?=$objResult["id_type"];?>;
strValue = "<?=$objResult["id_sub_type"];?>";
strItem = "<?=$objResult["name_sub_type"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
frmMain.ddlProvince.options[frmMain.ddlProvince.length]= myOption
}
<?
}
?>
}
//**** List Province (End) ***//
</script>
</head>
<body>
<?php include("admin_menu.php"); ?>
<form name="frmMain" method="post" action="admin_product_edit2.php" enctype="multipart/form-data">
<p><b>แก้ไขสินค้า</b></p>
<table width="400" border="0 " cellpadding="1"cellspacing="1">
<tr>
<td width="101">รหัสสินค้า</td>
<td><?php echo $code;?></td>
</tr>
<tr>
<td width="101">ชื่อสินค้า</td>
<td><input name="name" type="text" size="40"
value="<?php echo $name_prd;?>" >*</td>
</tr>
<tr>
<td>ประเภทสินค้าหลัก</td>
<td>
<select id="ddlGeo" name="ddlGeo" onChange = "ListProvince(this.value)">
<option selected value=""></option>
<?php
$strSQL="select * from tb_type order by id_type";
$objQuery=mysql_db_query($dbname,$strSQL);
while($objResult=mysql_fetch_array($objQuery)) {
$id_type=$objResult[id_type];
$name_type=$objResult[name_type];
if ($ref_id_type==$id_type) {
echo "<option value='<?=$objResult['id_type'];?>"><?=$objResult['name_type'];?></option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td>ประเภทสินค้าย่อย</td>
<td>
<select id="ddlProvince" name="ddlProvince" style="width:120px" ></select>
</td>
</tr>
<tr>
<td>รายละเอียดสินค้า</td>
<td><textarea name="detail" cols="40"
rows="4"><?php echo $detail_prd;?></textarea>*</td>
</tr>
<tr>
<td>ราคา</td>
<td><input type="text" name="price" size="20"
value="<?php echo $price_prd;?>" >บาท*</td>
</tr>
<tr>
<td>รูปภาพ</td>
<td>
<?php
if ($photo_prd<>" ") {
echo "<input type='checkbox' name='chkdel'
value='1'> ลบรูปภาพ <br>";
echo "<a href='photo/$photo_prd' target
='_blank'> แสดงรูปภาพ</a>";
} else {
echo "<input type='file' name='fileupload'>";
echo "<input type='hidden' name='MAX_FILE_SIZE'
value='100000'>";
}
?> </td>
</tr>
<tr>
<td> </td>
<td>
<input type="submit" name="Submit" value="Submit" />
<input type="reset" name="Submit2" value="reset" />
<input type="hidden" name="id_edit" value="<?php echo $id_edit;?>">
<input type="hidden" name="photo_del" value="<?php echo $photo_prd;?>">
</td>
</tr>
</table>
</form>
</body>
</html>
Date :
2009-10-21 12:06:13By :
teekaiman
Code (PHP) echo "<option value='<?=$objResult['id_type'];?>"><?=$objResult['name_type'];?></option>";
Code (PHP) echo "<option value='$objResult[id_type]'>$objResult[name_type]</option>";
Date :
2009-10-21 12:09:25By :
webmaster
หลังจากส่งค่า value มาแล้วลิสเมนูย่อยมันไม่โชว์ครับพี่...โชว์แต่เมนูหลักครับผม..
Date :
2009-10-21 14:18:57By :
teekaiman
Server 01
Load balance : Server 01
