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条)

报告相同问题？

悬赏问题

  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 对于相关问题的求解与代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料