Answer the question
In order to leave comments, you need to log in
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]);
}
}
}
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question