F
F
FeL1ksS2017-06-12 08:56:02
PHP
FeL1ksS, 2017-06-12 08:56:02

JSON.parse property 'length' of undefined?

After transferring the site to hosting, one php and js script does not work correctly.

$query = "SELECT ID_reserve,TypeOrder,ID_user,CheckOrdMenu,Date, TIME_FORMAT(Time, '%H:%i') as TimeCount_guest,Name,LastName,Telephone,Notes,DATE_FORMAT(Data_create, '%Y-%m-%d %H:%i') as Data_create, Status, IF(UseBonus = 1, true, false) as UseBonus, Bonus, TokenMessage FROM Reserve_table ORDER BY Reserve_table.ID_reserve DESC";
    $result = $pdo->query($query); 

    $data = array();
    $i = 0;
    foreach ($result as $row){
        if( ($row["TypeOrder"] == "mobile") && ($row["CheckOrdMenu"] == '1') ){
            $query = $pdo->prepare('SELECT Title_dish,Caption_dish,Price_dish,Amount_dish FROM Menu_table LEFT JOIN ReserveMenu_table ON Menu_table.ID_dish = ReserveMenu_table.ID_dish WHERE ReserveMenu_table.ID_reserve = :id_reserve');
            $query->execute(array('id_reserve' => $row["ID_reserve"]));
            $row["dishes"] = $query->fetchAll();
        }
        $data[] = $row;
    }
    echo json_encode($data);

var dataReserve = JSON.parse(response.data);
                console.log(dataReserve[0]);
                for (prop in dataReserve) {
                    
                    if(dataReserve[prop] != undefined){
                       if (dataReserve[prop].Status === "new") {
                           this.listReserveNew.push(dataReserve[prop]);
                       } else if (dataReserve[prop].Status === "accept") {
                           this.listReserveAccept.push(dataReserve[prop]);
                       }
                    }
                }

This is how it outputs from the local server:
06df6feb95a34cee94c5f220ead1c13f.jpg
This is how it is from the hosting: 789cca68a5ea403385d1be58f850be34.jpg
I clicked encodings on the hosting, to no avail. Does anyone know what could be the reason? very urgent.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Boris Korobkov, 2017-06-12
@FeL1ksS

Try
echo json_encode($data, JSON_NUMERIC_CHECK);

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question