donglu9978 2016-05-31 09:04
浏览 62
已采纳

如何从php到html <select>选项获得结果?

i have a select option in index.html , i want to get result from mySQL via php, but how to get the result from php ,and add results to html automatically

index.html:

<form action="get.php" method="post" >
    <select>
    <option  class="rm" value="trap"><get results from php></option>
.............
    </select>
 </form>

If you could show me a working example which does that, or may be any similar idea, it would be good.

  • 写回答

1条回答 默认 最新

  • douao8204 2016-05-31 09:11
    关注

    I don't really understand what you mean. But did you mean something like this:

    <html>
    <body>
    <select>
    <?php
    $root = realpath($_SERVER["DOCUMENT_ROOT"]);
    include "$root/config.php";
    
    $something1 = "something1";
    $something2 = "something2";
    
    $stmt = $pdo->prepare('SELECT DISTINCT from_mysql FROM customers WHERE something1 = :something1 AND from_mysql != :something2 ORDER BY from_mysql');
    $stmt->execute(array(':something1' => $something1, ':something2' => $something2));
    
    $results = $stmt->fetchAll();
    
    if (empty($results)) { 
        echo 'Error: Please contact technical support!'; 
    } else {
    foreach( $results as $row ) {
        echo "<option>".$row['from_mysql']."</option>";
    }
    }
    ?>
    </select>
    </body>
    </html>
    

    P.S. You'll have to use index.php

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果