<?php
$conf['DB_USER'] = 'user';
$conf['DB_PWD'] = 'pwd';
$conf['DB_NAME'] = 'dbname';
$conn = mysql_connect('localhost',$conf['DB_USER'],$conf['DB_PWD']);
if (!$conn) {
echo '数据库连接错误！';
}
mysql_set_charset('utf8', $conn); //set charset
mysql_select_db($conf['DB_NAME']); //select datebase
$sql2 = 'select catid,catname from v9_category';
$cat = mysql_query($sql2);
while ($catrow=mysql_fetch_array($cat)) {
echo $catrow['catname'].'</br>';
$sql = '(select title,url from v9_news where catid='.$catrow["catid"].' order by id desc)
UNION (select title,url from v9_product where catid='.$catrow["catid"].' order by id desc)';
$result = mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
echo $row['url']."</br>";
}
}
?>
PHP怎么学习？PHP怎么入门？PHP在哪学？PHP怎么学才快？不用担心，这里为大家提供了PHP速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
广告Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
11059
收藏
