douxun4173 2015-08-03 00:32 采纳率: 0%
浏览 52
已采纳

数据无法在表单提交时发送？ [关闭]

This is my code: 

<?php
require_once "connect.php";

if ($_SERVER["REQUEST_METHOD"] == "POST") {
  $email = test_input($_POST["email"]);
    if(!empty($email))
    {
        $insert = $db->prepare("INSERT INTO creations(email) VALUES (?)");
        $insert->bind_param('s', $email);
    }
}

function test_input($data) {
  $data = trim($data);
  $data = stripslashes($data);
  $data = htmlspecialchars($data);
  return $data;
}
?>

<!DOCTYPE html>
<html>
    <body>
        <form method="post" action="">

            <input type="text" name="email">
            <input type="submit">
        </form>
    </body>
</html>

When I submit anything in the email input box, I get an error saying this:

Fatal error: Call to a member function bind_param() on a non-object in /home/xx/xx/xx/xx on line 12.

I've tried this with a few different forms and got the same error. I've double checked everything on both my database and in my PHP code...

  • 写回答

1条回答 默认 最新

  • douruoshen1449 2015-08-03 00:54
    关注

    This should do the trick let me know if you have any problems.

    //CODE

    <?php
//PATH --- /var/www/html/connect.php
require_once($_SERVER['DOCUMENT_ROOT'] . "/connect.php");
if (isset($_POST["email"])){
    $email = filter_data($_POST["email"]);
    $stmt = $db->prepare("INSERT INTO creations(email) VALUES (?)"); 
    $stmt->bind_param('s', $email);
    $stmt->execute();
    $stmt->close(); 
}
function filter_data($data) {
  $data = trim($data);
  $data = stripslashes($data);
  $data = htmlspecialchars($data);
  return $data;
}
?>
<!DOCTYPE html>
<html>
    <body>
        <form method="post" action="">
            <input type="text" name="email">
            <input type="submit">
        </form>
    </body>
</html>
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？

悬赏问题

  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示？
  • ¥15 有了解d3和topogram.js库的吗？有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar，时序沉降图怎么画
  • ¥15 买了个传感器，根据商家发的代码和步骤使用但是代码报错了不会改，有没有人可以看看
  • ¥15 关于#Java#的问题，如何解决？
  • ¥15 加热介质是液体，换热器壳侧导热系数和总的导热系数怎么算
  • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
  • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
  • ¥500 火焰左右视图、视差（基于双目相机）