ds342222 2015-12-13 18:02
浏览 37

通过AJAX将数据从数据库检索到选项值

I am having problems trying to fetch some data from my database to display it in a value, I'm using Smarty as a template engine, I have my working code which is:

<div style="width: 50%">
<table id="listado" width="100%" cellpadding="2" cellspacing="1" border="0">
<thead>
    <tr>
        <th>&nbsp;</th>
        <th style="text-align: center;">ID</th>
        <th style="text-align: center;">NOMBRE</th>
        <th style="text-align: center;">DOCUMENTO</th>
    </tr>
</thead>
<tbody>
</tbody>
</table>
</div>
{literal}
<script type="text/javascript">
    $(document).ready(function(){

        $.ajax({
        "url": API_PATH+"/empresas/",
        "method": "GET",
        "dataType": 'json',
        'cache':false
    }).done(function (response) {
        var allregs = [];
        $.each(response, function(key,val){
            var items = [];
            items.push('<tr>');
            items.push('<td style="text-align: center;"><a href="javascript:;" class="selectEmpresa" data-id="'+val.id+'">seleccionar</a></td>');
            items.push('<td style="text-align: center;">'+val.id+'</td>');
            items.push('<td style="text-align: center;">'+val.nombre+'</td>');
            items.push('<td style="text-align: center;">'+val.documento+'</td>');
            items.push('</tr>');
            allregs.push(items);
        });
        $('#listado tbody').append(allregs.join(''));
    }).fail(function(jqXHR, textStatus){
        if(jqXHR.status == 404){
            alert("No existen registros");
        }
    });

    $('body').on('click','.selectEmpresa',function(){
        var empresaid = $(this).attr('data-id');
        $.ajax({
            "url": API_PATH+"/empresas/select/"+empresaid,
            "method": "GET",
            "dataType": 'json',
            'cache':false
        }).done(function (response) {
            location.href = SERVER_PATH+'/';
        }).fail(function(jqXHR, textStatus){
            alert('error');
        });

    });


});
</script>
{/literal}

it works perfectly using normal thead, tbody, tr, td, what im trying to do is fetch the same data just val.nombre but inside :

    <div class="container">
        <section>
            <select class="cs-select cs-skin-border">
                <option value="" disabled selected>Seleccionar Empresa</option>
                <option value="prueba1">Prueba 1</option>
                <option value="prueba2">Prueba 2</option>
                <option value="prueba3">Prueba 3</option>
            </select>
        </section>
    </div>
    <script src="{$smarty.const.ASSETS_FOLDER}/select-empresas/classie.js"></script>
    <script src="{$smarty.const.ASSETS_FOLDER}/select-empresas/selectFx.js"></script>
    <script>
        (function() {
            [].slice.call( document.querySelectorAll( 'select.cs-select' ) ).forEach( function(el) {    
                new SelectFx(el);
            } );
        })();
    </script>

instead of setting the values manually I want to fetch it from the database dynamically

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 有偿求苍穹外卖环境配置
    • ¥15 代码在keil5里变成了这样怎么办啊,文件图像也变了,
    • ¥20 Ue4.26打包win64bit报错,如何解决?(语言-c++)
    • ¥15 clousx6整点报时指令怎么写
    • ¥30 远程帮我安装软件及库文件
    • ¥15 关于#自动化#的问题:如何通过电脑控制多相机同步拍照或摄影(相机或者摄影模组数量大于60),并将所有采集的照片或视频以一定编码规则存放至规定电脑文件夹内
    • ¥20 深信服vpn-2050这台设备如何配置才能成功联网?
    • ¥15 Arduino的wifi连接,如何关闭低功耗模式?
    • ¥15 Android studio 无法定位adb是什么问题?
    • ¥15 C#连接不上服务器,