dousi4900 2019-07-08 19:01
浏览 37

电子邮件更改数据不会出现

when I make a change update the email data does not appear and does not enter the database.

this is the display when you want to make changes to the data.

https://i.imgur.com/GuG0pT0.jpg

this is the display when I have made changes, the email does not enter the database and does not appear

https://i.imgur.com/vOkHAkI.jpg

this is the code for updating data in file siswa.php

$(document).on('click', '.ubah_siswa', function() {
    siswa_id = $(this).attr('id');
    clear_field();
    $.ajax({
        url: "siswa_action.php",
        method: "POST",
        data: {
            action: 'edit_fetch',
            siswa_id: siswa_id
        },
        dataType: "json",
        success: function(data) {
            $('#nama_siswa').val(data.nama_siswa);
            $('#kelas_siswa').val(data.kelas_siswa);
            $('#siswa_peminatan_id').val(data.siswa_peminatan_id);
            $('#email_siswa').val(data.email_siswa);
            $('#error_foto_siswa').html('<img src="foto_siswa/' + data.foto_siswa + '" class="img-thumbnail" width="50" />');
            $('#hidden_foto_siswa').val(data.foto_siswa);
            $('#siswa_id').val(data.siswa_id);
            $('#modal_title').text("Ubah Data siswa");
            $('#button_action').val('Ubah');
            $('#action').val('Ubah');
            $('#formModal').modal('show');
        }
    });
});

this is the code for updating data in file siswa_action.php

if ($_POST["action"] == "Ubah") {
    $data = array(
                ':nama_siswa'                =>    $nama_siswa,
                ':kelas_siswa'            =>    $kelas_siswa,
                ':siswa_peminatan_id'            =>    $siswa_peminatan_id,
                ':email_siswa'            =>    $email_siswa,
                ':foto_siswa'            =>    $foto_siswa,
                ':siswa_id'                =>    $_POST["siswa_id"]
            );
    $query = "UPDATE tbl_siswa 
                SET nama_siswa = :nama_siswa, 
                kelas_siswa = :kelas_siswa,
                foto_siswa = :foto_siswa, 
                email_siswa = :email_siswa, 
                siswa_peminatan_id = :siswa_peminatan_id
                WHERE siswa_id = :siswa_id
                ";
    $statement = $connect->prepare($query);
    if ($statement->execute($data)) {
        $output = array(
            'success'        =>    'Data Berhasil Diubah',
        );
    }
}

if ($_POST["action"] == "edit_fetch") {
    $query = "SELECT * FROM tbl_siswa WHERE siswa_id = '" . $_POST["siswa_id"] . "'";
    $statement = $connect->prepare($query);
    if ($statement->execute()) {
        $result = $statement->fetchAll();
        foreach ($result as $row) {
            $output['nama_siswa'] = $row['nama_siswa'];
            $output['kelas_siswa'] = $row['kelas_siswa'];
            $output['email_siswa'] = $row['email_siswa'];
            $output['siswa_peminatan_id'] = $row['siswa_peminatan_id'];
            $output['foto_siswa'] = $row['foto_siswa'];
            $output['siswa_id'] = $row['siswa_id'];
        }
        echo json_encode($output);
    }
}

for full code in here, https://codesandbox.io/s/kind-dust-fjusz?fontsize=14

I've tried to search for what's wrong, maybe here someone knows the error where, can be checked in the full code for details

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 对于这个问题的解释说明
    • ¥200 询问:python实现大地主题正反算的程序设计,有偿
    • ¥15 smptlib使用465端口发送邮件失败
    • ¥200 总是报错,能帮助用python实现程序实现高斯正反算吗?有偿
    • ¥15 对于squad数据集的基于bert模型的微调
    • ¥15 为什么我运行这个网络会出现以下报错?CRNN神经网络
    • ¥20 steam下载游戏占用内存
    • ¥15 CST保存项目时失败
    • ¥15 树莓派5怎么用camera module 3啊
    • ¥20 java在应用程序里获取不到扬声器设备