gpt4 book ai didi

php - 使用 php 激活和停用 mysql 记录

转载 作者:行者123 更新时间:2023-11-29 01:31:07 25 4
gpt4 key购买 nike

您好,我正在研究用户管理系统。我显示了数据库中的所有记录,并成功执行了添加、编辑和删除操作。现在我需要在主页中显示为仅来自 Mysql 表的事件记录。我的管理控制中有 2 个链接,一个是激活的,另一个是停用的。如果我单击激活,记录将显示在主页中,停用意味着记录将隐藏在主页中。我用

插入字段状态
datatype enum('active','deactive')`.

我的编码如下。在编码方面我需要哪些改变?

索引.php:

<form method="post">
<table>

<tr>
<td>Title:</td>
<td><input type="text" name="title" /></td>
</tr>
<tr>
<td>Author</td>
<td><input type="text" name="author" /></td>
</tr>
<tr>
<td>Publisher Name</td>
<td><input type="text" name="name" /></td>
</tr>
<tr>
<td>Copyright Year</td>
<td><input type="text" name="copy" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="submit" value="add" /></td>
</tr>
</table>
<?php
if (isset($_POST['submit']))
{
include 'db.php';

$title=$_POST['title'] ;
$author= $_POST['author'] ;
$name=$_POST['name'] ;
$copy=$_POST['copy'] ;

mysql_query("INSERT INTO `books`(Title,Author,PublisherName,CopyrightYear)
VALUES ('$title','$author','$name','$copy')");


}
?>
</form>
<table border="1">

<?php
include("db.php");


$result=mysql_query("SELECT * FROM books");

while($test = mysql_fetch_array($result))
{
$id = $test['BookID'];
echo "<tr align='center'>";
echo"<td><font color='black'>" .$test['BookID']."</font></td>";
echo"<td><font color='black'>" .$test['Title']."</font></td>";
echo"<td><font color='black'>". $test['Author']. "</font></td>";
echo"<td><font color='black'>". $test['PublisherName']. "</font></td>";
echo"<td><font color='black'>". $test['CopyrightYear']. "</font></td>";
echo"<td> <a href ='view.php?BookID=$id'>Edit</a>";
echo"<td> <a href ='view.php?BookID=$id'>Activate</a>";
echo"<td> <a href ='view.php?BookID=$id'>Deactivate</a>";
echo"<td> <a href ='del.php?BookID=$id'><center>Delete</center></a>";

echo "</tr>";
}
mysql_close($conn);
?>
</table>

View.php:
<?php
require("db.php");
$id =$_REQUEST['BookID'];

$result = mysql_query("SELECT * FROM books WHERE BookID = '$id'");
$test = mysql_fetch_array($result);
if (!$result)
{
die("Error: Data not found..");
}
$Title=$test['Title'] ;
$Author= $test['Author'] ;
$PublisherName=$test['PublisherName'] ;
$CopyrightYear=$test['CopyrightYear'] ;

if(isset($_POST['save']))
{
$title_save = $_POST['title'];
$author_save = $_POST['author'];
$name_save = $_POST['name'];
$copy_save = $_POST['copy'];

mysql_query("UPDATE books SET Title ='$title_save', Author ='$author_save',
PublisherName ='$name_save',CopyrightYear ='$copy_save' WHERE BookID = '$id'")
or die(mysql_error());
echo "Saved!";

header("Location: index.php");
}
mysql_close($conn);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<form method="post">
<table>
<tr>
<td>Title:</td>
<td><input type="text" name="title" value="<?php echo $Title ?>"/></td>
</tr>
<tr>
<td>Author</td>
<td><input type="text" name="author" value="<?php echo $Author ?>"/></td>
</tr>
<tr>
<td>Publisher Name</td>
<td><input type="text" name="name" value="<?php echo $PublisherName ?>"/></td>
</tr>
<tr>
<td>Copyright Year</td>
<td><input type="text" name="copy" value="<?php echo $CopyrightYear ?>"/></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="save" value="save" /></td>
</tr>
</table>

</body>
</html>

del.php:

<?php
include("db.php");

$id =$_REQUEST['BookID'];


// sending query
mysql_query("DELETE FROM books WHERE BookID = '$id'")
or die(mysql_error());

header("Location: index.php");
?>

请给出一些想法或编码。这是我第一次使用这个概念。??

最佳答案

在使用主动非主动逻辑时..

您必须遵循以下步骤:-

  1. You have to create some flag status with enum value for active and deactive.
  2. while fetching data from database you have to give condition to fetch only active record.
  3. If you have active or deactive button you have to update your record based on that.

如果您遵循这些步骤,它就会成功!!

关于php - 使用 php 激活和停用 mysql 记录,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/12311822/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com