json_encode does not work? [duplicate]

Web Technologies Web Development 2 years ago

0 1 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating
_x000D_ _x000D_ _x000D_ This question already has an answer here:_x000D_ _x000D_ _x000D_ How do I get PHP errors to display?_x000D_ _x000D_ 27 answers_x000D_ _x000D_ _x000D_ _x000D_ _x000D_ I want to convert mysql table data into json but unfortunately it does not return anything. fetch_object()) { $tempArray = $row; array_push($resultArray, $tempArray); } echo json_encode($resultArray); } mysqli_close($con); ?> My page is just blank what am I missing here?

Posted on 16 Aug 2022, this text provides information on Web Development related to Web Technologies. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (1)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago
_x000D_ You are trying to access a method in this line: $result->fetch_object(); mysqli_query($con, $sql) doesn't return instance of object. use while ($row = mysqli_fetch_assoc($result)) instead. To encode as JSON object: echo json_encode($row);

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.

Important Web Technologies Links