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.