Åê¹Æ¼Ô |
¥á¥Ã¥»¡¼¥¸ |
|
< PHP¥×¥í¥°¥é¥ß¥ó¥° ~ PHP¥×¥í¥°¥é¥ß¥ó¥°¤Ë¤Ä¤¤¤Æ |
|
»þ´Ö:
ÅÚ 4·î 15, 2006 6:44 pm
|
|
|
ÅÐÏ¿Æü: 2006ǯ4·î 15Æü
Åê¹Æµ»ö: 3
|
|
¸½ºß¡¢PHP¤ÈMySQL¤ò»ÈÍѤ·¤Æ¸ÜµÒ¾ðÊó¤òÅÐÏ¿¤¹¤ë»ÅÁȤߤòºîÀ®¤·¤Æ¤¤¤Þ¤¹¡£
PHP¤ÇÅÐÏ¿¥Õ¥©¡¼¥à¤òºîÀ®¤·¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¢¤½¤ÎºÝ¤ËÉô½ð¥³¡¼¥É¤ò¥×¥ë¥À¥¦¥ó¤è
¤ê»²¾È¤·¤Æ³ºÅö¤¹¤ëÉô½ð¥³¡¼¥É¤ËÉտ魯¤ë¼Ò°÷̾¤Î¤ß¤òÁªÂò¤Ç¤¤ë¤è¤¦¤Ê¥×¥ë¥À
¥¦¥ó¤ò¤òɽ¼¨¤µ¤»¤ëÊýË¡¤¬Ê¬¤«¤é¤º¶ìÀ路¤Æ¤ª¤ê¤Þ¤¹¡£
ACCESS¤Ç¤¹¤È¡¢¥×¥ë¥À¥¦¥ó¤Î¥Õ¥©¡¼¥«¥¹¼èÆÀ»þ¤Ë½èÍý¤òµ½Ò¤¹¤ë¤³¤È¤¬²Äǽ¤Ç¤¹
¤¬¡¢PHP¤Ç¤â¥×¥ë¥À¥¦¥ó¤ÇÁªÂò¤·¤¿Ãͤò¼¡¤Î¥×¥ë¥À¥¦¥ó¤ÎÁªÂò¤Î¾ò·ï¤Ë¤¹¤ë»ö¤Ï²Ä
ǽ¤Ç¤·¤ç¤¦¤«¡©
ʬ¤«¤ê¤Ë¤¯¤¤ÀâÌÀ¤Ç¿½¤·Ìõ¤´¤¶¤¤¤Þ¤»¤ó¤¬¡¢¸æ¶µ¼ø¤ÎÊý¤è¤í¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹
¡£ |
|
|
|
|
|
|
|
»þ´Ö:
·î 4·î 17, 2006 10:19 am
|
|
|
ÅÐÏ¿Æü: 2006ǯ3·î 23Æü
Åê¹Æµ»ö: 48
|
|
PHP¤È¤¤¤¦¤è¤êHTML¤ÎÌäÂê¤Ç¤¹¤Í |
|
|
|
|
|
|
|
»þ´Ö:
²Ð 4·î 18, 2006 9:41 am
|
|
|
ÅÐÏ¿Æü: 2006ǯ4·î 15Æü
Åê¹Æµ»ö: 3
|
|
¤·¤â¤ä¤ó¤µ¤ó¡¢ÊÖ¿®¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
ʬ¤«¤ê¤Ë¤¯¤¤ÀâÌÀ¤Ç¿½¤·Ìõ¤´¤¶¤¤¤Þ¤»¤ó¤¬¡¢HTML¤Ç²¼µ¤Î»ö¾Ý¤¬¼Â¸½²Äǽ¤«¸æ¶µ¼ø¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
¸½ºß¡¢MySQL¤Î¥Ç¡¼¥¿¤ËÉô½ð¥³¡¼¥É¤È¼Ò°÷̾¤Î¥Õ¥£¡¼¥ë¥É¤ò»ý¤Ã¤¿¥Þ¥¹¥¿¤¬¤¢¤ê¤Þ¤¹¡£
¤³¤Î¥Þ¥¹¥¿¤òHTML¤Î¥×¥ë¥À¥¦¥ó¤è¤ê¼Ò°÷̾¤òÁªÂò¤µ¤»¤¿¤¤¤Î¤Ç¤¹¤¬¡¢¼Ò°÷¿ô¤¬Â¿¤¤¤¿¤á¤Ò¤È¤Ä¤Î¥×¥ë¥À¥¦¥ó¤Ç¤¹¤Ù¤Æ¤Î¼Ò°÷̾¤òɽ¼¨¤¹¤ë¤Î¤Ï¸·¤·¤¤¤Ç¤¹¡£
¤½¤³¤Ç¡¢HTML¤Ç¥×¥ë¥À¥¦¥ó¤ò2¤ÄÍѤ¤¤Æ¥Ç¡¼¥¿¤ò¹Ê¤Ã¤Æɽ¼¨¤µ¤»¤¿¤¤¤Î¤Ç¤¹¤¬¡¢£±¤Ä¤á¤Î¥×¥ë¥À¥¦¥ó¤ÇÉô½ð¥³¡¼¥É¤òÁªÂò¤·¤Æ2¤Ä¤á¤Î¥×¥ë¥À¥¦¥ó¤Ç£±¤Ä¤á¤Î¥×¥ë¥À¥¦¥ó¤ÇÁªÂò¤·¤¿Éô½ð¥³¡¼¥É¤ËÉտ魯¤ë¼Ò°÷̾¤òɽ¼¨¤µ¤»¤ë»ö¤Ï²Äǽ¤Ç¤·¤ç¤¦¤«¡©
¤è¤í¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£ |
|
|
|
|
|
|
|
»þ´Ö:
²Ð 4·î 18, 2006 10:26 am
|
|
|
ÅÐÏ¿Æü: 2006ǯ3·î 23Æü
Åê¹Æµ»ö: 48
|
|
ajax¤Ê¤É¤ÇưŪ¤ËÊѹ¹¤¹¤ë¤³¤È¤Ï²Äǽ¤À¤È»×¤¤¤Þ¤¹¡£ |
|
|
|
|
|
|
|
»þ´Ö:
²Ð 4·î 18, 2006 2:08 pm
|
|
|
ÅÐÏ¿Æü: 2006ǯ4·î 05Æü
Åê¹Æµ»ö: 14
|
|
JavaScript¤Ï¶ì¼ê¤Ê¤Î¤Ç¡¢¥×¥ë¥À¥¦¥óϢư¡Ö¤ß¤¿¤¤¤Ê¡×Æ°ºî¤ò¤¹¤ë¥¹¥¯¥ê¥×¥È¤ò¡¢»¨¤Ç¤¹¤¬½ñ¤¤¤Æ¤ß¤Þ¤·¤¿¡£
Àܳ¤ä¥»¥¥å¥ê¥Æ¥£¤Ï³ä°¦¤·¤Æ¤ë¤Î¤Ç¡¢¤´Ãí°Õ¤ò¡£
²¾Äꤹ¤ë¥Æ¡¼¥Ö¥ëÆâÍÆ¡
¡¦¥Æ¡¼¥Ö¥ë̾¡§busho_tblŽ¥Ž¥Ž¥Éô½ð¾ðÊó¥Æ¡¼¥Ö¥ë
¡¦¥«¥é¥à1¡§busho_idŽ¥Ž¥Ž¥Éô½ðID
¡¦¥«¥é¥à2¡§bushoŽ¥Ž¥Ž¥Éô½ð̾
²¾Äꤹ¤ë¥Æ¡¼¥Ö¥ëÆâÍÆ¢
¡¦¥Æ¡¼¥Ö¥ë̾¡§shain_tblŽ¥Ž¥Ž¥¼Ò°÷¾ðÊó¥Æ¡¼¥Ö¥ë
¡¦¥«¥é¥à1¡§shain_idŽ¥Ž¥Ž¥¼Ò°÷ID
¡¦¥«¥é¥à2¡§shainŽ¥Ž¥Ž¥¼Ò°÷̾
¡¦¥«¥é¥à3¡§busho_idŽ¥Ž¥Ž¥Éô½ðID
Code: |
<?
//Éô½ð¥×¥ë¥À¥¦¥óɽ¼¨
function BUSHO($busho_id){
$sql = "select * from busho_tbl";
if(!$res = mysql_query($sql)){
exit;
}
while($row = mysql_fetch_array($res)){
$url = $_SERVER[ 'PHP_SELF' ] . '?busho_id=' . $row[ 'busho_id' ];
if($busho_id == $row[ 'busho_id' ]){
echo '<option value="' . $url . '" selected>' . $row[ 'busho' ];
} else{
echo '<option value="' . $url . '">' . $row[ 'busho' ];
}
}
mysql_free_result($res);
}
//¼Ò°÷¥×¥ë¥À¥¦¥óɽ¼¨
function SHAIN($busho_id){
$sql = "select * from shain_tbl where busho_id='$busho_id'";
if(!$res = mysql_query($sql)){
exit;
}
while($row = mysql_fetch_array($res)){
echo '<option value="' . $row[ 'shain_id' ] . '">' . $row[ 'shain' ];
}
mysql_free_result($res);
}
?>
<html>
<head>
<!-- ¥¸¥ã¥ó¥×¤¹¤ëJavaScript¤³¤³¤«¤é -->
<script language="JavaScript">
<!--
function Jump()
{
var si = document.form1.select1.selectedIndex;
var url = document.form1.select1.options[si].value;
location.href = url;
}
//-->
</script>
<!-- ¥¸¥ã¥ó¥×¤¹¤ëJavaScript¤³¤³¤Þ¤Ç -->
</head>
<body>
<form action="foo.php" name="form1" method="post">
<!-- Éô½ð¤Î¥×¥ë¥À¥¦¥ó¤³¤³¤«¤é -->
<div>
<select name="select1" size="1" onChange="Jump()">
<option value="<?=$_SERVER[ 'PHP_SELF' ]?>">Éô½ðÁªÂò
<?
BUSHO($_GET[ 'busho_id' ]);
?>
</select>
</div>
<!-- Éô½ð¤Î¥×¥ë¥À¥¦¥ó¤³¤³¤Þ¤Ç -->
<!-- ¼Ò°÷¤Î¥×¥ë¥À¥¦¥ó¤³¤³¤«¤é -->
<div>
<select name="shain_id" size="1">
<?
SHAIN($_GET[ 'busho_id' ]);
?>
</select>
</div>
<!-- ¼Ò°÷¤Î¥×¥ë¥À¥¦¥ó¤³¤³¤Þ¤Ç -->
<div>
<input type="submit" name="submit" value="submit">
</div>
</form>
</body>
</html>
|
²¾Äê¤ÎÍ×ÁǤ¬¤¢¤ë¤Î¤Ç¡¢³°¤·¤Æ¤¿¤é¤¹¤ß¤Þ¤»¤ó¡£ |
|
|
|
|
|
|
|
»þ´Ö:
Æü 4·î 23, 2006 7:52 am
|
|
|
ÅÐÏ¿Æü: 2006ǯ4·î 15Æü
Åê¹Æµ»ö: 3
|
|
¤Á¤Ó¤µ¤ó¡¢ÊÖ¿®¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
Áᮡ¢·îÍËÆü¤Ë¶µ¤¨¤Æ¤¤¤¿¤À¤¤¤¿¥½¡¼¥¹¤ò¤â¤È¤Ë»î¤·¤Æ¤ß¤Þ¤¹¡£
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£ |
|
|
|
|
|
|
|