Add voting options

Here you need to query and display all the voting questions that have been added:

<?php
<select style="width:300px;" name="subject">
   <option value="" checked>请选择问题</option>
<?php
   $result = $db->query("select * from votename");
   while($row = mysqli_fetch_assoc($result)){
?>
   <option value="<?php echo $row['cid']; ?>"><?php echo $row['question_name']; ?></option>
<?php
   }
?>
</select>

All codes:

<?php
   include('../conn.php');
   if(isset($_POST['voteoption'])?$_POST['voteoption']:''){
      $voteoption = $_POST['voteoption'];
      $subject = $_POST['subject'];
      if($subject == ""){
         echo "<script>onload = function(){document.getElementById('errortext').innerHTML='请选择问题！';}</script>";
      }else{
         $result = $db->query("insert into voteoption (optionname, upid, votenum) values ('$voteoption', '$subject', '0')");
         if($result){
            echo "<script>onload = function(){document.getElementById('errortext').innerHTML='添加选项成功';}</script>";
         }else{
            echo "<script>onload = function(){document.getElementById('errortext').innerHTML='添加选项失败';}</script>";
         }
      }
   }
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<script type="text/javascript" src="js/jquery.min.js"></script>
<link rel="stylesheet" href="css/add.css" type="text/css" media="screen" />
<link rel="stylesheet" href="utilLib/bootstrap.min.css" type="text/css" media="screen" />
</head>
<body>
<div class="div_from_aoto" style="width: 500px; margin:30px 40px;">
    <FORM action="Addvoteoption.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
   <div id="result111" class="result111" style="width:300px; height:20px; margin:4px auto; color:#33FF99;  ">
   <h5 id="errortext"></h5>
   </div> 
        <DIV class="control-group">
            <label class="laber_from">投票选项</label>
            <DIV  class="controls" ><INPUT class="username" style="width:300px;" name="voteoption" type=text placeholder=" 请输入投票选项"><P class=help-block>不要超过20个字</P></DIV>
        </DIV>
        <DIV class="control-group">
            <label class="laber_from">所属问题</label>
            <DIV  class="controls" ><select style="width:300px;" name="subject">
                              <option value="" checked>请选择问题</option>
                           <?php
                              $result = $db->query("select * from votename");
                              while($row = mysqli_fetch_assoc($result)){
                           ?>
                              <option value="<?php echo $row['cid']; ?>"><?php echo $row['question_name']; ?></option>
                           <?php
                              }
                           ?>
                           </select>
         <P class=help-block></P></DIV>
        </DIV>
        <DIV class="control-group">
            <LABEL class="laber_from" ></LABEL>
            <DIV class="controls" ><button class="btn btn-success" style="width:120px;" >添加选项</button></DIV>
        </DIV>
  </FORM>
</div>
</body>
</html>

Show results:

gif5新文件 (34).gif

Continuing Learning

new file

<?php echo "投票选项添加";

submit Reset Code

Automatic operation

Add voting options

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]