Bootstrap 如何在mysql中通过模式编辑器编辑数据

bpsygsoo  于 2022-12-07  发布在  Bootstrap
关注(0)|答案(2)|浏览(174)

这段代码我一直有错误。我是引导程序的新手，也是使用模态函数的新手。我过去常常为我所有的“花哨”窗体运行子窗体，但现在我正在向模态函数迈进。这是我用来获取模态函数的代码：

<button class="btn btn-primary" data-toggle="modal" data-target="#newmemberModal">Add new Member</button>

<br />
<br />

<?php
    $result = mysql_query("SELECT * FROM `players` ORDER BY `players`.`user` ASC") 
        or die(mysql_error());  

    echo " <div class='table-responsive'><table class='table'>";
    echo "<tr><th>Username</th> <th>Rank</th> <th>Position</th> <th>DoP</th> <th>Tag</th> <th>AiT</th> <th>Service Stripes</th> <th>Notes</th> <th></th> <th></th><th></th></tr>";
    while($row = mysql_fetch_array( $result )) {

        echo "<tr>";
        echo '<td>' . $row['user'] . '</td>';
        echo '<td>' . $row['rank'] . '</td>';
        echo '<td>' . $row['position'] . '</td>';
        echo '<td>' . $row['date'] . '</td>';
        echo '<td>' . $row['tag'] . '</td>';
        echo '<td>' . $row['ait'] . '</td>';
        echo '<td>' . $row['ss'] . '</td>';
        echo '<td>' . $row['notes'] . '</td>';
        echo '<td><button class="btn btn-default" data-toggle="modal" data-target="#editModal">Edit</button></td>';
        echo '<td><a href="classes/forms/delete.php?id=' . $row['id'] . '">Delete</a></td>';
        echo '<td><a href="javascript:void(0);" NAME="My Window Name" title=" My title here " onClick=window.open("dd.php?id=' . $row['id'] . '","Ratting","width=350,height=550,0,status=0,");>DD</a><BR /><a href="javascript:void(0);" NAME="My Window Name" title=" My title here " onClick=window.open("hd.php?id=' . $row['id'] . '","Ratting","width=350,height=550,0,status=0,");>HD</a></td>';
        echo "</tr>"; 
    } 
    echo "</table> </div>";

?>

下面是我的编辑.php：

<?php include_once('classes/check.class.php'); ?>
    <?php
     function renderForm($id, $user, $rank, $position, $date, $tag, $ait, $ss, $notes, $error)
     {
     ?>

      <?php 
     if ($error != '')
     {
     echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
     }
     ?> 
    <?php if( protectThis("1, 2") ) : ?>
     <center><form action="" method="post">
     <input type="hidden" name="id" value="<?php echo $id; ?>"/>
     <div>
     <strong>Username: *</strong> <br/><input class="tb5" type="text" name="user" value="<?php echo $user; ?>" /><br/><br/>
     <strong>Rank: * Current is </strong> <?php echo $rank; ?> <br/> 
     <select name="rank">
     <option value="recruit" <?php if ($rank == 'recruit') echo 'selected'; ?>>Pending Rank</option>
     <option value="officer" <?php if ($rank == 'officer') echo 'selected'; ?>>PVT</option>
     <option value="leader" <?php if ($rank == 'leader') echo 'selected'; ?>>PV2</option>
    </select><br/><br/>

     <strong>Position: </strong> <br/><input class="tb5" type="text" name="position" value="<?php echo $position; ?>" /><br/><br/>
     <strong>Date: *</strong> <br/><input class="tb5" type="text" name="date" value="<?php echo $date; ?>" /><br/><br/>
     <strong>Tag: *</strong> <br/><input class="tb5" type="text" name="tag" value="<?php echo $tag; ?>" /><br/><br/>
     <strong>AiT's: </strong> <br/><input class="tb5" type="text" name="ait" value="<?php echo $ait; ?>" /><br/><br/>
     <strong>Service Stripes: </strong><br/> <input class="tb5" type="text" name="ss" value="<?php echo $ss; ?>" /><br/><br/>
     <strong>Notes: </strong><br/> <input class="tb5" type="text" name="notes" value="<?php echo $notes; ?>" /><br/><br/>
     <input class="btn-style" type="submit" name="submit" value="Submit"></center>

     </div>
     </form>    
    <?php elseif( protectThis(6) ) : ?> 
      <center><form action="" method="post">
     <input type="hidden" name="id" value="<?php echo $id; ?>"/>
     <div>
     <strong>Username: *</strong> <br/><input class="tb5" type="test" name="user" value="<?php echo $user; ?>" disabled /><br/><br/>
     <strong>Rank: * Current is </strong> <?php echo $rank; ?> <br/> 
     <select name="rank">
     <option value="recruit" <?php if ($rank == 'recruit') echo 'selected'; ?>>PVT</option>
     <option value="officer" <?php if ($rank == 'officer') echo 'selected'; ?>>PV2</option>

    </select><br/><br/>

     <strong>Position: </strong> <br/><input class="tb5" type="hidden" name="position" value="<?php echo $position; ?>" /><br/><br/>
     <strong>Date: *</strong> <br/><input class="tb5" type="text" name="date" value="<?php echo $date; ?>" /><br/><br/>
     <strong>Tag: *</strong> <br/><input class="tb5" type="text" name="tag" value="<?php echo $tag; ?>" /><br/><br/>
     <strong>AiT's: </strong> <br/><input class="tb5" type="text" name="ait" value="<?php echo $ait; ?>" /><br/><br/>
     <strong>Service Stripes: </strong><br/> <input class="tb5" type="hidden" name="ss" value="<?php echo $ss; ?>" /><br/><br/>
     <strong>Notes: </strong><br/> <input class="tb5" type="hidden" name="notes" value="<?php echo $notes; ?>" /><br/><br/>
     <input class="btn-style" type="submit" name="submit" value="Submit"></center>

     </div>
     </form> 
        <?php endif; ?>
    <?php
     }
     include('connect-db.php');

     if (isset($_POST['submit']))
     { 
     if (is_numeric($_POST['id']))
     {
     $id = $_POST['id'];
     $user = mysql_real_escape_string(htmlspecialchars($_POST['user']));
     $rank = mysql_real_escape_string(htmlspecialchars($_POST['rank']));
     $position = mysql_real_escape_string(htmlspecialchars($_POST['position']));
     $date = mysql_real_escape_string(htmlspecialchars($_POST['date']));
     $tag = mysql_real_escape_string(htmlspecialchars($_POST['tag']));
     $ait = mysql_real_escape_string(htmlspecialchars($_POST['ait']));
     $ss = mysql_real_escape_string(htmlspecialchars($_POST['ss']));
     $notes = mysql_real_escape_string(htmlspecialchars($_POST['notes']));

     if ($user == '' || $rank == '' || $date == '' || $tag == '')
     {
     $error = 'ERROR: Please fill in all required fields!';

     @renderForm($id, $user, $rank, $position, $date, $tag, $ait, $ss, $notes, $error);
     }
     else
     {

     mysql_query("UPDATE players SET user='$user', rank='$rank', position='$position', date='$date', tag='$tag', ait='$ait', ss='$ss', notes='$notes' WHERE id='$id'")
     or die(mysql_error()); 

    header("Location: home.php");
     }
     }
     else
     {

     echo 'Error!';
     }
     }
     else

 {

 if (isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0)
 {
 $id = $_GET['id'];
 $result = mysql_query("SELECT * FROM players WHERE id=$id")
 or die(mysql_error()); 
 $row = mysql_fetch_array($result);

 if($row)
 {
 $id = $row['id'];
 $user = $row['user'];
 $rank = $row['rank'];
 $position = $row['position'];
 $date = $row['date'];
 $tag = $row['tag'];
 $ait = $row['ait'];
 $ss = $row['ss'];
 $notes = $row['notes'];

 @renderForm($id, $user, $rank, $position, $date, $tag, $ait, $ss, $notes, '');
 }
 else
 {
 echo "No results!";
 }
 }
 else
 {
 echo 'Error!';
 }
 }
?>

问题是我总是在模态框中收到“Error！”消息，而不是其他任何消息。我试图做的目标是让它从存储在我的数据库中的ID中提取数据。我认为问题实际上是当我点击用户的编辑时，它没有抓取ID。坦白地说，我不知道如何才能通过模态编辑ID。非常感谢帮助。谢谢
额外好处：我不能在同一页打开两个模态。如果我在同一页打开两个模态，它们都不会显示：

<!--Modals-->   

<div class="modal fade" id="newmemberModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Add New Member</h4>
            </div>

            <div class="modal-body">
            <?php include("classes/forms/new.php"); ?>

            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="editModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Edit</h4>
            </div>

            <div class="modal-body">
            <?php include("classes/forms/edit.php"); ?>

            </div>
        </div>
    </div>
</div>
twitter-bootstrap

2条答案

按热度按时间
idv4meu8

idv4meu81#

您的编辑按钮没有将ID传递给edit.php，这就是模态没有被激活的原因。您需要在打开编辑模态之前填充它的内容，而不是在加载它的时候。使用include将加载编辑页面，而不会将ID传递给它。

重写编辑按钮以包含ID

<button class="btn btn-primary" data-toggle="modal" 
data-target="#editModal" data-formid="<?php echo $id; ?>">
    Edit <?php echo $id; ?>
</button>

JS用于在打开模态时加载编辑窗体

//jQuery function for loading data 
$("#editModal").on('show.bs.modal', function(event){
    var button = $(event.relatedTarget);
    //bootstrap way of retrieving data-* attributes
    //data-formid in this case
    var id = button.data('formid');
    $.get(yourSiteUrl+'/classes/forms/edit.php?id='+id, 
    function(data) {
        $("#editModal .modal-title").html(data);
        //Resize the modal to the size of the loaded form.
        $("#editModal").modal("handleUpdate");
    });
});

Check this tutorial to learn about bootstrap modals
我知道OP现在可能已经解决了这个问题，或者会采取不同的方法，我已经发布了答案，这样它可能对其他人有用。

赞(0）分享  回复(0）举报  2022-12-07
2ekbmq32

2ekbmq322#

试试这个..
//编辑链接或按钮。

<a href="#"  data-toggle="modal" data-target="#myModal_23" data-formid="<?php echo $id; ?>" class="button yellow" >
    <i class="ace-icon fa fa-pencil bigger-130"></i>
    </a>

 //ajax_edit.php
//modal window

<div class="modal fade " id="myModal_23" role="dialog">
    $id = $_REQUEST['id'];
    //echo $id;
   //code

</div>

//脚本

<script>

$("#myModal_23").on('show.bs.modal', function(event){
        var button = $(event.relatedTarget);           
        var id = button.data('formid');
        //alert(id);        
        $.get('ajax_edit.php?id='+id,
            function(data) {
             $("#myModal_23").html(data);   
                });
            });
      </script>
赞(0）分享  回复(0）举报  2022-12-07
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com