WordPress直接访问数据库列出指定分类目录下的文章

最新推荐文章于 2025-05-19 08:36:04 发布

哈哈哈_Programmer

最新推荐文章于 2025-05-19 08:36:04 发布

阅读量947

点赞数

CC 4.0 BY-SA版权

分类专栏： wordpress 文章标签： wordpress mysql

本文链接：https://blog.youkuaiyun.com/weixin_38728964/article/details/89353633

wordpress 专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍了使用PHP进行数据库连接、查询操作的方法，并通过具体示例展示了如何从WordPress数据库中获取分类下的最新文章信息。涉及到的技术包括MySQL数据库连接、SQL查询、WordPress后台分类ID的运用及结果展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?php 
    
    //数据库连接信息
	$mysql_conf = array(

	    'host'    => '', 

	    'db'      => '', 

	    'db_user' => '', 

	    'db_pwd'  => '', 

    );

    //数据库连接
	$mysqli = @new mysqli($mysql_conf['host'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);

	if ($mysqli->connect_errno) {

	    die("could not connect to the database:\n" . $mysqli->connect_error);//诊断连接错误

	}

	$mysqli->query("set names 'utf8';");//编码转化
    
	$select_db = $mysqli->select_db($mysql_conf['db']);

	if (!$select_db) {

	    die("could not connect to the db:\n" .  $mysqli->error);

	}
    
    //wordpress后台分类ID
	$cids = [3985,3915,3931,36,3983];

	$html = '';

	foreach ($cids as $k=>$v) {

		$sql="SELECT ID,post_title,post_date,post_content FROM wp_posts,wp_term_relationships,wp_term_taxonomy WHERE ID=object_id and wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id and post_type='post' and post_status = 'publish' and wp_term_taxonomy.term_id = $v and taxonomy = 'category' order by ID desc limit 10"; 

		$res = $mysqli->query($sql);

		if (!$res) {

		    die("sql error:\n" . $mysqli->error);

		}

		$html .= "<div class='regCnt'><ul>";

		while ($row = $res->fetch_assoc()) {

				$html .= "<li><a href='https://xxx.com/?p=".$row['ID']."' target='_blank'>".$row['post_title']."</a></li>";

		}

		$html .= "</ul></div>";

	}

	echo $html;

	$res->free();

	$mysqli->close();

?>