mysql+php select ÏÂÀÁбíÊ÷µÄ¼òµ¥ÊµÏÖ
Êý¾Ý¿âÉè¼Æ£º
--
-- Êý¾Ý¿â: `test`
--
-- --------------------------------------------------------
--
-- ±íµÄ½á¹¹ `menu`
--
CREATE TABLE IF NOT EXISTS `menu` (
`ID` int(10) unsigned NOT NULL auto_increment,
`PID` int(11) NOT NULL,
`TITLE` varchar(200) NOT NULL,
`REMARK` varchar(200) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- µ¼³ö±íÖеÄÊý¾Ý `menu`
--
INSERT INTO `menu` (`ID`, `PID`, `TITLE`, `REMARK`) VALUES
(1, 0, '¹«Ë¾', '¸ù'),
(2, 1, '²ÆÎñ²¿', '²¿ÃÅ'),
(3, 1, 'ÏúÊÛ²¿', '²¿ÃÅ'),
(4, 1, 'ÈËʲ¿', ''),
(5, 2, '»á¼Æ', ''),
(6, 3, 'ÒµÎñÔ±', ''),
(7, 4, 'ÈËÊÂ×ܹÜ', '');
--------------------------------------------------------
PHP´úÂ룺
--------------------------------------------------------
<?php
include "config.php";
include "mysql.php";
$db = new Mysql('test'); //¼¸¸ö¼òµ¥µÄÀ࣬²»ÓÃÁгöÀ´´ó¼ÒÒ²¿´µÃ¶®¡£¾ÍÊÇʵÀý»¯Ò»¸öÊý¾Ý¿âÁ¬½Ó¶øÒÑ¡£
function RootMenu ($PID,$n){
global $arr,$db;
$sql = "select * from menu where `PID` =$PID";
$result = $db->query($sql);
while ($i=$db->fetch_array($result)){
$i["TITLE"] =str_repeat('--',$n).$i["TITLE"];
$arr[] =$i;
RootMenu($i["ID"],($n+4));
}
return $arr;
}
$arr = RootMenu(0,0);
?>
<select id="">
<option value="0" selected="selected">ÇëÑ¡Ôñ²¿ÃÅ</option>
<?php
for ($i=0;$i<count($arr);$i++) {
?>
<option value="<?php echo $arr[$i]["ID"] ?>"><?php echo $arr[$i]["TITLE"] ?></option>
<?php }?>
</select>
--------------------------------------------------------
Ïà¹ØÎĵµ£º
ÏÈÏÂÔØ²¢°²×°eclipse£¬ÏÂÔØµØÖ·£ºhttp://download.Eclipse.org/downloads/index.php¡£Eclipse ÐèÒª jre µÄÖ§³Ö£¬ËùÒÔÈç¹û»úÆ÷ÉÏ»¹Ã»×°jreµÄ»°¾Í¸Ï¿ìÈ¥ÏÂÔØÒ»¸ö×°ÉÏ£¬http://java.sun.comÓÐjreµÄÏÂÔØ¡£
µÚ¶þ£¬ÏÂÔØ²¢°²×° PHP ÔÚ Eclipse µÄ²å¼þ
µØÖ·£ºhttp://sourceforge.net/project/showfiles.php?group_id=57621&pa ......
ÎÒÏÖÔÚÓÐÕâÑùÒ»¸öÐèÇ󣬻òÐí×öc++³ÌÐòµÄ×ö¹ýÕâÑùµÄÍæÒâ¶ù£¬ÎÒÏÖÔÚÏëÓÃphpÀ´ÊµÏÖ£¬´ÓûÅöµ½ÕâÑùµÄÇé¿ö£¬ËùÒÔÓеãã¡£»¹Çë¸ßÈËÖ¸µãŶ£¬²»Ê¤¸Ð¼¤£¬Çë²é¿´ÎÒÉÏ´«µÄ½ØÍ¼£¬¸´ÖƹýÀ´£¬ÑùʽÂÒÁË¡£
ÃèÊöÒ»ÏÂÐèÇó°É£º¾ÍÊÇÔÚÎı¾ÀïÃæÓÃÖÆ±í·û»³ö±í¸ñÊ ......
°ÑphpÊý¾Ý»òÖµ´«µÝ¸øjs
£ººÜ¼òµ¥£¬Ö±½ÓÔÚjsÖÐʹÓÃphp´úÂ룬»ì±à¼´¿É¡£
°ÑjsÊý¾Ý´«µÝ¸øphp
£º¿ÉÒÔʹÓôò¿ªÐ´°¿ÚµÄ·½Ê½£¬Í¨¹ýurlµØÖ·°ÑÊý¾Ý´«µÝ¹ýÈ¥¡£Ò²¿ÉÒÔʹÓÃajax£¬Í¨¹ýget»òpost´«µÝ¸øphp£¬Ò²¿ÉÒÔ±£´æcookieÈÃphpÀ´¶Á¡£
ÔÚ´«µÝÊý¾Ý¹ý³ÌÖпÉÄÜÓöµ½ÖÐÎıàÂë
ÎÊÌ⣬¿ÉÒÔͳһ±àÂ뷽ʽΪjsµÄescape£¬unescape£¬Ò²¿ÉÒÔÍ³Ò ......
grant replication slave on *.* to 'guest'@'192.168.1.%' identified by '123456'
change master to master_host='192.168.1.190',master_user='guest',master_password='123456',master_port=3306
mysql> change master to master_host='192.168.1.190',master_user='guest',master_password='123456',master_log ......
Ò».Ê×ÏÈÊÇPHPÍøÒ³µÄ±àÂë
¡¡¡¡1.phpÎļþ±¾ÉíµÄ±àÂëÓëÍøÒ³µÄ±àÂëӦƥÅä
¡¡¡¡a.Èç¹ûÓûʹÓÃgb2312±àÂ룬ÄÇôphpÒªÊä³öÍ·£ºheader(“Content-Type: text/html; charset=gb2312")£¬¾²Ì¬Ò³ÃæÌí¼Ó£¬ËùÓÐÎļþµÄ±àÂë¸ñʽΪANSI£¬¿ÉÓüÇʱ¾´ò¿ª£¬Áí´æÎªÑ¡Ôñ±àÂëΪANSI£¬¸²¸ÇÔ´Îļþ¡£
¡¡¡¡b.Èç¹ûÓûʹÓÃutf-8±àÂ룬ÄÇôphpÒªÊä³ ......