duanchi6397 2018-06-01 15:45
浏览 50
已采纳

使用表条目加一个填充文本框?

I am trying to increment project number based on the last entry. The the primary key PROJECTNOID auto-increments but is not the same format as the project number (Ex: PROJECTNOID = 1 and Project Number = 19000). I don't want this to be a dropdown box even though some of my code shows the opposite.

<?php
   connect = mysqli_connect("**", "**", "**", "**");

   $query4 = "SELECT PROJECTNOID, ProjectNumber FROM tblProjects ORDER BY 
              PROJECTNOID";
   $result4 = mysqli_query($connect,$query4);

   $options4 = "";

   while($row4 = mysqli_fetch_row($result4);){
      $options4 = $options4."<input value=$row4[0]$row4[1]</input>";
   }

?>

Here is the html textbox:

<label for="txtfield">Project Number</label>
            <!--<input type="text" id="reqtxtfield" name="projectnumber" 
value="<?php  ?>" readonly/>-->
              <?php echo $options4;?>
  • 写回答

2条回答 默认 最新

  • douxian1923 2018-07-05 14:44
    关注

    PHP:

    <?php
      $query_5 = "SELECT MAX(ProjectNumber) FROM tblProjects;";
      $result_5 = mysqli_query($conn, $query_5);
      $row_5 = mysqli_fetch_array($result_5);
      $nextproject=$row_5['MAX(ProjectNumber)']+1;
    ?>
    

    HTML:

    <html>
      <form class="myform" action="<?php echo htmlspecialchars($_SERVER[" PHP_SELF "]);?>" method="post">
      <label for="txtfield">Project Number</label>
         <input type="text" id="reqtxtfield" name="projectnumber" value="<?php echo $nextproject ?>" readonly/><br>
    

    After running successful insert query:

    echo "<meta http-equiv='refresh' content='0'>";  //REFRESH PAGE TO UPDATE PROJECT NUMBER
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)