回顯mysqli查詢

當(dāng)使用mysqli時(shí)，您應(yīng)該通過mysqli_fetch_row或類似的方式讀取結(jié)果。并建議您使用mysql_pdo。

<?php
//if error happend,this will display error on page
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$result = mysqli_query($conn, "SELECT field_name FROM table_name");

//print result like this
while($row = mysqli_fetch_row($result)){
    print_r($row);
}