} } if (count($old_techs) > 0) { foreach ($old_techs as $values) { array_push($delarray, $values["id"]); } $delString = implode(", ", $delarray); $sql = "DELETE FROM " . $tableName . "_techs WHERE id in (" . $delString . ")"; if (!mysql_query($sql)) { exit(mysql_error()); } } $data["keywords"] = $keywords; $data["info"] = json_decode($data["info"], true); $out = array("error" => 0, "json" => $data); exit($Obj->JSON($out)); } else { if ($_GET["mod"] == "delete") { $sql = "DELETE FROM " . $tableName . " WHERE id=" . $_POST["data"]; if (!mysql_query($sql)) { exit(mysql_error()); } $sql = "DELETE FROM " . $tableName . "_techs WHERE pid=" . $_POST["data"]; if (!mysql_query($sql)) { exit(mysql_error()); } exit("success"); } } $result = mysql_query("SELECT * FROM {$tableName} WHERE uid ='" . $uid . "' ORDER BY id DESC"); if ($result) {
function updateinfo($data) { $Obj = new wechatFlow(); global $othersql; global $info; $tableName = "rel_menu"; $olddata = $info; $delarray = array(); for ($i = 0; $i < count($data); $i++) { $value = $data[$i]; $value["orderid"] = $i; $value["pid"] = "0"; $sub_button = $value["sub_button"]; unset($value["sub_button"]); if ($value["id"] == "") { $value["id"] = $Obj->insertWithArray($value, $tableName); } else { $Obj->updateWithArray($value, $tableName, $value["id"]); unset($olddata[$value["id"]]); } for ($j = 0; $j < count($sub_button); $j++) { $values = $sub_button[$j]; $values["orderid"] = $j; $values["pid"] = $value["id"]; if ($values["id"] == "") { $values["id"] = $Obj->insertWithArray($values, $tableName); } else { $Obj->updateWithArray($values, $tableName, $values["id"]); unset($olddata[$values["id"]]); } } } if (is_array($olddata)) { foreach ($olddata as $value) { array_push($delarray, $value["id"]); } } if (count($delarray) > 0) { delWithArray($delarray, $tableName); } $type = array("", "click", "view"); $data = array(); $result = mysql_query("SELECT * FROM rel_menu ORDER BY `pid` ASC,`orderid` ASC"); while ($row = mysql_fetch_assoc($result)) { $infos[$row["id"]] = $row; } foreach ($infos as $value) { $array["name"] = $value["name"]; if ($value["type"] == 1) { $array["type"] = $type[$value["type"]]; $array["key"] = "menu_id_" . $value["id"]; } elseif ($value["type"] == 3) { $array["type"] = $type[1]; $array["key"] = "menu_id_" . $value["id"]; } elseif ($value["type"] == 2) { $array["type"] = $type[$value["type"]]; $array["url"] = $value["data"]; } elseif ($value["type"] == 0) { $array["id"] = $value["id"]; $array["sub_button"] = array(); } if ($value["pid"] != "0") { for ($i = 0; $i < count($data); $i++) { if ($data[$i]["id"] == $value["pid"]) { array_push($data[$i]["sub_button"], $array); } } } else { array_push($data, $array); } unset($array); } for ($i = 0; $i < count($data); $i++) { unset($data[$i]["id"]); if (count($data[$i]["sub_button"]) == 0 && $data[$i]["type"] == "") { unset($data[$i]); } } $postdata["button"] = $data; $result = $Obj->curl_http_request($url, $Obj->JSON($postdata)); $result = json_decode($result["json"], true); if ($result["errcode"] > 0) { exit($result["errmsg"]); } }