|
|
index.php
<?php
$link = mysqli_connect(&#39;localhost&#39;, &#39;root&#39;, &#39;root&#39;, &#39;test&#39;);
{
// 查询所有愿望
$sql = &#39;SELECT `id`,`name`,`content`FROM `wish`&#39;;
$res = mysqli_query($link, $sql);
$data = mysqli_fetch_all($res, MYSQLI_ASSOC);
mysqli_free_result($res);
}
//改
$id = @$_GET[&#39;id&#39;];
$action = @$_GET[&#39;action&#39;];
$name = @$_POST[&#39;name&#39;];
$content = @$_POST[&#39;content&#39;];
if ($action == &#39;edit&#39;) {
$findOneSql = &#39;SELECT `name`,`content` FROM `wish` WHERE `id`=&#39; . $id;
$findOneRes = mysqli_query($link, $findOneSql);
$edit = mysqli_fetch_assoc($findOneRes);
mysqli_free_result($findOneRes);
}
if ($action == &#39;submit&#39;) {
$sql = &#39;UPDATE `wish` SET `name`=&#34;&#39; . $name . &#39;&#34;,`content`=&#34;&#39; . $content . &#39;&#34; WHERE `id`=&#39; . $id;
mysqli_query($link, $sql);
header(&#39;Location: ./index.php&#39;);
//释放内存
mysqli_close($link);
}
?>
<?php foreach ($data as $v): ?>
<ul>
<a class=&#34;note-list-edit&#34; href=&#34;./index.php?action=edit&id=<?= $v[&#39;id&#39;] ?>&#34;
title=&#34;修改&#34;>✎</a>
<li>FORM: <span><?= $v[&#39;name&#39;] ?></span></li>
<li><?= $v[&#39;content&#39;] ?></li>
</ul>
<?php endforeach; ?>
<form method=&#34;post&#34; action=&#34;./index.php?action=submit&id=<?= $id ?>&#34;>
name:<input type=&#34;text&#34; name=&#34;name&#34; placeholder=&#34;未选择&#34; value=&#34;<?= @$edit[&#39;name&#39;] ?>&#34;><br>
content:<input type=&#34;text&#34; name=&#34;content&#34; placeholder=&#34;未选择&#34; value=&#34;<?= @$edit[&#39;content&#39;] ?>&#34;><br>
<input type=&#34;submit&#34; value=&#34;提交&#34;>
</form>
sql |
|
发表于 2023-1-18 09:50:25