I’m create live editable table, it changed data in table but it doesn’t update data in database. can anybody help me, to see where my mistakes ?
Update.php
$ query = "UPDATE admin SET '".$ _POST["Nama Depan"]."' = '".$ _POST["value"]."' WHERE id = '".$ _POST["pk"]."'";
index.php
</body> </html> <script type="text/javascript" language="javascript" > $ (document).ready(function(){ function fetch_employee_data() { $ .ajax({ url:"fetch.php", method:"POST", dataType:"json", success:function(data) { for(var count=0; count<data.length; count++) { var html_data = '<tr><td>'+data[count].id+'</td>'; html_data += '<td data-name="Nama Depan" class="nm_depan" data-type="text" data-pk="'+data[count].nm_depan+'">'+data[count].nm_depan+'</td>'; html_data += '<td data-name="Nama Belakang" class="nm_belakang" data-type="text" data-pk="'+data[count].nm_belakang+'">'+data[count].nm_belakang+'</td>'; html_data += '<td data-name="Email" class="email" data-type="text" data-pk="'+data[count].id+'">'+data[count].email+'</td>'; html_data += '<td data-name="Gender" class="gender" data-type="select" data-pk="'+data[count].gender+'">'+data[count].gender+'</td>'; html_data += '<td data-name="Password" class="password" data-type="text" data-pk="'+data[count].password+'">'+data[count].password+'</td>'; html_data += '<td data-name="CV" class="cv" data-type="text" data-pk="'+data[count].cv+'">'+data[count].cv+'</td>'; html_data += '<td data-name="Tanggal Upload" class="tgl_upload" data-type="text" data-pk="'+data[count].id+'">'+data[count].tgl_upload+'</td>'; html_data += '<td data-name="Jabatan" class="jabatan" data-type="select" data-pk="'+data[count].jabatan+'">'+data[count].jabatan+'</td>'; $ ('#admin_data').append(html_data); } }})} fetch_employee_data(); $ ('#admin_data').editable({ container: 'body', selector: 'td.nm_depan', url: "update.php", title: 'Nama Depan', type: "POST", //dataType: 'json', validate: function(value){ if($ .trim(value) == '') { return 'This field is required'; } } }); $ ('#admin_data').editable({ container: 'body', selector: 'td.nm_belakang', url: "update.php", title: 'Nama Belakang', type: "POST", //dataType: 'json', validate: function(value){ if($ .trim(value) == '') { return 'This field is required'; } } });
Thanks