使用mysqli进行数据读取 Leone

$mysqli = new mysqli($servername, username, password);

$sql = "sql语句";
mysqli_query($conn, $sql);
$mysqli->query($sql);


$sql = "select id, symbol,sign,planet,element from zodiac";
 
$result = $mysqli->query($sql);
if ($result instanceof mysqli_result) {
    echo "the query return a result!". "<br/>";
 
    while ( $row = $result->fetch_object() ) {
        echo "id:" . $row->id . " symbol:" . $row->symbol . " sign:" . $row->sign . "<br/>";
        
    }
}

$result1 = $mysqli->query($sql);
while ( $row = $result1->fetch_array() ) {
    echo "id:" . $row[0] . " symbol:" . $row[1] . " sign:" . $row[2] . "<br/>";
 
}

$result2 = $mysqli->query($sql);
while ( $row = $result2->fetch_assoc() ) {
    echo "id:" . $row ["id"] . " symbol:" . $row ["symbol"] . " sign:" . $row ["sign"] . "<br/>";
}