✏ 编辑: test1.php

<?php
ini_set("display_errors", 1);
error_reporting(E_ALL);

// Absolute path to config
require __DIR__ . '/db_config.php';

// Connect to database
$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

// Check connection
if ($conn->connect_error) {
    die("DB Connection Failed → " . $conn->connect_error);
}

echo "✅ Connected to database successfully!<br>";

// Optional: check charset
$conn->set_charset("utf8mb4");
echo "Charset: " . $conn->character_set_name() . "<br>";

// Check total rows in horoscopes table
$sql = "SELECT COUNT(*) AS total FROM horoscopes";
$result = $conn->query($sql);

if(!$result){
    die("Query error → " . $conn->error);
}

$row = $result->fetch_assoc();
echo "Total horoscopes: " . $row['total'] . "<br>";

// Fetch first 3 rows to verify data
$sql2 = "SELECT * FROM horoscopes LIMIT 3";
$result2 = $conn->query($sql2);

if(!$result2){
    die("Query error → " . $conn->error);
}

while($row = $result2->fetch_assoc()){
    echo "<pre>";
    print_r($row);
    echo "</pre>";
}

$conn->close();
?>