代碼無法插入???
INSERT INTO 'deepcate'(`id`, `pid`, `catename`, `cateorder`, `createtime`)VALUES
(1,0,"新聞",0,0),
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國內(nèi)新聞',0,0),
(4,1,'國際新聞',0,0),
(5,3,'北京新聞',0,0),
(6,4,'美國新聞',0,0),
(7,2,'美女圖片',0,0),
(8,2,'風(fēng)景圖片',0,0),
(9,7,'日韓明星',0,0),
(9,9,'日本AV',0,0);
INSERT INTO 'deepcate'(`id`, `pid`, `catename`, `cateorder`, `createtime`)VALUES
(1,0,"新聞",0,0),
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國內(nèi)新聞',0,0),
(4,1,'國際新聞',0,0),
(5,3,'北京新聞',0,0),
(6,4,'美國新聞',0,0),
(7,2,'美女圖片',0,0),
(8,2,'風(fēng)景圖片',0,0),
(9,7,'日韓明星',0,0),
(9,9,'日本AV',0,0);
2016-02-11
一字不漏照抄代碼,怎么沒反應(yīng)?連接數(shù)據(jù)庫完全正確,后面查數(shù)據(jù)表不對?
2015-12-08
while($row=mysql_fetch_assoc($res))
{$row['catename'] = str_repeat(' ',$spac) . '|--' . $row['catename'];
$result[] = $row;
getList($row['id'],$result,$spac);
}
return $result;
}
$rs = getList();
print_r($rs);
?>
{$row['catename'] = str_repeat(' ',$spac) . '|--' . $row['catename'];
$result[] = $row;
getList($row['id'],$result,$spac);
}
return $result;
}
$rs = getList();
print_r($rs);
?>
2015-12-08
<?php
funtion getList($pid=0,&$result=array(),$spac=0){
$spac = $spac + 2;
$sql="SELECT * FROM deepcate WHERE pid = $pid";
$res= mysql_query($sql);
funtion getList($pid=0,&$result=array(),$spac=0){
$spac = $spac + 2;
$sql="SELECT * FROM deepcate WHERE pid = $pid";
$res= mysql_query($sql);
2015-12-08
最贊回答 / 杰克_先生
//連接數(shù)據(jù)庫$db_host='localhost';$db_user="root";$db_password="";$db_name="imooc";$link=mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());mysql_select_db($db_name,$link);mysql_query("set names utf8") or die("編碼設(shè)置錯誤!");
2015-12-07