json_encode does not work? [duplicate]

Web Technologies Web Development 3 years ago

1.73K 1 0 0 0

_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?

User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.

Answers (1)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 3 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);
0 views
0 shares

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.

Similar Forum


Q

Unity hosting a custom piece of code on own website [on hold]

_x000D_ _x000D_ I was wondering how would you be able to host an "API" on your own website that you...
Q

I am needing advice on a web bot [on hold]

_x000D_ _x000D_ I want to code a bot that has a GUI or CLI doesn't really matter yet but a GUI would...
Q

date and time picker, that can take a max and min absolute time, compatible with react [on hold]

_x000D_ _x000D_ I have an issue with scheduling things in a web platform (react.js), and need a date...

Important Web Technologies Links