dongzhi1822 2017-08-25 11:15
浏览 112

为什么它显示pdo undefined?

I have a script for db connection that is

<?php

//$dsn ='mysql:dbname=medicare;host=localhost';
$me = "root";
$password ="";

try{
$pdo = new PDO('mysql:host=localhost;dbname=medicare',$me,$password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e){
echo"Error!:".$e->getMessage()."<br>";
die();


}

?>

then i have a function to add data in db_operations class that is

public static  function insert_admin($name,$pass){
// require_once("/connect.php");
$security = "?..H@Si./n/?";
$pass = md5($pass,PASSWORD_DEFAULT).$security;
$sql = "INSERT INTO admin(username,password)  VALUES(:username,:password)";

$stmt = $pdo->prepare($sql); (line 79)
$stmt->bindParam(':username',$name,PDO::PARAM_STR);
$stmt->bindParam(':password',$pass,PDO::PARAM_STR);
$stmt->execute();

$pdo = null;


}

But it has shown

Notice: Undefined variable: pdo in F:\xampp\htdocs\medicare\Model\class_db_operations.php on line 79

Fatal error: Call to a member function prepare() on a non-object in F:\xampp\htdocs\medicare\Model\class_db_operations.php on line 79 someone please help.

  • 写回答

2条回答 默认 最新

  • dongyue7796 2017-08-25 11:25
    关注

    There is no $pdo defined when $pdo->prepare() is called, you need to pass it as an argument or to make it available in the object as a property and set it with another method.

    评论

报告相同问题?

悬赏问题

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