Exemplo n.º 1
0
        }
    }
    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) {
Exemplo n.º 2
0
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"]);
    }
}