无法从MYSQL数据库中选择

Question

I have a mysql database in which I am administering via phpMyAdmin.

I can run INSERT and CREATE just fine with php, but cannot SELECT data from my database.

However, when I SELECT inside of phpMyAdmin it works just fine.

---

I get no errors, but the browser outputs a status of:

500 (Internal Server Error)

---

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

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

$sql = "SELECT * FROM test";

$result = $conn->query($sql);
echo mysql_error(); die;

echo "$result";

$conn->close();

Answer 1

For successful SELECT query mysqli_query() will return a mysqli_result object.

ie, $result is a mysqli_result object. So you cannot echo it directly.

Use mysqli_fetch-assoc() to get an associative array of strings representing the fetched row in the result set.

Also you are mixing mysqli and mysql functions

Use mysqli_error() function.