mysqlquery返回值处理

// 示例代码（使用mysqli）
$mysqli = new mysqli("localhost", "username", "password", "database");

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

$sql = "SELECT * FROM table_name";
$result = $mysqli->query($sql);

if ($result === FALSE) {
    echo "Query failed: " . $mysqli->error;
} else {
    // 处理结果集
}

$mysqli->close();

// 示例代码（分页查询）
$page = 1;
$limit = 10;
$offset = ($page - 1) * $limit;

$sql = "SELECT * FROM table_name LIMIT $limit OFFSET $offset";
$result = $mysqli->query($sql);

// 处理结果集

// 示例代码（使用预处理语句）
$stmt = $mysqli->prepare("SELECT * FROM table_name WHERE id = ?");
$stmt->bind_param("i", $id);

$id = $_GET['id']; // 假设id是从URL参数中获取的
$stmt->execute();

$result = $stmt->get_result();
// 处理结果集

$stmt->close();