doubo1883 2015-12-14 03:13
浏览 102

$ mysqli-> error你的SQL语法有错误; 查看与您的MySQL服务器版本对应的手册,以便在附近使用正确的语法

Need help!!

I got this error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, a.ip_description = ? WHERE b.id_ip_address = a.id_ip_address AND b.id_server =' at line 1

Here are my code

session_start();

include ('../connect.php');
$member_id = $_SESSION["id"];

$url = $_POST["url"]; //varchar
$list_ip_address = $_POST["list_ip_address"]; //int
$ip_description = $_POST["ip_description"]; //varchar
$dns_list = $_POST["dns_list"]; //int

$sql = "UPDATE virtual_server SET id_ip_address = ?, url = ? WHERE id_server = $member_id";
//This part right here is fine
$stsql = $mysqli->prepare($sql);
$stsql->bind_param('is', $list_ip_address, $url);

if ($stsql->execute()) {
    $ip = "UPDATE list_ip_address a, virtual_server b SET a.id_dns = ?, a.ip_description = ? 
            WHERE b.id_ip_address = a.id_ip_address AND b.id_server = $member_id";
    $stip = $mysqli->prepare($ip);
    $stip->bind_param('is', $dns_list, $ip_description);
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
    • ¥15 基于卷积神经网络的声纹识别
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 CSAPPattacklab
    • ¥15 一直显示正在等待HID—ISP