approve.php
:
<?php
include('lock.php');
include('config.php');
$querychange = mysql_query("UPDATE booking_members SET status='Approved'");
echo 'The Request has been approved. You may now go <a href="admin-panel.php">Back to the previous page</a>';
?>
如何更新 ID 以显示状态批准?
这是我的admin-panel.php
:
$req = mysql_query('select id, email, start_date, end_date, time_event,
time_submitted,payment_method, status from booking_members');
while($dnn = mysql_fetch_array($req)){?>
设置一个$id
变量,然后使用 WHERE
子句将其传递给查询。在第一页上的按钮上,您将通过 ?id=
传递变量。这看起来像:
首页代码:
<td class="left"> <a href="approve.php?id=<?php echo $dnn['id']; ?>">Approve</a> </td>
然后approve.php
:
// set id
$id = $_GET["id"];
$querychange = mysql_query("UPDATE booking_members SET status='Approved' WHERE id = '$id'");
我也有类似的问题...问题是没有批准的列。有一个授权(拼写如何在 DNN 中使用)列。这是我的选择声明,以显示我的网站的已批准成员:
SELECT
u.UserName,
upd.FirstName,
upd.LastName,
upd.unit as Numerical,
Upd.Street
FROM
dbo.Users AS u LEFT OUTER JOIN
(SELECT up.UserID,
MAX(CASE WHEN ppd.PropertyName = 'FirstName' THEN up.PropertyValue ELSE '' END)
AS FirstName, MAX(CASE WHEN ppd.PropertyName = 'LastName' THEN up.PropertyValue
'' END)
AS LastName,
MAX(CASE WHEN ppd.PropertyName = 'Unit' THEN up.PropertyValue ELSE '' END)
AS unit,
MAX(CASE WHEN ppd.PropertyName = 'Street' THEN up.PropertyValue ELSE '' END)
AS Street
FROM
dbo.UserProfile AS up INNER JOIN
dbo.ProfilePropertyDefinition AS ppd ON up.PropertyDefinitionID =
ppd.PropertyDefinitionID
and ppd.PortalID = 0 Group By up.UserID)
as upd on u.UserID = upd.UserID Join dbo.UserPortals on UserPortals.Userid =
U.Userid where Authorised='True'
and u.userid>16