wordpress教程数据库

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
echo "连接成功";
?>

-- 创建索引
CREATE INDEX idx_post_title ON wp_posts (post_title);

-- 优化查询
SELECT * FROM wp_posts WHERE post_status = 'publish' ORDER BY post_date DESC LIMIT 10;

<?php
// 备份数据库
function backup_database() {
    global $wpdb;
    $backup = $wpdb->get_results("SELECT * FROM $wpdb->posts");
    file_put_contents('backup.sql', serialize($backup));
}

// 恢复数据库
function restore_database() {
    global $wpdb;
    $backup = unserialize(file_get_contents('backup.sql'));
    foreach ($backup as $post) {
        $wpdb->insert($wpdb->posts, $post);
    }
}
?>