我的 Mysql 查询没有更新 [英] My Mysql query doesn't update
本文介绍了我的 Mysql 查询没有更新的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要有关此代码的帮助.我和我的朋友正在创建一个网站,但我们被困在:
I need help with this code. My friend and I creating a website but we're stuck at:
代码在这里:
<?php
$servern = $_GET['server'];
$vownerid = $mybb->user['uid'];
$i1 = mysql_query("SELECT * FROM serversNew WHERE servername ='$servern'");
if(mysql_num_rows($i1) == 0) {
return;
} else {
while($row = mysql_fetch_assoc($i1)) {
$servername = $row['servername'];
$votes = $row['votes'];
$port = $row['port'];
$ip = $row['ip'];
$status = $row['status'];
$owner = $row['owner'];
$ownerid = $row['ownerid'];
$loader = $row['loader'];
$desc = $row['desc'];
}
if(($ownerid != $vownerid) && ($vownerid != 1)) {
return;
} else {
}
}
?>
<?php
if(isset($_POST['update'])) {
$servername1 = htmlspecialchars($_POST['servername']);
$ip1 = htmlspecialchars($_POST['ip']);
$port1 = $_POST['port'];
$owner1 = htmlspecialchars($_POST['owner']);
$loader1 = $_POST['loader'];
$desc1 = $_POST['desc'];
if($loader1 == "no") {
$loader1 = $loader;
}
if($loader1 == "custom") {
$loader1 = htmlspecialchars($_POST['jar']);
}
if($loader1 == 1) {
$loader1 = "";
} else if($loader1 == 2) {
$loader1 = "";
} else if($loader1 == 3) {
$loader1 = "";
} else if($loader1 == 4) {
$loader1 = "";
} else if($loader1 == 5) {
$loader1 = "";
}
if($port1 == "no") {
$port1 = $port;
}
mysql_query("UPDATE serversNew SET ip='$ip1', loader='$loader1', port='$port1', owner='$owner1', desc='$desc1' WHERE servername='$servername'");
?><script>window.location = "/member.php"</script><?php
}
?>
我们想更新 MYSQL 查询,但它没有更新.
We want to update the MYSQL query but it doesn't update it.
希望有人能帮助我们.
推荐答案
在您的 SQL 查询中,输入 所有这些保留字变成反引号:
In your SQL query, put all these reserved words into backticks:
mysql_query("UPDATE serversNew SET ip='$ip1', loader='$loader1', port='$port1', owner='$owner1', `desc`='$desc1' WHERE servername='$servername'");
另见:
这篇关于我的 Mysql 查询没有更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文