Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.
</div>
</div>
</div>
<hr class="my12 outline-none baw0 bb bc-powder-2">
<div class="grid fw-nowrap fc-black-600">
<div class="grid--cell mr8">
<svg aria-hidden="true" class="svg-icon iconLightbulb" width="18" height="18" viewbox="0 0 18 18"><path d="M9.5.5a.5.5 0 0 0-1 0v.25a.5.5 0 0 0 1 0V.5zm5.6 2.1a.5.5 0 0 0-.7-.7l-.25.25a.5.5 0 0 0 .7.7l.25-.25zM1 7.5c0-.28.22-.5.5-.5H2a.5.5 0 0 1 0 1h-.5a.5.5 0 0 1-.5-.5zm14.5 0c0-.28.22-.5.5-.5h.5a.5.5 0 0 1 0 1H16a.5.5 0 0 1-.5-.5zM2.9 1.9c.2-.2.5-.2.7 0l.25.25a.5.5 0 1 1-.7.7L2.9 2.6a.5.5 0 0 1 0-.7z" fill-opacity=".4"></path><path opacity=".4" d="M7 16h4v1a1 1 0 0 1-1 1H8a1 1 0 0 1-1-1v-1z" fill="#3F3F3F"></path><path d="M15 8a6 6 0 0 1-3.5 5.46V14a1 1 0 0 1-1 1h-3a1 1 0 0 1-1-1v-.54A6 6 0 1 1 15 8zm-4.15-3.85a.5.5 0 0 0-.7.7l2 2a.5.5 0 0 0 .7-.7l-2-2z" fill="#FFC166"></path></svg>
</div>
<div class="grid--cell lh-md">
<p class="mb0">
<b>Want to improve this question?</b> <a href="/posts/61341127/edit">Update the question</a> so it's <a href="/help/on-topic">on-topic</a> for Stack Overflow.
</p>
<p class="mb0 mt6">Closed <span title="2020-04-21 23:55:31Z" class="relativetime">5 days ago</span>.</p>
</div>
</div>
</aside>
I have tried almost all options, but every time after I change value of table and then click anywhere, I get this warning:
Notice: Undefined index: id in C:\xampp\htdocs\edit.php on line 3
Function code:
function edit_data(id, text, column_name)
{
$.ajax({
url:"edit.php",
method:"POST",
data:{ID:id, text:text, column_name:column_name},
dataType:"text",
success:function(data){
alert(data);
$('#result').html("<div class='alert alert-success'>"+data+"</div>");
}
});
}
$(document).on('blur', '.Ime', function(){
var id = $(this).data("id1");
var Ime = $(this).text();
edit_data(id, Ime, "Ime");
});
$(document).on('blur', '.Prezime', function(){
var id = $(this).data("id2");
var Prezime = $(this).text();
edit_data(id,Prezime, "Prezime");
});
$(document).on('blur', '.Email', function(){
var id = $(this).data("id3");
var Email = $(this).text();
edit_data(id,Email, "Email");
});
$(document).on('blur', '.Adresa', function(){
var id = $(this).data("id4");
var Adresa = $(this).text();
edit_data(id,Adresa, "Adresa");
});
$(document).on('blur', '.BrojKuce', function(){
var id = $(this).data("id5");
var BrojKuce = $(this).text();
edit_data(id,BrojKuce, "BrojKuce");
});
$(document).on('blur', '.PostanskiBroj', function(){
var id = $(this).data("id6");
var PostanskiBroj = $(this).text();
edit_data(id,PostanskiBroj, "PostanskiBroj");
});
edit.php code:
<?php
$connect = mysqli_connect("localhost", "root", "", "testbaza");
$id = $_POST['id'];
$text = $_POST['text'];
$column_name = $_POST['column_name'];
$sql = "UPDATE korisnicibrojeva SET '$column_name' = '$text' WHERE ID= '$id'" ;
if(mysqli_query($connect, $sql))
{
echo 'Data Updated';
} ?>
</div>