普通网友 2015-05-20 10:26
浏览 34

PHP和AJAX填充选择列表

I have question about populating select box. I have first select box id='select_proizvodjaci' which work correctly, and on every change I've got correct data from function ($modelAuto = $proizvodjac->pretragaModelaPoProizvodjacu($pretraga); in firebug). But I don't know how can I populate select box select id='searchModel' in proizvodjac.php?

Here is my code:

proizvodjac.php

<form method='post' action='proizvodjac-select.php' id='proizvodjacForma'>
        <select name='pretraga' id='select_proizvodjaci'>
            <option value=''>Izaberi</option>
            <?php foreach($proizvodjaci as $sets): ?>
                    <option value='<?php echo $sets['id']; ?>'><?php echo $sets['naziv_proizvodjaca']; ?></option>
            <?php endforeach; ?>
        </select>
    </form>

<label>Model:</label><br/><br/>
    <select id='searchModel'>
        <?php foreach($modelAuta as $jedanModel): ?>
        <option value='<?php echo $jedanModel['id']; ?>'><?php echo $jedanModel['naziv_modela']; ?></option>
    <?php endforeach; ?>
    </select>

javascript.js

$('#select_proizvodjaci').change(function(){

    $.ajax({
        url: 'proizvodjac-select.php',
        dataType: 'json',
        type: 'post',
        data: 'pretraga=' + $('#select_proizvodjaci').val(),
        success: function(data) {
            $('#searchModel').html(data);
        }           
    });

});

proizvodjac-select.php

<?php 

include 'ProizvodjacModel.php';

// 1. Create database connection
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'radni_nalog_oop2';
$connection = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

// Test if connection occurred.
if (mysqli_connect_errno()) {
    die('Database connection failed: ' .
        mysqli_connect_error() . 
        ' (' . mysqli_connect_errno() . ')'
    );
} else {
    echo 'Connection is successfully!' . '<br/>';
}

$proizvodjac = new ProizvodjacModel($connection);


$proizvodjaci = $proizvodjac->dajProizvodjace();

if(isset($_POST['pretraga'])) {

    $pretraga = $_POST['pretraga'];

    $modelAuta = $proizvodjac->pretragaModelaPoProizvodjacu($pretraga);


    print_r($modelAuta);

    $model_option = '<option>---</option>';


}

?>
  • 写回答

1条回答 默认 最新

  • weixin_33734785 2015-05-20 12:48
    关注

    If you giving

    dataType: 'json'

    ajax return type should be json format else it wont work.

    remove that line or use

    dataType: 'html' ->if you expecting html 
    dataType: 'text' ->if you expecting plain text

    </div>
    
    评论

报告相同问题?

悬赏问题

  • ¥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 设置完毕后没有效果