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

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

i'm trying to make a simple webpage for making invoices. to select/load customer info i'm using a 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条)

相关推荐 更多相似问题