php+mysql做动态网站，修改用户信息，运行不报错，数据可以提交，但是数据库信息没有改变。

Question

<?php require_once('db_login.php');?>

<?php

$conn=new mysqli($db_host,$db_username,$db_password,$db_database);
function GetSQLValueString($theValue,$theType,$theDefinedValue="",$theNotDefinedValue="")
{
$theValue=(!get_magic_quotes_gpc())? addslashes($theValue):$theValue;
switch($theType)
{
case "text":
$theValue=($theValue!="") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue=($theValue!="") ? intval($theValue) : "NULL";
break;
case "double":
$theValue=($theValue!="") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "data":
$theValue=($theValue!="") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue=($theValue!="") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction=$_SERVER['PHP_SELF'];
if(isset($_SERVER['QUERY_STRING']))
{
$editFormAction .="?" . htmlentities($_SERVER['QUERY_STRING']);
}
if((isset($_POST["MM_update"]))&&($_POST["MM_update"]=="form1"))
{
$updateSQL=sprintf("UPDATE book SET accounts=%s, password=%s WHERE strID=%s",
GetSQLValueString($_POST['accounts'],"text"),
GetSQLValueString($_POST['password'],"text"),
GetSQLValueString($_POST['strID'],"int"));
//mysql_select_db($db_database,$conn);
$Result1=mysqli_query($conn,$updateSQL) or die(mysql_error($conn));
$updateGoTo="comein.php";
if(isset($_SERVER['QUERY_STRING']))
{
$updateGoTo .=(strpos($updateGoTo,'?')) ? "&" : "?";
$updateGoTo .=$_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s",$updateGoTo));
}

$query= sprintf("SELECT * FROM book" );
$admin=mysqli_query($conn,$query) or die(mysqli_error($conn));
$row_admin=mysqli_fetch_assoc($admin);
$totalRows_admin=mysqli_num_rows($admin);
?>

修改个人信息

// 账户名: 密码:   <input type="hidden" name="MM_update" value="form1"> </form></td> </tr> </table> </body>

Answer 1

这是显示代码：

修改个人信息

// 账户名: 密码:   <input type="hidden" name="MM_update" value="form1"> </form></td> </tr> </table> </body>