个人中心
gpt4 book ai didi

php - 如何将此表单放入对话框？

转载 作者：行者123 更新时间：2023-11-30 18:31:16 24 4
gpt4 key购买 nike

背景:

这个页面是一个表单，有一个表格可以为不同的用户选择权限(只读，可编辑)对于每个选择框，名称是用户的 ID。

问题:

1)如何使用jquery放入对话框？ 我用谷歌搜索发现弹出框不是像往常一样的新页面，而只是<div>中的一个表单。 element ，在这种情况下我需要使用数据表，所以我不能简单地这样做。

2)弹出框关闭后如何取回值？对于每个选择框，名称是用户的 ID，我想获取每个用户的用户 ID 和权限设置。

谢谢你的帮助

这是 add.php(上层表单)

<?
include("../connection/conn.php");
session_start();

if($_SERVER['REQUEST_METHOD'] == "POST"){

if (!isset($_POST['subscribe']))
$_POST['subscribe']=0;
if (!isset($_POST['unsubscribe']))
$_POST['unsubscribe']=0;

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

try {

    $listName = $_POST['lname'];
    $listFromName = $_POST['fname'];
    $listReplyTo = $_POST['remail'];
    $listSubject = $_POST['sub'];
    $listRemindSub = $_POST['subscribe'];
    $listRemindUnSub = $_POST['unsubscribe'];
    $listReminder = $_POST['creminder'];

    $query="INSERT INTO list (ListID,ListName,FromName,ReplyTo,Subject,IsRemindSub,IsRemindUnSub,CreateDate,Reminder) VALUES ('',?,?,?,?,?,?,CURDATE(),?)";
    $stmt = $conn->prepare($query);


    $stmt->bindParam(1, $listName , PDO::PARAM_STR);
    $stmt->bindParam(2, $listFromName, PDO::PARAM_STR);
    $stmt->bindParam(3, $listReplyTo, PDO::PARAM_STR);
    $stmt->bindParam(4, $listSubject, PDO::PARAM_STR);
    $stmt->bindParam(5, $listRemindSub, PDO::PARAM_INT);
    $stmt->bindParam(6, $listRemindUnSub, PDO::PARAM_INT);
    $stmt->bindParam(7, $listReminder, PDO::PARAM_STR);

    $stmt->execute();


}
catch(PDOException $e)
    {
    die ($e->getMessage().'<a href="add.php"> Back</a>'); 
    $conn->rollBack();
    }


try {
    $lastID=$conn->lastInsertId();
    $query="INSERT INTO require_attributes (ReqID,ListID,Attribute,Tag) VALUES ('',$lastID,'Email','{email}')";
    $stmt = $conn->prepare($query);
    $stmt->execute();
    $query="INSERT INTO require_attributes (ReqID,ListID,Attribute,Tag) VALUES ('',$lastID,'FirstName','{fname}')";
    $stmt = $conn->prepare($query);
    $stmt->execute();
    $query="INSERT INTO require_attributes (ReqID,ListID,Attribute,Tag) VALUES ('',$lastID,'LastName','{lname}')";
    $stmt = $conn->prepare($query);
    $stmt->execute();
}
catch(PDOException $e)
    {
    die ($e->getMessage().'<a href="add.php"> Back</a>'); 
    $conn->rollBack();
    } 

try {
    $userID = $_SESSION['username'];
    $query="INSERT INTO user_list (UserID,ListID,UserListRights) VALUES (?,$lastID,'Edit')";
    $stmt = $conn->prepare($query);
    $stmt->bindParam(1, $userID, PDO::PARAM_STR);

    $stmt->execute();

}
catch(PDOException $e)
    {
    die ($e->getMessage().'<a href="add.php"> Back</a>'); 
    $conn->rollBack();
    }    


$conn = null;

?>
<div id="stylized" class="myform">
<div style="text-align:center;font-weight:bold;">You have created a list. By default Mail Address, First Name , Last Name is in your list. Add more field if you want. <a href='add.php'>Back</a></div>
<div class="spacer"></div>
</div>
<?
}else{?>


<!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>

<script src="../plugin/jquery-1.6.1.min.js"></script>
<script src="../plugin/jquery.validate.min.js"></script>
<script src="../plugin/jquery.form.js"></script>
<link rel="stylesheet" type="text/css" href="../style/form.css" />
<script>
function loadDialogBox() {'
    $("#myEmptyDiv").load("popup.php", function() {

      $("#myEmptyDiv").dialog({
         title: "Permission Setting",
         autoOpen: false,
         buttons: { "Submit" : submitDialogForm() }
      });
      $("#myEmptyDiv").dialog("open");
    });
}

$(function() { $("#openDialog").on('click', loadDialogBox); });

$(document).ready(function(){
$("#addlist").validate();
});
</script>

</head>
<body>
<div id="stylized" class="myform">
<form id="addlist" method="post" action="add.php" >
<h1>Create your new subscriber list</h1> 
<p>Create a new list before adding subscriber <label class="right"><em class="dot">*</em> indicates required</label></p>

<label><em class="dot">*</em> List name:
<span class="small">Add your list name</span>
</label>
<input id="lname" name="lname" class="required" />

<div class="spacer"></div>

<label>Reminder:
<span class="small">Remind the details of your list</span>
</label>
<textarea id="creminder" name="creminder" cols="52" ></textarea>

<div class="spacer"></div>

<p>Permission Setting ...</p>

<a id="openDialog" href="#">Permission Settings</a>
<label>Or open to other users</label> <input type="checkbox" class="checkbox" name="public" value="1">


<div class="spacer"></div>

<p>Email me when ...</p> 
<label>People subscribe</label> <input type="checkbox" class="checkbox" name="subscribe" value="1">
<label>People unsubscribe</label> <input type="checkbox" class="checkbox" name="unsubscribe" value="1">


<div class="spacer"></div>
<input class="submit" type="submit" name="submit" value="Submit"/>
<div class="spacer"></div>

</form>
<div class="spacer"></div>
</div>
<br><br><br>
<div id="stylized" class="myform">
<?
try{
$sql = '
    SELECT   *
    FROM     list,user_list
    WHERE    user_list.UserID=?
    AND list.ListID=user_list.ListID
';
$stmt = $conn->prepare($sql);
$stmt->execute(array($_SESSION['username']));
$result= $stmt->fetchAll();
$num_rows= $stmt->rowCount();
}
catch(PDOException $e)
    {
    die ($e->getMessage().'<a href="add.php"> Back</a>'); 
    }
$conn = null;
if ($num_rows == 0) {
    echo '<div style="text-align:center;font-weight:bold;">You have not created any list yet.</div>';}
else {
    echo '<h1>Your Subscriber List</h1> <p>You have created '.$num_rows.' list(s).</p>';
foreach ($result as $set) 
{
echo '<div style="font-weight:bold;">List Name : '.$set['FromName'].'</div><br>';
echo '<div style="font-weight:bold;">Subscriber : </div><br>';
echo '<div style="font-weight:bold;">Create Date : '.$set['CreateDate'].'</div><br>';
echo '<hr>';
}}
    ?>

<div class="spacer"></div>
</div>
</body>
</html>

<?
}
?>

这是popup.php 

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <style type="text/css">
      @import "../plugin/datatable/media/css/demo_page.css";
      @import "../plugin/datatable/media/css/demo_table.css";
    </style>
    <script type="text/javascript" src="../plugin/datatable/media/js/jquery.js"></script>
    <script type="text/javascript" src="../plugin/datatable/media/js/jquery.dataTables.js"></script>
    <script>

    function submitDialogForm() {
  $.post("add.php", $("#myEmptyDiv form").serialize(), function(data) {
     $("#yourUserIdDisplay").val(data.userId);
  });
}
    $(document).ready(function() {
    $('#viewSub').dataTable();
    } );
    </script>
    </head>
<body>
<?
include("../connection/conn.php");
session_start();
$sql =
    "SELECT  UserID,Name,Rights,Position
    FROM     user
    WHERE UserID != ?
    AND Rights != 'Admin'
    ";
$stmt = $conn->prepare($sql);
$stmt->execute(array($_SESSION['username']));
$num_rows= $stmt->rowCount();
if ($num_rows == 0)
echo "There is no another user in this system";
else{
$result = $stmt->fetchAll();
?>
<form>
<table width="100%" class="display" id="viewSub">
<thead>
<tr>
<th field="col1" width="40%">Name:</th>
<th field="col2" width="40%">Position:</th>
<th field="col2" width="20%">Permission:</th>
</tr>
</thead>
<tbody>
<?
foreach ($result as $set) 
{
    echo "<tr><td>".$set['Name']."</td><td>".$set['Position']."</td><td><select name=".$set['UserID']."><option value='default'>Not Share</option><option value='Read'>Read Only</option><option value='Edit'>Editable</option></select></td></tr>";
}
?>
</tbody> 
</table>
<div style='text-align:center'> <button id='save'>Confirm</button></div>
</form>
<?
}
?>
</body>
</html>

最佳答案

首先，要从 jQuery 将页面加载到对话框中，请尝试如下操作:

function loadDialogBox() {
    $("#myEmptyDiv").load("url-to-this-form.php", function() {

      $("#myEmptyDiv").dialog({
         title: "your dialog title",
         autoOpen: false,
         buttons: { "Submit" : submitDialogForm() }
      });
      $("#myEmptyDiv").dialog("open");
    });
}

现在您可以通过调用 loadDialogBox 函数来加载和打开表单。也许是这样的:

<a id="openDialog" href="#">Open Dialog</a>

$(function() { $("#openDialog").on('click', loadDialogBox); });

然后，像这样创建一个提交函数:

function submitDialogForm() {
  $.post("submit-page.php", $("#myEmptyDiv form").serialize(), function(data) {
    // here you can parse your return data for userid or permission settings that come back from server
     $("#yourUserIdDisplay").val(data.userId);
  });
}

这将序列化对话框表单数据并将其发布到您的服务器。

希望这对您有所帮助!

关于php - 如何将此表单放入对话框？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/9543096/

24 4 0
文章推荐： javascript - JSON.stringify 返回空
文章推荐： javascript - JQuery——如何实现类似 mac os dock 的显示/隐藏行为的动画？
文章推荐： php jquery 自动加载内容
文章推荐： c++ - 为什么我只能将文件中的位置指示器 (SetFilePointerEx) 移动 512 乘数？
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com