在sript.js页面上使用JavaScript将HTML select中的值发送到PHP

Question

我正在尝试将sql数据库中表中的代码添加到div中，这取决于下拉框的结果，但它不起作用！有什么帮助吗？

index.php
 <p> Choose Subject Area </p>
    <form action="">
        <select name="business area">
        <option value="">Programming</option>
        <option value="NAME">Web Design</option>
        <option value="NAME">TV&Film</option>
    </select>
</form>
<button id="Search" type="button">Search</button>
<?php

script.js

   $(document).ready(function(){
     $('#Search').click(function(){
       $('#Results').append(
        <?php
            // generate sql query
            $sql = "SELECT * FROM Form WHERE  Company_area="business_area";
            // execute query
            $result=sqlite_query($db,$sql);
            // get number of records found
            $numrows = sqlite_num_rows($result);
            echo "Number of records found: $numrows <br /><br />";
            //show results on screen
            while ($row = sqlite_fetch_array($result)) {
                "<div>"
                    echo "Company Name: " . $row['Company_Name'] . "<br />";
                    echo "Company Area: " . $row['Company_area'] . "<br />";
                    echo "Description: " . $row['Description'] . "<br />";
                    echo "YouTube Link: " . $row['YouTube_Link'] . "<br />";
                    echo "Contact Name: " . $row['Contact_Name'] . "<br />";
                    echo "e-mail: " . $row['e-mail'] . "<br />";
                    echo "Facebook: " . $row['Facebook'] . "<br />";
                    echo "Twitter: " . $row['Twitter'] . "<br />";
                    echo "Website Address: " . $row['Website_address'] . "<br /><hr />";
                    "</div>"
                }
            ?>
        );
    });
});

Answer 1

我建议将script.js更改为script.php，并将其包含在页面中，如下所示：

include "script.php";

然后使用以下命令执行javascript代码：

<script type='text/javascript'>
  <?php 
    //php code here 
  ?>
</script>