duanfengtuo6012 2015-03-11 12:10
浏览 66


This question already has an answer here:

So I'm trying to create a prepared insert statement to a database for a web app. For the registration system, I'm feeding in values using post, then redirecting to a webpage to do the processing. However, I keep getting the error 'Call to a member function bindValue() on a non-object in /path/to/file.php on line 18, the first reference to bindValue(). The code is:



 require "database.php";
 $db = new Database("bills.db");

 $admin_password = $_POST['admin_password'];
 $admin_email = $_POST['admin'];
 $salt = sha1(time());
 $group_name = $_POST['group_name'];
 $group_password = $_POST['password'];

 $admin_hash = sha1($salt."--".$admin_password);
 $group_hash = sha1($salt."--".$group_password);

$stmt = $db->prepare("INSERT INTO billgroup VALUES (NULL, :adminemail, :adminpassword_hash, :groupname, :password_hash, :salt)");
$stmt->bindValue(':adminemail', $admin_email, SQLITE3_TEXT);
$stmt->bindValue(':adminpassword_hash', $admin_hash, SQLITE3_TEXT);
$stmt->bindValue(':groupname', $group_name, SQLITE3_TEXT);
$stmt->bindValue(':password_hash', $group_hash, SQLITE3_TEXT);
$stmt->bindValue(':salt', $salt, SQLITE3_TEXT);
$results = $stmt->execute();

 $stmt = $db->prepare("SELECT * FROM billgroup WHERE adminemail = :adminemail");
 $stmt->bindValue(':adminemail', $admin_email, SQLITE3_TEXT);
 $users = $stmt->execute();
 $user = $users->fetchArray();
  • 写回答

1条回答 默认 最新

  • dongniaocheng3773 2015-03-13 19:12

    You want connect to a sqlite database but you have:

    $db = new Database("bills.db");

    You must know that you must have something like this:

    $db = new PDO('sqlite:bills.db');

    And change in all the bindValue calls the SQLITE3_TEXT to PDO::PARAM_STR like this:

    $stmt->bindValue(':adminemail', $admin_email, SQLITE3_TEXT);


    $stmt->bindValue(':adminemail', $admin_email, PDO::PARAM_STR);
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥50 来个抓app跳转支付宝转链接的
  • ¥15 remotes安装提示没有description文件
  • ¥15 AttributeError: 'NoneType' object has no attribute 'drop_duplicates'报错
  • ¥15 以下代码,运行结果报错
  • ¥15 Vivado仿真数据出错
  • ¥15 银河麒麟不支持vant等前端框架怎么办?
  • ¥15 vue3的子组件在父页面调用不显示不生效问题
  • ¥15 cadence PEX
  • ¥15 phython创建了文件 显示在项目下面,但运行不了,运行时还是运行main文件,并且说main文件不允许并行运行
  • ¥15 FutureWarning:不推荐使用空或全 NA 条目的 DataFrame 串联行为。怎么改呢?