doudu4282 2014-02-24 16:29
浏览 103
已采纳

使用php / ajax选择下拉列表后,从数据库获取客户信息

i'm trying to make a simple webpage for making invoices. to select/load customer info i'm using a select dropdown filled with all the customers in the database. after selecting a customer i want php to get all the values of that customer from the database and echo somewhere else on the page. thought it would be something simple but tried everything and cant seem to get it to work.

any help?

after deleting all the code that didn't work anyway this is what i'm left with:

<select name="selectCustomer">
    <option selected>Klantnaam</option>
    <?
        $result = mysql_query('SELECT * FROM '.$c_tbl_name);

        while($row = mysql_fetch_array($result)) {
            echo    '<option value="'.$row['c_id'].'">';
            echo        $row['c_name'];
            echo    '</option>';
        }
    ?>
</select>
  • 写回答

2条回答 默认 最新

  • dtnat80842 2014-02-24 17:41
    关注

    You need some small AJAX function to do that:

    jQuery(document).ready(function($){
        $('[name="selectCustomer"]').change(function(){
            $('#result').load('load_data_from_db.php', {
                customer : $(this).val();
            });
        });
    });
    

    You than need a script load_data_from_db.php which takes the selected customer, generates the content and returns it to the client where it would be placed into an element with the ID result.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?