//check groupid ถ้ายังเหมือนเดิมอยู่ให้ add id กับ path เข้า $groupid if ($msgdata["message_id"] == $checkmsgid) { $groupiddetail = array("id" => $msgdata["group_id"], "path" => findparentpath($msgdata["group_id"], $con), "pict" => getgrouppict($con, $msgdata["group_id"])); array_push($grouppath, $groupiddetail); } else { //add element เข้า $msgdetail $msgdetail = array("id" => $id_db, "grouppath" => $grouppath, "body" => $body_db, "priority" => $priority_db, "fromid" => $fromid_db, "pict" => $pict, "formname" => $fromname, "read" => $read_db, "reach" => $reach_db, "date" => $c_date, "time" => $c_time); array_push($msg, $msgdetail); $grouppath = array(); //ย้าย id ใหม่ใส่ $checkmsgid $checkmsgid = $msgdata["message_id"]; //เคลียค่า $groupid $groupid = array(); //หา path ใส่ $groupid $path = findparentpath($msgdata["group_id"], $con); $pixx = getgrouppict($con, $msgdata["group_id"]); $groupiddetail = array("id" => $msgdata["group_id"], "path" => $path, "pict" => $pixx); array_push($grouppath, $groupiddetail); //get all rows from db to ตัวแปรใน php $id_db = $msgdata["message_id"]; $body_db = $msgdata["message_body"]; $priority_db = $msgdata["priority"]; $fromid_db = $msgdata["from_user_id"]; $fromname = $sendernamedata["name"]; $pict = $sendernamedata["picture"]; $read_db = $msgdata["read_status"]; $reach_db = $msgdata["reach_status"]; $c_date = $msgdata["create_date"]; $c_time = $msgdata["create_time"]; } }
//หา path ใส่ $groupid $path = $msgdata["pathmsg"]; $groupiddetail = array("id" => $msgdata["group_id"], "path" => $path); array_push($grouppath, $groupiddetail); //get all rows from db to ตัวแปรใน php $id_db = $msgdata["message_id"]; $body_db = $msgdata["message_body"]; $priority_db = $msgdata["priority"]; $fromid_db = $msgdata["from_user_id"]; $fromname = $sendernamedata["name"]; $pict = $sendernamedata["picture"]; $read_db = $msgdata["read_status"]; $reach_db = $msgdata["reach_status"]; $c_date = $msgdata["create_date"]; $c_time = $msgdata["create_time"]; $to_groupid = $msgdata["to_groupid"]; $to_groupname = $msgdata["to_groupname"]; $to_grouppict = getgrouppict($con, $msgdata["to_groupid"]); } } //หลุด loop แล้วยังต้องเอาค่า id สุดท้ายเก็บลง $msgdetail $msgdetail = array("id" => $id_db, "body" => $body_db, "priority" => $priority_db, "fromid" => $fromid_db, "pict" => $pict, "formname" => $fromname, "read" => $read_db, "reach" => $reach_db, "date" => $c_date, "time" => $c_time, "to_id" => $to_groupid, "to_name" => $to_groupname, "to_grouppict" => $to_grouppict); array_push($msg, $msgdetail); $response = array("status" => "success", "description" => "all data", "message" => $msg); } else { $response = array("status" => "success", "description" => "no message", "message" => $msg); } } else { $response = array("status" => "failed", "description" => "invalid session id", "message" => $msg); } echo json_encode($response);