convert multiple rows to json after PDO request with php and pdo method only

Question

I want to convert severals rows after PDO request but I can't display result on my page.

This is for use with a rubimotion app

there is my php code:

<?php
    //to see what return request in my php page
    header('Content-type: text/html; charset=utf-8');

    try {
        $pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
        $bdd = new PDO('mysql:host=IP;dbname=NAME','USER','PASS');

        $reponse = $bdd->prepare("SELECT * FROM table WHERE id = 1");
        $reponse->execute(); #this request return severals rows

        $nb = $reponse->rowCount();
        if($nb > 0){
            $json = json_encode( $reponse->fetchAll( PDO::FETCH_ASSOC ) );
            echo $json;
        }
    }
    catch (Exception $e) {
        echo "Connexion échouée : " . $e->getMessage();
    }

?>

But I have a white page and in the console the response is empty.

Whats wrong ?

I tryed many option however I have many errors like

array to string convertion
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

thanks ! And sorry for the mistakes I am french

Check if you have something like single quote (') or any other character in your dataset ... — Asad Khan
– Asad Khan, Commented Aug 22, 2017 at 13:20
check row count by echo $nb; first for result data is available or not.Or add else part of if($nb > 0) condition — Bharat Dangar
– Bharat Dangar, Commented Aug 22, 2017 at 13:20
I don't have single quote juste many fields string @BharatDangar : echo $nb -> 218 rows ! — rem
– rem, Commented Aug 22, 2017 at 13:24
Have you enabled error reporting in PHP? Do you see any errors in your web server error log? — Don't Panic
– Don't Panic, Commented Aug 22, 2017 at 13:24
Did you realize you have defined $pdo_options, but it isn't used in your connection? — Don't Panic
– Don't Panic, Commented Aug 22, 2017 at 13:26

Sagar Patil · Accepted Answer · 2017-08-22 13:32:21Z

0

You must removed header function & use below line. You should add below line above the json_encode function.

header("content-type:application/json");

answered Aug 22, 2017 at 13:32

Sagar Patil

427 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

rem Over a year ago

now I have $json = json_encode( $reponse->fetchAll( PDO::FETCH_ASSOC ) ); var_dump($json); in my page there is bool(false)

rem Over a year ago

header("content-type:application/json");  $reponse = $bdd->prepare("SELECT * FROM manager_vtours WHERE user_id = 1");  echo json_encode($reponse->fetchAll(PDO::FETCH_ASSOC));

result = []

rem Over a year ago

I don't have error... juste an empty response in my console and a white page

Collectives™ on Stack Overflow

convert multiple rows to json after PDO request with php and pdo method only

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related