如何在php中使用ajax从while循环插入动态数据
如何在php中使用ajax从while循环插入动态数据
提问于 2020-01-19 19:47:46
我尝试使用ajax根据用户单击的循环按钮插入隐藏字段中存储的循环用户的id，但它不起作用，有人能帮我吗？
<!----Suggested users Start---->
<div class="ms_heading">
<h1>Suggested Users</h1>
</div>
<div class="swiper-wrapper">
<?php
require '../db.php';
$sql = "select * from users order by id desc";
//
$sql_query = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql_query)) {
$id = $row['id'];
$user_image = $row['profile_img'];
$myusername = $row['Username'];
?>
<div class="swiper-slide">
<div class="ms_rcnt_box">
<div class="ms_pro_img">
<img src="User_Images/<?php echo $user_image;?>" alt="" class="img-fluid" id="pro_img">
</div>
<div class="ms_rcnt_box_text">
<center><b><a href=""><p><?php if(isset($myusername)){ echo $myusername;}?></p></a></b></center><br/>
<input type="hidden" value="<?php echo $id;?>" id="name">
<button type="submit" id="button">SAVE</button>
<script>
$(document).ready(function(){
$("#button").click(function(){
var name=$("#name").val();
$.ajax({
url:'insert.php',
method:'POST',
data:{
name:name,
},
success:function(data){
alert(data);
}
});
});
});
</script>
<?
php
}
?>
</div>insert.php
<?php
require '../db.php';
$name=$_POST['name'];
$sql="INSERT INTO `myTest` (`id`, `name`) VALUES (NULL, '$name')";
if ($conn->query($sql) === TRUE) {
echo "data inserted";
}
else
{
echo "failed";
}
?>回答 1
Stack Overflow用户
回答已采纳
发布于 2020-01-19 20:36:07
我已经修改了完整的html和脚本代码。如下所示：
$(document).ready(function () {
$("[id^=button_]").click(function () {
var id = $(this).data('id');
var name = $("#name_"+id).val();
console.log(id+"---"+name);
$.ajax({
url: 'insert.php',
method: 'POST',
data: {
name: name,
},
success: function (data) {
alert(data);
}
});
});
});<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<div class="ms_heading"><h1>Suggested Users</h1></div>
<div class="swiper-wrapper">
<?php
require 'db.php';
$sql = "select * from users order by iUserId desc";
$sql_query = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql_query)) {
$id = $row['iUserId'];
$user_image = $row['vImage'];
$myusername = $row['vFirstName'];
?>
<div class="swiper-slide">
<div class="ms_rcnt_box">
<!-- <div class="ms_pro_img">
<img src="User_Images/<?php echo $user_image;?>" alt="" class="img-fluid" id="pro_img">
</div> -->
<div class="ms_rcnt_box_text">
<center><b><a href=""><p><?php if(isset($myusername)){ echo $myusername;}?></p></a></b></center>
<br />
<input type="hidden" value="<?php echo $id;?>" id="name_<?=$id;?>" name="name">
<button type="submit" id="button_<?=$id;?>" data-id="<?=$id;?>">SAVE</button>
</div>
</div>
</div>
<?php } ?>
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/59809722
复制相关文章
相似问题
腾讯云开发者
