backup.php

<?php use Utils\Helper;

$name = "jasmine";
$db = Typecho_Db::get();
if (isset($_POST["type"])) {

  if ($_POST["type"] == "备份设置") {
    $value = $db->fetchRow(
      $db
        ->select()
        ->from("table.options")
        ->where("name = ?", "theme:" . $name)
    )["value"];
    if (
      $db->fetchRow(
        $db
          ->select()
          ->from("table.options")
          ->where("name = ?", "theme:" . $name . "_backup")
      )
    ) {
      $db->query(
        $db
          ->update("table.options")
          ->rows(["value" => $value])
          ->where("name = ?", "theme:" . $name . "_backup")
      ); ?>
            <script>
                alert("备份更新成功！");
                window.location.href = '<?php Helper::options()->adminUrl("options-theme.php"); ?>'
            </script>
        <?php
    } else {
       ?>
            <?php if ($value) {
              $db->query(
                $db
                  ->insert("table.options")
                  ->rows(["name" => "theme:" . $name . "_backup", "user" => "0", "value" => $value])
              ); ?>
                <script>
                    alert("备份成功！");
                    window.location.href = '<?php Helper::options()->adminUrl("options-theme.php"); ?>'
                </script>
            <?php
            }
    }
  }
  if ($_POST["type"] == "还原备份") {
    if (
      $db->fetchRow(
        $db
          ->select()
          ->from("table.options")
          ->where("name = ?", "theme:" . $name . "_backup")
      )
    ) {

      $_value = $db->fetchRow(
        $db
          ->select()
          ->from("table.options")
          ->where("name = ?", "theme:" . $name . "_backup")
      )["value"];
      $db->query(
        $db
          ->update("table.options")
          ->rows(["value" => $_value])
          ->where("name = ?", "theme:" . $name)
      );
      ?>
            <script>
                alert("还原成功！");
                window.location.href = '<?php Helper::options()->adminUrl("options-theme.php"); ?>'
            </script>
        <?php
    } else {
       ?>
            <script>
                alert("未备份过数据，无法恢复！");
                window.location.href = '<?php Helper::options()->adminUrl("options-theme.php"); ?>'
            </script>
        <?php
    } ?>
    <?php
  }
  ?>
    <?php if ($_POST["type"] == "删除备份") {
      if (
        $db->fetchRow(
          $db
            ->select()
            ->from("table.options")
            ->where("name = ?", "theme:" . $name . "_backup")
        )
      ) {
        $db->query($db->delete("table.options")->where("name = ?", "theme:" . $name . "_backup")); ?>
            <script>
                alert("删除成功");
                window.location.href = '<?php Helper::options()->adminUrl("options-theme.php"); ?>'
            </script>
        <?php
      } else {
         ?>
            <script>
                alert("没有备份内容，无法删除！");
                window.location.href = '<?php Helper::options()->adminUrl("options-theme.php"); ?>'
            </script>
        <?php
      } ?>
    <?php
    } ?>
<?php
}
?>
<?php echo '
    <form class="backup" action="?Joe_backup" method="post">
        <input type="submit" name="type" value="备份设置" />
        <input type="submit" name="type" value="还原备份" />
        <input type="submit" name="type" value="删除备份" />
    </form>';