dongmei8460 2016-09-29 23:22
浏览 16
已采纳

插入数据库给我“localhost not working”

I'm trying to insert information into database through two inputs when you click a submit button. But when I click it it says it can't connect to localhost (everything else works so I know it has to be some form of syntax problem) Code:

    <form action="prices.inc.php" method="post">
    <input class="price-list-input" type="text" id="priceupdate1" name="priceupdate1" required></input>
    <input class="price-list-input2" type="text" id="priceupdate2" name="priceupdate2" required></input>
    <input class="price-list-button" type="submit" id="priceupdate-button" name="priceupdate-button" value="Uppdatera"></input>
    </form>

the php..

<?php

require_once('check_login.inc.php');
    define('SECURE', true);
    require_once('connection.php');


if(isset($_POST['priceupdate-button'])){

    $info = trim(htmlspecialchars($_POST['priceupdate1'], $_POST['priceupdate2']));

    // prepared statement
    $stmt = $db->prepare('INSERT INTO prices (name, price) VALUES = (?, ?)');
    $stmt->bind_param('ss', $_POST['priceupdate1'], $_POST['priceupdate2']);
    $stmt->execute();
    $stmt->store_result();
    $stmt->bind_result($info);

}

?>
  • 写回答

1条回答 默认 最新

  • dou29106 2016-09-30 00:21
    关注

    GOT IT WORKING.. all that was the problem was the "=" that @Fred-ii- mentioned.. – Chumppe

    Posting as a community wiki. I don't want rep for this but just to close the question.

    As I said in comments, VALUES = (?, ?) the equal sign shouldn't be there.

    Example from the manual http://php.net/manual/en/mysqli.prepare.php

    $stmt = $mysqli->prepare("INSERT INTO City (District) VALUES (?)");
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 测距传感器数据手册i2c
  • ¥15 RPA正常跑,cmd输入cookies跑不出来
  • ¥15 求帮我调试一下freefem代码
  • ¥15 matlab代码解决,怎么运行
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法