我有点困惑，我收到了创建 CRUD 应用程序以编辑数组中的 JSON 对象并上传它们的请求。我做了一些研究并发现了 http://www.taffydb.com/但它并不真正符合我的要求。

编辑:我也遇到过 jtables，但它使用 mysql，类似于 http://www.jeasyui.com/tutorial/app/crud.php但它也使用mysql。是否可以跳过数据库部分并直接写入 JSON 文件？

由于这是一个非常小的 JSON 文件，拥有数据库似乎有些多余。我在 JSON 数组中有多个对象，外部应用程序将从中读取这些对象。

我可以选择哪些可行的选择？理想情况下，应用需要将浏览器内容添加/编辑/删除到 JSON 文件。

目前我可以在表格中相应地显示数据。我的代码如下所示:

PHP:

<?php
$getfile = file_get_contents('test.json');
$jsonfile = json_decode($getfile);
?>

HTML:

<table align="center">
<tr>
  <th>Title</th>
  <th>Background Image</th>
  <th>Video URL (Link to Video)</th>
  <th>Description of Video</th>
</tr>
  <?php
    foreach ($jsonfile->playlist as $obj) {
      echo '<tr><td>' . $obj->title . '</td>';
      echo '<td>' . $obj->title_bg . '</td>';
      echo '<td>' . $obj->link . '</td>';
      echo '<td>' . $obj->description . '</td></tr>';
    }
  ?>
</table>

JSON:

{
  "playlist": [
    {
      "title": "Test title",
      "title_bg": "link/to/image.png",
      "link": "https://www.google.com",
      "description": "This is a test JSON Object"
    }
  ]
}

JSON 文件将在 playlist 数组中有多个对象

最佳答案

你可以这样做:

test.json

{
    "playlist": [
        {
            "title": "Test title1222212321321321",
            "title_bg": "link\/to\/image.png",
            "link": "https:\/\/www.google.com",
            "description": "This is a test JSON Object"
        }, {
            "title": "sdfdasf",
            "title_bg": "adsfdas",
            "link": "fdasf",
            "description": "dasfdasf"
        }, {
            "title": "This is a title ",
            "title_bg": "This is a title bg",
            "link": "This is a link2",
            "description": "This is a description"
        }
    ]
}

index.php

<?php
$getfile = file_get_contents('test.json');
$jsonfile = json_decode($getfile);
?>
<a href="http://localhost/test/add.php">Add</a>
<table align="center">
    <tr>
        <th>Title</th>
        <th>Background Image</th>
        <th>Video URL (Link to Video)</th>
        <th>Description of Video</th>
        <th></th>
    </tr>
    <tbody>
        <?php foreach ($jsonfile->playlist as $index => $obj): ?>
            <tr>
                <td><?php echo $obj->title; ?></td>
                <td><?php echo $obj->title_bg; ?></td>
                <td><?php echo $obj->link; ?></td>
                <td><?php echo $obj->description; ?></td>
                <td>
                    <a href="http://localhost/test/edit.php?id=<?php echo $index; ?>">Edit</a>
                    <a href="http://localhost/test/delete.php?id=<?php echo $index; ?>">Delete</a>
                </td>
            </tr>
        <?php endforeach; ?>
    </tbody>
</table>

edit.php

<?php
if (isset($_GET["id"])) {
    $id = (int) $_GET["id"];
    $getfile = file_get_contents('test.json');
    $jsonfile = json_decode($getfile, true);
    $jsonfile = $jsonfile["playlist"];
    $jsonfile = $jsonfile[$id];
}

if (isset($_POST["id"])) {
    $id = (int) $_POST["id"];
    $getfile = file_get_contents('test.json');
    $all = json_decode($getfile, true);
    $jsonfile = $all["playlist"];
    $jsonfile = $jsonfile[$id];

    $post["title"] = isset($_POST["title"]) ? $_POST["title"] : "";
    $post["title_bg"] = isset($_POST["title_bg"]) ? $_POST["title_bg"] : "";
    $post["link"] = isset($_POST["link"]) ? $_POST["link"] : "";
    $post["description"] = isset($_POST["description"]) ? $_POST["description"] : "";



    if ($jsonfile) {
        unset($all["playlist"][$id]);
        $all["playlist"][$id] = $post;
        $all["playlist"] = array_values($all["playlist"]);
        file_put_contents("test.json", json_encode($all));
    }
    header("Location: http://localhost/test/index.php");
}
?>
<?php if (isset($_GET["id"])): ?>
    <form action="http://localhost/test/edit.php" method="POST">
        <input type="hidden" value="<?php echo $id ?>" name="id"/>
        <input type="text" value="<?php echo $jsonfile["title"] ?>" name="title"/>
        <input type="text" value="<?php echo $jsonfile["title_bg"] ?>" name="title_bg"/>
        <input type="text" value="<?php echo $jsonfile["link"] ?>" name="link"/>
        <input type="text" value="<?php echo $jsonfile["description"] ?>" name="description"/>
        <input type="submit"/>
    </form>
<?php endif; ?>

删除.php

<?php

if (isset($_GET["id"])) {
    $id = (int) $_GET["id"];
    $all = file_get_contents('test.json');
    $all = json_decode($all, true);
    $jsonfile = $all["playlist"];
    $jsonfile = $jsonfile[$id];

    if ($jsonfile) {
        unset($all["playlist"][$id]);
        $all["playlist"] = array_values($all["playlist"]);
        file_put_contents("test.json", json_encode($all));
    }
    header("Location: http://localhost/test/index.php");
}

add.php

<form action="http://localhost/test/add.php" method="POST">
    <input type="text" name="title" placeholder="title"/>
    <input type="text" name="title_bg" placeholder="title_bg"/>
    <input type="text" name="link" placeholder="link"/>
    <input type="text" name="description" placeholder="description"/>
    <input type="submit" name="add"/>
</form>
<?php
if (isset($_POST["add"])) {
    $file = file_get_contents('test.json');
    $data = json_decode($file, true);
    unset($_POST["add"]);
    $data["playlist"] = array_values($data["playlist"]);
    array_push($data["playlist"], $_POST);
    file_put_contents("test.json", json_encode($data));
    header("Location: http://localhost/test/index.php");
}
?>

要运行脚本，您必须在每个文件中指定一个文件路径 JSON。您还必须更改指向您的环境的链接地址。

关于PHP CRUD JSON 文件而不是像 mysql 这样的数据库，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/38301457/