dongsuiwo0279 2014-04-09 15:42
浏览 38

如何从数据库中显示多个图像的数据

html

 <a href="samcheckdb.php"><img src="getdesserticecreamimage.php?itemId=oepd1007" alt="image" id="img1"></a></li> 

samcheckdb.php

        <?php
        $hostname="localhost";
        $username="root";
        $password="tiger";
        $itemId=intval(\filter_input(\INPUT_GET,'itemId'));
        * @var $dbhandle type */
       $dbhandle = \mysqli_connect($hostname, $username, $password) 
        or die("Unable to connect to MySQL");

        /* @var $select type */
         $select= \mysqli_select_db($dbhandle,"sample")
     or mysqli_error($dbhandle);
     $sql="select subtitle,descript from dessert where itemId='oepd1007'"; 
      $result=mysqli_query($dbhandle,$sql);
    $row= mysqli_fetch_array($result);
    $subtitle=$row['subtitle'];
    $descript=$row['descript'];
     mysqli_close($dbhandle);
     ?>
  <html>
<head>
    <title>Customer menu card</title>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width">
    <link rel="stylesheet" type="text/css" href="dessert.css">
</head>
<body>
    <form id='custdisp' name='custdisp' method='post' action="samcheckdb.php"  enctype="multipart/form-data">
        <div id="d"><?php echo $descript ?></div>
        <div id="s"><?php echo $subtitle?></div>
    </form>
</body>
    </html>

I'm able to retrieve the corresponding data from the database with this code.But im having n number of images,it is not possible to create that many number of pages and i dont think it is optimal.How can i do this for multiple images???

  • 写回答

1条回答 默认 最新

  • dswwuo1223 2014-04-09 15:45
    关注

    You can put an onclick like

    <img src="getimage.php?itemId=oepsv1007" alt="image" id="img1" onclick="get_detail('oepsv1007');">
    

    then do a ajax call to get the detail using this id.

    javascript function

    function get_detail(id) {
      // ajax call
    }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 用hfss做微带贴片阵列天线的时候分析设置有问题
  • ¥50 我撰写的python爬虫爬不了 要爬的网址有反爬机制
  • ¥15 Centos / PETSc / PETGEM
  • ¥15 centos7.9 IPv6端口telnet和端口监控问题
  • ¥120 计算机网络的新校区组网设计
  • ¥20 完全没有学习过GAN,看了CSDN的一篇文章,里面有代码但是完全不知道如何操作
  • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
  • ¥20 海浪数据 南海地区海况数据,波浪数据
  • ¥20 软件测试决策法疑问求解答
  • ¥15 win11 23H2删除推荐的项目,支持注册表等