如何在刷新后使文本框保持其mysql值？ [英] How do I make a textbox keep its mysql value after a refresh?

问题描述

我有这个代码，它将值存储在文本框中，但是当我刷新时它会停留但是当我刷新两次时数据不存在！有没有办法解决这个问题？

I have this code, which stores values in the text-box but when I refresh It stays but when I refresh twice the data isn't there! Is there a way I can fix this?

$username = $_SESSION[user];
$user2 = $_SESSION[user];
$user = mysql_query("SELECT * FROM ajax_chat_users WHERE userName = '$username'");
$user=mysql_fetch_assoc($user);
$merry = mysqli_query($con,"SELECT * FROM ajax_chat_users WHERE userName = '$username'");
$row = mysqli_fetch_array($merry);
$merry2 = mysqli_query($con,"SELECT * FROM ajax_chat_users WHERE userName = '$user2'");
$row2 = mysqli_fetch_array($merry2);
if($user[userRole]== "AJAX_CHAT_OWNER" && $row2[userRole]!="AJAX_CHAT_OWNER"){
die("You have insufficient privileges to view this page! <a href=Members.php>Go back to user list?</a>");
}

$update4 = mysql_query("UPDATE ajax_chat_users
                       SET AboutMe='$update0', FriendCode='$update1', CSS='$update2', NNID='$update3'
                     WHERE userName = '$user2' ");

<form name=input action=edit_profile.php method=post>
<textarea name=ABOUT_ME>".$row[AboutMe]."</textarea><br>
Nintendo 3DS Friend Code:<br><input type=text name=FRIEND_CODE maxlength=12 pattern=.{12,12} value=".$row[FriendCode]."/><br>
NNID:<br><input type=text name=NNID maxlength=16 value=".$row[NNID]."><br>
CSS (Profile Styling):<br><textarea name=CSS>".$row[CSS]."</textarea><br>
<input type=submit value=\"Save Changes?\">

推荐答案

用户名 =

username =

_SESSION [user];

_SESSION[user];

user2 =

user2 =

这篇关于如何在刷新后使文本框保持其mysql值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！