This question already has answers here:
Answer
Solution:
when using mysqli you should read result by mysqli_fetch_row or something like that.
and suggest you use mysql_pdo instead.
<?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";
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$conn = mysqli_connect($servername, $username, $password, $dbname);
$result = mysqli_query($conn, "SELECT field_name FROM table_name");
//print result like this
while($row = mysqli_fetch_row($result)){
print_r($row);
}
Source