使用HTTPPOST方法通过php更新mysql数据库


Updating mysql database through php with HTTP POST methods

它在应用程序上执行得很好,我仔细检查了一下。它正确地发送了所有参数,问题是在php脚本中它没有执行查询(更新、删除)它正确地执行了插入查询。php脚本非常适合html表单,但我不知道问题出在哪里

这是我的php脚本:

$mysql_host="localhost";$mysql_database="定位器";$mysql_user="root";$mysql_password=";mysql_connect($mysql_host、$mysql_user、$mysql_password)或die(mysql_error());mysql_select_db($mysql_database);$uMail=$_POST['uMail'];$uIMEI=$_POST['uIMEI'];$uName=$_POST['u_name'];$uPass=$_POST['u_pass'];$t名称=$_POST['t_names'];$tIMEI=$_POST['t_IMEI'];$tDesc=$_POST['t_desc'];mysql_query("UPDATE user_master SET t_names='$tName',t_IMEI='$tIMEI',t_desc='$tDesc'WHERE u_mail='$uMail'AND u_IMEI='$uIMEI'");mysql_close();?>

也许您应该使用mysql_real_escape_string() 来转义字符串

$uMail = mysql_real_escape_string($_POST['u_mail']);
$uIMEI = mysql_real_escape_string($_POST['u_IMEI']);
$uName = mysql_real_escape_string($_POST['u_name']);
$uPass = mysql_real_escape_string($_POST['u_pass']);
$tName = mysql_real_escape_string($_POST['t_names']);
$tIMEI = mysql_real_escape_string($_POST['t_IMEIs']);
$tDesc = mysql_real_escape_string($_POST['t_desc']);
mysql_query("UPDATE user_master SET t_names='$tName',t_IMEIs='$tIMEI',t_desc= '$tDesc'      WHERE u_mail = '$uMail' AND u_IMEI = '$uIMEI'");

并确保CCD_ 2和CCD_