dqxuiq7772
2016-12-06 02:24
浏览 79
已采纳

无法从MYSQL数据库中选择

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();
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • doujiku1028 2016-12-06 02:37
    已采纳

    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.

    已采纳该答案
    打赏 评论

相关推荐 更多相似问题