$conn=@
mysql_connect(
'localhost',
'root',
'admin');
mysql_query(
'use blog',
$conn);
mysql_query(
'set names utf8');
$sql=
"select * from cat";
$res=
mysql_query(
$sql);
$cat=
array();
while(
$rwo=
mysql_fetch_assoc(
$res)){
$cat[]=
$rwo;
}
include(
'view/admin/artlist.html');
<?php foreach($cat as $v) {?>
<
tr
>
<
td
>
<?php echo $v['cat_id'];?>
</
td
>
<
td
>
<?php echo $v['catname'];?>
</
td
>
<
td
><
a
href=
"#"
>
<?php echo $v['num'];?>
</
a
></
td
>
<
td
>心情随笔
</
td
>
<
td
><
span
class=
"badge"
>12
</
span
></
td
>
<
td
>已发布
</
td
>
</
tr
>
<?php }?>