我想在更新语句时显示一条消息,但当我这样做时,按钮类型是提交,它刷新页面,消息不会显示,当我将按钮类型更改为按钮时,它显示消息,但不执行更新操作--这是我的代码html代码
<div class="alert alert-success hidden" id="success-alert">
<span class="glyphicon glyphicon-ok"></span> User Name Changed Succsefully
</div>
<div class="row">
<div class="col-md-6">
New username: <input type="text" class="form-control" name="user" placeholder="New username">
</div>
</div>
<div class="col-auto my-1">
<button type="submit" name="changeuser" id="user" class="btn btn-primary">change username</button>
</div>
</fieldset>
</form>java代码
<script type="text/javascript">
$(document).ready(function() {
$("#user").click(function() {
$('#success-alert').removeClass('hidden');
$('#success-alert').delay(5000).fadeOut('slow');
});
$("button.close").click(function() {
$('#success-alert').addClass('hidden');
});
});
php代码
if (isset($_POST['changeuser']))
{
$username=$_POST['user'];
$sql="SELECT * from user_account where username='$username'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)==1)
{
echo '<script language="javascript">';
echo 'alert("User name already exits Please Chose Another One")';
echo '</script>';
}
else
{
$up = mysqli_query($conn, "UPDATE user_account SET username='$username' WHERE id='$id'");
}
}发布于 2020-02-16 18:19:48
更改您的php代码如下:
$up = '';
if (isset($_POST['changeuser']))
{
$username=$_POST['user'];
$sql="SELECT * from user_account where username='$username'";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result)==1)
{
echo '<script language="javascript">';
echo 'alert("User name already exits Please Chose Another One")';
echo '</script>';
}
else
{
$up = mysqli_query($conn, "UPDATE user_account SET username='$username' WHERE id='$id'");
}
}并将html部分更改如下:
<?php
if($up) {
?>
<div class="alert alert-success" id="success-alert">
<span class="glyphicon glyphicon-ok"></span> User Name Changed Succsefully
</div>
<?php
}
?>https://stackoverflow.com/questions/60251618
复制相似问题