从PHP页面动态解析弹出模型框的值

Question

我试图解析php数据值，这个值在while循环中解析到弹出模型。

样本码

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

$sql = 'SELECT id FROM products WHERE tag="mixed" ORDER BY id DESC LIMIT 5';

mysql_select_db('levels');
$retval = mysql_query( $sql, $db_server );
if(! $retval )
{
  die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
  $id = $row['id'];
  
  ?>

<div onclick="showDialog('#dialog6');show_data();">

  <div id="getid">
    <?php echo $id; ?>
  </div>

</div>

<?php
}
mysql_close($db_server);
?>


<script>
    function showDialog(id){
        var dialog = $(id).data('dialog');
        dialog.open();
    }

    function show_data(){
      var x = document.getElementById("getid").innerHTML;
      document.getElementById("demo").innerHTML = x;
}
</script>
        
<!-- Popup Model -->
<div data-role="dialog" id="dialog6" >
 <div id="demo"> </div>

</div>

假设我有id => 1到10，上面的代码从表中写入最后5项。是6 7 8 9 10。(它运行得很好)。

我的要求是，当我单击7时，它应该将7解析为弹出模型。(或者让我们对innerHTML说)。

它只解析第一个值(5)。当我单击每个数字时，对所有onclick事件。

PS :这是使用mysql测试，而不是mysqli或pdo :)。

提前谢谢！

Answer 1

尝尝这个。希望能帮上忙。

    $sql = 'SELECT id FROM products WHERE tag="mixed" ORDER BY id DESC LIMIT 5';

    mysql_select_db('levels');
    $retval = mysql_query( $sql, $db_server );
    if(! $retval )
    {
      die('Could not get data: ' . mysql_error());
    }
    while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
    {
      $id = $row['id'];

      ?>

    <div onclick="showDialog('#dialog6');show_data(<?php echo $id; ?>);"> <!-- Changed -->

      <div id="getid<?php echo $id; ?>"> <!-- Changed -->
        <?php echo $id; ?>
      </div>

    </div>

    <?php
    }
    mysql_close($db_server);
?>


<script>
    function showDialog(id){
       var dialog = $(id).data('dialog');
       dialog.open();
    }

    function show_data(y){ // Changed
     var x = document.getElementById("getid"+y).innerHTML; // Changed
     document.getElementById("demo").innerHTML = x;
}
</script>

<!-- Popup Model -->
<div data-role="dialog" id="dialog6" >
 <div id="demo"> </div>

</div>

Answer 2

试试这个。

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

    $sql = 'SELECT id FROM products WHERE tag="mixed" ORDER BY id DESC LIMIT 5';

    mysql_select_db('levels');
    $retval = mysql_query( $sql, $db_server );
    if(! $retval )
    {
        die('Could not get data: ' . mysql_error());
    }
    while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
    {
        $id = $row['id'];

        ?>

        <div onclick="showDialog('#dialog6');show_data(<?php echo $id; ?>,'<?php echo $name; ?>','<?php echo $imgUrl; ?>');"> <!-- Changed -->

        <div id="id<?php echo $id; ?>"> <!-- Changed -->
        <?php echo $id; ?>
        </div>
        <div id="name<?php echo $name; ?>"> <!-- Changed -->
        <?php echo $id; ?>
        </div>
        <div id="image<?php echo $id; ?>"> <!-- Changed -->
            <img src="<?php echo $imgUrl; ?>" />
        </div>

        </div>

        <?php
    }
    mysql_close($db_server);
    ?>


    <script>
    function showDialog(id){
      var dialog = $(id).data('dialog');
      dialog.open();
    }

    function show_data(id, name, imgUrl){ // Changed
        document.getElementById("dispID").innerHTML = id;
        document.getElementById("dispName").innerHTML = name;
        document.getElementById("ImgDisplay").src = imgUrl;
    }
    </script>

    <!-- Popup Model -->
    <div data-role="dialog" id="dialog6" >
    <div id="demo"> <!-- Changed -->
        <div id="dispID"></div>
        <div id="dispName"></div>
        <div id="dispImg"><img id="ImgDisplay" src="" /></div>
    </div>

    </div>